Product: | ALR - Alert |
---|---|
Description: | All the alert check and alert action history currently stored |
Implementation/DBA Data: | APPS.ALR_ALERT_HISTORY_VIEW |
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