Friday, October 31, 2014

Exception- Onhand qty without locator for locator controlled subinv

UPDATE apps.MTL_ONHAND_QUANTITIES_DETAIL
set locator_id = (select inventory_location_id
 from mtl_item_locations_kfv
where concatenated_segments = 'CSKEN.000.00.00')
where organization_id = 87 -- ORGANIZATION_ID
and inventory_item_id in (select inventory_item_id
from APPS.mtl_system_items
where organization_id = 86
and segment1 in ('815662000PE')) --ITEM_NUMBER
and subinventory_code='CSKEN' -- SUBINVENTORY_CODE
and locator_id is null;

No comments:

Post a Comment