Join between AR and GL in Oracle Applications

SELECT *
  FROM xla.xla_transaction_entities xte,
       ra_customer_trx_all rcta,
       xla_events xe,
       xla_ae_headers xah,
       xla_ae_lines xal,
       gl_import_references gim,
       gl_je_headers gjh
 WHERE     xte.source_id_int_1 = rcta.customer_trx_id
       AND xte.entity_code = 'TRANSACTIONS'
       AND trx_number = :p_trx_number
       AND xte.entity_id = xe.entity_id
       AND xe.event_id = xah.event_id
       AND xah.ae_header_id = xal.ae_header_id
       AND xal.gl_sl_link_id = gim.gl_sl_link_id
       AND gim.je_header_id = gjh.je_header_id