[Home] [Help] [Dependency Information]

VIEW: APPS.AMS_TRIGGERS_VL

Object Details

Object Name:	AMS_TRIGGERS_VL
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AMS.AMS_TRIGGERS_VL
Subobject Name:
Status:	VALID

View Type

MultiLingual view (a language resolved view of the data.)

This view is created to give general information about Marketing triggers.

[View Source]

Columns

Query Text

Cut, paste (and edit) the following text to query this object:

SELECT TRIGGER_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      PROCESS_ID
,      TRIGGER_CREATED_FOR_ID
,      ARC_TRIGGER_CREATED_FOR
,      TRIGGERING_TYPE
,      VIEW_APPLICATION_ID
,      START_DATE_TIME
,      TIMEZONE_ID
,      USER_START_DATE_TIME
,      USER_LAST_RUN_DATE_TIME
,      USER_NEXT_RUN_DATE_TIME
,      USER_REPEAT_DAILY_START_TIME
,      USER_REPEAT_DAILY_END_TIME
,      USER_REPEAT_STOP_DATE_TIME
,      LAST_RUN_DATE_TIME
,      NEXT_RUN_DATE_TIME
,      REPEAT_DAILY_START_TIME
,      REPEAT_DAILY_END_TIME
,      REPEAT_FREQUENCY_TYPE
,      REPEAT_EVERY_X_FREQUENCY
,      REPEAT_STOP_DATE_TIME
,      METRICS_REFRESH_TYPE
,      TRIGGER_NAME
,      DESCRIPTION
,      NOTIFY_FLAG
,      EXECUTE_SCHEDULE_FLAG
,      TRIGGERED_STATUS
,      USAGE
FROM APPS.AMS_TRIGGERS_VL;

Dependencies

[top of page]

APPS

AMS_TRIGGERS

AMS_TRIGGERS_TL

APPS

AMS_TRIGGERS_V

AMS_TRIG_PVT - show dependent code

AMS_WFTRIG_PVT - show dependent code