Query to get the Customer Name, Account number, Transaction number , Receipt and Amount details

SELECT

  hca.account_number ,

  hp.party_name ,

  rcta.trx_number ,

  acra.receipt_number ,

  RCTA.TRX_DATE ,

  ACRA.CREATION_DATE ,

  acra.amount

FROM

HZ_PARTIES HP ,

HZ_CUST_ACCOUNTS HCA ,

RA_CUSTOMER_TRX_ALL RCTA ,

ar_cash_receipts_all acra ,

ar_receivable_applications_all aaa

WHERE AAA.APPLICATION_TYPE = 'CASH'

AND HP.PARTY_ID              = HCA.PARTY_ID

and RCTA.SOLD_TO_CUSTOMER_ID = HCA.CUST_ACCOUNT_ID

AND AAA.CASH_RECEIPT_ID = ACRA.CASH_RECEIPT_ID

AND AAA.APPLIED_CUSTOMER_TRX_ID = RCTA.CUSTOMER_TRX_ID

and acra.receipt_number      ='453753';