DBA Data[Home] [Help]

APPS.INV_INVARCLI_XMLP_PKG dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 109: MTL_ONHAND_QUANTITIES_DETAIL

105: NVL(SUM(PRIMARY_TRANSACTION_QUANTITY)
106: ,0)
107: INTO V_PRIMARY_SYS_QTY
108: FROM
109: MTL_ONHAND_QUANTITIES_DETAIL
110: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
111: AND ORGANIZATION_ID = P_ORG_ID
112: AND SUBINVENTORY_CODE = P_SUBINVENTORY
113: AND NVL(LOT_NUMBER