Supplier Bank tables in oracle fusion

Supplier Bank tables in oracle fusion

In this post , we will be discuss about the supplier bank tables in oracle fusion. These supplier bank tables helps to store the supplier banking informations. I will share the detail supplier bank table list and the sql query to extract the supplier banking informations in oracle fusion. These supplier bank tables , stores supplier Bank , Branch , Bank Account , IBAN and many other required banking details about supplier. Here below i will share Supplier Bank tables in oracle fusion.

7 Important Supplier Bank tables in oracle fusion

1.POZ_SUPPLIERS_V
2.IBY_EXTERNAL_PAYEES_ALL
3.IBY_PMT_INSTR_USES_ALL
4.IBY_EXT_BANK_ACCOUNTS
5.CE_BANKS_V
6.CE_BANK_BRANCHES_V
7.POZ_SUPPLIER_SITES_V

Detail SQL query using the Supplier Bank tables in oracle fusion

select VENDOR_NAME,IEBA.BANK_ACCOUNT_NUM,IBAN,IEBA.BANK_ACCOUNT_NAME,cbv.BANK_NAME,cbv.ADDRESS_LINE1 BANK_ADDRESS_1,CBV.COUNTRY BANK_COUNTRY,
CBV.CITY BANK_CITY,
CBBV.BANK_BRANCH_NAME,CBBV.ADDRESS_LINE1 BRANCH_ADDRESS_1,CBBV.CITY BRANCH_CITY,CBBV.COUNTRY BRANCH_COUNTRY,CBBV.BRANCH_NUMBER,CBBV.EFT_SWIFT_CODE BIC ,FOREIGN_PAYMENT_USE_FLAG
from POZ_SUPPLIERS_V APS,IBY_EXTERNAL_PAYEES_ALL IEPA,IBY_PMT_INSTR_USES_ALL IPIUA,IBY_EXT_BANK_ACCOUNTS IEBA
,ce_banks_v cbv, ce_bank_BRANCHES_V CBBV, POZ_SUPPLIER_SITES_V ass
where 1=1
AND APS.VENDOR_ID=ASS.VENDOR_ID
AND ASS.PRC_BU_ID='8977775390'
AND IEPA.PAYEE_PARTY_ID=APS.PARTY_ID
AND IPIUA.EXT_PMT_PARTY_ID(+)=IEPA.EXT_PAYEE_ID
AND IEBA.EXT_BANK_ACCOUNT_ID(+)=IPIUA.INSTRUMENT_ID
AND IEBA.BANK_ID=cbv.BANK_PARTY_ID(+)
AND IEBA.BRANCH_ID=CBBV.BRANCH_PARTY_ID(+)