Search Results cz_ui_ref_templates_pk




Overview
Explore in AI Chat

Overview

The CZ_UI_REF_TEMPLATES table is a core data object within the Oracle Configurator (CZ) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It serves as a junction table that manages template-to-template references within the Configurator's user interface (UI) definition framework. This table is essential for establishing hierarchical and referential relationships between different UI templates, enabling the construction of complex, reusable configuration interfaces. By defining these links, it allows one template to incorporate or reference the structure and logic defined in another, promoting modularity and consistency across configuration models.

Key Information Stored

The table's primary purpose is to store pairs of related UI templates. Its structure is defined by a composite primary key and two sets of foreign key columns that link to the master template table. The critical columns are:

  • TEMPLATE_ID and TEMPLATE_UI_DEF_ID: Together, these identify the parent or source template that is making the reference.
  • REF_TEMPLATE_ID and REF_TEMPLATE_UI_DEF_ID: Together, these identify the child or referenced template that is being included. The user's search for "ref_template_id" directly points to this column, which is a key identifier for the target of the template relationship.
Each record represents a single reference from one specific template version to another.

Common Use Cases and Queries

A primary use case is analyzing the dependency graph of UI templates to understand reuse or to assess the impact of changing a template. For instance, to find all templates that reference a specific template (identified by its ID and UI definition ID), one would query: 

SELECT template_id, template_ui_def_id
FROM cz_ui_ref_templates
WHERE ref_template_id = :1
AND ref_template_ui_def_id = :2;
Conversely, to list all templates referenced by a given parent template: 
SELECT ref_template_id, ref_template_ui_def_id
FROM cz_ui_ref_templates
WHERE template_id = :1
AND template_ui_def_id = :2;
These queries are vital for impact analysis, debugging configuration UI behavior, and documenting template architecture.

Related Objects

The CZ_UI_REF_TEMPLATES table has a tightly coupled relationship with the master template table, CZ_UI_TEMPLATES. As documented in the provided metadata, it maintains two foreign key relationships to this same parent table:

  • Foreign Key 1: Columns (TEMPLATE_ID, TEMPLATE_UI_DEF_ID) reference CZ_UI_TEMPLATES. This links the "referencing" side of the relationship.
  • Foreign Key 2: Columns (REF_TEMPLATE_ID, REF_TEMPLATE_UI_DEF_ID) reference CZ_UI_TEMPLATES. This links the "referenced" side of the relationship.
Therefore, any meaningful query on CZ_UI_REF_TEMPLATES will typically involve joins to CZ_UI_TEMPLATES (often via aliases) to retrieve descriptive names and details for both the source and target templates. The table's primary key constraint, CZ_UI_REF_TEMPLATES_PK, enforces uniqueness on the combination of these four key columns.