[Home] [Help]
View: PER_JP_BANK_LOOKUPS
Product: | PER - Human Resources |
Description: | Concatenated view of PAY_JP_BANKS and PAY_JP_BANK_BRANCHES. |
Implementation/DBA Data: |
APPS.PER_JP_BANK_LOOKUPS
|
View Text
SELECT BNK.BANK_CODE
, BNK.BANK_NAME
, BNK.BANK_NAME_KANA
, BCH.BRANCH_CODE
, BCH.BRANCH_NAME
, BCH.BRANCH_NAME_KANA
, BCH.CREATION_DATE
, BCH.CREATED_BY
, BCH.LAST_UPDATE_DATE
, BCH.LAST_UPDATED_BY
, BCH.LAST_UPDATE_LOGIN FROM PAY_JP_BANK_BRANCHES BCH
, PAY_JP_BANKS BNK WHERE BCH.BANK_CODE = BNK.BANK_CODE
Columns
Name |
BANK_CODE |
BANK_NAME |
BANK_NAME_KANA |
BRANCH_CODE |
BRANCH_NAME |
BRANCH_NAME_KANA |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |