Invoice and purchase order

This forum is to discuss different features/issues of Oracle Financials modules ( GL - General Ledger, AP - Accounts Payable, AR - Accounts Receivable, FA - Fixed Assets & CM - Cash Management ).
Post Reply
masaf
Posts: 10
Joined: Sat Mar 10, 2007 12:01 pm
Location: USA

Invoice and purchase order

Post by masaf »

While AP_INVOICES_ALL has invoice info, what table can I join with it to get the Purchase order number for the invoice?
masaf
Posts: 10
Joined: Sat Mar 10, 2007 12:01 pm
Location: USA

Post by masaf »

Answered my own question with Metalink research:

If invoice is matched to a PO, then the po_distribution_id will be populated in ap_invoice_distributions_all table. po_distribution_id is the link between ap_invoice_distributions_all table and PO_Distributions_All table.
Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest