Supplier_Bank_Query

SELECT s.vendor_name, ss.vendor_site_code, eb.bank_name, ebb.bank_branch_name,
       ebb.branch_number, eba.bank_account_num, eba.bank_account_name,
       pmt.payment_method_code
  FROM hz_parties hz,
       ap.ap_suppliers s,
       ap.ap_supplier_sites_all ss,
       apps.iby_ext_bank_accounts eba,
       apps.iby_account_owners ao,
       apps.iby_ext_banks_v eb,
       apps.iby_ext_bank_branches_v ebb,
       apps.iby_ext_party_pmt_mthds pmt
 WHERE hz.party_id = s.party_id
   AND s.vendor_id = ss.vendor_id
   AND ao.account_owner_party_id = s.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 pmt.ext_pmt_party_id(+) = s.vendor_id