Search Results ece_mvsto_details




Overview
Explore in AI Chat

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

ECE_MVSTO_DETAILS is a table owned by the EC schema within the Oracle e-Commerce Gateway module. It stores detail-level information for the outbound Movement Statistics transaction, a statutory reporting process used primarily to satisfy European Union Intrastat and related trade-statistics obligations. Where the header-level Movement Statistics record captures the transaction as a whole, ECE_MVSTO_DETAILS preserves the individual movement lines required for regulatory submission, including territory, transport, valuation, weight, and reference data.

From a Data Vault modeling perspective, the documented metadata classifies this object heuristically as standalone. This classification suggests the table functions primarily as a satellite-like structure capturing descriptive attributes, rather than acting as a canonical hub or link. Because it carries foreign keys to multiple operational tables without an obvious central business hub, a warehouse designer may prefer to model it as a satellite attached to a Movement Statistics hub, with links to picking, movement parameter, and security group dimensions.

Key Information Stored

ECE_MVSTO_DETAILS contains 303 documented columns in the ETRM 12.2.2 schema, reflecting the extensive data required for Intrastat and movement-statistics declarations. The most operationally significant columns include:

The surrogate primary key is not separately enumerated in the documented metadata; the unique indexes U1 and U2 identify the business-key candidates.

Common Use Cases and Queries

Typical reporting scenarios involve extracting movement statistics for submission, reconciling EDI transmission status, and auditing statutory declarations. Representative SQL patterns include:

  • Retrieving all detail lines for a given movement: SELECT * FROM EC.ECE_MVSTO_DETAILS WHERE MOVEMENT_ID = :movement_id;
  • Identifying records pending EDI transmission: SELECT TRANSACTION_RECORD_ID, MOVEMENT_ID FROM EC.ECE_MVSTO_DETAILS WHERE EDI_SENT_FLAG = 'N';
  • Summarizing movement amounts by destination territory and period for Intrastat reporting: SELECT DESTINATION_TERRITORY_CODE, PERIOD_NAME, SUM(MOVEMENT_AMOUNT) FROM EC.ECE_MVSTO_DETAILS GROUP BY DESTINATION_TERRITORY_CODE, PERIOD_NAME;

Related Objects

The most significant related objects, derived from the documented foreign-key relationships, are:

  • MTL_MOVEMENT_STATISTICS — Joined via ECE_MVSTO_DETAILS.MOVEMENT_ID; the parent header for movement statistics.
  • MTL_MOVEMENT_PARAMETERS — Joined via ENTITY_ORG_ID; defines movement-reporting configuration.
  • SO_PICKING_LINE_DETAILS — Joined via PICKING_LINE_DETAIL_ID; source picking detail.
  • SO_PICKING_LINES_ALL — Joined via PICKING_LINE_ID; source picking line.
  • FND_SECURITY_GROUPS — Joined via SECURITY_GROUP_ID; supports multi-org security.
  • MTL_TRANSACTIONS and RCV_TRANSACTIONS — Referenced via MTL_TRANSACTION_ID and RCV_TRANSACTION_ID for inventory and receiving origin.