Search Results hz_class_category_v




Overview
Explore in AI Chat

Overview

HZ_CLASS_CATEGORY_V is a seeded, read-only view owned by the APPS schema in Oracle E-Business Suite releases 12.1.1 and 12.2.2. It belongs to the Receivables (AR) product family and exposes the set of classification categories used by the Oracle Trading Community Architecture (TCA) and the customer/party model. In the TCA data model, a "class category" defines a classification axis—such as Industry, Customer Type, or Geography—for which individual lookup values (nodes in a classification hierarchy) can be assigned to entities such as parties, locations, and accounts. Because the view joins classification category definitions to the lookup type registry, it provides a single, self-describing result set: each row combines the structural attributes of a class category with its user-facing display name and description.

The view is important in reporting and integration scenarios because the underlying base table, HZ_CLASS_CATEGORIES, stores only the internal category code and its behavioral flags. Consumers must join to FND_LOOKUP_TYPES_VL to obtain the translatable MEANING and DESCRIPTION of the category. HZ_CLASS_CATEGORY_V performs this join internally, so reports, interfaces, and custom concurrent programs can resolve a category code to a business-friendly label without reimplementing the lookup translation logic. The view is defined with the standard TCA audit and multi-language columns and is marked STATUS = VALID, indicating it is an Oracle-supported query interface rather than a customer-modifiable object.

The user search term fnd_lookup_types_vl corresponds directly to the lookup type registry referenced by this view. HZ_CLASS_CATEGORY_V is one of the standard mechanisms by which FND_LOOKUP_TYPES_VL participates in the TCA classification model, and developers investigating lookup type usage in Receivables are frequently directed to this view.

Underlying Base Objects

The documented view metadata identifies two referenced base objects:

  • HZ_CLASS_CATEGORIES (SYNONYM) — the primary TCA table holding classification category definitions. It supplies the category code, structural behavior flags, delimiter, audit columns, application context, and the object version number.
  • FND_LOOKUP_TYPES_VL (VIEW) — the multi-lingual "VL" (view with translation) rendering of FND_LOOKUP_TYPES. It supplies the translated MEANING and DESCRIPTION plus lookup-level attributes such as CUSTOMIZATION_LEVEL, SECURITY_GROUP_ID, and VIEW_APPLICATION_ID.

Join condition, as documented in the view text:

HZ_CLASSCATEGORIES.CLASS_CATEGORY = FNDLOOKUPTYPESVL.LOOKUP_TYPE

The class category code itself is the lookup type name. The relationship is therefore a one-to-one correlation between a classification category and its corresponding lookup type, with the VL portion ensuring the correct language row is returned according to the session's language and MLS settings.

Key Columns

Common Use Cases and Queries

Typical uses include validating classification categories before data load, rendering LOVs for classification setup, and driving reports that show entity classifications alongside their human-readable category names. A minimal query returning active categories with their flags:

SELECT class_category, meaning, description,
       allow_multi_assign_flag, allow_leaf_node_only_flag, frozen_flag
  FROM apps.hz_class_category_v
 ORDER BY meaning;

To find categories that permit multiple assignments and are not frozen:

SELECT class_category, meaning, delimiter
  FROM apps.hz_class_category_v
 WHERE allow_multi_assign_flag = 'Y'
   AND frozen_flag = 'N';

Because HZ_CLASS_CATEGORY_V already resolves the lookup translatable columns, it is generally preferable to query the view rather than joining HZ_CLASS_CATEGORIES to FND_LOOKUP_TYPES_VL manually in custom reports and interfaces.