View: ALR_RESPONSE_ACTIONS_VIEW

Product:	ALR - Alert
Description:	All the defined action plus the pre-defined action "Return Original Mail"
Implementation/DBA Data:	APPS.ALR_RESPONSE_ACTIONS_VIEW

View Text

SELECT ACT.APPLICATION_ID
, ACT.ALERT_ID
, ACT.NAME
, ACT.ACTION_ID
, ACT.ACTION_TYPE
, ALRLKP.MEANING ACTION_TYPE_MEANING
, ACT.DESCRIPTION
, ACT.ENABLED_FLAG
FROM ALR_LOOKUPS ALRLKP
, ALR_ACTIONS ACT
WHERE ACT.ACTION_LEVEL_TYPE = 'D'
AND ALRLKP.LOOKUP_TYPE = 'ACTION_TYPE'
AND ALRLKP.LOOKUP_CODE = ACT.ACTION_TYPE
AND ACT.ENABLED_FLAG = 'Y' UNION ALL SELECT -2
, -2
, R.MEANING
, -2
, A.LOOKUP_CODE
, A.MEANING
, R.DESCRIPTION
, 'Y'
FROM ALR_LOOKUPS R
, ALR_LOOKUPS A
WHERE R.LOOKUP_TYPE = 'RETURN_MAIL_ACTION'
AND A.LOOKUP_TYPE = 'ACTION_TYPE'
AND A.LOOKUP_CODE = 'M'

Columns