Home » Applications » Oracle Fusion Apps & E-Business Suite » Query Related to Oracle Inventory (E-Business Suite 12.1.3)
icon4.gif  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

Previous Topic: GL_IMPORT_REFERENCES and XLA_AE_LINES
Next Topic: Live Oracle Fusion customers
Goto Forum:
  


Current Time: Thu Mar 28 18:29:54 CDT 2024