HRC_ALERT_TOKENS_VL

Details

• Schema: FUSION

• Object owner: HRC

• Object type: VIEW

Columns

Name
TOKEN_ID TOKEN_LEVEL ALERT_ID TEMPLATE_ID TOKEN_NAME DESCRIPTION MANDATORY DEFAULT_VALUE LANGUAGE SOURCE_LANG OBJECT_GUID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER SGUID MODULE_ID

Query

SQL_Statement

SELECT b.TOKEN_ID TOKEN_ID, b.TOKEN_LEVEL TOKEN_LEVEL, b.ALERT_ID ALERT_ID, b.TEMPLATE_ID TEMPLATE_ID, b.TOKEN_NAME TOKEN_NAME, tl.DESCRIPTION DESCRIPTION, b.MANDATORY MANDATORY, b.DEFAULT_VALUE DEFAULT_VALUE, tl.LANGUAGE LANGUAGE, tl.SOURCE_LANG SOURCE_LANG, b.OBJECT_GUID OBJECT_GUID, b.CREATED_BY CREATED_BY, b.CREATION_DATE CREATION_DATE, b.LAST_UPDATED_BY LAST_UPDATED_BY, b.LAST_UPDATE_DATE LAST_UPDATE_DATE, b.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, b.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, b.SGUID SGUID, b.MODULE_ID MODULE_ID FROM HRC_ALERT_TOKENS_B b, HRC_ALERT_TOKENS_TL tl WHERE b.TOKEN_ID = tl.TOKEN_ID AND tl.LANGUAGE = USERENV('LANG')