VIEW: APPS.AMS_TRIGGERS_VL

Source

View Text - Preformatted

SELECT b.trigger_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.triggering_type ,b.view_application_id ,b.start_date_time ,b.timezone_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.user_repeat_stop_date_time ,b.last_run_date_time ,b.next_run_date_time ,b.repeat_daily_start_time ,b.repeat_daily_end_time ,b.repeat_frequency_type ,b.repeat_every_x_frequency ,b.repeat_stop_date_time ,b.metrics_refresh_type ,tl.trigger_name ,tl.description ,b.notify_flag ,b.execute_schedule_flag ,b.triggered_status ,b.usage FROM ams_triggers b, ams_triggers_tl tl WHERE b.trigger_id = tl.trigger_id AND tl.language = USERENV('LANG')

View Text - HTML Formatted

SELECT B.TRIGGER_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.TRIGGERING_TYPE
, B.VIEW_APPLICATION_ID
, B.START_DATE_TIME
, B.TIMEZONE_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.USER_REPEAT_STOP_DATE_TIME
, B.LAST_RUN_DATE_TIME
, B.NEXT_RUN_DATE_TIME
, B.REPEAT_DAILY_START_TIME
, B.REPEAT_DAILY_END_TIME
, B.REPEAT_FREQUENCY_TYPE
, B.REPEAT_EVERY_X_FREQUENCY
, B.REPEAT_STOP_DATE_TIME
, B.METRICS_REFRESH_TYPE
, TL.TRIGGER_NAME
, TL.DESCRIPTION
, B.NOTIFY_FLAG
, B.EXECUTE_SCHEDULE_FLAG
, B.TRIGGERED_STATUS
, B.USAGE
FROM AMS_TRIGGERS B
, AMS_TRIGGERS_TL TL
WHERE B.TRIGGER_ID = TL.TRIGGER_ID
AND TL.LANGUAGE = USERENV('LANG')