Query to get the bank account assigned to supplier

SELECT sup.segment1 Vendor_Num,
       sup.vendor_name,
       sit.vendor_site_code,
       ext.BANK_ACCOUNT_NUM,
       inst.creation_date Bank_Acct_Assign_Date
  FROM apps.ap_suppliers sup,
       apps.ap_supplier_sites_all sit,
       apps.iby_ext_bank_Accounts ext,
       apps.iby_account_owners own,
       apps.iby_external_payees_all pay,
       apps.iby_pmt_instr_uses_all inst
 WHERE     1 = 1
       AND sup.vendor_id = sit.vendor_id
       AND own.ACCOUNT_OWNER_PARTY_ID = sup.party_id
       AND ext.EXT_BANK_ACCOUNT_ID = own.EXT_BANK_ACCOUNT_ID
       AND pay.supplier_site_id = sit.vendor_site_id
       AND pay.payee_party_id = sup.party_id
       AND pay.EXT_PAYEE_ID = inst.ext_pmt_party_id
       AND inst.INSTRUMENT_ID = ext.EXT_BANK_ACCOUNT_ID
       AND sup.segment1 = '201671'