CJM_SETTINGS_VL
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: CJM
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
SETTING_ID SETTING_GUID SETTING_CODE SETTING_LEVEL_CODE OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN REQUIRED_FLAG ENABLED_FLAG SETTING_NAME DESCRIPTION SETTING_CATEGORY SETTING_LEVEL |
問合せ
| SQL_Statement |
|---|
|
SELECT B.SETTING_ID, B.SETTING_GUID, B.SETTING_CODE, B.SETTING_LEVEL_CODE, B.OBJECT_VERSION_NUMBER, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.REQUIRED_FLAG, B.ENABLED_FLAG, TL.SETTING_NAME, TL.DESCRIPTION, TL.SETTING_CATEGORY, TL.SETTING_LEVEL FROM CJM_SETTINGS_B B, CJM_SETTINGS_TL TL WHERE B.SETTING_ID = TL.SETTING_ID AND TL.LANGUAGE = USERENV('LANG') |