Onhand qty with locator for no locator controlled subinv ..

update apps.MTL_ONHAND_QUANTITIES_DETAIL 

set locator_id = NULL

where organization_id = 373  -- ORGANIZATION ID

and inventory_item_id in (select inventory_item_id

from apps.mtl_system_items

where organization_id = 86

and segment1 in ('082-103390'))  -- ITEM NUMBER 

and subinventory_code='DRSK'  -- SUBINVENTORY CODE

and locator_id = (select inventory_location_id

from apps.mtl_item_locations_kfv

where concatenated_segments = 'DRSKEN.00.00.00'); -- LOCATOR