physical inventory count by locator
Hi,
I'm trying to come up with a way to count a specific subinventory in sections. I have a subinventory, defined as STOCK. I'd like to break that subinventory up into sections, based on mtl_item_locations.segment1. So, take the results from the following query, break it into manageable chunks, and do a count against one chunk.
select distinct mil.segment1 from mtl_item_locations mil, mtl_secondary_locators msl where msl.secondary_locator = mil.physical_location_id and msl.subinventory_code = 'STOCK' and mil.segment1 not in ('STOCK','SHIP','STAGING')
Is there a way to do that using EBS or an API? I only see how to do physical inventory by subinventory (as described at
select distinct mil.segment1 from mtl_item_locations mil, mtl_secondary_locators msl where msl.secondary_locator = mil.physical_location_id and msl.subinventory_code = 'STOCK' and mil.segment1 not in ('STOCK','SHIP','STAGING')
Is there a way to do that using EBS or an API? I only see how to do physical inventory by subinventory (as described at
0