[Home] [Help]
2752:
2753: SELECT NVL(SUM(QUANTITY),0)
2754: into l_qoh
2755: FROM MTL_SECONDARY_INVENTORIES MSS,
2756: MTL_ITEM_QUANTITIES_VIEW MOQ,
2757: MTL_SYSTEM_ITEMS MSI
2758: WHERE MOQ.ORGANIZATION_ID = p_org_id
2759: AND MSI.ORGANIZATION_ID = p_org_id
2760: AND MSS.ORGANIZATION_ID = p_org_id