VIEW: APPS.PER_JP_BANK_LOOKUP_V

Source

View Text - Preformatted

SELECT v. BANK_CODE, v. BANK_NAME, v.BANK_NAME_KANA FROM (select bnk.bank_code, bnk.bank_name, bnk.bank_name_kana, bch.branch_code, bch.branch_name, bch.branch_name_kana from pay_jp_bank_branches bch, pay_jp_banks bnk where bch.bank_code = bnk.bank_code) v GROUP BY v.BANK_CODE, v.BANK_NAME, v. BANK_NAME_KANA

View Text - HTML Formatted

SELECT V. BANK_CODE
, V. BANK_NAME
, V.BANK_NAME_KANA
FROM (SELECT BNK.BANK_CODE
, BNK.BANK_NAME
, BNK.BANK_NAME_KANA
, BCH.BRANCH_CODE
, BCH.BRANCH_NAME
, BCH.BRANCH_NAME_KANA
FROM PAY_JP_BANK_BRANCHES BCH
, PAY_JP_BANKS BNK
WHERE BCH.BANK_CODE = BNK.BANK_CODE) V GROUP BY V.BANK_CODE
, V.BANK_NAME
, V. BANK_NAME_KANA