取客户的银行帐号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)
郑重声明:本站内容如果来自互联网及其他传播媒体,其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享,并不代表本站赞同其观点和对其真实性负责,也不构成任何其他建议。