Operation Details
Description: Returns the list of milestones and the related IDs created at a sub goal 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.planTemplateSubGoalID = :planTemplateSubGoalID
AND PlanTemplateMilestone.milestoneConfigurationID = MilestoneConfiguration.milestoneConfigurationID
ORDER BY PlanTemplateMilestone.LastWritten