R12 TCA BANKS, BRANCHES and Bank Accounts

//TCA BANKS

 

select ib.HOME_COUNTRY, BANK_NAME

, ib.HOME_COUNTRY ||'|'||BANK_NAME

, ib.*

from iby_ext_banks_v ib

where ib.home_country = 'KR'

order by ib.BANK_NAME;

 

//TCA BANK BRANCHES

select ieb.home_country

, ieb.BANK_NAME

, iebb.home_country

, iebb.BANK_BRANCH_NAME,iebb.BRANCH_NUMBER, iebb.COUNTRY,iebb.BANK_BRANCH_TYPE, iebb.EFT_SWIFT_CODE

from apps.iby_ext_bank_branches_v iebb,iby_ext_banks_v ieb

WHERE SUBSTR(BANK_BRANCH_NAME, 1,1) NOTBETWEEN '0' AND '9'

AND iebb.bank_party_id =ieb.bank_party_id

AND ieb.home_country = 'KR'

ORDER BY ieb.home_country,ieb.BANK_NAME, iebb.BANK_BRANCH_NAME;

 

//TCA BANK ACCOUNTS

 

select country_code

, ext_bank_account_id

, bank_party_id

, bank_name

, bank_number

, branch_party_id

, bank_branch_name

, branch_number

, branch_type

, EFT_SWIFT_CODE

, BANK_ACCOUNT_ID

, BANK_ACCOUNT_NAME

, BANK_ACCOUNT_NUMBER,BANK_ACCOUNT_NUM_ELECTRONIC

, currency_code

, MULTI_CURRENCY_ALLOWED_FLAG

, PRIMARY_ACCT_OWNER_PARTY_ID

, PRIMARY_ACCT_OWNER_NAME

, ACCOUNT_CLASSIFICATION

, START_DATE

, END_DATE

, FOREIGN_PAYMENT_USE_FLAG

from IBY_EXT_BANK_ACCOUNTS_V

where country_code='AU'; --in('AU','NZ','FJ','PG');