Report to show PO with its contract and RFQ details
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.
0