Query to find AR transaction details in oracle fusion

 SELECT
hou.name business_unit,
rcta.trx_number transaction_number,
rcta.creation_date transaction_creation_date,
rcta.trx_date transaction_date,
apsa.due_date,
rcta.invoice_currency_code transaction_Currency,
hp_bill.party_name customer_name,
hca_bill.account_number customer_account_number,
hca_bill.attribute2 customer_site_id,
apsa.amount_due_original entered_amount,
round(apsa.amount_due_original * nvl(apsa.exchange_rate,1),2) accounted_amount_usd,
apsa.amount_due_remaining balance_amount_foreign_currency,
round(apsa.amount_due_remaining * nvl(apsa.exchange_rate,1),2) balance_amount_usd,
rcta.customer_trx_id
FROM ra_customer_trx_all rcta,
ar_payment_schedules_all apsa,
hr_operating_units hou,
hz_cust_accounts hca_bill,
hz_parties hp_bill
where 1=1
AND rcta.customer_trx_id = apsa.customer_trx_id
AND rcta.org_id = hou.organization_id
AND rcta.bill_to_customer_id = hca_bill.cust_account_id
AND hca_bill.party_id = hp_bill.party_id
AND rcta.trx_date >= nvl(:p_from_date,rcta.trx_date)
AND rcta.trx_date <= nvl(:p_to_date,rcta.trx_date)
AND hou.organization_id = nvl(:p_business_unit,hou.organization_id)
--AND rcta.trx_number in ('INV23994226','111100001030','99999100000000')