Search Results ref_expl_node_id




Overview
Explore in AI Chat

Overview

APPS.CZ_UIEXPL_HGRID is a reporting view in the Oracle E-Business Suite (EBS) 12.1.1 / 12.2.2 environment belonging to the Oracle Enterprise Technical Reference Model (ETRM) / Applications Technology stack. It exposes a hierarchical, flattened representation of the UI exploration tree used by the "UI Explorer" and related configuration utilities, joining root UI definitions to their descendant UI components along with the model-reference exploration chain that connects them. In practice, the view answers the question: "For a given root UI definition within a development project (model), which child UI components exist, how deep are they in the exploration hierarchy, and what is their persistent/leaf node identity?" This makes it valuable for auditing UI component trees, documenting configuration structure, and integrating UI metadata into downstream reporting or migration tooling. Because the "ref_expl_node_id" column is projected as a literal NULL (via TO_NUMBER(NULL)), consumers should understand that the reference-exploration node identifier is intentionally not populated in this particular projection and must be derived elsewhere.

Underlying Base Objects

The view is constructed over several documented base objects: CZ_UI_DEFS (synonym, aliased RUDF for root UI definitions), CZ_MODEL_REF_EXPLS (synonym, referenced three times as ROOTXP, DESCXP, and RTDOWNX), CZ_ALL_UI_COMPONENTS_V (view, aliased ALLUI), the package CZ_MODEL_UTIL_PVT, and the collection type CZ_EXPL_PAIR_TBL. The package function CZ_MODEL_UTIL_PVT.GET_PARALLEL_EXPLS is invoked in the FROM clause via TABLE(CAST(...)) to produce the set of exploration pairs (enclosing and descendant exploration nodes), typed as SYSTEM.CZ_EXPL_PAIR_TBL. The joins bind: root XP to the root UI definition by devl_project_id, the descendant XP (descxp) and enclosing XP (rtdownx) through the parallel-exploration collection, and CZ_ALL_UI_COMPONENTS_V to the descendant exploration node via LOCAL_EXPL_NODE_ID. All three CZ_MODEL_REF_EXPLS aliases and the CZ_UI_DEFS row are filtered with DELETED_FLAG = '0', so only active (non-deleted) records participate. Note that CZ_UTILS is listed as a referenced object, indicating supporting utility logic used indirectly.

Key Columns

Common Use Cases and Queries

Typical scenarios include auditing UI component trees per model, preparing documentation of configured UI structure, and extracting hierarchy data for migration or comparison. A standard query retrieves active components for a project:

  • SELECT root_ui_name, name, object_type, expl_node_depth FROM apps.cz_uiexpl_hgrid WHERE model_id = :p_model_id ORDER BY tree_seq;
  • SELECT DISTINCT root_ui_def_id, root_ui_name FROM apps.cz_uiexpl_hgrid;
  • SELECT name, leaf_persistent_node_id FROM apps.cz_uiexpl_hgrid WHERE virtual_flag = '0' AND child_model_id = :p_model;

Because REF_EXPL_NODE_ID returns NULL, queries requiring the reference exploration node identifier should source it from CZ_MODEL_REF_EXPLS or CZ_MODEL_UTIL_PVT functions rather than from this view.