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
Quick Links:
Do you have
an Oracle Question?
Best regards,
Oracle Database, SQL,
Application, Programming Tips
All the site contents are Copyright © www.sap-img.com
and the content authors. All rights reserved.
All product names are trademarks of their respective
companies.
The site www.sap-img.com is not affiliated with or endorsed
by any company listed at this site.
Every effort is made to ensure the content integrity.
Information used on this site is at your own risk.
The content on this site may not be reproduced
or redistributed without the express written permission of
www.sap-img.com or the content authors.