DBA Data[Home] [Help]

VIEW: APPS.PAYBV_JP_BANKS_V

Source

View Text - Preformatted

SELECT BANK_CODE ,BANK_NAME ,BANK_NAME_KANA ,ENABLED_FLAG ,START_DATE_ACTIVE ,END_DATE_ACTIVE ,CREATION_DATE ,CREATED_BY ,LAST_UPDATE_DATE ,LAST_UPDATED_BY ,LAST_UPDATE_LOGIN , HR_BIS.BIS_DECODE_LOOKUP('YES_NO',PJB.ENABLED_FLAG ) ENABLED_FLAG_M from pay_jp_banks PJB
View Text - HTML Formatted

SELECT BANK_CODE
, BANK_NAME
, BANK_NAME_KANA
, ENABLED_FLAG
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PJB.ENABLED_FLAG ) ENABLED_FLAG_M
FROM PAY_JP_BANKS PJB