The below given Bank Query retrieves data for AR Cash Receipt Number

SELECT   APBB.BANK_NAME BANK_ACCOUNT_NAME ,
APBAA.BANK_ACCOUNT_NUM BANK_ACCOUNT_NUM,
APBAA.BANK_ACCOUNT_ID,
HP.PARTY_NAME CUSTOMER_NAME,
HCA.ACCOUNT_NUMBER CUSTOMER_NUMBER,
ACR.PAY_FROM_CUSTOMER CUST_ACCOUNT_ID,
ACR.RECEIPT_NUMBER RECEIPT_NUMBER,
ACR.CURRENCY_CODE,
ACR.SET_OF_BOOKS_ID,
ACR.TYPE,
ACR.DEPOSIT_DATE DEPOSIT_DATE,
ACR.RECEIPT_DATE RECEIPT_DATE,
ACR.AMOUNT RECEIPT_AMOUNT ,
ARM.NAME DOCUMENT_TYPE
FROM
HZ_PARTIES HP,
HZ_CUST_ACCOUNTS_ALL HCA,
AR_CASH_RECEIPTS_ALL ACR,
AR_RECEIPT_METHODS ARM,
AR_RECEIPT_CLASSES ARC,
AP_BANK_ACCOUNTS_ALL APBAA,
AP_BANK_BRANCHES APBB
WHERE       1 = 1
AND ACR.CONFIRMED_FLAG = 'Y'
AND ACR.PAY_FROM_CUSTOMER = HCA.CUST_ACCOUNT_ID(+)
AND HP.PARTY_ID(+) = HCA.PARTY_ID
AND ACR.REMITTANCE_BANK_ACCOUNT_ID = APBAA.BANK_ACCOUNT_ID(+)
AND APBB.BANK_BRANCH_ID(+) = APBAA.BANK_BRANCH_ID
AND ACR.RECEIPT_METHOD_ID = ARM.RECEIPT_METHOD_ID
AND ARM.RECEIPT_CLASS_ID = ARC.RECEIPT_CLASS_ID
--AND APBAA.Bank_Account_Id = NVL (:p_bank_account_id, APBAA.Bank_Account_Id)
AND ACR.RECEIPT_NUMBER = '538AR201507030'
--AND TRUNC (acr.receipt_date) >= '31-MAY-2015'
-- AND TRUNC (acr.receipt_date) <= '30-JUN-2015'
ORDER BY ACR.RECEIPT_DATE DESC