DBA Data[Home] [Help]

APPS.ENG_ENGRCNSR_XMLP_PKG dependencies on MTL_ONHAND_QUANTITIES

Line 33: MTL_ONHAND_QUANTITIES Q

29: SELECT
30: NVL(SUM(Q.TRANSACTION_QUANTITY)
31: ,0) TOTALQTY
32: FROM
33: MTL_ONHAND_QUANTITIES Q
34: WHERE Q.ORGANIZATION_ID = ORG_ID
35: AND Q.INVENTORY_ITEM_ID = COMPONENT_ITEM_ID;
36: BEGIN
37: FOR X_OnHand IN COMPUTE_ONHAND LOOP