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;