VIEW: APPS.ALR_GROUPS_AND_ACTIONS_VIEW

Source

View Text - Preformatted

SELECT APPLICATION_ID , ALERT_ID , ACTION_ID , NAME , ACTION_TYPE , aorg.meaning || ': ' || t.meaning description , 'A' TYPE FROM ALR_ACTIONS A, ALR_LOOKUPS AORG, ALR_LOOKUPS T WHERE aorg.lookup_type = 'GROUP_TYPE' AND aorg.lookup_code = 'A' AND t.lookup_type = 'ACTION_TYPE' AND t.lookup_code = a.action_type AND a.enabled_flag = 'Y' UNION ALL SELECT application_id, alert_id, action_group_id, name, action_group_type, aorg.meaning || ': ' || t.meaning, group_type type FROM alr_action_groups g, alr_lookups aorg, alr_lookups t WHERE aorg.lookup_type = 'GROUP_TYPE' AND aorg.lookup_code = g.group_type AND t.lookup_type = 'ACTION_TYPE' AND t.lookup_code = g.action_group_type UNION ALL SELECT a.application_id, a.alert_id, -5, l.meaning, 'A', l.description, 'A' FROM alr_lookups l, alr_alerts a WHERE l.lookup_type = 'ALR_EXIT_ACTION'

View Text - HTML Formatted

SELECT APPLICATION_ID
, ALERT_ID
, ACTION_ID
, NAME
, ACTION_TYPE
, AORG.MEANING || ': ' || T.MEANING DESCRIPTION
, 'A' TYPE
FROM ALR_ACTIONS A
, ALR_LOOKUPS AORG
, ALR_LOOKUPS T
WHERE AORG.LOOKUP_TYPE = 'GROUP_TYPE'
AND AORG.LOOKUP_CODE = 'A'
AND T.LOOKUP_TYPE = 'ACTION_TYPE'
AND T.LOOKUP_CODE = A.ACTION_TYPE
AND A.ENABLED_FLAG = 'Y' UNION ALL SELECT APPLICATION_ID
, ALERT_ID
, ACTION_GROUP_ID
, NAME
, ACTION_GROUP_TYPE
, AORG.MEANING || ': ' || T.MEANING
, GROUP_TYPE TYPE
FROM ALR_ACTION_GROUPS G
, ALR_LOOKUPS AORG
, ALR_LOOKUPS T
WHERE AORG.LOOKUP_TYPE = 'GROUP_TYPE'
AND AORG.LOOKUP_CODE = G.GROUP_TYPE
AND T.LOOKUP_TYPE = 'ACTION_TYPE'
AND T.LOOKUP_CODE = G.ACTION_GROUP_TYPE UNION ALL SELECT A.APPLICATION_ID
, A.ALERT_ID
, -5
, L.MEANING
, 'A'
, L.DESCRIPTION
, 'A'
FROM ALR_LOOKUPS L
, ALR_ALERTS A
WHERE L.LOOKUP_TYPE = 'ALR_EXIT_ACTION'