View: ALR_CHECK_ACTION_HISTORY_VIEW

Product:	ALR - Alert
Description:	All the alert history currently stored
Implementation/DBA Data:	APPS.ALR_CHECK_ACTION_HISTORY_VIEW

View Text

SELECT AC.APPLICATION_ID APPLICATION_ID
, AC.ALERT_ID ALERT_ID
, AC.ALERT_CHECK_ID ALERT_CHECK_ID
, AC.LAST_UPDATE_DATE ALERT_CHECK_DATE
, AC.HISTORY_PURGE_DATE HISTORY_PURGE_DATE
, AC.SUCCESS_FLAG ALERT_CHECK_SUCCESS_FLAG
, SC.CHECK_ID ACTION_SET_CHECK_ID
, SC.ACTION_SET_ID ACTION_SET_ID
, SC.ORACLE_ID ORACLE_ID
, SC.ROW_COUNT NUMBER_OF_EXCEPTIONS
, SC.ACTION_COUNT NUMBER_OF_ACTIONS_PERFORMED
, SC.SUCCESS_FLAG ACTION_SET_CHECK_SUCCESS_FLAG
, AH.ACTION_SET_MEMBER_ID ACTION_SET_MEMBER_ID
, AH.ACTION_ID ACTION_ID
, AH.VERSION_NUMBER ACTION_VERSION_NUMBER
, AH.ACTION_LEVEL ACTION_LEVEL
, AH.ACTION_EXECUTED_FLAG ACTION_EXECUTED_FLAG
, AD.ROW_NUMBER EXCEPTION_SEQUENCE
, AD.DUPLICATE_FLAG DUPLICATE_FLAG
, OH.NAME OUTPUT_NAME
, OH.DATA_TYPE OUTPUT_DATA_TYPE
, OH.VALUE OUTPUT_VALUE
FROM ALR_OUTPUT_HISTORY OH
, ALR_ACTION_DATA AD
, ALR_ACTION_HISTORY AH
, ALR_ACTION_SET_CHECKS SC
, ALR_ALERT_CHECKS AC
WHERE AC.APPLICATION_ID = SC.APPLICATION_ID
AND AC.ALERT_ID = SC.ALERT_ID
AND AC.ALERT_CHECK_ID = SC.ALERT_CHECK_ID
AND SC.APPLICATION_ID = OH.APPLICATION_ID(+)
AND SC.CHECK_ID = OH.CHECK_ID(+)
AND SC.APPLICATION_ID = AH.APPLICATION_ID(+)
AND SC.ALERT_ID = AH.ALERT_ID(+)
AND SC.ACTION_SET_ID = AH.ACTION_SET_ID(+)
AND SC.CHECK_ID = AH.CHECK_ID(+)
AND AH.APPLICATION_ID = AD.APPLICATION_ID(+)
AND AH.ACTION_HISTORY_ID = AD.ACTION_HISTORY_ID(+)
AND AH.CHECK_ID = AD.CHECK_ID(+)
AND AH.APPLICATION_ID = AD.APPLICATION_ID(+)
AND AH.ACTION_HISTORY_ID = AD.ACTION_HISTORY_ID(+)
AND AH.CHECK_ID = AD.CHECK_ID(+)
AND NVL(AD.ROW_NUMBER
, -1) = NVL(OH.ROW_NUMBER
, -1)

Columns