[Home] [Help] [Dependency Information]
Object Name: | ALR_ALERT_HISTORY_VIEW |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | ALR.ALR_ALERT_HISTORY_VIEW |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
APPLICATION_ID | NUMBER | Yes | Application identifier | |
ALERT_NAME | VARCHAR2 | (50) | Yes | Alert name |
ALERT_CHECK_DATE | DATE | Yes | Date on which alert check was performed | |
HISTORY_PURGE_DATE | DATE | Date on which Periodic Alert Checker purges history for this alert check | ||
ALERT_CHECK_SUCCESS_FLAG | VARCHAR2 | (1) | Alert check success flag | |
ACTION_SET_NAME | VARCHAR2 | (50) | Yes | Action set name |
ACTION_SET_SEQUENCE | NUMBER | Yes | User-defined sequence number that identifies the execution order of enabled action sets for an alert | |
ORACLE_ID | NUMBER | Oracle user identifier | ||
NUMBER_OF_EXCEPTIONS | NUMBER | Number of exceptions found for an action set check | ||
NUMBER_OF_ACTIONS_PERFORMED | NUMBER | Number of actions performed for an action set check | ||
ACTION_SET_CHECK_SUCCESS_FLAG | VARCHAR2 | (1) | Action set check success flag | |
ACTION_SET_MEMBER_SEQUENCE | NUMBER | Yes | User-defined sequence number identifying the order of execution of an action or action group during an action set check | |
ACTION_SET_MEMBER_TYPE | VARCHAR2 | (1) | Action set member type | |
ACTION_GROUP_NAME | VARCHAR2 | (80) | Action group name | |
THRESHOLD_OR_ESCALATION_GROUP | VARCHAR2 | (1) | Escalation group or Threshold group | |
ACTION_NAME | VARCHAR2 | (80) | Action name | |
ACTION_VERSION_NUMBER | NUMBER | Action version number | ||
ACTION_LEVEL_TYPE | VARCHAR2 | (1) | Action level code | |
ACTION_TYPE | VARCHAR2 | (1) | Action type code | |
ACTION_LEVEL | NUMBER | Detail action escalation level | ||
ACTION_EXECUTED_FLAG | VARCHAR2 | (1) | Flag recording whether or not Oracle Alert executed an action | |
EXCEPTION_SEQUENCE | NUMBER | Exception identifier | ||
OUTPUT_NAME | VARCHAR2 | (30) | Output name | |
OUTPUT_DATA_TYPE | VARCHAR2 | (1) | Output data type | |
OUTPUT_VALUE | VARCHAR2 | (240) | Actual value retrieved from the database for this output during the alert check |
Cut, paste (and edit) the following text to query this object:
SELECT APPLICATION_ID
, ALERT_NAME
, ALERT_CHECK_DATE
, HISTORY_PURGE_DATE
, ALERT_CHECK_SUCCESS_FLAG
, ACTION_SET_NAME
, ACTION_SET_SEQUENCE
, ORACLE_ID
, NUMBER_OF_EXCEPTIONS
, NUMBER_OF_ACTIONS_PERFORMED
, ACTION_SET_CHECK_SUCCESS_FLAG
, ACTION_SET_MEMBER_SEQUENCE
, ACTION_SET_MEMBER_TYPE
, ACTION_GROUP_NAME
, THRESHOLD_OR_ESCALATION_GROUP
, ACTION_NAME
, ACTION_VERSION_NUMBER
, ACTION_LEVEL_TYPE
, ACTION_TYPE
, ACTION_LEVEL
, ACTION_EXECUTED_FLAG
, EXCEPTION_SEQUENCE
, OUTPUT_NAME
, OUTPUT_DATA_TYPE
, OUTPUT_VALUE
FROM APPS.ALR_ALERT_HISTORY_VIEW;
APPS.ALR_ALERT_HISTORY_VIEW is not referenced by any database object
|
|
|