Search Results mtl_stat_type_usages




Overview
Explore in AI Chat

Overview

The MTL_STAT_TYPE_USAGES table is a core configuration table within the Oracle E-Business Suite Inventory (INV) module. Its primary role is to define and control the statistical type data required for each legal entity operating within the application. This table acts as a central mapping mechanism, linking legal entities and economic zones to specific statistical types and their associated usage rules. By storing this configuration, it enables the system to enforce and report on statistical data—such as intrastat reporting for the European Union—based on the legal and geographic context of a transaction. Its existence is fundamental for organizations that must comply with regional trade and fiscal regulations requiring detailed movement-of-goods statistics.

Key Information Stored

The table's structure is defined by its primary key and several foreign key relationships. The primary key uniquely identifies a configuration record through a combination of four columns: LEGAL_ENTITY_ID, ZONE_CODE, STAT_TYPE, and USAGE_TYPE. This design allows for granular control, specifying valid statistical types (STAT_TYPE) for a given usage (USAGE_TYPE) within a specific legal entity (LEGAL_ENTITY_ID) and economic zone (ZONE_CODE). Two critical foreign key columns, ATTRIBUTE_RULE_SET_CODE and ALT_UOM_RULE_SET_CODE, reference the MTL_MVT_STATS_RULE_SETS_B table. These columns determine which rule sets govern the validation of statistical attributes and the conversion rules for alternate units of measure, respectively, for the defined statistical type usage.

Common Use Cases and Queries

The primary use case for this table is the setup and maintenance of intrastat and other statistical reporting requirements within the Inventory and Order Management modules. A common administrative task is querying the current configuration for a legal entity to verify setup completeness. A typical validation query would join to related setup tables:

SELECT mstu.legal_entity_id,
       mstu.zone_code,
       mstu.stat_type,
       mstu.usage_type,
       mstu.attribute_rule_set_code,
       mstu.alt_uom_rule_set_code
  FROM inv.mtl_stat_type_usages mstu,
       hr_all_organization_units hou
 WHERE mstu.legal_entity_id = hou.organization_id
   AND hou.name = '&LEGAL_ENTITY_NAME';

This table is also central during transaction processing (e.g., shipping a sales order), where the system queries it to determine the applicable statistical type and rule sets for generating statistical data based on the transaction's legal entity, item, and destination.

Related Objects

  • HR_ALL_ORGANIZATION_UNITS: Provides the legal entity definition via a foreign key relationship on LEGAL_ENTITY_ID.
  • MTL_ECONOMIC_ZONES_B: Defines the economic zones (e.g., EU) referenced by the ZONE_CODE foreign key.
  • MTL_MVT_STATS_RULE_SETS_B: The source table for the rule sets governing attribute validation (ATTRIBUTE_RULE_SET_CODE) and unit of measure conversion (ALT_UOM_RULE_SET_CODE).
  • MTL_TRANSACTION_STATISTICS: This transactional table likely consumes the rules defined in MTL_STAT_TYPE_USAGES to store the actual statistical data generated from material transactions.