Hi Marito,

Find below the query to get supplier bank details:

SELECT ASP.SEGMENT1 VENDOR_NUM
,ASP.VENDOR_NAME
,ASA.VENDOR_SITE_CODE
,HOU.NAME OU_NAME
,IEBA.COUNTRY_CODE
,CBBV.BANK_NAME
,IEBA.BANK_ACCOUNT_NAME_ALT
,CBBV.BANK_NUMBER
,CBBV.BANK_BRANCH_NAME
,CBBV.BRANCH_NUMBER
,CBBV.EFT_SWIFT_CODE
,IEBA.BANK_ACCOUNT_NUM
,IEBA.IBAN
,IEBA.CURRENCY_CODE
FROM AP_SUPPLIERS ASP
,AP_SUPPLIER_SITES_ALL ASA
,IBY_EXTERNAL_PAYEES_ALL IEPAYEES
,IBY_PMT_INSTR_USES_ALL IPIUA
,IBY_EXT_BANK_ACCOUNTS IEBA
,CE_BANK_BRANCHES_V CBBV
,IBY_ACCOUNT_OWNERS IAOWNERS
,HR_OPERATING_UNITS HOU
WHERE IAOWNERS.PRIMARY_FLAG = 'Y'
AND IAOWNERS.EXT_BANK_ACCOUNT_ID = IEBA.EXT_BANK_ACCOUNT_ID
AND IAOWNERS.EXT_BANK_ACCOUNT_ID = IPIUA.INSTRUMENT_ID
AND IEPAYEES.EXT_PAYEE_ID = IPIUA.EXT_PMT_PARTY_ID
AND IEPAYEES.PAYEE_PARTY_ID = IAOWNERS.ACCOUNT_OWNER_PARTY_ID
AND IEPAYEES.SUPPLIER_SITE_ID = ASA.VENDOR_SITE_ID
AND ASA.VENDOR_ID = ASP.VENDOR_ID
AND IEBA.BRANCH_ID = CBBV.BRANCH_PARTY_ID(+)
AND HOU.ORGANIZATION_ID = ASA.ORG_ID;

Above query will list all suppliers bank details:

Supplier Number, Name, Supplier Site Code, Operating unit that belong to supplier site, Country, Bank name, Bank alternative Name (like Arabic Name of the bank), Bank Number, Branch number and name, the swift code, the account number, IBAN, and currency code.

And the list is open to add any other column/s you prefer.