VIEW: APPS.AMS_TRIGGERS_V

Source

View Text - Preformatted

SELECT B.ROWID ROW_ID ,B.TRIGGER_ID ,C.TRIGGER_CHECK_ID ,null TRIGGER_ACTION_ID ,B.LAST_UPDATE_DATE ,B.LAST_UPDATED_BY ,B.CREATION_DATE ,B.CREATED_BY ,B.LAST_UPDATE_LOGIN ,B.OBJECT_VERSION_NUMBER ,B.PROCESS_ID ,B.TRIGGER_CREATED_FOR_ID ,B.ARC_TRIGGER_CREATED_FOR ,B.TIMEZONE_ID ,H.GLOBAL_TIMEZONE_NAME ,B.TRIGGERING_TYPE ,AMS_UTILITY_PVT.GET_LOOKUP_MEANING('AMS_TRIGGER_TYPE', B.TRIGGERING_TYPE) TRIGGERING_TYPE_NAME ,B.TRIGGER_NAME ,B.VIEW_APPLICATION_ID ,B.USER_START_DATE_TIME ,B.USER_LAST_RUN_DATE_TIME ,B.USER_NEXT_RUN_DATE_TIME ,B.USER_REPEAT_DAILY_START_TIME ,B.USER_REPEAT_DAILY_END_TIME ,B.REPEAT_FREQUENCY_TYPE ,B.REPEAT_EVERY_X_FREQUENCY ,B.USER_REPEAT_STOP_DATE_TIME ,B.METRICS_REFRESH_TYPE ,B.DESCRIPTION ,C.OBJECT_VERSION_NUMBER CHK_OBJ_VERSION_NUMBER ,C.CHK1_TYPE ,C.CHK1_ARC_SOURCE_CODE_FROM ,C.CHK1_ACT_OBJECT_ID ,C.CHK1_SOURCE_CODE ,C.CHK1_SOURCE_CODE_METRIC_ID ,C.CHK1_SOURCE_CODE_METRIC_TYPE ,C.CHK1_TO_CHK2_OPERATOR_TYPE ,C.CHK2_TYPE ,C.CHK2_VALUE ,C.CHK2_LOW_VALUE ,C.CHK2_HIGH_VALUE ,C.CHK2_SOURCE_CODE ,C.CHK2_ARC_SOURCE_CODE_FROM ,C.CHK2_ACT_OBJECT_ID ,C.CHK2_SOURCE_CODE_METRIC_ID ,C.CHK2_SOURCE_CODE_METRIC_TYPE ,C.CHK2_WORKBOOK_NAME ,C.CHK2_WORKBOOK_OWNER ,C.CHK2_UOM_CODE ,C.CHK2_CURRENCY_CODE ,C.CHK2_WORKSHEET_NAME , null ACT_OBJ_VER_NUM ,null NOTIFY_FLAG ,null GENERATE_LIST_FLAG ,null ACTION_NEED_APPROVAL_FLAG ,null ACTION_APPROVER_USER_ID ,null APPROVER_NAME ,null EXECUTE_ACTION_TYPE ,null LIST_HEADER_ID ,null LIST_CONNECTED_TO_ID ,null ARC_LIST_CONNECTED_TO ,null DELIVERABLE_ID ,null ACTIVITY_OFFER_ID ,null DSCRIPT_NAME ,null COVER_LETTER_ID ,null MAIL_SUBJECT ,null MAIL_SENDER_NAME ,null FROM_FAX_NO FROM AMS_TRIGGERS_VL B,AMS_TRIGGER_CHECKS C ,HZ_TIMEZONES h WHERE B.TRIGGER_ID = C.TRIGGER_ID(+) AND H.TIMEZONE_ID = B.TIMEZONE_ID

View Text - HTML Formatted

SELECT B.ROWID ROW_ID
, B.TRIGGER_ID
, C.TRIGGER_CHECK_ID
, NULL TRIGGER_ACTION_ID
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_LOGIN
, B.OBJECT_VERSION_NUMBER
, B.PROCESS_ID
, B.TRIGGER_CREATED_FOR_ID
, B.ARC_TRIGGER_CREATED_FOR
, B.TIMEZONE_ID
, H.GLOBAL_TIMEZONE_NAME
, B.TRIGGERING_TYPE
, AMS_UTILITY_PVT.GET_LOOKUP_MEANING('AMS_TRIGGER_TYPE'
, B.TRIGGERING_TYPE) TRIGGERING_TYPE_NAME
, B.TRIGGER_NAME
, B.VIEW_APPLICATION_ID
, B.USER_START_DATE_TIME
, B.USER_LAST_RUN_DATE_TIME
, B.USER_NEXT_RUN_DATE_TIME
, B.USER_REPEAT_DAILY_START_TIME
, B.USER_REPEAT_DAILY_END_TIME
, B.REPEAT_FREQUENCY_TYPE
, B.REPEAT_EVERY_X_FREQUENCY
, B.USER_REPEAT_STOP_DATE_TIME
, B.METRICS_REFRESH_TYPE
, B.DESCRIPTION
, C.OBJECT_VERSION_NUMBER CHK_OBJ_VERSION_NUMBER
, C.CHK1_TYPE
, C.CHK1_ARC_SOURCE_CODE_FROM
, C.CHK1_ACT_OBJECT_ID
, C.CHK1_SOURCE_CODE
, C.CHK1_SOURCE_CODE_METRIC_ID
, C.CHK1_SOURCE_CODE_METRIC_TYPE
, C.CHK1_TO_CHK2_OPERATOR_TYPE
, C.CHK2_TYPE
, C.CHK2_VALUE
, C.CHK2_LOW_VALUE
, C.CHK2_HIGH_VALUE
, C.CHK2_SOURCE_CODE
, C.CHK2_ARC_SOURCE_CODE_FROM
, C.CHK2_ACT_OBJECT_ID
, C.CHK2_SOURCE_CODE_METRIC_ID
, C.CHK2_SOURCE_CODE_METRIC_TYPE
, C.CHK2_WORKBOOK_NAME
, C.CHK2_WORKBOOK_OWNER
, C.CHK2_UOM_CODE
, C.CHK2_CURRENCY_CODE
, C.CHK2_WORKSHEET_NAME
, NULL ACT_OBJ_VER_NUM
, NULL NOTIFY_FLAG
, NULL GENERATE_LIST_FLAG
, NULL ACTION_NEED_APPROVAL_FLAG
, NULL ACTION_APPROVER_USER_ID
, NULL APPROVER_NAME
, NULL EXECUTE_ACTION_TYPE
, NULL LIST_HEADER_ID
, NULL LIST_CONNECTED_TO_ID
, NULL ARC_LIST_CONNECTED_TO
, NULL DELIVERABLE_ID
, NULL ACTIVITY_OFFER_ID
, NULL DSCRIPT_NAME
, NULL COVER_LETTER_ID
, NULL MAIL_SUBJECT
, NULL MAIL_SENDER_NAME
, NULL FROM_FAX_NO
FROM AMS_TRIGGERS_VL B
, AMS_TRIGGER_CHECKS C
, HZ_TIMEZONES H
WHERE B.TRIGGER_ID = C.TRIGGER_ID(+)
AND H.TIMEZONE_ID = B.TIMEZONE_ID