Results for “property_value”

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

Overview

CZ_ITEM_ITEMPROPVALS_V is a seed data view owned by the APPS schema within the Oracle E-Business Suite Configurator (CZ) product family. As its description states, the view presents property values attached to items, joining item property value records with their defining property metadata and the parent item and item type context. In the broader Configurator data model, properties are the user-defined characteristics that drive configuration rules, and property values are the concrete assignments made against individual items. This view denormalizes that relationship into a single readable, flattened structure.

Because it pre-joins items, item types, properties, and property values, the view is well suited to operational reporting, data extraction, and integration scenarios. Rather than requiring consumers to reconstruct four-way joins across the CZ base tables, the view delivers a stable, human-readable projection that is commonly used for item property audits, validation extracts, and downstream interfaces that need property-level detail without invoking the Configurator runtime APIs.

Underlying Base Objects

The view is defined over four base objects, each exposed to APPS through a synonym: CZ_ITEM_MASTERS, CZ_ITEM_TYPES, CZ_ITEM_PROPERTY_VALUES, and CZ_PROPERTIES. Its join topology is a hub-and-spoke arrangement anchored by CZ_ITEM_MASTERS.

• CZ_ITEM_MASTERS joins to CZ_ITEM_TYPES on ITEM_TYPE_ID, establishing the item-to-type relationship.
• CZ_ITEM_PROPERTY_VALUES joins to CZ_ITEM_MASTERS on ITEM_ID, supplying the actual assigned values.
• CZ_PROPERTIES joins to CZ_ITEM_PROPERTY_VALUES on PROPERTY_ID, supplying property definitions including the unit of measure.
• Deleted records are excluded by requiring DELETED_FLAG = '0' on all four objects, so the view surfaces only active, non-deleted data.
• A predicate ensures at least one value is populated: PROPERTY_VALUE IS NOT NULL OR PROPERTY_NUM_VALUE IS NOT NULL. Rows with both value columns null are suppressed.

Key Columns

• ITEM_ID and ITEM_TYPE_ID — identifiers of the configured item and its item type; the primary join keys to CZ_ITEM_MASTERS and CZ_ITEM_TYPES.
• ITEM_TYPE_NAME and ITEM_TYPE_DESC_TEXT — the name and descriptive text of the item type to which the item belongs.
• PROPERTY_ID — identifier of the property definition; links back to CZ_PROPERTIES.
• PROPERTY_NAME and PROPERTY_DESC_TEXT — readable name and description of the property.
• PROPERTY_UNIT — the unit of measure associated with the property, which is the attribute most directly relevant to searches for "property_unit." This column identifies the unit label applied to the property definition.
• DATA_TYPE — indicates whether the property holds a character or numeric value, determining which value column is meaningful.
• PROPERTY_VALUE — the character representation of the assigned value.
• PROPERTY_NUM_VALUE — the numeric representation of the assigned value, populated for numeric property definitions.

Common Use Cases and Queries

Typical uses include retrieving all properties and values for a given item, reviewing property definitions together with their units, and extracting property assignments for a specific item type. The following query lists property values with their units for a target item:

• SELECT ITEM_ID, ITEM_TYPE_NAME, PROPERTY_NAME, PROPERTY_UNIT, DATA_TYPE, PROPERTY_VALUE, PROPERTY_NUM_VALUE FROM APPS.CZ_ITEM_ITEMPROPVALS_V WHERE ITEM_ID = :p_item_id;
• SELECT ITEM_ID, PROPERTY_NAME, PROPERTY_UNIT FROM APPS.CZ_ITEM_ITEMPROPVALS_V WHERE ITEM_TYPE_NAME = :p_type_name ORDER BY PROPERTY_NAME;
• SELECT DISTINCT PROPERTY_NAME, PROPERTY_UNIT, DATA_TYPE FROM APPS.CZ_ITEM_ITEMPROPVALS_V ORDER BY PROPERTY_NAME;

Because the view enforces deleted-flag and value-presence filters, queries against it return only active assignments, which makes it appropriate for reconciliation extracts and reporting without additional cleanup logic.