Search Results item_choices_gui




Overview
Explore in AI Chat

Overview

APPS.MTL_ITEM_ATTRIBUTE_NAMES_V is a reporting view in Oracle E-Business Suite that exposes the descriptive or "user-friendly" names of item attributes together with the attribute group they belong to. Its defining characteristic is the dependency on the lookup type ITEM_CHOICES_GUI, which is the very search term by which this object is commonly located. The view therefore answers a recurring functional requirement: translating the internal, technical attribute identifiers stored in the MTL_ITEM_ATTRIBUTES repository into the GUI labels and grouping categories that end users actually see on item definition forms and Inquiry screens.

Because item attributes number in the hundreds and span multiple functional areas (Inventory, Purchasing, Order Management, Costing, and so on), the view acts as a metadata dictionary for those attributes. It is read-only in practice and is typically consumed by reports, extensions, personalizations, and integration interfaces that need to identify an attribute by its display name rather than its internal column name.

Underlying Base Objects

Per the documented ETRM metadata for release 12.2.2, the view is defined over two referenced base objects:

  • MTL_ITEM_ATTRIBUTES (SYNONYM) — the attribute-seed and configuration table aliased as MIA in the view text. It supplies the technical attribute name, the GUI name, the GUI group identifier, and the display sequence.
  • MFG_LOOKUPS (VIEW) — aliased as MFG, it is filtered to LOOKUP_TYPE = 'ITEM_CHOICES_GUI' and supplies the MEANING for each attribute group.

The join is established by matching MFG.LOOKUP_CODE to MIA.ATTRIBUTE_GROUP_ID_GUI. The owner of both the view and its referenced objects is APPS.

Key Columns

  • ATTRIBUTE_NAME — the internal/technical attribute identifier from MTL_ITEM_ATTRIBUTES; the physical or logical column name used by the application.
  • USER_ATTRIBUTE_NAME_GUI — the user-facing descriptive label shown to end users. Rows where this is NULL are excluded by the view's WHERE clause, so only named (user-visible) attributes are returned.
  • ATTRIBUTE_GROUP_ID_GUI — the identifier of the group (tab/page) to which the attribute belongs; joined to the lookup code.
  • MEANING — the translated, descriptive name of the attribute group, retrieved from MFG_LOOKUPS.
  • SEQUENCE_GUI — the ordinal position used to order attributes within the GUI display.

Common Use Cases and Queries

Typical scenarios include building inquiries that list attributes by group, validating attribute presence for integration mapping, and driving dynamic personalizations.

SELECT ATTRIBUTE_NAME,
       USER_ATTRIBUTE_NAME_GUI,
       MEANING,
       SEQUENCE_GUI
  FROM APPS.MTL_ITEM_ATTRIBUTE_NAMES_V
 ORDER BY MEANING, SEQUENCE_GUI;

To find the technical name corresponding to a known GUI label (e.g., a specific descriptive flexfield-style attribute), filter on USER_ATTRIBUTE_NAME_GUI. Group-level extracts can be produced by aggregating on MEANING.

SELECT a.ATTRIBUTE_NAME, a.USER_ATTRIBUTE_NAME_GUI
  FROM APPS.MTL_ITEM_ATTRIBUTE_NAMES_V a
 WHERE a.ATTRIBUTE_GROUP_ID_GUI = :group_id
 ORDER BY a.SEQUENCE_GUI;

Because the view is a simple two-table join with a lookup filter, it is lightweight and suitable for list-of-values definitions and report parameters, though it should not be used for transactional postings.