Query to get Alert History Details

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 like '<<Give 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;