--R12供应商银行账户SQL:
SELECT APS.VENDOR_NAME,
APS.SEGMENT1 VENDOR_CODE,
HP_BANK.PARTY_NAME AS BANK_NAME,
IEBA.BANK_ACCOUNT_NAME,
IEBA.BANK_ACCOUNT_NUM,
HP_BRANCH.PARTY_NAME AS BRANCH_NAME,
HP_BANK.PARTY_ID AS BANK_ID,
HP_BRANCH.PARTY_ID AS BRANCH_ID,
IEBA.EXT_BANK_ACCOUNT_ID,
APS.VENDOR_ID,
(SELECT meaning
FROM fnd_lookup_values_vl
WHERE lookup_code = APS.vendor_type_lookup_code
AND lookup_type = 'VENDOR TYPE') vendor_type,
apt.name term_name
FROM AP_SUPPLIERS APS,
IBY_ACCOUNT_OWNERS IAO,
IBY_EXT_BANK_ACCOUNTS IEBA,
HZ_PARTIES HP_BANK,
R12供应商银行账户SQL
最新推荐文章于 2022-09-22 09:55:54 发布
这是一个关于Oracle R12系统的SQL查询,用于获取供应商的银行账户详细信息,包括供应商名称、代码、银行名称、账户名、账户号、分行名等。查询涉及AP_SUPPLIERS、IBY_ACCOUNT_OWNERS、HZ_PARTIES等多个关键表,并通过不同条件进行联接。查询结果按供应商名称排序。
摘要由CSDN通过智能技术生成