SELECT
MilestoneDelivery.milestoneDeliveryID,
MilestoneDelivery.milestoneConfigurationID,
MilestoneDelivery.caseID,
MilestoneDelivery.ownerUserName,
MilestoneDelivery.expectedStartDate,
MilestoneDelivery.expectedEndDate,
MilestoneDelivery.actualStartDate,
MilestoneDelivery.actualEndDate,
MilestoneDelivery.comments,
MilestoneDelivery.status,
SPMilestoneDeliveryLink.spMilestoneDeliveryLinkID,
SPMilestoneDeliveryLink.plannedGroupID,
SPMilestoneDeliveryLink.plannedSubGoalID
INTO
:milestoneDeliveryID,
:milestoneConfigurationID,
:caseID,
:ownerUserName,
:expectedStartDate,
:expectedEndDate,
:actualStartDate,
:actualEndDate,
:comments,
:status,
:spMilestoneDeliveryLinkID,
:plannedGroupID,
:plannedSubGoalID
FROM
MilestoneDelivery,
SPMilestoneDeliveryLink
WHERE MilestoneDelivery.caseID = :caseID
AND SPMilestoneDeliveryLink.milestoneDeliveryID = MilestoneDelivery.milestoneDeliveryID
AND SPMilestoneDeliveryLink.plannedSubGoalID = :plannedSubGoalID
|