Results for “cz_item_attribute_values_v”

4 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

CZ_ITEM_ATTRIBUTE_VALUES_V is a documented view in the Oracle E-Business Suite (EBS) 12.1.1 / 12.2.2 environment, categorized under the BOM (Bills of Material) product family and described as "Item attribute values." Its role is to flatten the flexible attribute framework maintained by the Oracle Application Object Library (AK) into a denormalized, item-centric form. Rather than requiring report authors, integration developers, and functional consultants to join the many AK configuration tables directly against the item master, this view assembles the descriptive and user-defined attribute values that are attached to inventory items into a single, readable result set.

The presence of the LIST_TYPE column is significant because it exposes the value set or list definition associated with each attribute. Where a value is constrained by a list of valid values, LIST_TYPE identifies that list, enabling filtering and validation in downstream queries. The view is useful both for reporting on item descriptive elements and for data migration or interfacing exercises that need to read attribute values without the complexity of the underlying AK model.

Underlying Base Objects

Although the documented metadata records no keyed base objects, the view text defines its sources explicitly. The view joins four principal objects:

  • AK_INST_ATTRIBUTE_VALUES (alias IAV) — the central table holding the actual attribute values per instance.
  • MTL_SYSTEM_ITEMS_KFV (alias MSI) — the key flexfield view over the item master, supplying the concatenated item segment and description.
  • AK_ATTRIBUTES (alias AKA) — defines each attribute and its data type.
  • AK_REGIONS_TL (alias ART) and AK_REGION_ITEMS (alias ARI) — provide the region code and list-related metadata.

The join is restricted to ATTRIBUTE_APPLICATION_ID = 702 and DATABASE_OBJECT_NAME = 'MTL_SYSTEM_ITEMS_KFV', scoping the view to item-level attributes. Item and organization identifiers are matched through the KEY_VALUE1 (organization) and KEY_VALUE2 (item) columns.

Key Columns

Each row carries both identifying and descriptive columns:

  • ATTRIBUTE_CODE and DATA_TYPE — the attribute identifier and its declared type.
  • LIST_TYPE — the name of the associated list or value set, returned from AK_REGIONS_TL.NAME.
  • ATTRIBUTE_VALUE — a decoded representation that returns the numeric value when DATA_TYPE = 'NUMBER', otherwise the varchar value.
  • ITEM and DESCRIPTION — the concatenated item segments and item description.
  • REGION_CODE — the region code from the region items join.
  • KEY_VALUE1 / KEY_VALUE2 — the organization and inventory item identifiers.
  • Standard audit columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Typical uses include validating that a required attribute list has been populated, extracting attribute values for an item interface, and auditing configuration values such as the list type bound to each attribute.

SELECT ITEM, ATTRIBUTE_CODE, LIST_TYPE, ATTRIBUTE_VALUE
FROM   CZ_ITEM_ATTRIBUTE_VALUES_V
WHERE  ATTRIBUTE_CODE = :attr_code
ORDER  BY ITEM;

To enumerate the available list types for a given attribute:

SELECT DISTINCT ATTRIBUTE_CODE, LIST_TYPE
FROM   CZ_ITEM_ATTRIBUTE_VALUES_V
ORDER  BY ATTRIBUTE_CODE;

Because the view exposes LIST_TYPE directly, it is well suited to queries that verify list-driven attribute configuration without traversing the AK tables manually.