In this post we’ll see query to get PO payment details in Oracle Fusion Cloud, this query will help you to find if PO purchase order payment is done in Oracle Fusion.
SELECT aca.check_number
FROM ap_invoices_all aia
,ap_invoice_distributions_all aid
,po_distributions_all pod
,po_headers_all poa
,ap_invoice_payments_all aip
,ap_checks_all aca
where aia.invoice_id = aid.invoice_id
and aid.po_distribution_id = pod.po_distribution_id
and pod.po_header_id = poa.po_header_id
and aia.invoice_id = aip.invoice_id
and aip.check_id = aca.check_id
and aia.payment_status_flag = ‘Y’
and poa.po_header_id = :p_po_header_id