DBA Data[Home] [Help]

APPS.INV_CACHE dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 535: FROM MTL_ONHAND_QUANTITIES_DETAIL

531: l_return_val := TRUE;
532: ELSE
533: SELECT status_id
534: INTO moqd_rec.status_id
535: FROM MTL_ONHAND_QUANTITIES_DETAIL
536: WHERE inventory_item_id = p_inventory_item_id
537: AND organization_id = p_organization_id
538: AND subinventory_code = p_sub_code
539: AND nvl( locator_id, -9999) =nvl(p_loc_id, -9999)