eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.ALR_RESPONSE_ACTIONS_VIEW

Source

View Text - Preformatted


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'

View Text - HTML Formatted

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'