//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');