Results for “quoteable_flag”

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

Overview

CZ_ITEM_ITEM_POP_V is a Configurator (CZ) module view owned by the APPS schema in Oracle E-Business Suite. Its documented purpose is a "Populator view - from Items," indicating that it exists to expose item master records in a denormalized, flattened form suitable for consumption by the Configurator's populator and related processing logic. In Oracle EBS 12.1.1 and 12.2.2, Configurator populator views act as the data source layer through which item and model information is presented to the configuration engine, reporting tools, and integration interfaces without requiring callers to join the underlying model tables directly.

The view presents a union-compatible shape: it exposes item-level rows (with PROPERTY_ID and PROPERTY_NAME as NULL placeholders) alongside the descriptive attributes of each item master. This structure allows the view to participate in queries where item and property data share a common column footprint, a common pattern in Configurator reporting views.

Underlying Base Objects

The ETRM documentation identifies two referenced base objects, both accessed through synonyms in the APPS schema:

• CZ_ITEM_MASTERS (SYNONYM) — the primary source table holding item master records, including item type linkage, reference part number, description text, quoteable flag, and primary unit of measure.
• CZ_ITEM_TYPES (SYNONYM) — the item type definition table, providing the type name used to categorize each item master.

The view joins these two tables on ITEM_TYPE_ID, then filters out logically deleted records via the DELETED_FLAG predicates (NVL(DELETED_FLAG,'0') <> '1'). Only non-deleted item masters and non-deleted item types are surfaced, ensuring downstream consumers see active configuration data only.

Key Columns

• ITEM_TYPE_ID — Identifier of the item type; the join key between the two base tables.
• ITEM_ID — Unique identifier of the item master record.
• PROPERTY_ID — Always NULL in this view; retained for column-shape compatibility.
• ITEM_TYPE_NAME — Descriptive name of the item type from CZ_ITEM_TYPES.
• ITEM_MASTER_NAME / NAME — Both map to CZ_ITEM_MASTERS.REF_PART_NBR, the reference part number used to identify the item.
• PROPERTY_NAME — Always NULL; the property counterpart to PROPERTY_ID.
• DESC_TEXT — Descriptive text for the item master.
• QUOTEABLE_FLAG — Indicates whether the item is quoteable within Configurator.
• PRIMARY_UOM_CODE — Primary unit of measure code for the item.

Common Use Cases and Queries

Typical scenarios include validating which Configurator items are active, extracting quoteable items for pricing or order-entry integrations, and building reports that group items by type. A basic listing query is:

• SELECT ITEM_ID, NAME, ITEM_TYPE_NAME, QUOTEABLE_FLAG, PRIMARY_UOM_CODE FROM APPS.CZ_ITEM_ITEM_POP_V ORDER BY ITEM_TYPE_NAME, NAME;
• Filter by quoteable items: SELECT ITEM_ID, NAME FROM APPS.CZ_ITEM_ITEM_POP_V WHERE QUOTEABLE_FLAG = 'Y';
• Filter by type: SELECT ITEM_ID, NAME, PRIMARY_UOM_CODE FROM APPS.CZ_ITEM_ITEM_POP_V WHERE ITEM_TYPE_NAME = :p_type;

Because the view already applies the DELETED_FLAG filters, callers do not need to re-apply soft-delete logic. Join it to other Configurator views on ITEM_ID or ITEM_TYPE_ID for extended reporting.