Re: Oracle Apps., AP Table connections needed

From: Tim <t.camden_at_chello.nl>
Date: 15 Jan 2005 23:52:23 -0800
Message-ID: <6bb82815.0501152352.3c9fc5e9@posting.google.com>

This is for Oracle Applications 11i, 11.5.8 using RDBMS 8.1.7.4.0.

Also using all the supporting oracle financials software, i.e., GL, AR, FA, PO, CE, etc. Imoorting a new join / Discoverer Business Area to support this query, so that will be the supporting part of the EUL.

The report is just reporting the revenue actually paid to suppliers between certain dates, but needs the account and address for the correct site in relation to the supplier (the one paying).

I am using the standard views from oracle applications 11i screens (found in record history), but not finding the right table / View to link in order to isolate the specific account and address used for payment. Similar problem for the link to the flexfield values used for payment in the distributions from the invoice in AP.

Really need an overview of AP tables and basic connections for Oracle applications 11i finanacials Received on Sun Jan 16 2005 - 01:52:23 CST