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