View: ALR_ALERT_ACTIONS_VIEW

Product:	ALR - Alert
Description:	Actions that are attached to an action set
Implementation/DBA Data:	APPS.ALR_ALERT_ACTIONS_VIEW

View Text

SELECT A.APPLICATION_ID APPLICATION_ID
, A.ALERT_ID ALERT_ID
, A.ALERT_NAME ALERT_NAME
, A.ENABLED_FLAG ALERT_ENABLED_FLAG
, A.END_DATE_ACTIVE ALERT_END_DATE_ACTIVE
, S.ACTION_SET_ID ACTION_SET_ID
, S.SEQUENCE ACTION_SET_SEQUENCE
, S.NAME ACTION_SET_NAME
, S.ENABLED_FLAG ACTION_SET_ENABLED_FLAG
, SM.ACTION_SET_MEMBER_ID ACTION_SET_MEMBER_ID
, SM.SEQUENCE ACTION_SET_MEMBER_SEQUENCE
, DECODE(GA.ACTION_ID
, NULL
, 'A'
, 'G') ACTION_SET_MEMBER_TYPE
, AG.ACTION_GROUP_ID ACTION_GROUP_ID
, AG.NAME ACTION_GROUP_NAME
, AG.ACTION_GROUP_TYPE ACTION_GROUP_TYPE
, AG.GROUP_TYPE THRESHOLD_OR_ESCALATION_GROUP
, GM.ACTION_LEVEL ACTION_LEVEL
, NVL(GA.ACTION_ID
, SA.ACTION_ID) ACTION_ID
, NVL(GA.VERSION_NUMBER
, SA.VERSION_NUMBER) ACTION_VERSION_NUMBER
, NVL(GA.NAME
, SA.NAME) ACTION_NAME
, NVL(GA.ACTION_TYPE
, SA.ACTION_TYPE) ACTION_TYPE
, NVL(GA.ACTION_LEVEL_TYPE
, SA.ACTION_LEVEL_TYPE) ACTION_LEVEL_TYPE
, NVL(GA.ENABLED_FLAG
, SA.ENABLED_FLAG) ACTION_ENABLED_FLAG
, DECODE(GA.ACTION_ID
, NULL
, SA.END_DATE_ACTIVE
, GA.END_DATE_ACTIVE) ACTION_END_DATE_ACTIVE
FROM ALR_ACTIONS SA
, ALR_ACTIONS GA
, ALR_ACTION_SET_MEMBERS SM
, ALR_ACTION_GROUP_MEMBERS GM
, ALR_ACTION_SETS S
, ALR_ACTION_GROUPS AG
, ALR_ALERTS A
WHERE A.APPLICATION_ID = S.APPLICATION_ID
AND A.ALERT_ID = S.ALERT_ID
AND S.APPLICATION_ID = SM.APPLICATION_ID
AND S.ALERT_ID = SM.ALERT_ID
AND S.ACTION_SET_ID = SM.ACTION_SET_ID
AND SM.APPLICATION_ID = SA.APPLICATION_ID(+)
AND SM.ALERT_ID = SA.ALERT_ID(+)
AND SM.ACTION_ID = SA.ACTION_ID(+)
AND SM.APPLICATION_ID = AG.APPLICATION_ID(+)
AND SM.ALERT_ID = AG.ALERT_ID(+)
AND SM.ACTION_GROUP_ID = AG.ACTION_GROUP_ID(+)
AND AG.APPLICATION_ID = GM.APPLICATION_ID(+)
AND AG.ALERT_ID = GM.ALERT_ID(+)
AND AG.ACTION_GROUP_ID = GM.ACTION_GROUP_ID(+)
AND GM.APPLICATION_ID = GA.APPLICATION_ID(+)
AND GM.ALERT_ID = GA.ALERT_ID(+)
AND GM.ACTION_ID = GA.ACTION_ID(+)

Columns