Search Results cz_config_items_v




Overview
Explore in AI Chat

Overview

CZ_CONFIG_ITEMS_V is an APPS-owned database view in the Oracle EBS Configurator (CZ) product family. It is documented as the client (installed-base) view of the CZ_CONFIG_ITEMS table. In release 12.1.1 and 12.2.2 the object carries a VALID status and remains available for read access to configuration item data without exposing the underlying transactional table directly. Its primary role is to provide a stable, filtered projection of configured items that reporting, extensions, and integration logic can query. Because it joins CZ_CONFIG_ITEMS to CZ_CONFIG_HDRS and filters on DELETED_FLAG = '0', consumers of the view see only active configuration items that belong to a valid configuration header revision. This makes the view suitable for installed-base (IB) reporting, where records must reflect live configuration state rather than rows historically marked for deletion.

Underlying Base Objects

The view is defined over two base objects referenced through APPS synonyms: CZ_CONFIG_ITEMS and CZ_CONFIG_HDRS. The dependency is an inner join on CONFIG_HDR_ID and CONFIG_REV_NBR, ensuring each returned item is anchored to a matching configuration header revision. Filtering on A.DELETED_FLAG = '0' restricts output to non-deleted configuration item rows. The view therefore inherits the column structure of CZ_CONFIG_ITEMS while adding MODEL_INSTANTIATION_TYPE from CZ_CONFIG_HDRS. No alternative or external source tables are referenced, so the view represents a straightforward, condition-filtered join rather than an aggregation or transformation. Any change to the two base tables propagates to the view on the next query execution.

Key Columns

Common Use Cases and Queries

Typical scenarios include installed-base reporting, configuration validation, and custom extensions that need node-level configuration detail. A common query filters on the node identifier to locate a specific configuration item and its attributes:

SELECT config_item_id, config_hdr_id, config_rev_nbr, node_identifier, item_val, inventory_item_id, organization_id FROM cz_config_items_v WHERE node_identifier = :p_node_identifier;

To review all active items for a single configuration revision:

SELECT config_item_id, parent_config_item_id, name, item_val, model_instantiation_type FROM cz_config_items_v WHERE config_hdr_id = :p_hdr_id AND config_rev_nbr = :p_rev ORDER BY sequence_nbr;

The view may also be joined to CZ_CONFIG_HDRS, inventory tables, or BOM structures when building installed-base reports, since it already excludes deleted items and supplies header-level instantiation context.