Operation Details
Description: Searches details of all milestones required for baseline milestone creation at planned group level.
Sterotype: nsmulti
SQL 
SELECT
  SPMilestoneDeliveryLink.plannedGroupID,
  MilestoneDelivery.milestoneDeliveryID,
  MilestoneConfiguration.name,
  MilestoneConfiguration.nameTextID,
  MilestoneConfiguration.type,
  MilestoneConfiguration.typeTextID,
  MilestoneDelivery.expectedStartDate,
  MilestoneDelivery.expectedEndDate,
  MilestoneDelivery.actualStartDate,
  MilestoneDelivery.actualEndDate
INTO
  :plannedGroupID,
  :milestoneDeliveryID,
  :name,
  :nameTextID,
  :type,
  :typeTextID,
  :expectedStartDate,
  :expectedEndDate,
  :actualStartDate,
  :actualEndDate 
FROM
  MilestoneDelivery,
  MilestoneConfiguration,
  SPMilestoneDeliveryLink 
WHERE SPMilestoneDeliveryLink.plannedGroupID = :plannedGroupID 
  AND SPMilestoneDeliveryLink.milestoneDeliveryID = MilestoneDelivery.milestoneDeliveryID 
  AND MilestoneDelivery.milestoneConfigurationID = MilestoneConfiguration.milestoneConfigurationID
ORDER BY 
    MilestoneDelivery.createdOn