Search Results dispatch_territory_code

Overview

APPS.ECE_MVSTO_DETAILS_V is a private reporting view owned by the APPS schema and delivered with the Oracle e-Commerce Gateway (EC) product. Its documented purpose is to extract line-level information for the outbound Movement Statistics (INTRASTAT) transaction. In EBS 12.1.1 and 12.2.2 the Movement Statistics feature supports European Union Intrastat regulatory reporting, capturing cross-border movements of goods between EU member states and aggregating them into an outbound EDI transaction. This view is the reporting and extraction surface that sits between the raw movement data held in Inventory and the outbound EC gateway interface.

The view is registered in ETRM metadata as a BUSINESS_ENTITY of category INV_MOVEMENT, with the internal scope marked private and a display name of "Movement Statistics Line View." The lifecycle status is active and the primary inventory product is confirmed as INV, indicating that although the view is owned by EC, the underlying business content belongs to Oracle Inventory. Use of the view allows the e-Commerce Gateway to assemble movement statistics line details without directly touching the base transactional table.

Underlying Base Objects

The documented referenced base objects are FND_GLOBAL (PACKAGE), FND_LOOKUPS (VIEW), and MTL_MOVEMENT_STATISTICS (SYNONYM). MTL_MOVEMENT_STATISTICS is the core Inventory table that stores movement statistics records, and the view columns correspond one-to-one with most of its columns—such as EDI_SENT_FLAG, PERIOD_NAME, EDI_TRANSACTION_REFERENCE, MOVEMENT_ID, MOVEMENT_TYPE, and the territory and statistical value fields. The synonym resolves to the APPS synonym of that Inventory table, which is why the view can be defined in the APPS schema without a fully qualified table prefix.

FND_GLOBAL is referenced in typical EC reporting views to derive the operating unit or responsibility context via functions such as FND_GLOBAL.ORG_ID, while FND_LOOKUPS supplies descriptive values for coded fields. The view text confirms that MTL_MOVEMENT_STATISTICS is aliased as MMS and that column names are carried forward with minimal transformation, making ECE_MVSTO_DETAILS_V a thin projection of the movement statistics table with EC-specific naming.

Key Columns

• EDI_SENT_FLAG – Indicates whether the movement statistics line has been transmitted outbound; used to exclude already-reported lines.
• PERIOD_NAME / SET_OF_BOOKS_PERIOD – Accounting or Intrastat reporting period for the movement.
• EDI_TRANSACTION_REFERENCE, EDI_TRANSACTION_DATE – Reference and date of the outbound EDI submission.
• FLOW_INDICATOR_CODE, STAT_METHOD, STAT_TYPE, TRANSPORT_MODE, TRANSACTION_NATURE – Intrastat classification codes describing the nature and method of the movement.
• MOVEMENT_NATURE_CODE – Derived from MMS.STATISTICAL_PROCEDURE_CODE; significant because the user search term document_source_type relates to how a movement is classified and sourced, and in this view the analogous classification is exposed through the statistical procedure and nature codes.
• ORIGIN_TERRITORY_EU_CODE / ORIGIN_TERRITORY_CODE, DESTINATION_TERRITORY_EU_CODE / DESTINATION_TERRITORY_CODE, DISPATCH_TERRITORY_* – Country and region identifiers for dispatch and destination.
• MOVEMENT_AMOUNT, ITEM_COST, DOCUMENT_UNIT_PRICE, DOCUMENT_LINE_EXT_VALUE, STAT_ADJ_AMOUNT – Statistical and document valuation amounts required on Intrastat returns.
• CURRENCY_CODE, CURRENCY_CONVERSION_TYPE, CURRENCY_CONVERSION_DATE, CURRENCY_CONVERSION_RATE – Currency and conversion attributes for the reported values.
• MOVEMENT_ID, MOVEMENT_TYPE, ZONE_CODE, PORT, AREA – Identification and geographic attributes of the movement.

Common Use Cases and Queries

The principal use case is verifying which movement statistics lines are pending or already transmitted for an Intrastat reporting period. A typical query retrieves unsent lines for a given period:

• SELECT movement_id, period_name, edi_sent_flag, movement_type, movement_amount, document_line_ext_value FROM apps.ece_mvsto_details_v WHERE period_name = :period AND edi_sent_flag = 'N';
• SELECT movement_id, origin_territory_code, destination_territory_code, flow_indicator_code, movement_amount FROM apps.ece_mvsto_details_v WHERE edi_transaction_reference = :ref;
• SELECT stat_method, stat_type, transaction_nature, COUNT(*) FROM apps.ece_mvsto_details_v WHERE period_name = :period GROUP BY stat_method, stat_type, transaction_nature;

These queries support reconciliation of outbound EDI submissions, audit of statistical values by territory and nature code, and troubleshooting of incomplete movement statistics extraction. Because the view is private, code should reference it as APPS.ECE_MVSTO_DETAILS_V rather than relying on it being exposed through a public synonym.