Database SQL Operation: ProductDeliveryPlanItemLink.readPlannedItemActualStartDateIDAndVersionNoByCaseID
Description: | Reads planned item actual start date, planned item ID and versionNo by caseID. |
Sterotype: | ns |
SELECT
PlannedItem.plannedItemID,
PlannedItem.actualStartDate,
PlannedItem.versionNo
INTO
:plannedItemID,
:actualStartDate,
:versionNo
FROM
ProductDeliveryPlanItemLink,
PlannedItem
WHERE ProductDeliveryPlanItemLink.caseID = :caseID
AND PlannedItem.plannedItemID = ProductDeliveryPlanItemLink.plannedItemID
|