Search Results item_locator_control




Overview
Explore in AI Chat

Overview

MTL_ONHAND_REV_V is an Oracle E-Business Suite (EBS) reporting view owned by the APPS schema and validated in both 12.1.1 and 12.2.2. It resides in the Inventory (INV) product family and carries the ETRM description "10SC ONLY," indicating that its use is limited to a specific Oracle-delivered configuration rather than general-purpose inventory reporting. Functionally, the view presents aggregated on-hand balances summarized by item and revision, enriched with item descriptive attributes and organization context. Because the on-hand quantity tables store transactions at the detailed level, this view provides a convergence point that rolls those rows into a single total quantity on hand (TOTAL_QOH) per organization, item, and revision combination.

The reference to item_locator_control in the search that surfaced this object is reflected directly in the view's column list, where the item attribute LOCATION_CONTROL_CODE is aliased as ITEM_LOCATOR_CONTROL. This makes the view a convenient source when reporting must distinguish items that are locator-controlled from those that are not, alongside their lot and serial control attributes.

Underlying Base Objects

The view text selects from four physical sources. On-hand quantities originate from MTL_ONHAND_QUANTITIES_DETAIL (referenced through a synonym), which supplies ORGANIZATION_ID, INVENTORY_ITEM_ID, REVISION, and PRIMARY_TRANSACTION_QUANTITY. Item master attributes come from MTL_SYSTEM_ITEMS_KFV, the key flexfield view over the item master, supplying the concatenated item segments, description, primary unit of measure, and the control-code columns. Organization metadata is drawn from MTL_PARAMETERS (synonym) for ORGANIZATION_CODE and from HR_ORGANIZATION_UNITS for the organization name. The documented dependency list further includes HR_GENERAL and HR_SECURITY packages, which implement organization-level security filtering, plus the HR_ORGANIZATION_UNITS view.

Key Columns

  • ORGANIZATION_ID / INVENTORY_ITEM_ID — the composite key identifying the inventory organization and item.
  • PADDED_CONCATENATED_SEGMENTS — the padded, concatenated item flexfield segments used as the human-readable item identifier.
  • REVISION — the item revision; balances are grouped by revision, so revision-controlled items yield multiple rows.
  • TOTAL_QOH — the summed PRIMARY_TRANSACTION_QUANTITY, representing aggregate on-hand quantity.
  • ITEM_DESCRIPTION / PRIMARY_UOM_CODE — item description and primary unit of measure.
  • ORGANIZATION_CODE / ORGANIZATION_NAME — the inventory organization code and its descriptive name.
  • ITEM_LOCATOR_CONTROL — the item's location (locator) control code, aliased from LOCATION_CONTROL_CODE.
  • ITEM_LOT_CONTROL / ITEM_SERIAL_CONTROL — lot and serial number control codes for the item.

Common Use Cases and Queries

Typical usage includes revision-level on-hand reporting, control-attribute validation, and integration extracts that require balances joined to item control settings. The following query illustrates filtering for locator-controlled items:

SELECT organization_code, padded_concatenated_segments, revision, total_qoh, item_locator_control FROM apps.mtl_onhand_rev_v WHERE item_locator_control = 2;

A second pattern aggregates total quantity across revisions for a given item, or joins the view to other INV or BOM reporting views. Because the view embeds HR_SECURITY-based organization filtering, results are automatically restricted to organizations the querying user may access, which must be accounted for when comparing output against unfiltered base-table queries.