首页 > 代码库 > 取客户的银行帐号SQL
取客户的银行帐号SQL
SELECT ibybanks.bank_name, --银行 ibybanks.bank_branch_name, --分行 ibybanks.bank_account_num_electronic--银行帐号 FROM iby_external_payers_all iepa, iby_pmt_instr_uses_all ipiua, iby_ext_bank_accounts_v ibybanks WHERE iepa.payment_function = ‘CUSTOMER_PAYMENT‘ AND iepa.cust_account_id =123456789--客户帐号ID AND ibybanks.bank_account_id = ipiua.instrument_id AND ipiua.instrument_type = ‘BANKACCOUNT‘ AND ipiua.ext_pmt_party_id = iepa.EXT_PAYER_ID AND ipiua.payment_function = ‘CUSTOMER_PAYMENT‘ AND sysdate BETWEEN ibybanks.start_date AND nvl(ibybanks.end_date,sysdate+1)
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。