Script on Oracle alert History

Oracle Alert history query

 

Select

distinct AAHV . *
FROM apps.ALR_ALERTS al ,
APPS.ALR_ACTION_HISTORY AAH ,
APPS.ALR_OUTPUT_HISTORY AOH ,
APPS.ALR_ACTIONS_V ALV ,
apps.ALR_ALERT_HISTORY_VIEW AAHV
WHERE al . alert_name ='Sample Alert Name '
AND al . alert_id = aah . alert_id
AND aah . check_id = aoh . check_id
and ALV . ALERT_ID = AAH . ALERT_ID
and AAHV . ALERT_NAME = AL . ALERT_NAME
order by aahv.alert_check_date desc;