Search Results origin_territory_code
The INV.MTL_MOVEMENT_STATISTICS
table in Oracle E-Business Suite (EBS) 12.1.1 or 12.2.2 is a critical data repository within the Inventory (INV) module, designed to track and analyze movement statistics for inventory items. This table plays a pivotal role in capturing transactional data related to item movements, providing visibility into stock transfers, receipts, issues, and adjustments. Below is a detailed breakdown of its structure, purpose, and significance in Oracle EBS implementations.
Purpose and Functional Overview
TheMTL_MOVEMENT_STATISTICS
table serves as a historical ledger for inventory movements, enabling organizations to monitor item flow across warehouses, subinventories, and locators. It stores aggregated data derived from transactional tables like MTL_MATERIAL_TRANSACTIONS
, facilitating reporting and analytical processes without directly impacting transactional integrity. Key use cases include:
- Inventory Turnover Analysis: Tracks how frequently items move in and out of stock, aiding in demand forecasting.
- Performance Metrics: Measures efficiency of warehouse operations by analyzing movement patterns.
- Audit and Compliance: Provides a traceable record of item movements for regulatory reporting.
Table Structure and Key Columns
The table comprises columns that categorize movement types, quantify transactions, and link to related entities. Notable columns include:- MOVEMENT_STATISTIC_ID: Primary key, uniquely identifying each movement record.
- INVENTORY_ITEM_ID: References
MTL_SYSTEM_ITEMS_B
, linking to the item master. - ORGANIZATION_ID: Associates movements with a specific inventory organization.
- SUBINVENTORY_CODE: Identifies the subinventory involved in the movement.
- TRANSACTION_TYPE_ID: Categorizes movements (e.g., receipt, issue, transfer) via
MTL_TRANSACTION_TYPES
. - QUANTITY: Captures the unit count of items moved.
- TRANSACTION_DATE: Timestamp of the movement.
- UOM_CODE: Unit of measure for the quantity.
Integration with Other Modules
MTL_MOVEMENT_STATISTICS
integrates with core EBS modules:
- Purchasing (PO): Tracks receipt transactions from purchase orders.
- Order Management (OM): Logs issues tied to sales orders.
- Cost Management (CST): Supports cost roll-up calculations by providing movement data.
Technical Considerations
- Data Population: Typically updated via batch processes or triggers from transactional tables.
- Indexing: Commonly indexed on
INVENTORY_ITEM_ID
,ORGANIZATION_ID
, andTRANSACTION_DATE
for query performance. - Purge Policies: Historical data may be archived to maintain performance, leveraging Oracle’s partitioning or custom purge scripts.
Reporting and Analytics
The table feeds standard Oracle reports (e.g., Inventory Turnover Report) and custom BI solutions. SQL queries often join withMTL_SYSTEM_ITEMS_B
, MTL_CATEGORIES
, and MTL_TRANSACTION_TYPES
to enrich movement data with item descriptions, categories, and transaction types.
Conclusion
INV.MTL_MOVEMENT_STATISTICS
is a foundational table for inventory analytics in Oracle EBS, offering granular insights into item movements. Its structured design supports operational reporting, compliance, and strategic decision-making, making it indispensable for inventory-intensive businesses. Proper utilization of this table enhances visibility into supply chain dynamics, optimizing stock levels and warehouse efficiency.
-
VIEW: INV.MTL_MOVEMENT_STATISTICS#
12.2.2
-
VIEW: APPS.INVBV_MOVEMENT_STATISTICS
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:INV.INVBV_MOVEMENT_STATISTICS, object_name:INVBV_MOVEMENT_STATISTICS, status:VALID,
-
VIEW: APPS.INVBV_MOVEMENT_STATISTICS
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:INV.INVBV_MOVEMENT_STATISTICS, object_name:INVBV_MOVEMENT_STATISTICS, status:VALID,
-
Lookup Type: MVT_ATTRIBUTE_NAME
12.2.2
product: INV - Inventory , meaning: MVT_ATTRIBUTE_NAME , description: Attribute Names ,
-
View: ECE_MVSTO_DETAILS_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:EC.ECE_MVSTO_DETAILS_V, object_name:ECE_MVSTO_DETAILS_V, status:VALID, product: EC - e-Commerce Gateway , description: This view extracts line informationfor the outbound Movement Statistics (INTRASTAT) transaction.@rep:scope private@rep:product INV@rep:lifecycle active@rep:displayname Movement Statistics Line View@rep:category BUSINESS_ENTITY INV_MOVEMENT_ , implementation_dba_data: APPS.ECE_MVSTO_DETAILS_V ,
-
APPS.MTL_MOVEMENT_STAT_PKG SQL Statements
12.1.1
-
Lookup Type: MVT_ATTRIBUTE_NAME
12.1.1
product: INV - Inventory , meaning: MVT_ATTRIBUTE_NAME , description: Attribute Names ,
-
APPS.INV_MGD_MVT_EXPORT_DATA SQL Statements
12.1.1
-
APPS.INV_MGD_MVT_EXPORT_DATA SQL Statements
12.2.2
-
APPS.MTL_MOVEMENT_STAT_PKG SQL Statements
12.2.2
-
View: ECE_MVSTO_DETAILS_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:EC.ECE_MVSTO_DETAILS_V, object_name:ECE_MVSTO_DETAILS_V, status:VALID, product: EC - e-Commerce Gateway , description: This view extracts line informationfor the outbound Movement Statistics (INTRASTAT) transaction.@rep:scope private@rep:product INV@rep:lifecycle active@rep:displayname Movement Statistics Line View@rep:category BUSINESS_ENTITY INV_MOVEMENT_ , implementation_dba_data: APPS.ECE_MVSTO_DETAILS_V ,
-
VIEW: EC.ECE_MVSTO_DETAILS#
12.2.2
-
View: INVBV_MOVEMENT_STATISTICS
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:INV.INVBV_MOVEMENT_STATISTICS, object_name:INVBV_MOVEMENT_STATISTICS, status:VALID, product: INV - Inventory , description: - Retrofitted , implementation_dba_data: APPS.INVBV_MOVEMENT_STATISTICS ,
-
VIEW: INV.MTL_MOVEMENT_STATISTICS#
12.2.2
owner:INV, object_type:VIEW, object_name:MTL_MOVEMENT_STATISTICS#, status:VALID,
-
View: INVBV_MOVEMENT_STATISTICS
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:INV.INVBV_MOVEMENT_STATISTICS, object_name:INVBV_MOVEMENT_STATISTICS, status:VALID, product: INV - Inventory , description: - Retrofitted , implementation_dba_data: APPS.INVBV_MOVEMENT_STATISTICS ,
-
VIEW: APPS.ECE_MVSTO_DETAILS_V
12.1.1
-
VIEW: APPS.ECE_MVSTO_DETAILS_V
12.2.2
-
APPS.MTL_MOVEMENT_STATISTICS2_PKG SQL Statements
12.2.2
-
APPS.MTL_MOVEMENT_STATISTICS2_PKG SQL Statements
12.1.1
-
VIEW: APPS.ECE_MVSTO_DETAILS_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:EC.ECE_MVSTO_DETAILS_V, object_name:ECE_MVSTO_DETAILS_V, status:VALID,
-
VIEW: APPS.ECE_MVSTO_DETAILS_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:EC.ECE_MVSTO_DETAILS_V, object_name:ECE_MVSTO_DETAILS_V, status:VALID,
-
APPS.MTL_MOVEMENT_STATISTICS3_PKG SQL Statements
12.2.2
-
APPS.MTL_MOVEMENT_STATISTICS3_PKG SQL Statements
12.1.1
-
APPS.MTL_MOVEMENT_STATISTICS1_PKG SQL Statements
12.2.2
-
APPS.MTL_MOVEMENT_STATISTICS1_PKG SQL Statements
12.1.1
-
VIEW: EC.ECE_MVSTO_DETAILS#
12.2.2
owner:EC, object_type:VIEW, object_name:ECE_MVSTO_DETAILS#, status:VALID,
-
View: INVFV_MOVEMENT_STATISTICS
12.1.1
product: INV - Inventory , description: - Retrofitted , implementation_dba_data: Not implemented in this database ,
-
View: INVFV_MOVEMENT_STATISTICS
12.2.2
product: INV - Inventory , description: - Retrofitted , implementation_dba_data: Not implemented in this database ,
-
PACKAGE BODY: APPS.MTL_MOVEMENT_STATISTICS3_PKG
12.2.2
-
PACKAGE BODY: APPS.MTL_MOVEMENT_STATISTICS3_PKG
12.1.1
-
View: MTL_MOVEMENT_STATISTICS_V
12.1.1
product: INV - Inventory , implementation_dba_data: Not implemented in this database ,
-
View: MTL_MOVEMENT_STATISTICS_V
12.2.2
product: INV - Inventory , implementation_dba_data: Not implemented in this database ,
-
TABLE: INV.MTL_MOVEMENT_STATISTICS
12.1.1
owner:INV, object_type:TABLE, fnd_design_data:INV.MTL_MOVEMENT_STATISTICS, object_name:MTL_MOVEMENT_STATISTICS, status:VALID,
-
TABLE: INV.MTL_MOVEMENT_STATISTICS
12.2.2
owner:INV, object_type:TABLE, fnd_design_data:INV.MTL_MOVEMENT_STATISTICS, object_name:MTL_MOVEMENT_STATISTICS, status:VALID,
-
APPS.INV_MGD_MVT_STATS_PVT SQL Statements
12.2.2
-
APPS.INV_MGD_MVT_STATS_PVT SQL Statements
12.1.1
-
PACKAGE BODY: APPS.MTL_MOVEMENT_STATISTICS1_PKG
12.2.2
-
PACKAGE BODY: APPS.MTL_MOVEMENT_STATISTICS1_PKG
12.1.1
-
PACKAGE BODY: APPS.MTL_MOVEMENT_STAT_PKG
12.1.1
-
PACKAGE BODY: APPS.MTL_MOVEMENT_STAT_PKG
12.2.2
-
TABLE: EC.ECE_MVSTO_DETAILS
12.2.2
owner:EC, object_type:TABLE, fnd_design_data:EC.ECE_MVSTO_DETAILS, object_name:ECE_MVSTO_DETAILS, status:VALID,
-
TABLE: EC.ECE_MVSTO_DETAILS
12.1.1
owner:EC, object_type:TABLE, fnd_design_data:EC.ECE_MVSTO_DETAILS, object_name:ECE_MVSTO_DETAILS, status:VALID,
-
APPS.INV_MGD_MVT_STATS_PROC SQL Statements
12.1.1
-
APPS.INV_MGD_MVT_STATS_PROC SQL Statements
12.2.2
-
APPS.INV_MGD_MVT_DATA_STR dependencies on MTL_MOVEMENT_STATISTICS
12.2.2
-
APPS.INV_MGD_MVT_DATA_STR dependencies on MTL_MOVEMENT_STATISTICS
12.1.1
-
PACKAGE: APPS.INV_MGD_MVT_DATA_STR
12.1.1
-
PACKAGE: APPS.INV_MGD_MVT_DATA_STR
12.2.2
-
PACKAGE BODY: APPS.INV_MGD_MVT_EXPORT_DATA
12.1.1
-
PACKAGE BODY: APPS.MTL_MOVEMENT_STATISTICS2_PKG
12.1.1