1628: SUM(O.REQUIRED_QUANTITY - O.QUANTITY_ISSUED)
1629: INTO QTY
1630: FROM
1631: WIP_DISCRETE_JOBS D,
1632: WIP_REQUIREMENT_OPERATIONS O
1633: WHERE O.WIP_ENTITY_ID = D.WIP_ENTITY_ID
1634: AND O.ORGANIZATION_ID = D.ORGANIZATION_ID
1635: AND D.ORGANIZATION_ID = ORG_ID
1636: AND O.INVENTORY_ITEM_ID = ITEM_ID