VIEW: ALR.ALR_ALERTS#

Source

View Text - Preformatted

select APPLICATION_ID APPLICATION_ID, ALERT_ID ALERT_ID, ALERT_NAME ALERT_NAME, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, ALERT_CONDITION_TYPE ALERT_CONDITION_TYPE, ENABLED_FLAG ENABLED_FLAG, START_DATE_ACTIVE START_DATE_ACTIVE, END_DATE_ACTIVE END_DATE_ACTIVE, TABLE_ID TABLE_ID, TABLE_APPLICATION_ID TABLE_APPLICATION_ID, DESCRIPTION DESCRIPTION, FREQUENCY_TYPE FREQUENCY_TYPE, WEEKLY_CHECK_DAY WEEKLY_CHECK_DAY, MONTHLY_CHECK_DAY_NUM MONTHLY_CHECK_DAY_NUM, DAYS_BETWEEN_CHECKS DAYS_BETWEEN_CHECKS, CHECK_BEGIN_DATE CHECK_BEGIN_DATE, DATE_LAST_CHECKED DATE_LAST_CHECKED, INSERT_FLAG INSERT_FLAG, UPDATE_FLAG UPDATE_FLAG, DELETE_FLAG DELETE_FLAG, MAINTAIN_HISTORY_DAYS MAINTAIN_HISTORY_DAYS, CHECK_TIME CHECK_TIME, CHECK_START_TIME CHECK_START_TIME, CHECK_END_TIME CHECK_END_TIME, SECONDS_BETWEEN_CHECKS SECONDS_BETWEEN_CHECKS, CHECK_ONCE_DAILY_FLAG CHECK_ONCE_DAILY_FLAG, ONE_TIME_ONLY_FLAG ONE_TIME_ONLY_FLAG, TABLE_NAME TABLE_NAME, SQL_STATEMENT_TEXT SQL_STATEMENT_TEXT, SECURITY_GROUP_ID SECURITY_GROUP_ID, ZD_EDITION_NAME ZD_EDITION_NAME from "ALR"."ALR_ALERTS"

View Text - HTML Formatted

SELECT APPLICATION_ID APPLICATION_ID
, ALERT_ID ALERT_ID
, ALERT_NAME ALERT_NAME
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ALERT_CONDITION_TYPE ALERT_CONDITION_TYPE
, ENABLED_FLAG ENABLED_FLAG
, START_DATE_ACTIVE START_DATE_ACTIVE
, END_DATE_ACTIVE END_DATE_ACTIVE
, TABLE_ID TABLE_ID
, TABLE_APPLICATION_ID TABLE_APPLICATION_ID
, DESCRIPTION DESCRIPTION
, FREQUENCY_TYPE FREQUENCY_TYPE
, WEEKLY_CHECK_DAY WEEKLY_CHECK_DAY
, MONTHLY_CHECK_DAY_NUM MONTHLY_CHECK_DAY_NUM
, DAYS_BETWEEN_CHECKS DAYS_BETWEEN_CHECKS
, CHECK_BEGIN_DATE CHECK_BEGIN_DATE
, DATE_LAST_CHECKED DATE_LAST_CHECKED
, INSERT_FLAG INSERT_FLAG
, UPDATE_FLAG UPDATE_FLAG
, DELETE_FLAG DELETE_FLAG
, MAINTAIN_HISTORY_DAYS MAINTAIN_HISTORY_DAYS
, CHECK_TIME CHECK_TIME
, CHECK_START_TIME CHECK_START_TIME
, CHECK_END_TIME CHECK_END_TIME
, SECONDS_BETWEEN_CHECKS SECONDS_BETWEEN_CHECKS
, CHECK_ONCE_DAILY_FLAG CHECK_ONCE_DAILY_FLAG
, ONE_TIME_ONLY_FLAG ONE_TIME_ONLY_FLAG
, TABLE_NAME TABLE_NAME
, SQL_STATEMENT_TEXT SQL_STATEMENT_TEXT
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "ALR"."ALR_ALERTS"