Search Results cz_uitempl_utility_v




Overview
Explore in AI Chat

Overview

CZ_UITEMPL_UTILITY_V is an Oracle E-Business Suite view owned by the APPS schema within the Oracle Configurator (CZ) product family. It is a narrowly scoped, filtered view whose purpose is to expose a specific subset of Configurator user interface template types that belong to a single template type group and client code. Unlike its parent view, which presents a broader catalog of template type definitions, CZ_UITEMPL_UTILITY_V constrains its result set to the template type IDs 170, 174, 545, 565, and 188, the template type group identified by TEMPLTYPE_GROUP_ID 180, and the client code 'NEWTEMPL'.

Within the EBS 12.1.1 and 12.2.2 environments, this object functions as a convenience layer for reporting, extensions, and integration logic that must reference this particular grouping of utility template types without re-specifying the filter predicates. Because it is a view and not a table, it carries no stored data of its own; every query against it is resolved dynamically against the underlying template type view.

Underlying Base Objects

The view is defined over CZ_UI_TEMPLATE_TYPES_V, itself a view rather than a physical table. The documented object metadata lists CZ_UI_TEMPLATE_TYPES_V (VIEW) and FND_PROFILE (PACKAGE) as referenced base objects. The dependency on FND_PROFILE reflects the standard EBS pattern in which the template type view applies profile option filtering, typically to restrict visible rows according to the current user's responsibility, organization, or site-level profile settings. As a result, the rows returned by CZ_UITEMPL_UTILITY_V may vary between users and operating units even though the static predicates — group 180, client 'NEWTEMPL', and the enumerated template type IDs — remain constant.

Internally, CZ_UI_TEMPLATE_TYPES_V resolves to the underlying Configurator template type definition data. CZ_UITEMPL_UTILITY_V adds no joins of its own; it is a pure projection and filter over that parent view.

Key Columns

  • TEMPLATE_TYPE_NAME — The descriptive name of the UI template type, used for display and reporting.
  • TEMPLATE_TYPE_ID — The unique identifier of the template type; restricted to 170, 174, 545, 565, and 188 in this view.
  • TEMPLTYPE_GROUP_NAME — The name of the template type group to which the type belongs; filtered to group 180.
  • TEMPLTYPE_GROUP_ID — The numeric identifier of the template type group, fixed at 180.
  • CLIENT_CODE — The client code qualifier for the template type; fixed at 'NEWTEMPL'.

Common Use Cases and Queries

Typical uses include validating that the expected utility template types are present and active in an environment, driving extension logic that keys off the enumerated type IDs, and supporting diagnostics during Configurator patching or cloning. A basic query is:

SELECT template_type_id,
       template_type_name,
       templtype_group_id,
       templtype_group_name,
       client_code
FROM   apps.cz_uitempl_utility_v
ORDER  BY template_type_id;

To confirm availability of a specific type:

SELECT COUNT(*)
FROM   apps.cz_uitempl_utility_v
WHERE  template_type_id = 545;

Because output depends on FND_PROFILE, comparisons across responsibilities should be performed with the profile context explicitly noted, and results should never be treated as a static list of the five type IDs.