SELECT
MilestoneDelivery.milestoneDeliveryID,
MilestoneConfiguration.name,
MilestoneConfiguration.nameTextID,
MilestoneConfiguration.type,
MilestoneConfiguration.typeTextID,
MilestoneDelivery.expectedStartDate,
MilestoneDelivery.expectedEndDate,
MilestoneDelivery.actualStartDate,
MilestoneDelivery.actualEndDate,
MilestoneDelivery.createdBySystem,
MilestoneDelivery.status
INTO
:milestoneDeliveryID,
:name,
:nameTextID,
:type,
:typeTextID,
:expectedStartDate,
:expectedEndDate,
:actualStartDate,
:actualEndDate,
:createdBySystem,
:status
FROM
MilestoneConfiguration,
MilestoneDelivery
WHERE MilestoneDelivery.milestoneConfigurationID = MilestoneConfiguration.milestoneConfigurationID
AND MilestoneDelivery.caseID = :caseID
ORDER BY
MilestoneDelivery.createdOn
|