DBA Data[Home] [Help]

APPS.INV_INVARCLI_XMLP_PKG dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 106: MTL_ONHAND_QUANTITIES_DETAIL

102: NVL(SUM(PRIMARY_TRANSACTION_QUANTITY)
103: ,0)
104: INTO V_PRIMARY_SYS_QTY
105: FROM
106: MTL_ONHAND_QUANTITIES_DETAIL
107: WHERE INVENTORY_ITEM_ID = INVENTORY_ITEM_ID_V
108: AND ORGANIZATION_ID = P_ORG_ID
109: AND SUBINVENTORY_CODE = SUBINVENTORY
110: AND NVL(LOT_NUMBER