![Invoices Associated with the Given Purchase Order Number, www.askhareesh.com](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjeiBI26jmUrpiPyrfrJpwRbKgZvnwLizGaCKrITTkSEqwDD_sEuqP_9Mk9xrcR4DOqZN4uu_-trmS47HzhZBAu6et8VGF9gJoZkr7gPZ2NLr2IB8Y0JtSWeuon8j_Ir4uK6ZvsdmvV9KI/s200/AskHareesh.png)
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 <>'UNMATCHED') b where b.invoice_id=aip.invoice_id and b.po_number= ‘Purchase Order Number’;
No comments:
Post a Comment