DBA Data[Home] [Help]

APPS.INV_CACHE dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 534: FROM MTL_ONHAND_QUANTITIES_DETAIL

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