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: AMS.AMS_TRIGGERS#

Object Details

Object Name:	AMS_TRIGGERS#
Object Type:	VIEW
Owner:	AMS
Subobject Name:
Status:	VALID

[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
TRIGGER_NAME	VARCHAR2	(120)
VIEW_APPLICATION_ID	NUMBER		Yes
START_DATE_TIME	DATE		Yes
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)
DESCRIPTION	VARCHAR2	(4000)
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
SECURITY_GROUP_ID	NUMBER
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
,      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# references the following:

AMS: AMS_TRIGGERS

AMS.AMS_TRIGGERS# is referenced by following:

APPS: AMS_TRIGGERS