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.AML_MONITOR_CONDITIONS

Object Details

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

Monitor rules may have conditions which are stored in this table

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AML_MONITOR_CONDITIONS_U1	NORMAL	UNIQUE	APPS_TS_SEED	MONITOR_CONDITION_ID
AML_MONITOR_CONDITIONS_U2	NORMAL	UNIQUE	APPS_TS_SEED	PROCESS_RULE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
MONITOR_CONDITION_ID	NUMBER		Yes	Monitor Condition Identifier
LAST_UPDATE_DATE	DATE		Yes	Standard WHO column
LAST_UPDATED_BY	NUMBER		Yes	Standard WHO column
CREATION_DATE	DATE		Yes	Standard WHO column
CREATED_BY	NUMBER		Yes	Standard WHO column
LAST_UPDATE_LOGIN	NUMBER		Yes	Standard WHO column
OBJECT_VERSION_NUMBER	NUMBER		Yes	Object Version Number. Used by API's for checking whether record has been modified
REQUEST_ID	NUMBER			Standard WHO column
PROGRAM_APPLICATION_ID	NUMBER			Application identifier of last concurrent program to update record
PROGRAM_ID	NUMBER			Identifier of last concurrent program to update record
PROGRAM_UPDATE_DATE	DATE			Last date concurrent program updated record
PROCESS_RULE_ID	NUMBER		Yes	Process rule identifier. Foreign key to PV_PROCESS_RULES table.
MONITOR_TYPE_CODE	VARCHAR2	(30)		Category Monitor
TIME_LAG_NUM	NUMBER			Time Unit for calculating when the first notification should be sent.
TIME_LAG_UOM_CODE	VARCHAR2	(10)		Unit of Measure for Time Lag
TIME_LAG_FROM_STAGE	VARCHAR2	(100)		The starting state for monitor to start
TIME_LAG_TO_STAGE	VARCHAR2	(100)		The ending stage for the Monitor
EXPIRATION_RELATIVE	VARCHAR2	(1)		If set to Y, the first notification is sent time_lag_num before expiration date
REMINDER_DEFINED	VARCHAR2	(1)		stores whether reminders are set
TOTAL_REMINDERS	NUMBER			stores total num of reminders
REMINDER_FREQUENCY	NUMBER			stores info of time diff between reminders
REMINDER_FREQ_UOM_CODE	VARCHAR2	(30)		Unit of Measure of Reminder Freq
TIMEOUT_DEFINED	VARCHAR2	(1)		Stores info whether Lead needs to be Timeout out and rerouted
TIMEOUT_DURATION	NUMBER			Stores info on the time after first notification that the lead should be rerouted
TIMEOUT_UOM_CODE	VARCHAR2	(30)		Unit of Measure of Timeout duration
NOTIFY_OWNER	VARCHAR2	(1)		stores whether notification should be sent to Lead Owner
NOTIFY_OWNER_MANAGER	VARCHAR2	(1)		stores info whether notification should be sent to lead owner's manager
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive Flexfield category.
ATTRIBUTE1	VARCHAR2	(150)		Descriptive Flexfield column.
ATTRIBUTE2	VARCHAR2	(150)		Descriptive Flexfield column.
ATTRIBUTE3	VARCHAR2	(150)		Descriptive Flexfield column.
ATTRIBUTE4	VARCHAR2	(150)		Descriptive Flexfield column.
ATTRIBUTE5	VARCHAR2	(150)		Descriptive Flexfield column.
ATTRIBUTE6	VARCHAR2	(150)		Descriptive Flexfield column.
ATTRIBUTE7	VARCHAR2	(150)		Descriptive Flexfield column.
ATTRIBUTE8	VARCHAR2	(150)		Descriptive Flexfield column.
ATTRIBUTE9	VARCHAR2	(150)		Descriptive Flexfield column.
ATTRIBUTE10	VARCHAR2	(150)		Descriptive Flexfield column.
ATTRIBUTE11	VARCHAR2	(150)		Descriptive Flexfield column.
ATTRIBUTE12	VARCHAR2	(150)		Descriptive Flexfield column.
ATTRIBUTE13	VARCHAR2	(150)		Descriptive Flexfield column.
ATTRIBUTE14	VARCHAR2	(150)		Descriptive Flexfield column.
ATTRIBUTE15	VARCHAR2	(150)		Descriptive Flexfield column.
SECURITY_GROUP_ID	NUMBER			Subscriber id, for CRM Online Services use

Query Text

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


SELECT MONITOR_CONDITION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      PROCESS_RULE_ID
,      MONITOR_TYPE_CODE
,      TIME_LAG_NUM
,      TIME_LAG_UOM_CODE
,      TIME_LAG_FROM_STAGE
,      TIME_LAG_TO_STAGE
,      EXPIRATION_RELATIVE
,      REMINDER_DEFINED
,      TOTAL_REMINDERS
,      REMINDER_FREQUENCY
,      REMINDER_FREQ_UOM_CODE
,      TIMEOUT_DEFINED
,      TIMEOUT_DURATION
,      TIMEOUT_UOM_CODE
,      NOTIFY_OWNER
,      NOTIFY_OWNER_MANAGER
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      SECURITY_GROUP_ID
FROM AMS.AML_MONITOR_CONDITIONS;

Dependencies

[top of page]

AMS.AML_MONITOR_CONDITIONS does not reference any database object

AMS.AML_MONITOR_CONDITIONS is referenced by following:

AMS: AML_MONITOR_CONDITIONS#