Search Results root_ui_def_id




Overview
Explore in AI Chat

Overview

APPS.CZ_UIS_FOR_EXPLNODES_V is a read-only database view owned by the APPS schema in Oracle E-Business Suite release 12.1.1 and 12.2.2. It is registered in the Applications FND design data under the designator CZ.CZ_UIS_FOR_EXPLNODES_V, which indicates that its definition is managed by Oracle Application Object Library and shipped as part of the product seed data rather than created ad hoc by a customer.

The view exposes the relationship between a configuration model reference explosion and the user interface (UI) definitions used to present its nodes. Specifically, it returns, for each model reference explosion row, the root UI definition and the enclosing UI definition, together with descriptive names and a flag identifying the root UI. This makes the view a compact projection layer for reporting, extensions, and integration code that must resolve UI identifiers into human-readable names without reimplementing the join logic against the base configuration tables. The view currently holds a VALID status, and the presence of a CZ_VIEW_REVISION column confirms that Oracle tracks the shipped revision of the view definition, allowing Oracle Support and customers to detect divergence from the delivered definition.

Underlying Base Objects

The ETRM metadata documents the following base objects referenced by the view, all reached through APPS synonyms: CZ_MODEL_REF_EXPLS, CZ_UI_DEFS, CZ_UI_REFS, and the PUBLIC synonym DUAL. Because the view is defined against APPS synonyms rather than fully qualified table names, it resolves through the APPS schema in the standard fashion for Oracle EBS views. CZ_MODEL_REF_EXPLS supplies the model and model reference explosion identifiers that anchor each row. CZ_UI_DEFS supplies the UI definition rows from which the root and enclosing UI names are drawn. CZ_UI_REFS supplies the UI reference chain that links a node to its enclosing UI, which is what allows the view to distinguish the root UI from the enclosing UI in the same result set. DUAL is used as a constant source in the view's construction. Downstream, the view is referenced by APPS.CZ_UIS_FOR_EXPLNODES_V consumers such as CZ_UIPAGES_FOR_EXPLNODES_V, so it functions as an intermediate layer feeding higher-level UI page reporting views.

Key Columns

  • MODEL_ID (NUMBER) — Identifier of the configuration model that the model reference explosion belongs to.
  • MODEL_REF_EXPL_ID (NUMBER) — Identifier of the model reference explosion record; the primary linkage back to CZ_MODEL_REF_EXPLS.
  • ROOT_UI_DEF_ID (NUMBER) — UI definition identifier of the root user interface associated with the explosion.
  • ROOT_UI_NAME (VARCHAR2(255)) — Descriptive name of the root UI definition, resolved from CZ_UI_DEFS. This is the column most frequently targeted by ad hoc searches, including the query term "root_ui_name".
  • ENCL_UI_DEF_ID (NUMBER) — UI definition identifier of the enclosing UI, i.e. the UI that contains the node within the hierarchy.
  • ENCL_UI_NAME (VARCHAR2(255)) — Descriptive name of the enclosing UI definition.
  • IS_ROOT_UI_FLAG (VARCHAR2) — Flag indicating whether the associated UI definition is the root UI for the node.
  • CZ_VIEW_REVISION (CHAR(10)) — Shipped revision marker of the view definition.

Common Use Cases and Queries

Typical uses include validating model reference explosions prior to deployment, producing pick lists of available UIs in extensions, and joining to CZ_UIPAGES_FOR_EXPLNODES_V for page-level reporting. A straightforward lookup by root UI name is shown below.

SELECT model_id, model_ref_expl_id, root_ui_def_id, root_ui_name, encl_ui_name, is_root_ui_flag, cz_view_revision FROM apps.cz_uis_for_explnodes_v WHERE UPPER(root_ui_name) = UPPER(:p_root_ui_name);

To list all nodes belonging to a given model explosion, filter on MODEL_ID and order by ROOT_UI_NAME, joining back to CZ_MODEL_REF_EXPLS where model attributes are required. Because the view performs the UI def resolution internally, custom code should query it directly rather than reproducing the joins against CZ_UI_DEFS and CZ_UI_REFS.