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_TRIGGER_CHECKS

Object Details

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

AMS_TRIGGER_CHECKS stores all checks that should be run when a datetime(specified in the AMS_TRIGGERS table) is reached. If any of these checks are true the actions specified for the trigger will be executed. Some examples of checks that can be performed:
- Check when a certain activity metric <= than a certain value
- Check when a certain activity metric => than another metric(support forecast vs actual checks)
- Check when a certain activity metric > Check no of rows returned by a workbook
Chk1 is Refered as the Left hand side of the Check and Chk2 is refered as the right hand side of the check.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AMS_TRIGGER_CHECKS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	TRIGGER_CHECK_ID
AMS_TRIGGER_CHECKS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRIGGER_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TRIGGER_CHECK_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.
TRIGGER_ID	NUMBER		Yes	Indicates the Trigger to which this check is attached
ORDER_NUMBER	NUMBER	(15)		Indicates the Order number of the Check attached to Trigger
CHK1_TYPE	VARCHAR2	(30)	Yes	Type of Right Hand Side of the Check For example Metric
CHK1_ARC_SOURCE_CODE_FROM	VARCHAR2	(30)		Indicates Whether the Left hand side Metric is attached to Campaign or Collateral.
CHK1_SOURCE_CODE	VARCHAR2	(30)		Source code of the Activity to which the Left hand side Metric is attached. For example Source code of the Campaign if the CHK1_ARC_SOURCE_CODE_FROM is CAMP
CHK1_SOURCE_CODE_METRIC_ID	NUMBER			Indicates the Metric id of the Left hand side of the Check.
CHK1_SOURCE_CODE_METRIC_TYPE	VARCHAR2	(30)		Indicates the Metric Type of the left hand side of the check. For example Forecasted,Actual.
CHK1_TO_CHK2_OPERATOR_TYPE	VARCHAR2	(30)	Yes	Indicates the Operator of the check.
CHK2_TYPE	VARCHAR2	(30)	Yes	Indicates the Type of the Right hand side of the check. For example Metric,Workbook,Static Value.
CHK2_VALUE	NUMBER	(15)		Indicates the Value for Right hand side of the Check if the Right hand side of the Check is Static Value.
CHK2_LOW_VALUE	NUMBER	(15)		Indicates the low value of the range of the right hand side of the check if it is Static Value Range.
CHK2_HIGH_VALUE	NUMBER	(15)		Indicates the High value of the range of the right hand side of the check if it is Static Value Range.
CHK2_UOM_CODE	VARCHAR2	(3)		Indicates the uom of the Static Values.
CHK2_CURRENCY_CODE	VARCHAR2	(15)		Indicates the Currency of the Static value.
CHK2_SOURCE_CODE	VARCHAR2	(30)		Source code of the Activity to which the Right hand side Metric is attached. For example Source code of the Campaign if the CHK2_ARC_SOURCE_CODE_FROM is CAMP.
CHK2_ARC_SOURCE_CODE_FROM	VARCHAR2	(30)		Indicates Whether the Right hand side Metric is attached to Campaign or Collateral.
CHK2_SOURCE_CODE_METRIC_ID	NUMBER			Indicates the Metric id of the Right hand side of the Check.
CHK2_SOURCE_CODE_METRIC_TYPE	VARCHAR2	(30)		Indicates the Metric Type of the Right hand side of the check. For example Forecasted,Actual.
CHK2_WORKBOOK_NAME	VARCHAR2	(254)		Indicates the name of the workbook if the Right hand side of the check is Workbook.
CHK2_WORKBOOK_OWNER	VARCHAR2	(100)		Indicates the name of the workbook Owner if the Right hand side of the check is Workbook.
CHK2_WORKSHEET_NAME	VARCHAR2	(254)		Indicates the name of the worksheet of the workbook if the Right hand side of the check is Workbook.
SECURITY_GROUP_ID	NUMBER			Used in hosted environments
CHK1_ACT_OBJECT_ID	NUMBER			Left hand side object of the trigger check.
CHK2_ACT_OBJECT_ID	NUMBER			Left hand side object of the trigger check.

Query Text

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


SELECT TRIGGER_CHECK_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      TRIGGER_ID
,      ORDER_NUMBER
,      CHK1_TYPE
,      CHK1_ARC_SOURCE_CODE_FROM
,      CHK1_SOURCE_CODE
,      CHK1_SOURCE_CODE_METRIC_ID
,      CHK1_SOURCE_CODE_METRIC_TYPE
,      CHK1_TO_CHK2_OPERATOR_TYPE
,      CHK2_TYPE
,      CHK2_VALUE
,      CHK2_LOW_VALUE
,      CHK2_HIGH_VALUE
,      CHK2_UOM_CODE
,      CHK2_CURRENCY_CODE
,      CHK2_SOURCE_CODE
,      CHK2_ARC_SOURCE_CODE_FROM
,      CHK2_SOURCE_CODE_METRIC_ID
,      CHK2_SOURCE_CODE_METRIC_TYPE
,      CHK2_WORKBOOK_NAME
,      CHK2_WORKBOOK_OWNER
,      CHK2_WORKSHEET_NAME
,      SECURITY_GROUP_ID
,      CHK1_ACT_OBJECT_ID
,      CHK2_ACT_OBJECT_ID
FROM AMS.AMS_TRIGGER_CHECKS;

Dependencies

[top of page]

AMS.AMS_TRIGGER_CHECKS does not reference any database object

AMS.AMS_TRIGGER_CHECKS is referenced by following:

AMS: AMS_TRIGGER_CHECKS#