[Home] [Help] [Dependency Information]
Object Name: | ALR_ALERT_ACTIONS_VIEW |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | ALR.ALR_ALERT_ACTIONS_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_NAME | VARCHAR2 | (50) | Yes | Alert name |
ALERT_ENABLED_FLAG | VARCHAR2 | (1) | Yes | Alert enabled flag |
ALERT_END_DATE_ACTIVE | DATE | Last date alert is enabled | ||
ACTION_SET_ID | NUMBER | Yes | Action set identifier | |
ACTION_SET_SEQUENCE | NUMBER | Yes | User-defined sequence number that identifies the execution order of enabled action sets for an alert | |
ACTION_SET_NAME | VARCHAR2 | (50) | Yes | Action set name |
ACTION_SET_ENABLED_FLAG | VARCHAR2 | (1) | Yes | Action set enabled flag |
ACTION_SET_MEMBER_ID | NUMBER | Yes | Action set member identifier | |
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_ID | NUMBER | Action group identifier | ||
ACTION_GROUP_NAME | VARCHAR2 | (80) | Action group name | |
ACTION_GROUP_TYPE | VARCHAR2 | (1) | Action group lookup type | |
THRESHOLD_OR_ESCALATION_GROUP | VARCHAR2 | (1) | Escalation group or Threshold group | |
ACTION_LEVEL | NUMBER | Detail action escalation level | ||
ACTION_ID | NUMBER | Action identifier | ||
ACTION_VERSION_NUMBER | NUMBER | Action version number | ||
ACTION_NAME | VARCHAR2 | (80) | Action name | |
ACTION_TYPE | VARCHAR2 | (1) | Action type code | |
ACTION_LEVEL_TYPE | VARCHAR2 | (1) | Action level code | |
ACTION_ENABLED_FLAG | VARCHAR2 | (1) | Action enabled flag | |
ACTION_END_DATE_ACTIVE | DATE | Last date action is enabled |
Cut, paste (and edit) the following text to query this object:
SELECT APPLICATION_ID
, ALERT_ID
, ALERT_NAME
, ALERT_ENABLED_FLAG
, ALERT_END_DATE_ACTIVE
, ACTION_SET_ID
, ACTION_SET_SEQUENCE
, ACTION_SET_NAME
, ACTION_SET_ENABLED_FLAG
, ACTION_SET_MEMBER_ID
, ACTION_SET_MEMBER_SEQUENCE
, ACTION_SET_MEMBER_TYPE
, ACTION_GROUP_ID
, ACTION_GROUP_NAME
, ACTION_GROUP_TYPE
, THRESHOLD_OR_ESCALATION_GROUP
, ACTION_LEVEL
, ACTION_ID
, ACTION_VERSION_NUMBER
, ACTION_NAME
, ACTION_TYPE
, ACTION_LEVEL_TYPE
, ACTION_ENABLED_FLAG
, ACTION_END_DATE_ACTIVE
FROM APPS.ALR_ALERT_ACTIONS_VIEW;
|
|
|