 Query Related to Oracle Inventory [message #565271] |
Sun, 02 September 2012 23:46 |
 |
Ashukh
Messages: 2
Registered: December 2011
Location: Kolkata
|
Junior Member |
|
|
I have to prepare a report in Oracle Inventory (R12) where I have to extract below fields
1. Inventory Quantity Sold for previous days and weekly basis etc
2. Quantity Physically on a shelf at a distribution center but commited to end customer
3. Quantity transfeerd from one or more distribution center within distributor
4. Quantity on order with manufacturer but not yet received
5.Quantity Intransit (Intercompany Transfer to the location)
But I am unable to derive those fields. Please help me to build the query to fetch those fields.
[EDITED by LF: removed superfluous empty lines]
[Updated on: Mon, 03 September 2012 00:37] by Moderator Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
