Oracle apps AR Cash Receipt for Bank Account Id

Hi, Please find the Bank Query to retrieve 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, […]