Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Oracle R12 Customer wise Partno wise backorder query in Oracle Fusion. — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Oracle R12 Customer wise Partno wise backorder query in Oracle Fusion.

Received Response
10
Views
2
Comments
edited Jul 24, 2020 4:24AM in Reporting and Analytics for ERP 2 comments

Summary

Customer wise partno wise backorder query.

Content

Hi,

We recently migrated our Oracle R12 to Oracle Fusion. We have developed some custom reports in our Old Oracle R12, we need to develop it in Oracle Fusion. We face difficulty in finding tables and fields.

 

Below is the query, please suggest changes.

select hr.NAME,
          oeh.ORDER_NUMBER,
          oeh.ORDERED_DATE,
          oeh.CUST_PO_NUMBER[in Oracle Fusion CUSTOMER_PO_NUMBER],
          oel.ORDER_QUANTITY_UOM[in Oracle Fusion ORDERED_UOM],
          oel.ORDERED_ITEM[in Oracle Fusion ?????],
          oel.ORDERED_QUANTITY[in Oracle Fusion ORDERED_QTY],
          oel.SHIPPED_QUANTITY[in Oracle Fusion SHIPPED_QTY]

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!