Oracle R12 Customer wise Partno wise backorder query in Oracle Fusion.
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]
0