[Home] [Help] [Dependency Information]
Object Name: | ALR_CHECK_ACTION_HISTORY_VIEW |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | ALR.ALR_CHECK_ACTION_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_ID | NUMBER | Yes | Alert identifier | |
ALERT_CHECK_ID | NUMBER | Yes | Alert check identifier | |
ALERT_CHECK_DATE | DATE | Yes | Date on which alert check was last performed | |
HISTORY_PURGE_DATE | DATE | Date on which Periodic Alert Checker purges history for this alert check. If null, Oracle Alert did not save history for the alert check. | ||
ALERT_CHECK_SUCCESS_FLAG | VARCHAR2 | (1) | Alert check success flag | |
ACTION_SET_CHECK_ID | NUMBER | Yes | Action set check identifier | |
ACTION_SET_ID | NUMBER | Yes | Action set identifier | |
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_ID | NUMBER | Action set member identifier | ||
ACTION_ID | NUMBER | Action identifier | ||
ACTION_VERSION_NUMBER | NUMBER | Action version number | ||
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 | ||
DUPLICATE_FLAG | VARCHAR2 | (1) | Flag indication duplicate exception | |
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_ID
, ALERT_CHECK_ID
, ALERT_CHECK_DATE
, HISTORY_PURGE_DATE
, ALERT_CHECK_SUCCESS_FLAG
, ACTION_SET_CHECK_ID
, ACTION_SET_ID
, ORACLE_ID
, NUMBER_OF_EXCEPTIONS
, NUMBER_OF_ACTIONS_PERFORMED
, ACTION_SET_CHECK_SUCCESS_FLAG
, ACTION_SET_MEMBER_ID
, ACTION_ID
, ACTION_VERSION_NUMBER
, ACTION_LEVEL
, ACTION_EXECUTED_FLAG
, EXCEPTION_SEQUENCE
, DUPLICATE_FLAG
, OUTPUT_NAME
, OUTPUT_DATA_TYPE
, OUTPUT_VALUE
FROM APPS.ALR_CHECK_ACTION_HISTORY_VIEW;
|
|
|