[Home] [Help] [Dependency Information]
Object Name: | AMV_D_COMPL_RULE_ITEMS |
---|---|
Object Type: | TABLE |
Owner: | AMV |
FND Design Data: | AMV.AMV_D_COMPL_RULE_ITEMS |
Subobject Name: | |
Status: | VALID |
AMV_D_COMPL_RULE_ITEMS stores what rule conditions together build up a complex distribution rule.
Example of two rule conditions:
Customer.Revenue 'BETWEEN 100 and 200'
Customer.Profile = 'Fortune 500 Company'
So, this table documents the fact that this item should only be published to the calling application (e.g. Deal Maker from OFS) if both of the conditions above are met. ('Met' means that the parameters passed in by the calling application contain these values). Basically this table can be seen as grouping rule conditions together with an 'AND' condition.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AMV_D_COMPL_RULE_ITEMS_U1 | NORMAL | UNIQUE | APPS_TS_SEED | COMPLEX_RULE_ITEM_ID |
AMV_D_COMPL_RULE_ITEMS_N1 | NORMAL | NONUNIQUE | APPS_TS_SEED | RULE_CONDITION_ID |
AMV_D_COMPL_RULE_ITEMS_N2 | NORMAL | NONUNIQUE | APPS_TS_SEED | ITEM_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
COMPLEX_RULE_ITEM_ID | NUMBER | Yes | Complex rule item Identifier | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | This column is used for locking purposes |
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 | |
COMPLEX_RULE_ID | NUMBER | Yes | Complex rule Identifier | |
RULE_CONDITION_ID | NUMBER | Yes | Rule Condition Identifier | |
ITEM_ID | NUMBER | Yes | Item Identifier | |
STATUS | VARCHAR2 | (30) | Yes | Status of complex rule |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments |
Cut, paste (and edit) the following text to query this object:
SELECT COMPLEX_RULE_ITEM_ID
, OBJECT_VERSION_NUMBER
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, COMPLEX_RULE_ID
, RULE_CONDITION_ID
, ITEM_ID
, STATUS
, SECURITY_GROUP_ID
FROM AMV.AMV_D_COMPL_RULE_ITEMS;
AMV.AMV_D_COMPL_RULE_ITEMS does not reference any database object
AMV.AMV_D_COMPL_RULE_ITEMS is referenced by following:
|
|
|