Query to obtain information on Receipt Application on Transactions

SELECT
   hp.party_number,
   hp.party_name,
   hca.account_number,
   hca.account_name,
   hca.orig_system_reference,
   hps.party_site_number,
   acra.receipt_number,
   to_char(acra.receipt_date, 'MM/DD/YYYY') AS receipt_date,
   decode(acra.status, 'APP', 'Applied', 'UNAPP', 'Unapplied', 'UNID', 'Unidentified', 'NSF', 'Nonsufficient Funds', 'REV', 'Reversed Receipt', 'STOP', 'Stop Payment') AS receipt_status,
   arm.name receipt_method_name,
   rcta.trx_number AS transaction_number,
   to_char(rcta.trx_date, 'MM/DD/YYYY') AS transaction_date,
   rtt.name AS payment_term,
   trunc (acra.receipt_date) - trunc(rcta.trx_date) AS days_taken_for_payment
FROM
   ar_cash_receipts_all acra,
   hz_cust_accounts hca,
   ar_receipt_methods arm,
   hz_parties hp,
   hz_cust_acct_sites_all hcasa,
   hz_party_sites hps,
   ra_customer_trx_all rcta,
   hz_cust_site_uses_all hcsua,
   ra_terms_tl rtt,
   ar_receivable_applications_all araa
WHERE
   1 = 1
   AND hp.party_id = hca.party_id
   AND hca.cust_account_id = acra.pay_from_customer
   AND arm.receipt_method_id = acra.receipt_method_id
   AND hca.cust_account_id = hcasa.cust_account_id
   AND hps.party_site_id = hcasa.party_site_id
   AND rcta.bill_to_customer_id = hca.cust_account_id
   AND rcta.bill_to_site_use_id = hcsua.site_use_id
   AND hcsua.cust_acct_site_id = hcasa.cust_acct_site_id
   AND rtt.term_id = rcta.term_id
   AND araa.cash_receipt_id = acra.cash_receipt_id
   AND araa.status = 'APP'
   AND araa.applied_customer_trx_id = rcta.customer_trx_id
   AND trunc(acra.receipt_date) >= trunc(sysdate - 365)
ORDER BY
acra.receipt_number,
rcta.trx_number