Query to get alerts information

SELECT

alv . *

FROM ALR_ALERTS al ,

ALR_ACTION_HISTORY aah ,

ALR_OUTPUT_HISTORY aoh ,

ALR_ACTIONS_V alv ,

alr_alert_historY_view aahv

WHERE al . alert_name = <name of alert > ---------'XX_ALERTS_SAMPLE'

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;