SQL Query to identify the Bank details of Supplier/Customer in Oracle Apps r12

Customer Banks

select DISTINCT ac.customer_name

,ac.customer_number
from iby_pmt_instr_uses_all instr_assign,iby_external_payers_all payee,iby_ext_bank_accounts bankacct,hz_cust_accounts_all hcal,ar_customers acwhere instr_assign.instrument_id = bankacct.ext_bank_account_id
and instr_assign.ext_pmt_party_id = payee.ext_payer_id
and instr_assign.instrument_type = 'BANKACCOUNT'and instr_assign.payment_flow = 'FUNDS_CAPTURE'and instr_assign.payment_function = 'CUSTOMER_PAYMENT'and hcal.cust_account_id = payee.cust_account_id
and ac.customer_number = hcal.account_number
and bankacct.bank_account_num = '22090402' (Pass Banks Account or leave blank)

Suppliers Bank Details

SELECT (SELECT VENDOR_NAME
FROM PO_VENDORS POV
WHERE POV.VENDOR_ID=PVS.VENDOR_ID ) SUPPLIER_NAME,PVS.VENDOR_ID,(SELECT SEGMENT1 FROM PO_VENDORS POV
WHERE POV.VENDOR_ID=PVS.VENDOR_ID ) VENDOR_NUMBER,PVS.VENDOR_SITE_CODE,BANKACCT.BANK_ACCOUNT_NAME,BANKACCT.BANK_ACCOUNT_NUM
FROM IBY_PMT_INSTR_USES_ALL INSTR_ASSIGN,IBY_EXTERNAL_PAYEES_ALL PAYEE,IBY_EXT_BANK_ACCOUNTS BANKACCT,CE_BANK_BRANCHES_V CEBRANCH,PO_VENDOR_SITES_ALL PVS,IBY_ACCOUNT_OWNERS IAOWHERE INSTR_ASSIGN.INSTRUMENT_ID = BANKACCT.EXT_BANK_ACCOUNT_ID
AND INSTR_ASSIGN.EXT_PMT_PARTY_ID = PAYEE.EXT_PAYEE_ID
AND INSTR_ASSIGN.INSTRUMENT_TYPE = 'BANKACCOUNT'AND INSTR_ASSIGN.PAYMENT_FLOW = 'DISBURSEMENTS'AND BANKACCT.BRANCH_ID = CEBRANCH.BRANCH_PARTY_ID(+)AND IAO.EXT_BANK_ACCOUNT_ID= BANKACCT.EXT_BANK_ACCOUNT_ID
AND IAO.ACCOUNT_OWNER_PARTY_ID =PAYEE_PARTY_ID
AND PAYEE.SUPPLIER_SITE_ID =PVS.VENDOR_SITE_ID
AND PAY_SITE_FLAG ='Y'
AND BANKACCT.BANK_ACCOUNT_NUM='00266471' (Pass Banks Account or leave blank)