VIEW: APPS.ALR_CHECK_ACTION_HISTORY_VIEW

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)