R12 - How to link GL data to the subledger data or vice versa
Submitted by vamsi kasina on Sat, 2009-06-06 13:16

gl_je_lines (je_header_id, je_line_num) -> gl_import_references (je_header_id, je_line_num) gl_import_references (gl_sl_link_table, gl_sl_link_id) -> xla_ae_lines (gl_sl_link_table, gl_sl_link_id) xla_ae_lines (applicaiton_id, ae_header_id) -> xla_ae_headers (application_id, ae_header_id) xla_ae_headers (application_id, event_id) -> xla_events (application_id, event_id) xla_events (application_id, entity_id) -> xla.xla_transaction_entities (application_id, entity_id)
xla.xla_transaction_entities (source_id_int_1, etc) after filtering by application_id, entity_code and ledger_id -> subledger's table(its key columns mentioned in xla_entity_id_mappings) for that ledger_id For Ex: xla.xla_transaction_entities (source_id_int_1) filtered by application_id 200, entity_code AP_INVOICES and ledger_id -> ap_invoices_all (invoice_id) for that set_of_books_id.
»
- vamsi kasina's blog
- Login to post comments
