Search Results p_page_element_type




Overview
Explore in AI Chat

Overview

The view APPS.CZ_NODES_FOR_UIELEMS_EFF_CV is a configuration-management database object within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 Oracle Configurator (CZ) schema. It exposes the effective-dated hierarchy of configuration model nodes as they are presented to user-interface elements. The name components indicate its purpose: "NODES_FOR_UIELEMS" (nodes rendered for UI elements), "EFF" (effective-dated), and "CV" (a custom or covered view). The view is owned by APPS and is consumed by Configurator runtime and administrative screens that render the model tree in the user interface, particularly those that drive the guided-selling and configuration pages exposed to end users.

Its central role is to resolve which model nodes are available, how they nest, and which page element type (signature) governs each node's presentation. The column alias p_page_element_type — the very term the user searched for — is a derived column that carries the signature identifier for the page element type associated with a given configuration node. This makes the view a critical integration point between the model definition layer and the UI rendering layer.

Underlying Base Objects

Per ETRM metadata for 12.2.2, the view is defined over the following documented base objects:

  • CZ_EXPLNODES_IMAGE_EFF_V (VIEW) — supplies the effective-dated expanded node image, aliased as CZEXPLIMGV in the view text. Nearly all projected node attributes originate here.
  • CZ_SIGNATURES (SYNONYM) — provides the signature identifier resolved into p_page_element_type.
  • CZ_PDT_2_PGE_RELS_V (VIEW) — the product-definition-type-to-page-element-type relationship view used in the correlated subquery that computes node_disabled_flag.
  • CZ_TYPE_RELATIONSHIPS (SYNONYM) — joins with CZ_PDT_2_PGE_RELS_V to detect conversion (REL_TYPE_CODE = 'CNV') relationships.
  • CZ_TYPES (PACKAGE) — supplies GET_UI_SIGNATURE_ID, the function that derives the UI signature from node attributes.
  • CZ_UTILS and CZ_DEVELOPER_UTILS_PVT (PACKAGES) — supporting utility packages referenced by the definition.
  • DUAL (SYNONYM) — used in the EXISTS/COUNT(*) construct that produces the disabled-node flag.

Key Columns

Common Use Cases and Queries

Typical usages include diagnosing which nodes render for a given page element type, locating disabled nodes, and validating effective-date coverage before publishing a model.

SELECT ps_node_id, name, p_page_element_type, node_disabled_flag
FROM   apps.cz_nodes_for_uielements_eff_cv
WHERE  p_page_element_type = :signature_id
  AND  node_disabled_flag = 0
ORDER BY tree_seq;

SELECT ps_node_id, name, effective_from, effective_until
FROM   apps.cz_nodes_for_uielements_eff_cv
WHERE  TRUNC(SYSDATE) BETWEEN effective_from AND NVL(effective_until, SYSDATE);

These queries support runtime troubleshooting, extension development, and impact analysis whenever page element type definitions or effectivity sets are modified.