Search Results entity_org_id

Overview

ECE_MTL_MOV_MOV_STAT_V is an APPS-owned database view in the Oracle E-Business Suite e-Commerce Gateway (EC) product. It presents aggregated movement type information for inventory movement statistics records that are associated with EDI transactions still pending transmission, meaning they have not yet been flagged as sent. The view is a reporting and integration artifact rather than a transactional interface; it exposes a read-only, pre-aggregated projection of statistical movement data suitable for downstream EDI processing, reconciliation, and operational reporting.

The view is defined in both EBS 12.1.1 and 12.2.2 with the same structure and ownership. Its central role is to isolate those movement statistics rows whose EDI_SENT_FLAG is null or 'N' and whose movement status is valid ('V') or final ('F'), while restricting document source types to values present in the MVT_SOURCE_DOCUMENT_TYPES lookup. This makes it a convenient source for identifying EDI-bound statistical movements that are awaiting submission, without requiring consumers to reapply those business filters themselves.

Underlying Base Objects

The documented referenced base objects are FND_LOOKUPS (a view), MTL_MOVEMENT_STATISTICS (accessed via a synonym), and the FND_GLOBAL package (used implicitly for session context such as organization or user identifiers through standard EBS multi-org conventions). The view's text confirms that it joins MTL_MOVEMENT_STATISTICS (aliased MMS) to FND_LOOKUPS (aliased FL) on the condition that the lookup type equals MVT_SOURCE_DOCUMENT_TYPES and the lookup code equals the movement statistic's DOCUMENT_SOURCE_TYPE. This inner join ensures only recognized source document types contribute to the result set.

The WHERE clause further filters to rows where MOVEMENT_STATUS is either 'V' or 'F' and NVL(EDI_SENT_FLAG, 'N') = 'N', thereby excluding records already transmitted. Because the view groups by movement and transaction attributes, each output row represents a summarized statistical position rather than a single inventory transaction.

Key Columns

MOVEMENT_TYPE — The classification of the inventory movement being reported.
PERIOD_NAME — The accounting or reporting period associated with the movement.
EDI_TRANSACTION_REFERENCE — The reference identifying the associated EDI transaction.
EDI_TRANSACTION_DATE — The transaction date carried on the EDI movement record; this column is central to date-filtered reporting and pending-EDI reconciliations, and is the field most commonly referenced by users searching on edi_transaction_date.
REPORT_REFERENCE and REPORT_DATE — Identifiers and dates for the associated movement report.
STAT_TYPE — The statistical type categorizing the movement.
USAGE_TYPE — Indicates how the statistical movement is used.
MOVEMENT_STATUS — Status of the movement, restricted here to 'V' or 'F'.
ZONE_CODE, ORGANIZATION_ID, ENTITY_ORG_ID — Organizational and zone identifiers supporting multi-org reporting.
TOTAL_INVOICE_EXT_VALUE — Sum of invoice line extended values.
TOTAL_SUPPLEMENTARY_UNITS — Sum of supplementary statistical units.
TOTAL_STATISTICAL_VALUE — Sum of movement statistical amounts.
TOTAL_TOTAL_WEIGHT — Sum of movement weights.
TOTAL_RECORDS — Count of contributing movement statistics records.

Common Use Cases and Queries

Typical use cases include identifying pending EDI movement statistics for a period, reconciling EDI transaction dates against reporting periods, and aggregating statistical values and weights for compliance or intrastat-style reporting. The following query selects pending movements within a date range:

SELECT movement_type, period_name, edi_transaction_reference, edi_transaction_date, total_statistical_value, total_records FROM ece_mtl_mov_stat_v WHERE edi_transaction_date BETWEEN :from_date AND :to_date ORDER BY edi_transaction_date;
SELECT organization_id, period_name, SUM(total_statistical_value) FROM ece_mtl_mov_stat_v GROUP BY organization_id, period_name;
SELECT * FROM ece_mtl_mov_stat_v WHERE movement_status = 'F' AND organization_id = :org_id;

Because the view already filters unsent records and valid statuses, queries remain concise and consistent across releases.

View: ECE_MTL_MOV_STAT_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:EC.ECE_MTL_MOV_STAT_V, object_name:ECE_MTL_MOV_STAT_V, status:VALID, product: EC - e-Commerce Gateway , description: Contains the movement type information for documents with EDI transactions pending. , implementation_dba_data: APPS.ECE_MTL_MOV_STAT_V ,
View: ECE_MTL_MOV_STAT_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:EC.ECE_MTL_MOV_STAT_V, object_name:ECE_MTL_MOV_STAT_V, status:VALID, product: EC - e-Commerce Gateway , description: Contains the movement type information for documents with EDI transactions pending. , implementation_dba_data: APPS.ECE_MTL_MOV_STAT_V ,
View: ECE_MVSTO_HEADERS_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:EC.ECE_MVSTO_HEADERS_V, object_name:ECE_MVSTO_HEADERS_V, status:VALID, product: EC - e-Commerce Gateway , description: This view extracts header informationfor the outbound Movement Statistics (INTRASTAT) transaction.@rep:scope private@rep:product INV@rep:lifecycle active@rep:displayname Movement Statistics Header View@rep:category BUSINESS_ENTITY INV_MOVEM , implementation_dba_data: APPS.ECE_MVSTO_HEADERS_V ,
View: ECE_MVSTO_HEADERS_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:EC.ECE_MVSTO_HEADERS_V, object_name:ECE_MVSTO_HEADERS_V, status:VALID, product: EC - e-Commerce Gateway , description: This view extracts header informationfor the outbound Movement Statistics (INTRASTAT) transaction.@rep:scope private@rep:product INV@rep:lifecycle active@rep:displayname Movement Statistics Header View@rep:category BUSINESS_ENTITY INV_MOVEM , implementation_dba_data: APPS.ECE_MVSTO_HEADERS_V ,
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 ,
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 ,