Results for “template_ui_def_id”

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

Overview

The CZ_UIDEF_SIGNATURE_TEMPLS_V view is a Configurator (CZ) module object owned by the APPS schema in Oracle E-Business Suite. It exposes the relationship between user interface (UI) definitions and the signatures that drive Configurator template assignment logic. In ETRM 12.1.1 and 12.2.2 environments, this view is queried by Configurator runtime and administrative logic to resolve which UI definition templates are associated with a given signature type. As a reporting and integration artifact, it consolidates the intersection of content-type template assignments and object-type relationships into a single denormalized result set, sparing callers from writing custom joins across the underlying tables. Its status is VALID, indicating the view compiles correctly against its base objects.

Underlying Base Objects

The view is defined over two documented base objects, both registered as SYNONYMs in the APPS schema:

• CZ_UI_CONT_TYPE_TEMPLS (aliased UCTT): Stores user-interface content-type-to-template assignments. It contributes the UI definition identifier, template identifiers, and the deletion state of each assignment row.
• CZ_TYPE_RELATIONSHIPS (aliased RELS): Stores relationships between object types. It supplies the signature identifier and the relationship semantics that qualify which templates apply.

The join is governed by three documented predicates. First, UCTT.DELETED_FLAG = '0' restricts output to live content-type template rows. Second, RELS.SUBJECT_TYPE = UCTT.CONTENT_TYPE aligns each content-type assignment with its corresponding type relationship. Third, RELS.REL_TYPE_CODE = 'CNV' limits relationships to the conversion (CNV) relationship type, with RELS.DELETED_FLAG = '0' excluding logically deleted relationships. Together these conditions ensure the view returns only active, semantically valid template-to-signature mappings.

Key Columns

• UI_DEF_ID — Identifier of the UI definition associated with the content-type template assignment.
• SIGNATURE_ID — Derived from RELS.OBJECT_TYPE. This is the column most frequently targeted by searches for "signature_id" and represents the object type acting as the signature for the template relationship.
• TEMPLATE_ID — Identifier of the template attached to the content type.
• TEMPLATE_UI_DEF_ID — UI definition identifier for the template itself, allowing navigation to the template's presentation layer.
• EXACT_TEMPL_ASSIGN_FLAG — A constant literal '1' emitted by the view, signalling an exact template assignment for every row returned.

Common Use Cases and Queries

Typical consumers retrieve all signature-template mappings for a UI definition, or enumerate which signatures are tied to a specific template. A representative query follows:

• Filter by UI definition:
  SELECT signature_id, template_id, template_ui_def_id
FROM cz_uidef_signature_templs_v
WHERE ui_def_id = :p_ui_def_id;
• Locate mappings for a given signature:
  SELECT ui_def_id, template_id
FROM cz_uidef_signature_templs_v
WHERE signature_id = :p_signature_id;

These queries support Configurator diagnostics, template assignment audits, and integration extracts. Because the view already enforces deletion and relationship-type filtering, standard callers should not re-apply those predicates.