Results for “movement_id”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
MTL_MOVEMENT_STATISTICS_EFC is an Inventory (INV) module table in Oracle E-Business Suite 12.1.1 and 12.2.2 that serves as the Euro-as-a-Functional-Currency archive for movement statistics records. The "_EFC" suffix denotes "Euro Functional Currency," identifying this as a supplementary archive created to preserve movement statistics transactions after a set of books transitioned to the Euro as its functional currency. The table is owned by the INV schema and is documented as VALID.
The table records only three columns: CURRENCY_CONVERSION_RATE, MOVEMENT_ID, and SET_OF_BOOKS_ID. This narrow footprint confirms its archival purpose: it stores the conversion rate applied to each archived movement record and links back to the originating movement statistics row through MOVEMENT_ID. Because the table carries only rate and key data, it functions as an extension of the parent statistics record rather than a standalone transactional entity.
The heuristic Data Vault classification mined from the foreign key structure is standalone. In Data Vault modeling terms, this object does not behave as a hub, link, or satellite in isolation; instead it should be modeled as a satellite or descriptive extension attached to the MTL_MOVEMENT_STATISTICS hub, keyed by MOVEMENT_ID and qualified by SET_OF_BOOKS_ID. Its single-column foreign key relationship to MTL_MOVEMENT_STATISTICS confirms this dependent relationship.
Key Information Stored
The documented physical schema for 12.2.2 contains exactly three columns:
- CURRENCY_CONVERSION_RATE — The exchange rate used to convert the movement statistics amount into the Euro functional currency at the time the archive record was created. This is the core business value of the table.
- MOVEMENT_ID — The identifier of the associated movement statistics transaction. This is a foreign key referencing MTL_MOVEMENT_STATISTICS.MOVEMENT_ID and serves as the primary business-key candidate joining archived EFC data back to source records.
- SET_OF_BOOKS_ID — The set of books (ledger) under which the movement was booked. This distinguishes archival rows across multiple accounting representations, since a given movement may be archived under more than one set of books.
No surrogate primary key column is documented in the metadata excerpt, and no unique index is enumerated. The effective uniqueness of a row is therefore governed by the combination of MOVEMENT_ID and SET_OF_BOOKS_ID. Practitioners should treat this composite as the natural key when reconciling or de-duplicating archive contents.
Common Use Cases and Queries
Typical use cases center on audit, reporting, and migration validation following a Euro conversion.
- Audit of conversion rates applied to movement statistics: Retrieve the rate stored for each archived movement to verify Euro conversion accuracy.
- Reconciliation with the parent table: Join the archive back to MTL_MOVEMENT_STATISTICS to confirm every movement has a corresponding rate record.
- Multi-ledger reporting: Filter by SET_OF_BOOKS_ID to report on Euro-converted movement statistics for a specific ledger.
- Data migration validation: Compare archived rates against externally maintained rate tables when upgrading from 12.1.1 to 12.2.2.
A representative query joining the archive to its source:
SELECT mms.MOVEMENT_ID, mms.SET_OF_BOOKS_ID, efc.CURRENCY_CONVERSION_RATE
FROM INV.MTL_MOVEMENT_STATISTICS mms, INV.MTL_MOVEMENT_STATISTICS_EFC efc
WHERE mms.MOVEMENT_ID = efc.MOVEMENT_ID
AND mms.SET_OF_BOOKS_ID = efc.SET_OF_BOOKS_ID;
Related Objects
The table has a narrow dependency footprint, with one documented foreign key relationship:
- MTL_MOVEMENT_STATISTICS — The parent table; joined on MOVEMENT_ID. This is the primary object referenced by the archive and the principal source of related transactional detail.
Beyond the documented FK, the following objects are commonly associated with movement statistics processing and are relevant when interpreting this archive: MTL_MATERIAL_TRANSACTIONS (the underlying transaction source), MTL_TRANSACTION_TYPES, MTL_PARAMETERS, and GL_SETS_OF_BOOKS / FND_CURRENCIES (for functional currency context). Because the metadata classifies this object as standalone and documents only a single FK, the archive should be treated as a tightly scoped supplement to MTL_MOVEMENT_STATISTICS rather than a hub in its own right.
-
Euro as a Functional Currency Archive
-
Euro as a Functional Currency Archive
-
View: SO_PICKING_LINES 12.1.1
10SC ONLY
APPS.SO_PICKING_LINES·↳ SO_PICKING_LINES_ALL·Explore OE module →
-
View: WSHBV_PICK_LINE_DETAIL 12.2.2
- Retrofitted
APPS.WSHBV_PICK_LINE_DETAIL·↳ SO_PICKING_LINE_DETAILS·Explore OE module →
-
Pending inventory transactions
-
Completed inventory transactions
-
View: WSH_SHIPPING_DETAILS_V 12.2.2
APPS.WSH_SHIPPING_DETAILS_V·↳ HR_LOCATIONS_ALL·↳ OE_INSTALL·↳ OE_ORDER_HEADERS_ALL·Explore WSH module →
-
View: WSH_SHIPPING_DETAILS_V 12.1.1
APPS.WSH_SHIPPING_DETAILS_V·↳ HR_LOCATIONS_ALL·↳ OE_INSTALL·↳ OE_ORDER_HEADERS_ALL·Explore WSH module →
-
View: CST_XLA_RCV_REF_V 12.2.2
APPS.CST_XLA_RCV_REF_V·↳ PO_HEADERS_ALL·↳ RCV_ACCOUNTING_EVENTS·↳ RCV_RECEIVING_SUB_LEDGER·Explore BOM module →
-
View: WSHBV_PICK_LINE 12.2.2
- Retrofitted
APPS.WSHBV_PICK_LINE·↳ SO_PICKING_LINES_ALL·Explore OE module →
-
Stores all relevant information for movement statistics transactions.
-
Pending inventory transactions
-
View: RCV_TRANSACTIONS_MRC_V 12.1.1
- Retrofitted
APPS.RCV_TRANSACTIONS_MRC_V·↳ RCV_MC_TRANSACTIONS·↳ RCV_TRANSACTIONS·Explore PO module →
-
Picking line details
-
Picking line details
-
Customer Transactions Details View
APPS.ICX_RA_CUSTOMER_TRX_LINES_V·↳ AR_LOOKUPS·↳ FND_CURRENCY·↳ MTL_UNITS_OF_MEASURE·Explore ICX module →
-
Picking lines
-
Picking lines
-
APPS.WSH_DELIVERY_DETAILS_OB_GRP_V·↳ WSH_DELIVERY_DETAILS·Explore WSH module →
-
This view joins MTL_TXN_REQUEST_LINES with MTL_MATERIAL_TRANSACTIONS_TEMP. A record from WMS_COST_GROUP_INPUT_V serves as the input for the WMS cost group rules engine.
APPS.WMS_COST_GROUPS_INPUT_V·↳ MTL_INTERORG_PARAMETERS·↳ MTL_MATERIAL_TRANSACTIONS_TEMP·↳ MTL_SERIAL_NUMBERS·Explore WMS module →
-
View: ECE_MVSTO_DETAILS_V 12.2.2
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_
APPS.ECE_MVSTO_DETAILS_V·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ MTL_MOVEMENT_STATISTICS·Explore EC module →
-
View: SO_PICKING_LINES_V 12.1.1
10SC Only
APPS.SO_PICKING_LINES_V·↳ MTL_PARAMETERS·↳ MTL_SYSTEM_ITEMS_VL·↳ SO_HEADERS_ALL·Explore OE module →
-
Line and distribution-level archive information
-
- Retrofitted
APPS.INVBV_MOVEMENT_STATISTICS·↳ MTL_MOVEMENT_STATISTICS·Explore INV module →
-
View: WSHBV_DELIVERY_DETAILS 12.1.1
APPS.WSHBV_DELIVERY_DETAILS·↳ MTL_CUSTOMER_ITEMS·↳ MTL_ITEM_LOCATIONS·↳ MTL_SYSTEM_ITEMS·Explore WSH module →
-
APPS.RA_CUST_TRX_LN_ALL_MRC_V·↳ RA_CUSTOMER_TRX_LINES_ALL·↳ RA_MC_CUSTOMER_TRX_LINES·Explore AR module →
-
View: SO_PICKING_LINES 12.2.2
10SC ONLY
APPS.SO_PICKING_LINES·↳ SO_PICKING_LINES_ALL·Explore OE module →
-
- Retrofitted
APPS.INVBV_MOVEMENT_STATISTICS·↳ MTL_MOVEMENT_STATISTICS·Explore INV module →
-
APPS.POR_RCV_INTERNAL_RECEIPTS_V·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ HR_GENERAL·↳ HR_PERSON_NAME·Explore ICX module →
-
View: AR_INVOICE_LINES_V 12.2.2
Collects invoice line item information
APPS.AR_INVOICE_LINES_V·↳ AR_INVOICE_SQL_FUNC_PUB·↳ AR_MEMO_LINES·↳ AR_VAT_TAX_VL·Explore AR module →
-
APPS.JAI_OM_WSH_DELIVERIES_V·↳ WSH_DELIVERY_ASSIGNMENTS·↳ WSH_DELIVERY_DETAILS·↳ WSH_NEW_DELIVERIES·Explore JA module →
-
View: WSH_DEL_DTL_ASSGN_V 12.1.1
APPS.WSH_DEL_DTL_ASSGN_V·↳ WSH_DEL_ASSGN_INTERFACE·↳ WSH_DEL_DETAILS_INTERFACE·Explore WSH module →
-
This is history table for mtl_material_transaction_temp. - This for WMS internal Use only.
-
Delivery Detail interface Table
-
Contains the detail level information for the outbound Movement Statistics transaction.
-
(Release 115)
APPS.RA_CUSTOMER_TRX_LINES_V·↳ ARH_ADDR_PKG·↳ ARPT_SQL_FUNC_UTIL·↳ ARP_BAL_UTIL·Explore AR module →
-
APPS.WSH_STOP_DELIVERABLES_V·↳ WSH_DELIVERY_LEGS·↳ WSH_DLVY_DELIVERABLES_V·↳ WSH_NEW_DELIVERIES·Explore WSH module →
-
View: WSHFV_DELIVERY_DETAILS 12.2.2
Full BIS Business View for Delivery Details.
APPS.WSHFV_DELIVERY_DETAILS·↳ HZ_CUST_ACCOUNTS·↳ HZ_CUST_SITE_USES_ALL·↳ HZ_PARTIES·Explore WSH module →
-
View for querying items to be returned to the supplier (vendor)
APPS.POR_RCV_RETURN_TO_VENDOR_V·↳ FND_GLOBAL·↳ HR_GENERAL·↳ HR_LOCATIONS_ALL·Explore ICX module →
-
Line and distribution-level archive information
-
View: CST_XLA_RCV_REF_V 12.1.1
APPS.CST_XLA_RCV_REF_V·↳ PO_HEADERS_ALL·↳ RCV_ACCOUNTING_EVENTS·↳ RCV_RECEIVING_SUB_LEDGER·Explore BOM module →