Oracle11i - AP-GL Transfer Detail Report

Hi All,

There is a requirement to prepare an Oracle Discoverer report to generate the AP-GL transfer detail.

As part of the requirement, we have the query to get the extract. There are few additional columns required to add in the report which are as follows:

-Pending Reason
-Invoice Total(still keeping line totals)
-Transfer to Project Accounting Date
-Change Organization(column G) to read 103,474 or 634
-Currency(USD or CAD)

In the already existing query, the following tables are used:

ap_invoices_all

ap_invoice_distributions_all

po_vendors

pa_projects_all

Can somebody let me know from which tables do i need to fetch the above mentioned columns.