DBA Data[Home] [Help]

APPS.INV_PROJECT dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 285: FROM MTL_ONHAND_QUANTITIES_DETAIL

281:
282: BEGIN
283: SELECT NVL(SUM(primary_transaction_quantity),0)
284: INTO qty_found
285: FROM MTL_ONHAND_QUANTITIES_DETAIL
286: WHERE organization_id = org_id
287: AND subinventory_code = NVL(sub_code, subinventory_code)
288: AND NVL(locator_id,-9999) = NVL(loc_id, NVL(locator_id,-9999)) ;
289: