VIEW: APPS.ALR_ALERT_HISTORY_VIEW

Source

View Text - Preformatted

SELECT a.application_id APPLICATION_ID, a.alert_name ALERT_NAME, h.alert_check_date ALERT_CHECK_DATE, h.history_purge_date HISTORY_PURGE_DATE, h.alert_check_success_flag ALERT_CHECK_SUCCESS_FLAG, a.action_set_name ACTION_SET_NAME, a.action_set_sequence ACTION_SET_SEQUENCE, h.oracle_id ORACLE_ID, h.number_of_exceptions NUMBER_OF_EXCEPTIONS, h.number_of_actions_performed NUMBER_OF_ACTIONS_PERFORMED, h.action_set_check_success_flag ACTION_SET_CHECK_SUCCESS_FLAG, a.action_set_member_sequence ACTION_SET_MEMBER_SEQUENCE, a.action_set_member_type ACTION_SET_MEMBER_TYPE, a.action_group_name ACTION_GROUP_NAME, a.threshold_or_escalation_group THRESHOLD_OR_ESCALATION_GROUP, a.action_name ACTION_NAME, a.action_version_number ACTION_VERSION_NUMBER, a.action_level_type ACTION_LEVEL_TYPE, a.action_type ACTION_TYPE, h.action_level ACTION_LEVEL, h.action_executed_flag ACTION_EXECUTED_FLAG, h.exception_sequence EXCEPTION_SEQUENCE, h.output_name OUTPUT_NAME, h.output_data_type OUTPUT_DATA_TYPE, h.output_value OUTPUT_VALUE FROM ALR_CHECK_ACTION_HISTORY_VIEW H, ALR_ALERT_ACTIONS_VIEW A where a.application_id = h.application_id and a.alert_id = h.alert_id and a.action_set_id = h.action_set_id and a.action_set_member_id = h.action_set_member_id and a.action_id = h.action_id and a.action_version_number = h.action_version_number

View Text - HTML Formatted

SELECT A.APPLICATION_ID APPLICATION_ID
, A.ALERT_NAME ALERT_NAME
, H.ALERT_CHECK_DATE ALERT_CHECK_DATE
, H.HISTORY_PURGE_DATE HISTORY_PURGE_DATE
, H.ALERT_CHECK_SUCCESS_FLAG ALERT_CHECK_SUCCESS_FLAG
, A.ACTION_SET_NAME ACTION_SET_NAME
, A.ACTION_SET_SEQUENCE ACTION_SET_SEQUENCE
, H.ORACLE_ID ORACLE_ID
, H.NUMBER_OF_EXCEPTIONS NUMBER_OF_EXCEPTIONS
, H.NUMBER_OF_ACTIONS_PERFORMED NUMBER_OF_ACTIONS_PERFORMED
, H.ACTION_SET_CHECK_SUCCESS_FLAG ACTION_SET_CHECK_SUCCESS_FLAG
, A.ACTION_SET_MEMBER_SEQUENCE ACTION_SET_MEMBER_SEQUENCE
, A.ACTION_SET_MEMBER_TYPE ACTION_SET_MEMBER_TYPE
, A.ACTION_GROUP_NAME ACTION_GROUP_NAME
, A.THRESHOLD_OR_ESCALATION_GROUP THRESHOLD_OR_ESCALATION_GROUP
, A.ACTION_NAME ACTION_NAME
, A.ACTION_VERSION_NUMBER ACTION_VERSION_NUMBER
, A.ACTION_LEVEL_TYPE ACTION_LEVEL_TYPE
, A.ACTION_TYPE ACTION_TYPE
, H.ACTION_LEVEL ACTION_LEVEL
, H.ACTION_EXECUTED_FLAG ACTION_EXECUTED_FLAG
, H.EXCEPTION_SEQUENCE EXCEPTION_SEQUENCE
, H.OUTPUT_NAME OUTPUT_NAME
, H.OUTPUT_DATA_TYPE OUTPUT_DATA_TYPE
, H.OUTPUT_VALUE OUTPUT_VALUE
FROM ALR_CHECK_ACTION_HISTORY_VIEW H
, ALR_ALERT_ACTIONS_VIEW A
WHERE A.APPLICATION_ID = H.APPLICATION_ID
AND A.ALERT_ID = H.ALERT_ID
AND A.ACTION_SET_ID = H.ACTION_SET_ID
AND A.ACTION_SET_MEMBER_ID = H.ACTION_SET_MEMBER_ID
AND A.ACTION_ID = H.ACTION_ID
AND A.ACTION_VERSION_NUMBER = H.ACTION_VERSION_NUMBER