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]

TABLE: AMS.AMS_TRIGGERS

Object Details

Object Name:	AMS_TRIGGERS
Object Type:	TABLE
Owner:	AMS
FND Design Data:	AMS.AMS_TRIGGERS
Subobject Name:
Status:	VALID

AMS_TRIGGERS stores the detail for the Triggers which sould fire at specific time and at specific interwals. The Triggers can have checks and Actions associated with it. The checks are stored in AMS_TRIGGER_CHECKS and the actions are stored in AMS_TRIGGER_ACTIONS.
The Trigger can be used to Refresh Metrics also.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AMS_TRIGGERS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	TRIGGER_ID
AMS_TRIGGERS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRIGGER_CREATED_FOR_ID ARC_TRIGGER_CREATED_FOR
AMS_TRIGGERS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRIGGERED_STATUS
AMS_TRIGGERS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	USAGE

Columns

Name	Datatype	Length	Mandatory	Comments
TRIGGER_ID	NUMBER		Yes	Unique Identifier.
LAST_UPDATE_DATE	DATE		Yes	Standard WHO Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO Column
CREATION_DATE	DATE		Yes	Standard WHO Column
CREATED_BY	NUMBER	(15)	Yes	Standard WHO Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO Column
OBJECT_VERSION_NUMBER	NUMBER	(9)		This column is used for locking purposes.
PROCESS_ID	NUMBER			Item Key of last Workflow process ran for this Trigger
TRIGGER_CREATED_FOR_ID	NUMBER		Yes	Indicates the Id of the Activity for which this Trigger is created. For example Campaign Id.
ARC_TRIGGER_CREATED_FOR	VARCHAR2	(30)	Yes	Indicates wether the Trigger was created for Campaigns or Events.
TRIGGERING_TYPE	VARCHAR2	(30)	Yes	Indicates whether the Trigger is date Trigger or if there is check attached to it. For example, Metric to Metric, Metric to Value.
TRIGGER_NAME	VARCHAR2	(120)		Indicates the name of the Trigger.
VIEW_APPLICATION_ID	NUMBER		Yes	Indicates which Application has created this Trigger.
START_DATE_TIME	DATE		Yes	Server Start Date and Time of the Trigger execution.
LAST_RUN_DATE_TIME	DATE			Indicates Server Date and time when Trigger was executed last time.
NEXT_RUN_DATE_TIME	DATE			Indicates the Server Date and time when Trigger will execute again.
REPEAT_DAILY_START_TIME	DATE			Indiates the Server Start time of the period of the day during which Trigger can execute or repeat.
REPEAT_DAILY_END_TIME	DATE			Indiates the Server End time of the period of the day during which Trigger can execute or repeat.
REPEAT_FREQUENCY_TYPE	VARCHAR2	(30)		Indicates whether the Trigger will repeat Daily,Monthly.
REPEAT_EVERY_X_FREQUENCY	NUMBER	(15)		Indicates the number of Repeat Frequency Type. like, 1 Day, 2 Days
REPEAT_STOP_DATE_TIME	DATE			Indicates the Server Expiry date of the Trigger.
METRICS_REFRESH_TYPE	VARCHAR2	(30)		Indicates if all Metrics has to be refreshed or only particular metric. If a single Metric has to be refreshed , the ARC_TRIGGER_CREATED_FOR and TRIGGER_CREATED_FOR_ID will store the details of that Activity Metric.
DESCRIPTION	VARCHAR2	(4000)		Description of the Trigger.
TIMEZONE_ID	NUMBER	(15)	Yes	Timezone id of the User.
USER_START_DATE_TIME	DATE			User Start Date and Time of the Trigger execution.
USER_LAST_RUN_DATE_TIME	DATE			Indicates User Date and time when Trigger was executed last time.
USER_NEXT_RUN_DATE_TIME	DATE			Indicates the User Date and time when Trigger will execute again.
USER_REPEAT_DAILY_START_TIME	DATE			Indiates the User Start time of the period of the day during which Trigger can execute or repeat.
USER_REPEAT_DAILY_END_TIME	DATE			Indiates the User End time of the period of the day during which Trigger can execute or repeat.
USER_REPEAT_STOP_DATE_TIME	DATE			Indicates the User Expiry date of the Trigger.
SECURITY_GROUP_ID	NUMBER			Used in hosted environments
NOTIFY_FLAG	VARCHAR2	(1)		Flag to indicate if notification should be sent when trigger check meets.
EXECUTE_SCHEDULE_FLAG	VARCHAR2	(1)		Flag to indicate if the associated schedules should be execute when the trigger check meets.
TRIGGERED_STATUS	VARCHAR2	(30)		Reflects whether the trigger is dormant or active
USAGE	VARCHAR2	(30)		Used for separating Triggers from Monitors in R12

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
,      TRIGGER_NAME
,      VIEW_APPLICATION_ID
,      START_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
,      DESCRIPTION
,      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
,      SECURITY_GROUP_ID
,      NOTIFY_FLAG
,      EXECUTE_SCHEDULE_FLAG
,      TRIGGERED_STATUS
,      USAGE
FROM AMS.AMS_TRIGGERS;

Dependencies

[top of page]

AMS.AMS_TRIGGERS does not reference any database object

AMS.AMS_TRIGGERS is referenced by following:

APPS: AMS_TRIGGERS