Results for “primary_uom_code”

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

Overview

CZ_ITEM_PROPERTY_POP_V is a reporting view owned by the APPS schema within the Oracle E-Business Suite Configurator (CZ) module. The object name suffix "POP" identifies it as a populator view — a purpose-built relational source used to drive Populator-style concurrent or UI processes that enumerate model item types alongside the properties assignable to them. It exposes a denormalized, human-readable combination of item type identifiers, item type names, property identifiers, and property names drawn from the Configurator property and item type model tables.

The view is documented as VALID status in both EBS 12.1.1 and 12.2.2 lineages, and the ETRM metadata records it as a standard APPS-owned view with no editioning or multi-tenant variation. Because it is a view rather than a table, it carries no storage of its own and reflects the current committed state of the underlying Configurator definition tables at query time.

Underlying Base Objects

The view text is defined over three synonyms, each resolving to a Configurator base table in the APPS schema:

• CZ_ITEM_TYPES — the item type definition table, supplying ITEM_TYPE_ID and the descriptive NAME that the view aliases as ITEM_TYPE_NAME.
• CZ_ITEM_TYPE_PROPERTIES — the intersection table that associates properties with item types; it contributes the join keys and the soft-delete flag used for filtering.
• CZ_PROPERTIES — the property master table, supplying PROPERTY_ID, NAME, and DESC_TEXT.

All three joins are implemented as outer joins (via the legacy (+) operator), with CZ_PROPERTIES as the driving table. This means every non-deleted property is returned even when no item type assignment exists, in which case the item type columns are null. The view applies an NVL-based soft-delete filter to all three sources, excluding rows where DELETED_FLAG equals '1' but retaining rows where the flag is null.

Key Columns

• ITEM_TYPE_ID — numeric identifier of the associated Configurator item type; null when the property is unassigned.
• ITEM_ID — always TO_NUMBER(NULL); a placeholder column included for interface compatibility with companion populator views.
• PROPERTY_ID — identifier of the property from CZ_PROPERTIES.
• ITEM_TYPE_NAME — the item type's display name, the column most often searched as "item_type_name".
• ITEM_MASTER_NAME — always TO_CHAR(NULL); reserved placeholder.
• PROPERTY_NAME / NAME — the property name, exposed twice under different aliases to satisfy differing consumer expectations.
• DESC_TEXT — the descriptive text maintained against the property.
• QUOTEABLE_FLAG / PRIMARY_UOM_CODE — both always null placeholders, present so the view's column list matches a common populator interface.

Common Use Cases and Queries

The view is typically used to report which properties are available per item type, to validate Configurator setup before deployment, and to feed populator logic that requires a flat property list. A representative query filtering on the searched term follows:

• SELECT ITEM_TYPE_NAME, PROPERTY_NAME, DESC_TEXT FROM CZ_ITEM_PROPERTY_POP_V WHERE ITEM_TYPE_NAME = '&item_type_name';
• SELECT ITEM_TYPE_ID, PROPERTY_ID, PROPERTY_NAME FROM CZ_ITEM_PROPERTY_POP_V WHERE ITEM_TYPE_ID IS NOT NULL ORDER BY ITEM_TYPE_ID, PROPERTY_NAME;
• SELECT PROPERTY_NAME FROM CZ_ITEM_PROPERTY_POP_V WHERE ITEM_TYPE_ID IS NULL; — identifies properties not yet assigned to any item type.

Because soft-deleted rows are filtered internally, no additional DELETED_FLAG predicate is required by callers.