Search Results cz_explnodes_image_eff_v




Overview
Explore in AI Chat

Overview

The view APPS.CZ_EXPLNODES_IMAGE_EFF_V is a Configurator (CZ) reporting and integration object that joins model explosion node data with node-type image metadata. It belongs to the Oracle Configurator module and is deployed in the APPS schema with a status of VALID. The view combines the hierarchical structure of a configured model — as exploded into individual nodes — with the images and usage codes associated with each node type, so that a caller can retrieve presentation-oriented information (image file, alternate text, full image path) alongside the structural and effectivity attributes of every node in an explosion.

The name element EXPLNODES refers to explored (exploded) model nodes, IMAGE refers to the node-type imagery supplied by the CZ_PSNODETYPE_IMAGES_V source, and EFF refers to the effectivity-oriented presentation of the data. A literal EFFECTIVITY_FILTER column is exposed and set to the constant 'N', distinguishing this view within the family of effectivity-aware explosion views. Because the view is read-only and validated, it is safe for ad hoc reporting and for external integrations that need image-aware model node listings without touching the underlying Configurator developer tables directly.

Underlying Base Objects

The documented base objects for this view are the following:

The join between the exploded node set and the node-type image set is the defining characteristic of the view, correlating each node's PS_NODE_TYPE with the imagery maintained for that node type.

Key Columns

Common Use Cases and Queries

Typical scenarios include retrieving all images associated with a given node type, auditing effectivity windows for exploded nodes, and driving Configurator UI or catalog output where node imagery must accompany structural data.

  • List nodes of a specific type with their imagery:
    SELECT PS_NODE_TYPE, NAME, IMAGE_FILE, FULL_IMAGE_PATH FROM CZ_EXPLNODES_IMAGE_EFF_V WHERE PS_NODE_TYPE = :p_node_type;
  • Inspect available image usage codes:
    SELECT DISTINCT PS_NODE_TYPE, IMAGE_USAGE_CODE, PSNODETYPE_NAME FROM CZ_EXPLNODES_IMAGE_EFF_V;
  • Review effectivity for a model:
    SELECT PS_NODE_ID, EFFECTIVE_FROM, EFFECTIVE_UNTIL, EFFECTIVITY_FILTER FROM CZ_EXPLNODES_IMAGE_EFF_V WHERE MODEL_ID = :p_model_id;

Because the view is read-only, all queries should be issued as SELECT statements; no DML is supported against it.