View: PER_JP_BANK_LOOKUP_V

Product:	PER - Human Resources
Description:	JP specific
Implementation/DBA Data:	APPS.PER_JP_BANK_LOOKUP_V

View Text

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

Columns