Oracle r12 supplier bank account assignment tables

Oracle r12 supplier bank account assignment tables

In this post , We will be discuss about Oracle r12 supplier bank account assignment tables. Supplier bank account assignments tables , helps to store the supplier bank related informations in oracle r12. We do use these oracle r12 supplier bank assignment tables to extract and develop the supplier bank account informations. Here below is the detail about Oracle r12 supplier bank account assignment tables.

Most Important Oracle r12 supplier bank account assignment tables

1.IBY_EXTERNAL_PAYEES_ALL

2.IBY_PMT_INSTR_USES_ALL

3.IBY_EXT_BANK_ACCOUNTS

4.CE_BANKS_V

5.CE_BANK_BRANCHES_V

Detail SQL Query Using Oracle r12 supplier bank account assignment tables

Here below is the sql query to extract the  supplier bank account informations in oracle apps r12.

select 'Suppplier Site' "Banking_Info" 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 apps.AP_SUPPLIERS APS,apps.IBY_EXTERNAL_PAYEES_ALL IEPA,apps.IBY_PMT_INSTR_USES_ALL IPIUA,APPS.IBY_EXT_BANK_ACCOUNTS IEBA
,apps.ce_banks_v cbv, apps.ce_bank_BRANCHES_V CBBV, apps.AP_SUPPLIER_SITES_ALL ass
where 1=1
AND APS.VENDOR_ID=ASS.VENDOR_ID
AND ASS.ORG_ID=:P_ORG_ID
AND IEPA.PAYEE_PARTY_ID=APS.PARTY_ID
AND IEPA.PARTY_SITE_ID IS NULL
AND IEPA.SUPPLIER_SITE_ID IS NULL
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(+)