Query to get Vendor Bank Detail in Oracle Fusion

SELECT DISTINCT psv.vendor_id

      ,psv.vendor_name

  ,pssa.vendor_site_id

      ,accts.ext_bank_account_id

      ,bank.party_name bank_name

      ,branch.bank_branch_name

      ,accts.bank_account_type

      ,accts.country_code

      ,accts.bank_account_name

      ,accts.attribute1 ifsc_code

      ,accts.bank_account_num

      ,accts.currency_code

  FROM poz_suppliers_v psv

      ,poz_supplier_sites_all_m pssa

      ,iby_pmt_instr_uses_all uses

      ,iby_external_payees_all payee

      ,iby_ext_bank_accounts accts

      ,hz_parties bank

      ,ce_bank_branches_v branch

 WHERE psv.vendor_id      = pssa.vendor_id

   AND psv.party_id       = payee.payee_party_id

   AND payee.ext_payee_id = uses.ext_pmt_party_id

   AND uses.instrument_id = accts.ext_bank_account_id

   AND accts.bank_id      = bank.party_id

   AND accts.branch_id    = branch.branch_party_id

   --AND payee.payment_function = 'PAYABLES_DISB'