Supplier Bank Tables:
In this post, we will discuss about supplier bank tables in oracle fusion. Supplier bank tables stores bank information like account number, account name, bank name, branch detail, IBAN, foreign currency flag (if bank allows transaction in foreign currency). I will also share the detailed query of supplier bank below of this post.
Supplier bank tables in oracle fusion:
- POZ_SUPPLIERS_V
- POZ_SUPPLIER_SITES_V
- IBY_EXTERNAL_PAYEES_ALL
- IBY_PMT_INSTR_USES_ALL
- IBY_EXT_BANK_ACCOUNTS
- CE_BANKS_V
- CE_BANK_BRANCHES_V
Detailed Query of Supplier Bank Information
SELECT psv.vendor_name,
psv.segment1 vendor_number,
ieba.bank_account_num,
ieba.bank_account_name,
cbv.bank_name,
cbbv.bank_branch_name,
cbbv.branch_number
FROM poz_suppliers_v psv,
poz_supplier_sites_v pssv,
iby_external_payees_all iepa,
iby_pmt_instr_uses_all ipua,
iby_ext_bank_accounts ieba,
ce_banks_v cbv,
ce_bank_branches_v cbbv
WHERE 1=1
AND psv.vendor_id = pssv.vendor_id
AND psv.party_id = iepa.payee_party_id
AND ipua.ext_pmt_party_id(+) = iepa.ext_payee_id
AND ieba.ext_bank_account_id(+) = ipua.instrument_id
AND ieba.bank_id = cbv.bank_party_id(+)
AND ieba.branch_id = cbbv.branch_party_id(+);
ieba.bank_account_num,
ieba.bank_account_name,
cbv.bank_name,
cbbv.bank_branch_name,
cbbv.branch_number
FROM poz_suppliers_v psv,
poz_supplier_sites_v pssv,
iby_external_payees_all iepa,
iby_pmt_instr_uses_all ipua,
iby_ext_bank_accounts ieba,
ce_banks_v cbv,
ce_bank_branches_v cbbv
WHERE 1=1
AND psv.vendor_id = pssv.vendor_id
AND psv.party_id = iepa.payee_party_id
AND ipua.ext_pmt_party_id(+) = iepa.ext_payee_id
AND ieba.ext_bank_account_id(+) = ipua.instrument_id
AND ieba.bank_id = cbv.bank_party_id(+)
AND ieba.branch_id = cbbv.branch_party_id(+);