Search Results mtl_mvt_stats_rule_sets_b




Overview
Explore in AI Chat

Overview

The MTL_MVT_STATS_RULE_SETS_B table is a core data structure within the Oracle E-Business Suite Inventory (INV) module. It functions as a master repository for defining rule sets, which are collections of validation rules governing the processing of movement statistics. These rule sets are integral to the system's ability to enforce data integrity and business logic on inventory transaction data. The table's primary role is to serve as a reference point for associating specific validation logic with statistical types and their usage, ensuring that inventory movement reporting and analysis adhere to configured standards.

Key Information Stored

The table's structure is centered on the unique identification and definition of a rule set. The primary and most critical column is RULE_SET_CODE, which stores a unique identifier for each validation rule set. This code acts as the key for all related configurations. While the provided ETRM metadata does not list additional columns for this base table, it is standard for such 'B' (base) tables in Oracle EBS to contain columns for creation date, created by, last update date, and last updated by to track record maintenance. The descriptive, translatable name for the rule set is stored in the related MTL_MVT_STATS_RULE_SETS_TL table, linked via the RULE_SET_CODE.

Common Use Cases and Queries

This table is primarily accessed for setup, maintenance, and diagnostic reporting of movement statistics validation rules. Common operational scenarios include validating which rule set is assigned to a specific statistical type or transaction action, and identifying all rules belonging to a particular set. A typical query would join this table to its descriptive translation table and related rules. For example, to list all defined rule sets with their descriptions, one might use:

  • SELECT b.RULE_SET_CODE, tl.RULE_SET_NAME FROM INV.MTL_MVT_STATS_RULE_SETS_B b, INV.MTL_MVT_STATS_RULE_SETS_TL tl WHERE b.RULE_SET_CODE = tl.RULE_SET_CODE AND tl.LANGUAGE = USERENV('LANG');

Another common pattern is to trace the application of a rule set by joining to MTL_STAT_TYPE_USAGES to see where it is applied as an attribute or alternate UOM rule set.

Related Objects

The MTL_MVT_STATS_RULE_SETS_B table maintains defined relationships with several other Inventory tables, as documented in the foreign key metadata.

  • MTL_MVT_STATS_RULES: This table stores the individual validation rules. It references MTL_MVT_STATS_RULE_SETS_B via the column MTL_MVT_STATS_RULES.RULE_SET_CODE, defining a one-to-many relationship where one rule set contains many rules.
  • MTL_STAT_TYPE_USAGES: This table references a rule set twice, applying it to statistical type usages. It uses MTL_MVT_STATS_RULE_SETS_B.RULE_SET_CODE for both the ATTRIBUTE_RULE_SET_CODE and the ALT_UOM_RULE_SET_CODE columns, linking the validation logic to specific transaction actions.
  • MTL_MVT_STATS_RULE_SETS_TL: This is the Translation table for the base entity. It holds the language-specific names and descriptions for each rule set, joined by the RULE_SET_CODE column.
  • Table: MTL_MVT_STATS_RULE_SETS_B 12.1.1

    owner:INV,  object_type:TABLE,  fnd_design_data:INV.MTL_MVT_STATS_RULE_SETS_B,  object_name:MTL_MVT_STATS_RULE_SETS_B,  status:VALID,  product: INV - Inventory ,  description: Movement Statistics table to store Rule Sets for validation rules. ,  implementation_dba_data: INV.MTL_MVT_STATS_RULE_SETS_B , 

  • Table: MTL_MVT_STATS_RULE_SETS_B 12.2.2

    owner:INV,  object_type:TABLE,  fnd_design_data:INV.MTL_MVT_STATS_RULE_SETS_B,  object_name:MTL_MVT_STATS_RULE_SETS_B,  status:VALID,  product: INV - Inventory ,  description: Movement Statistics table to store Rule Sets for validation rules. ,  implementation_dba_data: INV.MTL_MVT_STATS_RULE_SETS_B , 

  • Table: MTL_MVT_STATS_RULES 12.1.1

    owner:INV,  object_type:TABLE,  fnd_design_data:INV.MTL_MVT_STATS_RULES,  object_name:MTL_MVT_STATS_RULES,  status:VALID,  product: INV - Inventory ,  description: This table stores validation rules defined for movement statistics fields that belong to a rule set as defined in MTL_MVT_STATS_RULE_SETS_B table.Each row stores a rule that can determine a valid set of values for a field or an alternate u ,  implementation_dba_data: INV.MTL_MVT_STATS_RULES , 

  • Table: MTL_STAT_TYPE_USAGES 12.2.2

    owner:INV,  object_type:TABLE,  fnd_design_data:INV.MTL_STAT_TYPE_USAGES,  object_name:MTL_STAT_TYPE_USAGES,  status:VALID,  product: INV - Inventory ,  description: Stores information which determines the statistical type data for each legal entity. ,  implementation_dba_data: INV.MTL_STAT_TYPE_USAGES , 

  • Table: MTL_STAT_TYPE_USAGES 12.1.1

    owner:INV,  object_type:TABLE,  fnd_design_data:INV.MTL_STAT_TYPE_USAGES,  object_name:MTL_STAT_TYPE_USAGES,  status:VALID,  product: INV - Inventory ,  description: Stores information which determines the statistical type data for each legal entity. ,  implementation_dba_data: INV.MTL_STAT_TYPE_USAGES , 

  • Table: MTL_MVT_STATS_RULES 12.2.2

    owner:INV,  object_type:TABLE,  fnd_design_data:INV.MTL_MVT_STATS_RULES,  object_name:MTL_MVT_STATS_RULES,  status:VALID,  product: INV - Inventory ,  description: This table stores validation rules defined for movement statistics fields that belong to a rule set as defined in MTL_MVT_STATS_RULE_SETS_B table.Each row stores a rule that can determine a valid set of values for a field or an alternate u ,  implementation_dba_data: INV.MTL_MVT_STATS_RULES , 

  • View: MTL_MVT_STATS_RULE_SETS_VL 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:INV.MTL_MVT_STATS_RULE_SETS_VL,  object_name:MTL_MVT_STATS_RULE_SETS_VL,  status:VALID,  product: INV - Inventory ,  description: Multilingual view for Rule Sets tables. ,  implementation_dba_data: APPS.MTL_MVT_STATS_RULE_SETS_VL , 

  • Table: MTL_MVT_STATS_RULE_SETS_TL 12.1.1

    owner:INV,  object_type:TABLE,  fnd_design_data:INV.MTL_MVT_STATS_RULE_SETS_TL,  object_name:MTL_MVT_STATS_RULE_SETS_TL,  status:VALID,  product: INV - Inventory ,  description: MTL_MVT_STATS_RULE_SET_TL is the corresponding transalation table for MTL_MVT_STATS_RULE_SET_B.This table contains one entry for every Rule Set Code and Language.Rule Set Code and Language uniquely identify a row.Rule Set Display Name iden ,  implementation_dba_data: INV.MTL_MVT_STATS_RULE_SETS_TL , 

  • Table: MTL_MVT_STATS_RULE_SETS_TL 12.2.2

    owner:INV,  object_type:TABLE,  fnd_design_data:INV.MTL_MVT_STATS_RULE_SETS_TL,  object_name:MTL_MVT_STATS_RULE_SETS_TL,  status:VALID,  product: INV - Inventory ,  description: MTL_MVT_STATS_RULE_SET_TL is the corresponding transalation table for MTL_MVT_STATS_RULE_SET_B.This table contains one entry for every Rule Set Code and Language.Rule Set Code and Language uniquely identify a row.Rule Set Display Name iden ,  implementation_dba_data: INV.MTL_MVT_STATS_RULE_SETS_TL , 

  • View: MTL_MVT_STATS_RULE_SETS_VL 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:INV.MTL_MVT_STATS_RULE_SETS_VL,  object_name:MTL_MVT_STATS_RULE_SETS_VL,  status:VALID,  product: INV - Inventory ,  description: Multilingual view for Rule Sets tables. ,  implementation_dba_data: APPS.MTL_MVT_STATS_RULE_SETS_VL ,