Inventory Management - EBS (MOSC)

MOSC Banner

physical inventory count by locator

edited Nov 19, 2009 6:18PM in Inventory Management - EBS (MOSC) 8 commentsAnswered
 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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center