HRC_ALERTS_VL

Details

• Schema: FUSION

• Object owner: HRC

• Object type: VIEW

Columns

Name

ALERT_ID ALERT_TYPE RESOURCE_APPLICATION RESOURCE_PATH FILTER_EXPRESSIONS RUN_TYPE CREATE_HISTORY RUN_EXPRESSION SCHEDULED_REQUEST_ID SCHEDULED_START SCHEDULED_END KEEP KEEP_FREQ_TYPE KEEP_VALUE THRESHOLD TEST_MODE ENABLED OBJECT_GUID ALERT_CODE ALERT_ACCESS_LEVEL NAME DESCRIPTION LANGUAGE SOURCE_LANG CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER MODULE_ID SGUID RUN_OPTIONS

Query

SQL_Statement

SELECT b.ALERT_ID ALERT_ID, ALERT_TYPE ALERT_TYPE, b.RESOURCE_APPLICATION RESOURCE_APPLICATION, b.RESOURCE_PATH RESOURCE_PATH, b.FILTER_EXPRESSIONS FILTER_EXPRESSIONS, RUN_TYPE RUN_TYPE, CREATE_HISTORY CREATE_HISTORY, RUN_EXPRESSION RUN_EXPRESSION, SCHEDULED_REQUEST_ID SCHEDULED_REQUEST_ID, SCHEDULED_START SCHEDULED_START, SCHEDULED_END SCHEDULED_END, KEEP KEEP, KEEP_FREQ_TYPE KEEP_FREQ_TYPE, KEEP_VALUE KEEP_VALUE, THRESHOLD THRESHOLD, TEST_MODE TEST_MODE, ENABLED ENABLED, OBJECT_GUID OBJECT_GUID, ALERT_CODE ALERT_CODE, ALERT_ACCESS_LEVEL ALERT_ACCESS_LEVEL, NAME NAME, DESCRIPTION DESCRIPTION, LANGUAGE LANGUAGE, 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, MODULE_ID MODULE_ID, b.SGUID SGUID, b.RUN_OPTIONS FROM HRC_ALERTS_B b, HRC_ALERTS_TL tl WHERE b.ALERT_ID = tl.ALERT_ID AND tl.LANGUAGE = USERENV('LANG')