Operation Details
Description: This method lists all milestone deliveries for a case.
Sterotype: nsmulti
SQL
SELECT
  MilestoneDelivery.milestoneDeliveryID,
  MilestoneConfiguration.name,
  MilestoneConfiguration.nameTextID,
  MilestoneConfiguration.type,
  MilestoneConfiguration.typeTextID,
  MilestoneDelivery.expectedStartDate,
  MilestoneDelivery.expectedEndDate,
  MilestoneDelivery.actualStartDate,
  MilestoneDelivery.actualEndDate,
  MilestoneDelivery.createdBySystem,
  MilestoneDelivery.status
INTO
  :milestoneDeliveryID,
  :name,
  :nameTextID,
  :type,
  :typeTextID,
  :expectedStartDate,
  :expectedEndDate,
  :actualStartDate,
  :actualEndDate,
  :createdBySystem,
  :status 
FROM
  MilestoneConfiguration,
  MilestoneDelivery 
WHERE MilestoneDelivery.milestoneConfigurationID = MilestoneConfiguration.milestoneConfigurationID 
  AND MilestoneDelivery.caseID = :caseID
ORDER BY 
  MilestoneDelivery.createdOn