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: INV.MTL_MVT_STATS_RULE_SETS_B

Object Details

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.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MTL_MVT_STATS_RULE_SETS_UK	NORMAL	UNIQUE	APPS_TS_SEED	RULE_SET_CODE

Columns

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.

Query Text

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
FROM INV.MTL_MVT_STATS_RULE_SETS_B;

Dependencies

[top of page]

INV.MTL_MVT_STATS_RULE_SETS_B does not reference any database object

INV.MTL_MVT_STATS_RULE_SETS_B is referenced by following:

APPS: MTL_MVT_STATS_RULE_SETS_B