HRC_ALERT_TEMPLATES_VL

Details

• Schema: FUSION

• Object owner: HRC

• Object type: VIEW

Columns

Name
TEMPLATE_ID OBJECT_GUID ALERT_ID RESOURCE_NAME MIME_TYPE ENABLED ALERT_PER_TYPE ATTRIBUTES STORE_MESSAGES GROUPBY_EXPRESSION NT_FLAG NT_BODY NAME SHORT_MESSAGE SUBJECT BODY LANGUAGE SOURCE_LANG CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER RUN_EXPRESSION MODULE_ID DEFAULT_LANGUAGE SGUID DELETED_FLAG

Query

SQL_Statement

SELECT b.TEMPLATE_ID TEMPLATE_ID, b.OBJECT_GUID OBJECT_GUID, b.ALERT_ID ALERT_ID, b.RESOURCE_NAME RESOURCE_NAME, b.MIME_TYPE MIME_TYPE, b.ENABLED ENABLED, b.ALERT_PER_TYPE ALERT_PER_TYPE, b.ATTRIBUTES ATTRIBUTES, b.STORE_MESSAGES STORE_MESSAGES, b.GROUPBY_EXPRESSION GROUPBY_EXPRESSION, b.NT_FLAG NT_FLAG, b.NT_BODY NT_BODY, tl.NAME NAME, tl.SHORT_MESSAGE SHORT_MESSAGE, tl.SUBJECT SUBJECT, tl.BODY BODY, tl.LANGUAGE LANGUAGE, tl.SOURCE_LANG SOURCE_LANG, 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.RUN_EXPRESSION RUN_EXPRESSION, b.MODULE_ID MODULE_ID, b.DEFAULT_LANGUAGE DEFAULT_LANGUAGE, b.SGUID SGUID, b.DELETED_FLAG DELETED_FLAG FROM HRC_ALERT_TEMPLATES_B b, HRC_ALERT_TEMPLATES_TL tl WHERE b.TEMPLATE_ID = tl.TEMPLATE_ID AND tl.LANGUAGE = USERENV('LANG')