I want to develop a Creditors Ledger which will be generated after GL posting of AP data is done.  I want to take data from AP_AE_HEADERS_ALL and AP_AE_LINES_ALL. Then I want to join each record with the base table to which it pertains to get additional information needed for the ledger.
 

AP_AE_HEADERS_ALL is linked to AP_ACCOUNTING_EVENTS_ALL by ACCOUNTING_EVENT_ID

In AP_ACCOUNTING_EVENTS_ALL you will find source_table which will give you which transaction table to retrieve the data for the particular record from and source_id is the transaction id.

Illustrating this with an example....

If you are looking at a record in ap_accounting_events_all which has source_table as AP_INVOICES...then the source_id is the invoice_id and if the table name is AP_CHECKS then the source_id is the check_id

Accordingly you will get the link to the base table.

Cerina

Have a Oracle Question
Do you have an Oracle Question?

Oracle Books
Oracle Certification, Database Administration, SQL, Application, Programming Reference Books

Oracle Application
Oracle Application Hints and Tips

Oracle Home
Oracle Database, SQL, Application, Programming Tips