PO: Invoices Associated with the Given Purchase Order Number:-


SELECT aip.invoice_id invoice_id,

b.po_number po_number

FROM ap_invoices_all aip,

(SELECT invoice_id,po_number FROM ( SELECT ai.invoice_id,

AP_INVOICES_PKG.GET_PO_NUMBER( ai.invoice_id) po_number


WHERE a.po_number <>&apos;UNMATCHED&apos;) b

where b.invoice_id=aip.invoice_id

and b.po_number= ‘Purchase Order Number’;

Credit and original article at – via Oracle Apps Training.

4 thoughts

Want to give some comment to author ( Shivmohan Purohit )

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s