Re: Oracle Apps., AP Table connections needed

Tim wrote:

> Hello,
>
> I am trying to build a tax report in Discoverer for Oracle Accounts
> Payables.
>
> My problem is isolating the the specific location for address, account
> actually paid etc.
>
> In my join I get all addresses and accounts from the locations of the
> supplier when I only want the paying location and its details.
>
> Does somebody know the AP tables and exactly which table isolates:
> 1.) The paid bank account from payments and which ID to link on, like
> Vendor_ID etc?
>
> 2.) The Flexfield values for the paid distributions in the invoice,
> same thing
> really.
>
> I already have the AP_Invoices_V and directly connecting tables
> mapped!
> Lastly, I obviously don't have any other ideas for finding this
> information yet. So, if you have any kind of suggestion to get the
> info elsewhere it would be greatly appreciated.
>
> Thanks,
> Tim

Your questions are totally dependent upon: 1. Actual accounting software. Who made it? What version? 2. The end-user layer created by the system's administrator

You will need to check internally for the answers.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)


----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= East/West-Coast Server Farms - Total Privacy via Encryption =---