link between po and ap in oracle apps r12

link between po and ap in oracle apps r12

In this post, you will get the DB links between the PO and AP in oracle apps r12. The link between PO and AP only exists when the AP invoice matched the Purchase Order. When we will match the PO with the Ap invoices in Oracle then PO_distribution_id from po_distributions_all stores in the ap_invoice_distributions_all.

 

 

Tables Involved to link between po and ap in oracle apps r12

 

po_headers_all

po_distributions_all

ap_invoice_distributions_all

ap_invoices_all

 

 

link between po and ap in oracle apps r12

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 aid

       ,ap_invoices_all aia

 WHERE pha.po_header_id=pda.po_header_id

   AND aid.po_distribution_id=pda.po_distribution_id

   AND aia.invoice_id=aid.invoice_id

   AND pha.segment1=nvl(:P_PO_NUM,pha.segment1)

   AND aia.invoice_num=nvl(:P_INVOICE_NUM,aia.invoice_num)

 order by 2

;