Query to findout Credit memo details in oracle fusion

 select distinct
hca_bill.status account_status,
hca_bill.attribute28 account_id, 
hca_bill.account_number,
hcsua_bill.cust_acct_site_id,
hp_bill.party_name,
rcta.invoice_currency_code Currency,
decode(rcta.complete_flag,'Y','complete') credit_memo_status,
rcta.customer_trx_id credit_memo_id,
rcta.trx_number credit_memo_number, 
rcta.trx_date credit_memo_date,
rctla.line_type, 
decode(rctla.line_type,'LINE',rctla.extended_amount,0) without_tax_amount,
decode(rctla.line_type,'TAX',rctla.extended_amount,0) tax_amount,
rctla.extended_amount total_amount,
rcta.attribute_category transaction_source,
--decode((select count(*)  from xla_transaction_entities xte where rcta.customer_trx_id = xte.source_id_int_1 AND xte.entity_code = 'TRANSACTIONS' and rownum <=1),1,'Yes','No') accounting_status,
--decode((select distinct 'Y'  from xla_transaction_entities xte where xte.source_id_int_1=rcta.customer_trx_id AND xte.entity_code = 'TRANSACTIONS' and rownum <=1),'Y','Yes','No') accounting_status,
rctla.created_by,
rctla.creation_date,
(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, 
hl.state,
hl.country,
(select trx_number from ra_customer_trx_all rcm
where rcm.customer_trx_id = rcta.previous_customer_trx_id and rownum <=1) invoice_number,
rctla.attribute3 opp_id,
hou.name
from ra_customer_trx_all rcta,
ra_customer_trx_lines_all rctla,
ra_cust_trx_types_all rctta,
hr_operating_units hou,
hz_cust_accounts hca_bill,
hz_parties hp_bill,
hz_cust_site_uses_all hcsua_bill,
hz_cust_acct_sites_all hcasa_bill,
hz_party_sites hps_bill,
hz_locations hl
where 1=1
AND rcta.customer_trx_id = rctla.customer_trx_id
AND rcta.cust_trx_type_seq_id = rctta.cust_trx_type_seq_id 
AND rcta.bill_to_customer_id = hca_bill.cust_account_id
AND rcta.org_id = hou.organization_id
AND hca_bill.party_id = hp_bill.party_id
AND rcta.bill_to_site_use_id = hcsua_bill.site_use_id
AND hcsua_bill.cust_acct_site_id = hcasa_bill.cust_acct_site_id
AND hcasa_bill.party_site_id = hps_bill.party_site_id
AND hps_bill.location_id = hl.location_id
AND rcta.previous_customer_trx_id is not null
AND rcta.trx_number = nvl(:p_from_inv_number,rcta.trx_number) 
AND rcta.trx_number <= nvl(:p_to_inv_number,rcta.trx_number) 
AND rctta.type = nvl(:p_transaction_class,rctta.type)
AND hou.organization_id = nvl(:p_business_unit,hou.organization_id)
--and rcta.trx_number in  ('CM00849945','CM01249142')