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:

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

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.