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 = 1128--客户帐号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)
EBS获取客户银行信息的SQL
最新推荐文章于 2024-03-11 10:35:21 发布