Operation Details
Description: Returns the list of milestones and the related IDs created at a plan group level in the in a service plan template.
Sterotype: nsmulti
SQL 
SELECT
 PlanTemplateMilestone.planTemplateMilestoneID, 
 MilestoneConfiguration.nameTextID,
 PlanTemplateMilestone.planTemplateID,
 PlanTemplateMilestone.planTemplatePlanGroupID,
 PlanTemplateMilestone.planTemplateSubGoalID
INTO
 :planTemplateMilestoneID, 
 :nameTextID,
 :planTemplateID,
 :planTemplatePlanGroupID,
 :planTemplateSubGoalID
FROM 
 PlanTemplateMilestone, 
 MilestoneConfiguration
WHERE PlanTemplateMilestone.planTemplatePlanGroupID = :planTemplatePlanGroupID
AND PlanTemplateMilestone.planTemplateSubGoalID is null
AND PlanTemplateMilestone.milestoneConfigurationID = MilestoneConfiguration.milestoneConfigurationID
ORDER BY PlanTemplateMilestone.LastWritten