DBA Data[Home] [Help]

APPS.INV_PROJECT dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 280: FROM MTL_ONHAND_QUANTITIES_DETAIL

276:
277: BEGIN
278: SELECT NVL(SUM(primary_transaction_quantity),0)
279: INTO qty_found
280: FROM MTL_ONHAND_QUANTITIES_DETAIL
281: WHERE organization_id = org_id
282: AND subinventory_code = NVL(sub_code, subinventory_code)
283: AND NVL(locator_id,-9999) = NVL(loc_id, NVL(locator_id,-9999)) ;
284: