[Home] [Help] [Dependency Information]
Object Name: | MTL_MVT_STATS_RULE_SETS_B |
---|---|
Object Type: | TABLE |
Owner: | INV |
FND Design Data: | INV.MTL_MVT_STATS_RULE_SETS_B |
Subobject Name: | |
Status: | VALID |
This table stores validation rule sets defined for parameters of the Movement Statistics records.
You need one row to define a rule set in the table.
Each row is identified by a Rule_Set_Code.
Rule_Set_Type determines the type of rule set. Valid values are, 'Attribute Property' for rule sets associated to fields of movement statistics record. 'Alternate Uom' for rules sets associated with alternate unit of measures defined for a commodity code.
Seeded_Flag determines if the rule is seeded or is user defined, valid values are 'Y' for preseeded rules and 'N' for user defined rules.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MTL_MVT_STATS_RULE_SETS_UK | NORMAL | UNIQUE | APPS_TS_SEED |
RULE_SET_CODE
ZD_EDITION_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RULE_SET_CODE | VARCHAR2 | (30) | Yes | Unique Identifier of a Rule Set. |
CREATED_BY | NUMBER | (15) | Yes | Standard Who Column |
CREATION_DATE | DATE | Yes | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who Column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who Column | |
RULE_SET_TYPE | VARCHAR2 | (30) | Yes | Type of Rule Set.Rule Set could be of two types, 'Atttribute Property' that defines valid values associated to a field in movement statistics record. Or 'Alternate Uom' which gives an alternate unit of measure for a commodity code. |
SEEDED_FLAG | VARCHAR2 | (1) | Yes | Flag to state whether Rule Set is system seeded or user defined. Valid values are 'Y' for preseeded rule sets and 'N' for user defined. |
CATEGORY_SET_ID | NUMBER | Category Set ID is used for alternate uom rule type to determine valid commodity codes falling under a category set. Each row in MTL_STAT_TYPE_USAGES stores a validation rule set. For alternate unit of measure validation, Category Set ID qualifies the commodity codes that could be associated to a rule in the rules table. | ||
ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT RULE_SET_CODE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, RULE_SET_TYPE
, SEEDED_FLAG
, CATEGORY_SET_ID
, ZD_EDITION_NAME
FROM INV.MTL_MVT_STATS_RULE_SETS_B;
INV.MTL_MVT_STATS_RULE_SETS_B does not reference any database object
INV.MTL_MVT_STATS_RULE_SETS_B is referenced by following:
|
|
|