DBA Data[Home] [Help]

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