Operation Details
Description: Reads plan template plan item and plan item details for all PlanTemplatePlanItem records created for the PlanTemplateSubGoal.
Sterotype: nsmulti
SQL 
SELECT
  PlanTemplatePlanItem.planItemID,
  PlanTemplatePlanItem.expectedOutcomeID,
  PlanTemplatePlanItem.startDay,
  PlanTemplatePlanItem.duration,
  PlanItem.sensitivityCode,
  PlanItem.cost,
  PlanTemplatePlanItem.authorizedUnits,
  PlanTemplatePlanItem.maximumUnits,
  PlanTemplatePlanItem.approvalReqInd,
  PlanTemplatePlanItem.isMandatoryInd,
  PlanTemplatePlanItem.planTemplatePlanItemID
INTO
  :planItemID,
  :expectedOutcomeID,
  :startDay,
  :duration,
  :sensitivityCode,
  :cost,
  :authorizedUnits,
  :maximumUnits ,
  :approvalReqInd,
  :isMandatoryInd,
  :planTemplatePlanItemID 
FROM
  PlanTemplatePlanItem,
  PlanItem 
WHERE PlanTemplatePlanItem.planTemplateSubGoalID = :planTemplateSubGoalID 
  AND PlanItem.planItemID = PlanTemplatePlanItem.planItemID 
ORDER BY 
 PlanTemplatePlanItem.lastWritten