本文主要是介绍银行、支行、银行账号，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！
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 = p_customer_id--客户帐号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)
----------------------------------------------------------------------------------------------
1 银行账户表：ap_bank_accounts_all
分行（支行）表：ap_bank_branches
在新增银行账户时要选择对应的支行
2 供应商地点和银行账户对应关系表是：
ap_bank_account_uses_all ap_bank_account_uses_all中的vendor_site_id和external_bank_account_id
分别对应供应商地点表po_vendor_sites_all中的vendor_site_id和ap_bank_accounts_all中bank_account_id
3 供应商的银行账户不要维护科目组合（应该是地点中存在的ccid关联到了科目组合）
这篇关于银行、支行、银行账号的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！
