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: TableAMS.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: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AMS_TRIGGER_CHECKS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRIGGER_CHECK_ID
AMS_TRIGGER_CHECKS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRIGGER_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:

SchemaAPPS
SynonymAMS_TRIGGER_CHECKS