Query to find AR invoice Journal details in Oracle Fusion

 select distinct
customer_trx_id,
trx_number invoice_number, 
trx_date invoice_date,
(select trx_number from ra_customer_trx_all rcm
where rcm.previous_customer_trx_id = rcta.customer_trx_id and rownum <=1) cm_number,
(select name from ra_terms_vl rt where rt.term_id = rcta.term_id and rownum <=1) payment_term_name, 
(select description from ra_terms_vl rt where rt.term_id = rcta.term_id and rownum <=1) payment_term_desc, 
NVL((SELECT SUM(extended_amount)
FROM ra_customer_trx_lines_all lines
WHERE lines.customer_trx_id = rcta.customer_trx_id
),0) invoice_amount,
rcta.end_date_commitment,
rcta.start_date_commitment,
rcta.batch_id,
(select rba.name from ra_batches_all rba where rba.batch_id = rcta.batch_id and rownum <=1) batch_name,
--rcta.ct_reference,
--previous_customer_trx_id
gjh.period_name
from ra_customer_trx_all rcta,
gl_je_headers gjh,
gl_je_lines gjl,
gl_import_references imp,
xla_ae_lines xal,
xla_ae_headers xah,
xla_events xe,
xla_transaction_entities xte
where 1=1
--and previous_customer_trx_id is not null
AND gjh.je_source = 'Receivables'
AND gjh.je_header_id = gjl.je_header_id
AND gjl.je_header_id = imp.je_header_id
AND gjl.je_line_num = imp.je_line_num
AND imp.gl_sl_link_id = xal.gl_sl_link_id
AND imp.gl_sl_link_table = xal.gl_sl_link_table
AND xal.application_id = xah.application_id
AND xal.ae_header_id = xah.ae_header_id
AND xah.application_id = xe.application_id
AND xah.event_id = xe.event_id
AND xe.application_id = xte.application_id
--AND xte.application_id = 222
AND xe.entity_id = xte.entity_id
AND xte.entity_code = 'TRANSACTIONS'
AND xte.source_id_int_1 = rcta.customer_trx_id
and rcta.customer_trx_id =181754
INV23994226
111100001030
select distinct
rcta.customer_trx_id,
rcta.trx_number invoice_number, 
rcta.trx_date invoice_date,
(select trx_number from ra_customer_trx_all rcm
where rcm.previous_customer_trx_id = rcta.customer_trx_id and rownum <=1) cm_number,
(select name from ra_terms_vl rt where rt.term_id = rcta.term_id and rownum <=1) payment_term_name, 
(select description from ra_terms_vl rt where rt.term_id = rcta.term_id and rownum <=1) payment_term_desc, 
/*NVL((SELECT SUM(extended_amount)
FROM ra_customer_trx_lines_all lines
WHERE lines.customer_trx_id = rcta.customer_trx_id
),0) invoice_amount,*/
rctla.extended_amount invoice_amount,
rctla.attribute6 start_date,
rctla.attribute7 end_date,
--rcta.end_date_commitment,
--rcta.start_date_commitment,
rcta.batch_id,
(select rba.name from ra_batches_all rba where rba.batch_id = rcta.batch_id and rownum <=1) batch_name,
(select attribute28 from hz_cust_accounts hca where rcta.bill_to_customer_id  = hca.cust_account_id and rownum <=1) account_id,
--rcta.ct_reference,
--previous_customer_trx_id
gjh.period_name
from ra_customer_trx_all rcta,
ra_customer_trx_lines_all rctla,
gl_je_headers gjh,
gl_je_lines gjl,
gl_import_references imp,
xla_ae_lines xal,
xla_ae_headers xah,
xla_events xe,
xla_transaction_entities xte
where 1=1
--and previous_customer_trx_id is not null
AND rcta.customer_trx_id = rctla.customer_trx_id
AND gjh.je_source = 'Receivables'
AND gjh.je_header_id = gjl.je_header_id
AND gjl.je_header_id = imp.je_header_id
AND gjl.je_line_num = imp.je_line_num
AND imp.gl_sl_link_id = xal.gl_sl_link_id
AND imp.gl_sl_link_table = xal.gl_sl_link_table
AND xal.application_id = xah.application_id
AND xal.ae_header_id = xah.ae_header_id
AND xah.application_id = xe.application_id
AND xah.event_id = xe.event_id
AND xe.application_id = xte.application_id
--AND xte.application_id = 222
AND xe.entity_id = xte.entity_id
AND xte.entity_code = 'TRANSACTIONS'
AND xte.source_id_int_1 = rcta.customer_trx_id
--and rcta.customer_trx_id =181754
--and rcta.trx_number in ('INV23994226','111100001030')
and rcta.bill_to_customer_id is not null