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