Query to Get PO, Receipt, Invoice Number in Oracle Apps R12 This query will extract Receipt number and Invoice Number which are raised against PO number in Oracle R12 Application
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 |
SELECT DISTINCT pha.segment1 po_number, aia.invoice_num invoice_number, rsh.receipt_num receipt_number FROM po_headers_all pha, po_distributions_all pda, ap_invoice_distributions_all aida, ap_invoices_all aia, rcv_shipment_lines rsl, rcv_shipment_headers rsh WHERE pha.po_header_id = pda.po_header_id AND aida.po_distribution_id = pda.po_distribution_id AND aia.invoice_id = aida.invoice_id AND rsl.po_header_id = pha.po_header_id AND rsl.shipment_header_id = rsh.shipment_header_id; |