Operation Details
Description: Reads localized milestone name and milestone type along with the other details of a milestone delivery.
Sterotype: ns
SQL 
SELECT
  MilestoneDelivery.milestoneConfigurationID,
  MilestoneDelivery.caseID,
  MilestoneConfiguration.name,
  MilestoneConfiguration.nameTextID,
  MilestoneConfiguration.type,
  MilestoneConfiguration.typeTextID,
  MilestoneDelivery.expectedStartDate,
  MilestoneDelivery.expectedEndDate,
  MilestoneDelivery.actualStartDate,
  MilestoneDelivery.actualEndDate,
  MilestoneDelivery.status,
  MilestoneDelivery.createdBySystem,
  MilestoneDelivery.ownerUserName,
  MilestoneDelivery.comments,
  MilestoneDelivery.versionNo
INTO
  :milestoneConfigurationID,
  :caseID,
  :name,
  :nameTextID,
  :type,
  :typeTextID,
  :expectedStartDate,
  :expectedEndDate,
  :actualStartDate,
  :actualEndDate,
  :status,
  :createdBySystem,
  :ownerUserName,
  :comments,
  :versionNo 
FROM
  MilestoneConfiguration,
  MilestoneDelivery 
WHERE MilestoneDelivery.milestoneDeliveryID = :milestoneDeliveryID 
  AND MilestoneConfiguration.milestoneConfigurationID = MilestoneDelivery.milestoneConfigurationID