Operation Details |
Description: | Reads planned item ID and version number by case ID. |
Sterotype: | ns |
SQL |
SELECT PlannedItem.plannedItemID, PlannedItem.versionNo INTO :plannedItemID, :versionNo FROM ProductDeliveryPlanItemLink, PlannedItem WHERE ProductDeliveryPlanItemLink.caseID = :caseID AND PlannedItem.plannedItemID = ProductDeliveryPlanItemLink.plannedItemID |