EBS常用查询语句_查询银行账户

select t.bank_account_num,
       v.bank_name,
       v.bank_branch_name,
       t.bank_account_name
  from ce_bank_accounts t, ce_bank_branches_v v
 where 1 = 1
   and v.branch_party_id = t.bank_branch_id
   and t.bank_account_name not like '%失效%'
 order by v.bank_name, v.bank_branch_name