Search Results ece_mvsto_headers_u1

Overview

EC.ECE_MVSTO_HEADERS is a VALID interface table in the EC (E-Commerce/eBTax) schema that stores movement statistics header data supporting the outbound Movement Statistics transaction. It is populated primarily from data held in MTL_MOVEMENT_STATISTICS in Oracle Inventory and provides the statistical foundation for tracking the movement of goods across borders, regardless of the specific countries involved. The table resides in the APPS_TS_INTERFACE tablespace and is registered in FND Design Data as EC.ECE_MVSTO_HEADERS.

From a Data Vault modeling perspective, the mined foreign-key structure classifies this object as standalone — it does not participate in a classic hub-and-satellite chain with the tables it references, but rather functions as a movement-statistics header record whose extension data is held in ECE_MVSTO_HEADERS_X. The unique index ECE_MVSTO_HEADERS_U1 on TRANSACTION_RECORD_ID provides the anchor for that relationship.

Key Information Stored

The table contains 106 documented columns. The surrogate/business key is TRANSACTION_RECORD_ID, enforced by the unique index ECE_MVSTO_HEADERS_U1, which also links the row to the ECE_MVSTO_HEADERS_X extension table. The most significant columns include:

• TRANSACTION_RECORD_ID — unique key linking the header to its extension table.
• RUN_ID — the transaction run identifier grouping a processing batch.
• TRANSACTION_DATE — date and time of the movement transaction.
• DOCUMENT_TYPE / TP_DOCUMENT_CODE / TP_DOCUMENT_ID — document identity; TP_DOCUMENT_ID references ECE_AR_TRX_HEADERS.
• MOVEMENT_TYPE and its EXT1–EXT5 counterparts — internal and external representations of the movement classification.
• STAT_TYPE / USAGE_TYPE (with EXT variants) — statistical and usage coding for the movement.
• LEGAL_ENTITY_ID — references FV_LEGAL_ENTITIES; accompanied by LEGAL_ENTITY_NAME, LEGAL_ENTITY_VAT_CODE, and address fields.
• ENTITY_ORG_ID — references MTL_MOVEMENT_PARAMETERS, identifying the source organization.
• ORGANIZATION_ID — the inventory organization for the movement.
• SECURITY_GROUP_ID — references FND_SECURITY_GROUPS for multi-tenant access control.
• TOTAL_INVOICE_EXT_VALUE, TOTAL_SUPPLEMENTARY_UNITS, TOTAL_STATISTICAL_VALUE, TOTAL_TOTAL_WEIGHT, TOTAL_RECORDS — aggregate totals for the header.
• PERIOD_NAME and HEADER_DATA_EXIST_FLAG — period context and child-data indicator.

Columns labeled "Int" or "Internal" carry Oracle EBS internal values; those labeled "Ext" or "External" hold their converted equivalents sourced from ECE_XREF_DATA when code conversion is enabled.

Common Use Cases and Queries

Typical scenarios include movement-statistics reporting, cross-border trade compliance, and reconciliation of outbound transaction batches. A common pattern joins the header to its extension table:

• SELECT h.TRANSACTION_RECORD_ID, h.MOVEMENT_TYPE, h.TRANSACTION_DATE FROM EC.ECE_MVSTO_HEADERS h WHERE h.RUN_ID = :p_run_id;
• SELECT h.TRANSACTION_RECORD_ID, x.* FROM EC.ECE_MVSTO_HEADERS h, EC.ECE_MVSTO_HEADERS_X x WHERE h.TRANSACTION_RECORD_ID = x.TRANSACTION_RECORD_ID;
• SELECT h.LEGAL_ENTITY_ID, SUM(h.TOTAL_TOTAL_WEIGHT) FROM EC.ECE_MVSTO_HEADERS h GROUP BY h.LEGAL_ENTITY_ID;

Because the table is an interface object, queries are frequently run for batch verification, exception reporting, and audit of movement-statistics completeness prior to downstream compliance submission.

Related Objects

The documented foreign keys and key relationships define the principal related objects:

• EC.ECE_MVSTO_HEADERS_X — extension table joined on TRANSACTION_RECORD_ID.
• ECE_AR_TRX_HEADERS — referenced via TP_DOCUMENT_ID.
• FV_LEGAL_ENTITIES — referenced via LEGAL_ENTITY_ID.
• MTL_MOVEMENT_PARAMETERS — referenced via ENTITY_ORG_ID; source of movement configuration.
• FND_SECURITY_GROUPS — referenced via SECURITY_GROUP_ID.
• MTL_MOVEMENT_STATISTICS — upstream Inventory source for the statistical data.
• ECE_XREF_DATA — code-conversion source populating the external (Ext) columns.