Inventory Items (APC/PLM/PIM) - EBS (MOSC)

MOSC Banner

how to get the current stock up to date by a SQL query or from which tables?

edited Dec 9, 2013 3:03PM in Inventory Items (APC/PLM/PIM) - EBS (MOSC) 3 commentsAnswered
Hi All,

 i want to know the current stock but i don't know  what tables i should use 
 and how to get only the current stock

for example :

if there are 100  items in the inventory
 then 20 items have been issued
 then 10 items have been added to the stock

so my current stock now is 90 items 

how to get these 90 items in a SQL query


reply ASAP please

Thanks

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