APPS.EAM_MATERIAL_ALLOCQTY_PKG dependencies on MTL_ITEM_QUANTITIES_VIEW
Line 209: MTL_ITEM_QUANTITIES_VIEW MOQ,
205: -- for reconciliation begin changes for 6263104
206: SELECT NVL(SUM(QUANTITY),0)
207: into l_qoh
208: FROM MTL_SECONDARY_INVENTORIES MSS, 209: MTL_ITEM_QUANTITIES_VIEW MOQ, 210: MTL_SYSTEM_ITEMS MSI
211: WHERE MOQ.ORGANIZATION_ID = p_organization_id
212: AND MSI.ORGANIZATION_ID = p_organization_id
213: AND MSS.ORGANIZATION_ID = p_organization_id