CJM_SETTINGS_VL

Details

• Schema: FUSION

• Object owner: CJM

• Object type: VIEW

Columns

Name
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

Query

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')