link between ar and gl in oracle apps r12.link between ar and xla tables

Link between AR and GL in oracle apps r12.link between AR and XLA tables

 

 

AR to GL flow in oracle apps r12

In this post , i will share the XML linking between all the oracle modules to GL. We all know that all the Data flows from Different modules to General Ledger through XLA. XLA is the only link between GL and other sub-ledger modules.

link between ar and xla tables

SELECT GLB.NAME ,

GLB.description ,

gjh.je_category,

gjh.je_source,

gjh.period_name ,

gjh.NAME ,

gjh.status ,

gjh.description ,

gjl.je_line_num

FROM gl_je_batches GLB,

gl_je_headers gjh,

gl_je_lines gjl,

gl_code_combinations_kfv glcc,

gl_import_references gir,

xla_ae_lines xlal,

xla_ae_headers xlah,

xla_events xlae,

xla_transaction_entities xlate,

ra_customer_trx_all rct

WHERE GLB.je_batch_id = gjh.je_batch_id

AND gjh.je_header_id = gjl.je_header_id

AND xlal.code_combination_id = glcc.code_combination_id

AND gjl.je_header_id = gir.je_header_id

AND gjl.je_line_num = gir.je_line_num

AND gir.gl_sl_link_table = xlal.gl_sl_link_table

AND gir.gl_sl_link_id = xlal.gl_sl_link_id

AND xlal.ae_header_id = xlah.ae_header_id

AND xlah.event_id = xlae.event_id

AND xlae.entity_id = xlate.entity_id

AND xlae.application_id = xlate.application_id

AND gjh.je_source = 'Receivables'

AND rct.trx_number = xlate.transaction_number

AND xlate.transaction_number = :trx_number;

AND gcc.CODE_COMBINATION_ID = XAL.CODE_COMBINATION_ID

AND gcc.CODE_COMBINATION_ID = gjl.CODE_COMBINATION_ID

AND gjh.STATUS = 'P'

AND gjh.Actual_flag = 'A'