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

Report to show PO with its contract and RFQ details

edited Apr 15, 2024 7:55AM in Reporting and Analytics for SCM 1 comment

Hello Team,

I need to create a report which gives PO details and the contract / RFQ based on which those are created. I have found the below tables, please confirm if thee are correct.

For contracts :

There's a column contract_id in po_lines_all, and this contract_id corresponds to po_header_id of type blanket/contract. This way I can get all th po lines and its contract details.

For RFQs :

Pon_bid_po_numbers has po_header_id created against it. Also this table has auction_header_id corresponding to Pon_auction_headers_all from where I can get RFQ number. RFQ are not stored in po_headers_all in our project.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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