Product: | AMS - Marketing |
---|---|
Description: | This view is created to give general information about Marketing triggers. |
Implementation/DBA Data: | APPS.AMS_TRIGGERS_VL |
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')