Results for “property_num_value”

14 results




Overview
Explore in AI Chat

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

Overview

APPS.CZ_ITEM_PROPERTIES_V is a Configurator (CZ) reporting view that flattens the relationship between configurable item masters, item type properties, and the property values assigned to each item. It answers the core question: "for a given item and a given property, what is the effective value?" The view resolves that value by preferring the item-level override stored in CZ_ITEM_PROPERTY_VALUES and falling back to the default defined at the property level in CZ_PROPERTIES when no override exists. Because it is a view rather than a table, it exposes no independent storage; it is a read-only projection used by Configurator forms, concurrent programs, and customer reporting.

The view is of particular interest to implementers searching for translated_text, because it exposes both TRANSLATED_TEXT and DEF_TRANSLATED_TEXT columns that resolve internationalized text identifiers in CZ_INTL_TEXTS into displayable strings. Status is VALID and the owner is APPS, so it is queried as APPS.CZ_ITEM_PROPERTIES_V or via a synonym in a custom schema.

Underlying Base Objects

ETRM documents five referenced base objects, all accessed through APPS synonyms: CZ_PROPERTIES, CZ_ITEM_TYPE_PROPERTIES, CZ_ITEM_MASTERS, CZ_ITEM_PROPERTY_VALUES, and CZ_INTL_TEXTS.

The view is a UNION ALL of two branches. The first branch handles all non-translatable data types (DATA_TYPE <> 8) and returns NULL for both translated-text columns. The second branch handles translatable (text) properties, resolving DEF_NUM_VALUE and NVL(PROPERTY_NUM_VALUE, DEF_NUM_VALUE) through CZ_INTL_TEXTS to populate DEF_TRANSLATED_TEXT and TRANSLATED_TEXT.

Key Columns

  • PROPERTY_ID / ITEM_ID / ITEM_TYPE_ID — the composite key identifying which property applies to which item.
  • PROPERTY_NAME — the property's display name from CZ_PROPERTIES.NAME.
  • PROPERTY_VALUE — NVL(item override, property default) for character values.
  • PROPERTY_NUM_VALUE — NVL(item override, property default) for numeric values; for translatable properties this is an identifier into CZ_INTL_TEXTS.
  • TRANSLATED_TEXT — the resolved localized string for the effective numeric value; NULL for non-translatable properties.
  • DEF_TRANSLATED_TEXT — the resolved localized string for the property's default value.
  • INHERITED_FLAG — a DECODE over a correlated COUNT against CZ_ITEM_PROPERTY_VALUES; returns 1 when no active item-level value exists, indicating the value is inherited from the property default, and 0 when an explicit item value is present.
  • DATA_TYPE, DESC_TEXT, ORIG_SYS_REF, SRC_APPLICATION_ID, DELETED_FLAG — descriptive and provenance attributes.

Common Use Cases and Queries

Typical scenarios include generating item specification reports, auditing which items inherit defaults versus carry overrides, and extracting translated property text for multilingual catalogs or integrations.

List property values for a single item:

  • SELECT property_name, property_value, property_num_value, translated_text, inherited_flag FROM apps.cz_item_properties_v WHERE item_id = :p_item_id ORDER BY property_name;

Isolate translatable properties and their resolved text:

  • SELECT item_id, property_name, def_translated_text, translated_text FROM apps.cz_item_properties_v WHERE data_type = 8 AND translated_text IS NOT NULL;

Find items that override rather than inherit defaults:

  • SELECT item_id, property_name, property_value FROM apps.cz_item_properties_v WHERE inherited_flag = 0;

Join to CZ_ITEM_MASTERS for part context:

  • SELECT m.ref_part_nbr, v.property_name, v.property_value FROM apps.cz_item_properties_v v, apps.cz_item_masters m WHERE v.item_id = m.item_id AND m.deleted_flag = '0';

Because INHERITED_FLAG and the translated-text columns are derived through scalar subqueries, queries filtering heavily on TRANSLATED_TEXT or INHERITED_FLAG may benefit from narrowing first on ITEM_ID or ITEM_TYPE_ID.