Search Results parent_psnode_expl_id




Overview
Explore in AI Chat

Overview

CZ_EXPLMODEL_NODES_V is a view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the CZ – Configurator product. It exposes the node-level structure of an exploded configuration model, presenting each node in a configuration hierarchy together with resolved parentage information. Its primary purpose is to translate the stored representation of model nodes into a form that reflects the effective structural relationships between nodes at runtime, taking into account model references, parent explosion nodes, and development projects.

The view is particularly relevant when consumers need to reconstruct the tree of an exploded model — that is, the flattened set of components, features, and options generated from a base model definition. Because configuration hierarchies involve multiple layers of indirection (a node may point to another model, which in turn references further nodes), the view applies DECODE and NVL logic to resolve which parent should be treated as the structural parent for a given row. This makes it a convenient integration and reporting surface for anyone building queries around model structure rather than working directly with the underlying CZ_PS_NODES table.

Underlying Base Objects

The view is defined over the following documented base objects:

  • CZ_PS_NODES (SYNONYM) — the core persistent node table containing the physical configuration node records, including node identifiers, parent identifiers, feature types, and component attributes.
  • CZ_MODEL_REF_EXPLS (SYNONYM) — holds model reference explosion records that link a referring node to the exploded model instance it references.
  • CZ_DEVL_PROJECTS (SYNONYM) — the development project definitions used when a node belongs to a project rather than a released model.
  • CZ_UTILS (PACKAGE) — utility package referenced in the view logic for helper operations.
  • DUAL (SYNONYM) — used in the scalar subquery that computes the SUPPRESS_FLAG.

The view correlates CZ_PS_NODES (aliased PSN) with model reference explosion rows (XPL) and, where relevant, a parent explosion alias (PXPL). This aliasing allows the view to traverse both the node record and the reference explosion in a single row, resolving effective parents across model boundaries.

Key Columns

The most significant columns exposed by the view include:

Common Use Cases and Queries

The view is typically used to report or integrate configuration model structure, to trace parent-child node relationships, and to filter suppressed nodes from downstream processing. A frequent pattern is to retrieve the structural parent of every node in a given model:

SELECT ps_node_id, name, structural_parent_id, effective_parent_id
FROM apps.cz_explmodel_nodes_v
WHERE structural_parent_id IN (SELECT ps_node_id FROM apps.cz_explmodel_nodes_v);

Because the user search term was "structural_parent_id," the most direct query is to list children of a known parent node:

SELECT ps_node_id, name, feature_type, minimum, maximum
FROM apps.cz_explmodel_nodes_v
WHERE structural_parent_id = :parent_node_id
AND suppress_flag = '0';

Another common scenario is confirming which rows have no structural parent (typically model roots), which is useful when seeding a hierarchy traversal:

SELECT ps_node_id, name, model_ref_expl_id
FROM apps.cz_explmodel_nodes_v
WHERE structural_parent_id IS NULL;

Where the metadata is limited, the exact column list beyond the documented excerpt should be verified against the live view definition in the target instance, as the SELECT may differ slightly between 12.1.1 and 12.2.2 releases.