Thursday, March 23, 2017

How to join GL tables with XLA (SubLedger Accounting) table


  • GL_JE_BATCHES (je_batch_id) => GL_JE_HEADERS (je_batch_id)

  • GL_JE_HEADERS (je_header_id) => GL_JE_LINES (je_header_id)

  • 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 (application_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) 

1 comment:

Powered By Blogger