eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [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

Name	Datatype	Length	Mandatory
TRIGGER_ID	NUMBER		Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
CREATION_DATE	DATE		Yes
CREATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_LOGIN	NUMBER	(15)
OBJECT_VERSION_NUMBER	NUMBER	(9)
PROCESS_ID	NUMBER
TRIGGER_CREATED_FOR_ID	NUMBER		Yes
ARC_TRIGGER_CREATED_FOR	VARCHAR2	(30)	Yes
TRIGGERING_TYPE	VARCHAR2	(30)	Yes
VIEW_APPLICATION_ID	NUMBER		Yes
START_DATE_TIME	DATE		Yes
TIMEZONE_ID	NUMBER	(15)	Yes
USER_START_DATE_TIME	DATE
USER_LAST_RUN_DATE_TIME	DATE
USER_NEXT_RUN_DATE_TIME	DATE
USER_REPEAT_DAILY_START_TIME	DATE
USER_REPEAT_DAILY_END_TIME	DATE
USER_REPEAT_STOP_DATE_TIME	DATE
LAST_RUN_DATE_TIME	DATE
NEXT_RUN_DATE_TIME	DATE
REPEAT_DAILY_START_TIME	DATE
REPEAT_DAILY_END_TIME	DATE
REPEAT_FREQUENCY_TYPE	VARCHAR2	(30)
REPEAT_EVERY_X_FREQUENCY	NUMBER	(15)
REPEAT_STOP_DATE_TIME	DATE
METRICS_REFRESH_TYPE	VARCHAR2	(30)
TRIGGER_NAME	VARCHAR2	(120)	Yes
DESCRIPTION	VARCHAR2	(4000)
NOTIFY_FLAG	VARCHAR2	(1)
EXECUTE_SCHEDULE_FLAG	VARCHAR2	(1)
TRIGGERED_STATUS	VARCHAR2	(30)
USAGE	VARCHAR2	(30)

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_VL references the following:

APPS: AMS_TRIGGERS; AMS_TRIGGERS_TL

APPS.AMS_TRIGGERS_VL is referenced by following:

APPS: AMS_TRIGGERS_V; AMS_TRIG_PVT - show dependent code; AMS_WFTRIG_PVT - show dependent code