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.

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


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.


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