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(aliasIAV) — the central table holding the actual attribute values per instance.MTL_SYSTEM_ITEMS_KFV(aliasMSI) — the key flexfield view over the item master, supplying the concatenated item segment and description.AK_ATTRIBUTES(aliasAKA) — defines each attribute and its data type.AK_REGIONS_TL(aliasART) andAK_REGION_ITEMS(aliasARI) — 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_CODEandDATA_TYPE— the attribute identifier and its declared type.LIST_TYPE— the name of the associated list or value set, returned fromAK_REGIONS_TL.NAME.ATTRIBUTE_VALUE— a decoded representation that returns the numeric value whenDATA_TYPE = 'NUMBER', otherwise the varchar value.ITEMandDESCRIPTION— 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.
-
Item attribute values
Not implemented in this database·Explore BOM module →
-
Item attribute values
Not implemented in this database·Explore BOM module →
-
12.1.1 FND Design Data 12.1.1
-
12.2.2 FND Design Data 12.2.2