This query gives you all the applied receipts for a particular customer account. It can also be filtered on the date range based on Receipt Date
SELECT hou.name bu_name,
acra.misc_payment_source,
acra.currency_code,
acra.receipt_number,
acra.receipt_date receipt_date,
hp.party_name customer_name,
acra.comments Receipt_Description
FROM ar_cash_receipts_all acra,
hz_cust_accounts hca,
hr_operating_units hou,
ar_receivable_applications_all ara,
hz_parties hp
WHERE acra.pay_from_customer = hca.cust_account_id
AND hca.party_id = hp.party_id
AND ara.cash_receipt_id = acra.cash_receipt_id
AND hou.organization_id = acra.org_id
AND hp.party_name LIKE ‘%ORACLE%TECH%’
–AND trunc(acra.receipt_date) BETWEEN NVL(:p_from_dte,acra.receipt_date) AND NVL(:p_to_dte,acra.receipt_date)