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;