View: ALR_GROUPS_AND_ACTIONS_VIEW

Product:	ALR - Alert
Description:	Alert groups and actions for an alert
Implementation/DBA Data:	APPS.ALR_GROUPS_AND_ACTIONS_VIEW

View Text

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'

Columns