Search Results cz_explnodes_withimages_v




Overview
Explore in AI Chat

Overview

CZ_EXPLNODES_WITHIMAGES_V is a read-only database view owned by the APPS schema in Oracle EBS Release 12.1.1 and 12.2.2. It belongs to the CZ (Oracle Configurator) product family and operates as a presentation-layer object that joins exploded model node data with associated node type image metadata. Its purpose is to expose configuration model structure nodes together with the images and UI attributes that the Configurator runtime and reporting layers require when rendering or analyzing a configured model tree. The view is documented as VALID in the ETRM repository, confirming that it is a supported, active object in the shipped data model.

The name reflects its design intent: EXPL denotes the exploded (expanded) node hierarchy from the Configurator model structure, and WITHIMAGES indicates that node image information is concatenated into the result set via an inner relationship with the node type image view. In practice, this view is consumed where a flattened, image-enriched view of model nodes is preferable to querying the two source objects independently.

Underlying Base Objects

The documented dependency list for this view includes both views and PL/SQL packages, reflecting the layered architecture of the CZ schema:

The view therefore sits atop a small stack of CZ objects rather than directly over raw tables, which means its availability depends on the validity of CZ_EXPLMODEL_NODES_V and CZ_PSNODETYPE_IMAGES_V.

Key Columns

The projected column list is extensive and can be grouped functionally:

Common Use Cases and Queries

Typical uses include validating which nodes carry images, auditing UI sections for a given model, and feeding reporting extracts with both node and image data in a single pass.

List nodes with image assignments for a model:

SELECT ps_node_id, name, psnodetype_name, image_file, full_image_path
  FROM apps.cz_explnodes_withimages_v
 WHERE model_id = :model_id
   AND image_file IS NOT NULL
 ORDER BY node_depth, tree_seq;

Inspect UI sections and suppression flags:

SELECT ps_node_id, name, ui_section, ui_omit, suppress_flag
  FROM apps.cz_explnodes_withimages_v
 WHERE model_id = :model_id
   AND NVL(ui_omit,'N') = 'N';

Join to localized text for multilingual reporting, filter by organization, and constrain effectivity using EFFECTIVE_FROM and EFFECTIVE_UNTIL. Because the view is APPS-owned, callers should query it as APPS.CZ_EXPLNODES_WITHIMAGES_V or rely on the standard APPS synonym resolution, and grant SELECT privileges explicitly where cross-schema access is required.