Search Results tree_seq




Overview
Explore in AI Chat

Overview

CZ_UIDEF_CONTENTS_V is a reporting and diagnostic view in the Oracle E-Business Suite Configurator (CZ) module. It presents a hierarchical, flattened representation of the Configurator user interface definition (UI definition) metadata, exposing the internal structure of user interface definitions, their associated content types, and the templates assigned to those content types. The view is intended to support reporting, troubleshooting, and integration scenarios in which technical consultants and developers need to inspect how a Configurator UI definition is assembled without navigating the underlying normalized base tables directly.

The view is defined as a UNION ALL of several SELECT statements, each contributing a distinct "node" type to a unified parent/child hierarchy. A recursive CONNECT BY-style construct is applied over this union, with the LEVEL pseudocolumn returned as INFO_LEVEL and a padded, indented rendering of the INFO column returned as INDENT_INFO. This makes the view particularly useful for producing tree-style reports of UI definition contents. In the ETRM documentation the view is recorded as "Not implemented in this database," indicating that in some environments the object may not be deployed or may be present only in specific product configurations.

Underlying Base Objects

The documented ETRM metadata records no referenced base objects for this view. The view text, however, clearly references several Configurator tables: CZ_UI_DEFS (the master UI definition records), CZ_UI_CONT_TYPE_TEMPLS (the mapping of content types to templates), and the supporting view CZ_UI_CONT_TYPE_TEMPLS_VV (a validated/versioned variant exposing content type template details). The UNION ALL structure draws from these objects to build a coherent hierarchy keyed on UI_DEF_ID, with synthetic identifiers (IDENT and PARENT_IDENT) constructed using string prefixes such as 'UDF-', 'UDF-$CT', and 'UDF-$CT-'. Because the view is not materialized and is built purely from SELECT statements, it always reflects the current state of the underlying Configurator definition tables at query time.

Key Columns

  • MASTER_ID / MASTER_NAME — The UI definition identifier and its name; the top-level anchor of the hierarchy.
  • RECTYPE_CODE / RECTYPE_NAME — The node type. Codes include '0' (UI), '1' (MASTER TEMPLATE), 'B' (FRAGMENT - BOM), 'N' (FRAGMENT - NON-BOM), 'P' (PAGINATION), 'UTT_HDR' (UI CONTENT TYPES), and 'UDF_ATTR' (UI ATTRIBUTES).
  • IDENT / PARENT_IDENT — Synthetic unique identifiers used to link parents and children in the hierarchy.
  • TREE_SEQ — Ordering sequence used to sort sibling nodes within the tree.
  • SOURCE_TABLE — The base table from which the row originated (e.g., CZ_UI_DEFS, CZ_UI_CONT_TYPE_TEMPLS).
  • INFO — Descriptive text for the node, including UI style, description, and template details.
  • ROW_ID — The physical ROWID of the underlying record, useful for drill-back.
  • INFO_LEVEL / INDENT_INFO — The hierarchy depth and a space-padded, indented rendering of INFO for tree-style output.

Common Use Cases and Queries

Typical use cases include auditing UI definition structure, tracing which templates are mapped to which content types, and producing readable tree reports for a given Configurator model. A representative query filters by master definition and orders by the hierarchy:

  • SELECT INFO_LEVEL, INDENT_INFO, RECTYPE_NAME, SOURCE_TABLE FROM CZ_UIDEF_CONTENTS_V WHERE MASTER_ID = :ui_def_id ORDER BY TREE_SEQ, INFO_LEVEL;
  • SELECT MASTER_NAME, RECTYPE_NAME, COUNT(*) FROM CZ_UIDEF_CONTENTS_V GROUP BY MASTER_NAME, RECTYPE_NAME;
  • SELECT DISTINCT SOURCE_TABLE FROM CZ_UIDEF_CONTENTS_V; — Useful when searching for the origin table of a given node type, matching the common "source_table" search interest.