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

AR to GL flow in oracle apps r12

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'