AP Supplier Bank Info Query

 SELECT hou.name operating_unit,
  av.vendor_name                ,
  av.segment1 vendor_number     ,
  assa.vendor_site_code          ,
  eb.bank_name                 ,
  ebb.bank_branch_name         ,
  ebb.branch_number            ,
  eba.bank_account_num         ,
  eba.bank_account_name
   FROM ap.ap_suppliers av         ,
  ap.ap_supplier_sites_all assa     ,
  apps.iby_ext_bank_accounts eba  ,
  apps.iby_account_owners ao      ,
  apps.iby_ext_banks_v eb         ,
  apps.iby_ext_bank_branches_v ebb,
  hr_operating_units hou
  WHERE av.vendor_id           = assa.vendor_id
AND ao.account_owner_party_id = av.party_id
AND eba.ext_bank_account_id   = ao.ext_bank_account_id
AND eb.bank_party_id          = ebb.bank_party_id
AND eba.branch_id             = ebb.branch_party_id
AND eba.bank_id               = eb.bank_party_id
AND assa.org_id                 =hou.organization_id
AND assa.org_id                 =89 ;