Results for “mtl_movement_parameters_v”
28 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
MTL_MOVEMENT_PARAMETERS_V is an APPS-owned view in the Oracle E-Business Suite Inventory (INV) module. The ETRM documentation for this object, valid in both 12.1.1 and 12.2.2, carries the description "10SC ONLY," indicating that the view is restricted to a specific localization or vertical solution rather than the base Oracle Inventory product line. It is not a general-purpose inventory view and should not be treated as part of the standard Oracle Inventory data model.
The view presents organization-level movement parameters used to control goods movement between legal entities, branches, and tax offices. It exposes configuration data such as entity identifiers, period set names, category set information, weight units of measure, tax office details, and conversion options. Its structure follows a typical Inventory "parameter" pattern: a primary parameter row joined to descriptive and reference entities to expose codes alongside their descriptive names.
Underlying Base Objects
The view is defined over a single driving table and a set of reference objects:
- MTL_MOVEMENT_PARAMETERS (SYNONYM) — the driving table holding entity organization, branch reference, period set, category set, weight UOM, tax office, conversion, and dispatch/arrival tracking columns.
- HR_LEGAL_ENTITIES (VIEW) — joined on ENTITY_ORG_ID = ORGANIZATION_ID to supply the legal entity name (ENT.NAME).
- HR_LOCATIONS_NO_JOIN (VIEW) — outer-joined on TAX_OFFICE_LOCATION_ID to provide location code (LOC.LOCATION_CODE). The "+" outer-join syntax is used.
- HR_LOCATIONS_ALL_TL (SYNONYM) — outer-joined on LOCATION_ID, with a language DECODE filter matching USERENV('LANG') to retrieve the translated location name.
- MTL_CATEGORY_SETS_B and MTL_CATEGORY_SETS_TL (SYNONYMS) — outer-joined on CATEGORY_SET_ID to return category set name, again with a language DECODE filter.
- GL_DAILY_CONVERSION_TYPES (SYNONYM) — outer-joined on CONVERSION_TYPE to supply the user conversion type.
The metadata also records HR_GENERAL and HR_SECURITY as referenced packages, and HR_LOCATIONS_NO_JOIN as the user's original search term — a view specifically constructed to avoid certain join semantics against HR location data in the 10SC localization.
Key Columns
- ENTITY_ORG_ID / ENTITY_NAME — the legal entity organization identifier and its legal entity name.
- ENTITY_BRANCH_REFERENCE — branch reference associated with the entity organization.
- PERIOD_SET_NAME — accounting period set controlling movement periods.
- CATEGORY_SET_ID / CATEGORY_SET_NAME — category set used in movement processing.
- WEIGHT_UOM_CODE — unit of measure for weight calculations.
- TAX_OFFICE_NAME / TAX_OFFICE_CODE / TAX_OFFICE_LOCATION_ID — tax office details and linked location.
- LOCATION_CODE — location code resolved from HR_LOCATIONS_NO_JOIN.
- CONVERSION_OPTION / CONVERSION_TYPE / USER_CONVERSION_TYPE — currency or UOM conversion configuration.
- LAST_DISPATCH_PERIOD / LAST_DISPATCH_ID / LAST_ARRIVAL_PERIOD / LAST_ARRIVAL_ID and their adjustment counterparts — tracking of last dispatch and arrival runs.
- ATTRIBUTE1 through ATTRIBUTE30, ATTRIBUTE_CATEGORY — the standard DFF columns for descriptive flexfields.
- WHO columns — ROW_ID, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.
Common Use Cases and Queries
Because the view is limited to the 10SC localization, its use cases concern reporting on movement parameter configuration and auditing dispatch/arrival tracking. A typical query resolves names for reporting:
- Movement parameter listing by entity: Select ENTITY_ORG_ID, ENTITY_NAME, PERIOD_SET_NAME, CATEGORY_SET_NAME, WEIGHT_UOM_CODE from MTL_MOVEMENT_PARAMETERS_V where ENTITY_ORG_ID = :p_org_id.
- Tax office and location audit: Select ENTITY_NAME, TAX_OFFICE_NAME, TAX_OFFICE_CODE, LOCATION_CODE from MTL_MOVEMENT_PARAMETERS_V order by ENTITY_ORG_ID.
- Conversion configuration review: Select ENTITY_ORG_ID, CONVERSION_OPTION, CONVERSION_TYPE, USER_CONVERSION_TYPE from MTL_MOVEMENT_PARAMETERS_V where CONVERSION_TYPE is not null.
- Last dispatch/arrival status: Select ENTITY_ORG_ID, LAST_DISPATCH_PERIOD, LAST_DISPATCH_ID, LAST_ARRIVAL_PERIOD, LAST_ARRIVAL_ID from MTL_MOVEMENT_PARAMETERS_V.
Include the ORG_ID or ENTITY_ORG_ID filter in all queries; the outer joins to locations and category sets can otherwise return rows with null descriptive columns. Because the view is localization-specific, verify its presence and validity with the data dictionary before relying on it in a custom report or interface.
-
10SC ONLY
APPS.MTL_MOVEMENT_PARAMETERS_V·↳ GL_DAILY_CONVERSION_TYPES·↳ HR_GENERAL·↳ HR_LEGAL_ENTITIES·Explore INV module →
-
10SC ONLY
APPS.MTL_MOVEMENT_PARAMETERS_V·↳ GL_DAILY_CONVERSION_TYPES·↳ HR_GENERAL·↳ HR_LEGAL_ENTITIES·Explore INV module →
-
VIEW: APPS.HR_LEGAL_ENTITIES 12.2.2
-
VIEW: APPS.HR_LEGAL_ENTITIES 12.1.1
-
12.1.1 FND Design Data 12.1.1
-
12.2.2 FND Design Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
eTRM - INV Tables and Views 12.2.2
-
eTRM - INV Tables and Views 12.1.1
-
eTRM - PER Tables and Views 12.1.1
Table to store NQF Training info for a person
-
eTRM - INV Tables and Views 12.1.1
-
eTRM - INV Tables and Views 12.2.2
-
eTRM - PER Tables and Views 12.1.1
Table to store NQF Training info for a person