VIEW: APPS.ALR_ALERT_ACTIONS_VIEW

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)