Query to get AR Customer Receipt data in Oracle Apps R12

The blog provides the SQL Query to get Customer specific receipt details in Oracle Receivables R12

Query to get AR Customer Receipt data in Oracle Apps R12

SELECT 	ACRA.CASH_RECEIPT_ID,
DECODE (	 ACRA.TYPE,
			 'CASH', 'CASH RECEIPT RECEIPT',
			 'MISC', 'MISCELLANEOUS',
			 ACRA.TYPE
		) RECEIPT_TYPE,
		ACRA.CURRENCY_CODE,
		ACRA.DOC_SEQUENCE_VALUE RECEIPT_NUMBER,
		ACRA.RECEIPT_NUMBER REFERENCE_NUMBER,
		TRUNC (ACRA.RECEIPT_DATE) RECEIPT_DATE, 
		HP.PARTY_NAME RECEIVED_FROM,
		ACRA.MISC_PAYMENT_SOURCE,
		HCA.ACCOUNT_NUMBER CUSTOMER_NO,
		NVL (ACRA.AMOUNT, 0) ENTERED_AMOUNT,
		NVL (ACRA.AMOUNT, 0) * NVL (ACRA.EXCHANGE_RATE, 1) FUNCTIONAL_AMOUNT,
		ARM.NAME PAYMENT_METHOD,
		ABAA.BANK_ACCOUNT_NUM BANK_ACC_NUM,
		ABB.BANK_NAME,
		ABB.BANK_BRANCH_NAME,
		ACRA.COMMENTS DESCRIPTION
FROM 	AR_CASH_RECEIPTS_ALL ACRA,
		AR_RECEIPT_METHODS ARM,
		AP_BANK_ACCOUNTS_ALL ABAA,
		AP_BANK_BRANCHES ABB,
		HZ_CUST_ACCOUNTS HCA,
		HZ_PARTIES HP
WHERE 	ACRA.PAY_FROM_CUSTOMER = HCA.CUST_ACCOUNT_ID(+)
AND 	ACRA.ORG_ID = ABAA.ORG_ID(+)
AND 	HCA.PARTY_ID = HP.PARTY_ID(+)
AND 	ACRA.RECEIPT_METHOD_ID = ARM.RECEIPT_METHOD_ID
AND 	ACRA.REMITTANCE_BANK_ACCOUNT_ID = ABAA.BANK_ACCOUNT_ID
AND 	ABAA.BANK_BRANCH_ID = ABB.BANK_BRANCH_ID
AND 	HCA.CUST_ACCOUNT_ID = '<CUTOMER_ACCOUNT_ID>'
ORDER BY TRUNC (ACRA.RECEIPT_DATE), ACRA.DOC_SEQUENCE_VALUE;