Banki dostawców

 
 
 
SELECT   s.vendor_name ,
  ss.vendor_site_code ,
  eb.bank_name        ,
  EB.BANK_NAME_ALT    ,
  ebb.bank_branch_name,
  ebb.branch_number   ,
  eba.bank_account_num,
  eba.bank_account_name
FROM 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
WHERE 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;