Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

Query for Contract Review is not fetching rows.

edited Jul 21, 2020 10:07AM in Reporting and Analytics for SCM 1 comment

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 query is to fetch rows for Contract Review.
 
SELECT oeh.order_number Ord_no, oeh.creation_date, oeh.STATUS_CODE,                             
      --oel.request_date, --->>>(Where to find this column?)
               oeh.CUSTOMER_PO_NUMBER, oeh.ordered_date Ord_Date,
      -- oel.ordered_item, --->>>(Where to find this column?)
               oel.ORDERED_QTY, oel.unit_selling_price Price, cusitems.customer_item_number,
               bname, baddress1, baddress2, baddress3, bstate,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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