Query for Contract Review is not fetching rows.
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,
0