SELECT
MilestoneDelivery.milestoneDeliveryID,
MilestoneConfiguration.name,
MilestoneConfiguration.nameTextID,
MilestoneDelivery.expectedStartDate,
MilestoneDelivery.expectedEndDate,
MilestoneDelivery.actualStartDate,
MilestoneDelivery.actualEndDate
INTO
:milestoneDeliveryID,
:name,
:nameTextID,
:expectedStartDate,
:expectedEndDate,
:actualStartDate,
:actualEndDate
FROM
MilestoneConfiguration,
MilestoneDelivery,
SPMilestoneDeliveryLink
WHERE SPMilestoneDeliveryLink.milestoneDeliveryID = MilestoneDelivery.milestoneDeliveryID
AND MilestoneDelivery.milestoneConfigurationID = MilestoneConfiguration.milestoneConfigurationID
AND SPMilestoneDeliveryLink.plannedGroupID = :plannedGroupID
|