This content has been marked as final. Show 4 replies
why can't you use "Locator quantities report"
But this report shows the locaters which are filled/occupied, how to know the empty one?
You may use following query:
select organization_id, subinventory_code, concatenated_segments locator
from mtl_item_locations_kfv mil
where not exists (select 1 from mtl_onhand_quantities_detail moqd
where moqd.locator_id = mil.inventory_location_id
and moqd.organization_id = mil.organization_id)
--and organization_id = ...
And if you want to know the never used locators just replace the on hand table with the material transactions table.