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'