Search Results mtl_item_attribute_names_v




Overview
Explore in AI Chat

Overview

MTL_ITEM_ATTRIBUTE_NAMES_V is an Inventory (INV) module view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. The ETRM documentation classifies this object with a description of "10SC ONLY," indicating that its scope is restricted to a specific 10SC configuration or localization rather than the general EBS data model. The view serves as a presentation layer over the item attribute definition metadata, translating internal attribute identifiers into user-facing GUI labels. It joins the item attribute definitions to the MFG_LOOKUPS lookup view so that attribute groups can be displayed with their translated meaning instead of raw lookup codes.

Because it exposes attribute names, GUI labels, attribute group identifiers, group meanings, and display sequencing, the view is primarily consumed by item-definition configuration screens, personalizations, reporting, and integration layers that need to enumerate which item attributes are available and how they should be labeled to end users. It is a read-only, query-oriented object and carries no stored data of its own.

Underlying Base Objects

The view is defined over two documented base objects: MFG_LOOKUPS (exposed as a VIEW) and MTL_ITEM_ATTRIBUTES (exposed as a SYNONYM). The join is governed by the following conditions in the view text:

The view therefore inherits its attribute-name metadata from MTL_ITEM_ATTRIBUTES and its attribute-group translation from MFG_LOOKUPS. Rows are eliminated when the lookup relationship cannot be satisfied or when the GUI user attribute name is absent.

Key Columns

The documented column list, together with the select list in the view text, indicates the following significant columns:

  • ATTRIBUTE_NAME — the internal (database-level) name of the item attribute, sourced from MIA.ATTRIBUTE_NAME.
  • USER_ATTRIBUTE_NAME — the user-facing attribute label, sourced from MIA.USER_ATTRIBUTE_NAME_GUI. Rows with a null value here are excluded by the view's WHERE clause.
  • ATTRIBUTE_GROUP_ID — the attribute group identifier, sourced from MIA.ATTRIBUTE_GROUP_ID_GUI and linked to MFG_LOOKUPS.LOOKUP_CODE.
  • USER_GROUP_NAME — the translated meaning of the attribute group, derived from MFG.MEANING of the ITEM_CHOICES_GUI lookup.
  • SEQUENCE — the display sequence for the attribute, sourced from MIA.SEQUENCE_GUI, used to control ordering in GUI presentation.

Common Use Cases and Queries

Typical scenarios include enumerating the GUI-labelable item attributes for a configuration screen, driving flexfield or personalization logic that depends on attribute group membership, and reconciling internal attribute names against their displayed labels for migration or documentation.

A representative query that lists all GUI-visible attributes together with their group labels, ordered for display, is:

  • SELECT attribute_name, user_attribute_name, attribute_group_id, user_group_name, sequence FROM apps.mtl_item_attribute_names_v ORDER BY attribute_group_id, sequence;

To isolate the attributes belonging to one group:

  • SELECT attribute_name, user_attribute_name, sequence FROM apps.mtl_item_attribute_names_v WHERE user_group_name = :group_meaning ORDER BY sequence;

Because the description is limited to "10SC ONLY" and the view is a definition-level metadata source rather than a transactional table, consumers should confirm availability of the underlying MTL_ITEM_ATTRIBUTES and MFG_LOOKUPS objects in their environment and restrict usage to GUI-label resolution rather than item instance data retrieval.