Customer Experience Blog

AP Invoices Associated with the Given Purchase Order Number

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 FROM AP_INVOICES_ALL AI) A 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.

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

FROM AP_INVOICES_ALL AI) A

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.

Extra tips : Learnings from Good Managers v/s Bad Managers
Oracle Books – Packt – Exclusive Offer on Print Books – Buy 2 for the Price of 1

Receive the latest blog updates

Facebook Twitter Instagram Youtube Linkedin