[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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. |
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;
AMS.AMS_TRIGGER_CHECKS does not reference any database object
AMS.AMS_TRIGGER_CHECKS is referenced by following:
|
|
|