Query to get the Supplier Bank details in Oracle Apps

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,
       ap_supplier_sites_all pvs,
       iby_account_owners iao
 WHERE 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='0123456789' --<<Pass Banks Account Num>>)