Results for “cz_uipages_for_explnodes_v”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

CZ_UIPAGES_FOR_EXPLNODES_V is a Configurator (CZ) reporting view owned by the APPS schema within Oracle E-Business Suite, valid in releases 12.1.1 and 12.2.2. It exposes the relationship between UI pages and the configuration model nodes (explosion nodes) at which those pages become available. In the Oracle Configurator architecture, a UI definition (UI_DEF) contains one or more UI pages (UI_PAGES), and each page is bound to elements of a model's runtime structure. This view flattens that binding information into a single queryable surface, joining UI page definitions to their owning model, the root UI definition, the page element list, and the node onto which each page is attached.

Because Oracle Configurator stores compiled runtime UI metadata in terse numeric identifiers rather than friendly names, direct querying of the base tables is impractical for reporting. This view supplies both the raw identifiers and the descriptive names, allowing report writers, integration developers, and support analysts to trace how a given configuration session should render pages for a specific explosion node. The TARGET_UI_DEF_ID column is the anchor searched by most consumers of this view: it identifies the UI definition that a given page targets, and by extension the UI under which that page is visible.

Underlying Base Objects

The ETRM metadata for 12.2.2 documents the following referenced base objects:

• CZ_UI_PAGES — the page definitions themselves, carrying name, display condition, and local identifiers.
• CZ_UI_PAGE_ELEMENTS — the list joining a page to the UI or page base it belongs to, supplying element identifiers, bindings, and display conditions.
• CZ_UI_DEFS — the UI definition master, providing UI_DEF_ID and descriptive NAME.
• CZ_PS_NODES — persistent and page-base nodes describing model structure, instantiable flags, and node paths.
• CZ_MODEL_REF_EXPLS — model reference explosion nodes, used in the collection-check subquery and hierarchy traversal.
• CZ_UIS_FOR_EXPLNODES_V — a related sibling view supplying the root model/UI context for explosion nodes.
• CZ_DEVELOPER_UTILS_PVT — a package supplying ANNOTATED_NODE_PATH, used to build human-readable node paths.

The view text performs outer joins across these objects and uses a hierarchical CONNECT BY subquery to determine whether a node participates in a collection, exposing that result through NODE_COLLECTION_FLAG.

Key Columns

• ELEMENT_ID — identifier of the page element binding this row.
• TARGET_UI_DEF_ID / TARGET_UI_NAME — the UI definition that the target page belongs to, and its display name.
• TARGET_PAGE_ID / TARGET_PAGE_PERS_NODE_ID — the target page and its persistent node identifier.
• ROOT_UI_DEF_ID, ROOT_UI_NAME, ROOT_MODEL_ID, ROOT_MODEL_EXPL_ID, ROOT_MODEL_NODE_ID — the root UI and model context within which the page is resolved.
• PS_NODE_ID_PER_ROOT_MDL — persistent node identifier relative to the root model.
• TARGET_PAGE_ANN_PATH — a constructed annotated path naming the target page in model terms.
• TARGET_PAGE_DISPCOND_ID, TARGET_PAGE_DISPCOND_COMP, TARGET_PAGE_DISPCOND_VALUE — the display condition controlling page visibility.
• NODE_COLLECTION_FLAG, BOUND_VIA_PARENT_FLAG, ELEMENT_BINDING_FLAG — boolean indicators for collection membership and parent binding.
• PAGE_INCLUSION_DEPTH, TARGET_PAGE_REFERENCE_DEPTH, TARGET_PAGE_EXPL_NODE_DEPTH — depth metrics used in traversal and nesting.
• VIEW_REVISION — a timestamp indicating the view's last revision.

Common Use Cases and Queries

Typical scenarios include diagnosing why a page is not displayed for a node, auditing which UI definitions expose a given page, and building integration extracts that map model nodes to UI pages.

SELECT TARGET_UI_DEF_ID, TARGET_UI_NAME, TARGET_PAGE_ID,
       ROOT_UI_NAME, NODE_COLLECTION_FLAG, BOUND_VIA_PARENT_FLAG
FROM   APPS.CZ_UIPAGES_FOR_EXPLNODES_V
WHERE  TARGET_UI_DEF_ID = :p_ui_def_id;

SELECT ELEMENT_ID, TARGET_UI_NAME, TARGET_PAGE_ANN_PATH,
       TARGET_PAGE_DISPCOND_COMP, TARGET_PAGE_DISPCOND_VALUE
FROM   APPS.CZ_UIPAGES_FOR_EXPLNODES_V
WHERE  ROOT_MODEL_ID = :p_model_id
AND    NODE_COLLECTION_FLAG = '1';

Joining to CZ_UI_DEFS on TARGET_UI_DEF_ID confirms the authoritative UI name, while restricting on ROOT_MODEL_EXPL_ID isolates the explosion context for a specific configuration model.