Search Results cz_item_types




Overview
Explore in AI Chat

Overview

The CZ_ITEM_TYPES table is a core reference data object within the Oracle Configurator (CZ) module of Oracle E-Business Suite (EBS). It serves as the master repository for defining the distinct classes or categories of configurable items and components used in the modeling environment. Every configurable entity within the Configurator, such as a Model, Option Class, or Feature, is assigned a specific item type. This classification is fundamental to the system's logic, as it governs the behavior, properties, and valid relationships between different elements in a configuration model. The table's primary role is to provide a controlled vocabulary of item types that the application enforces, ensuring data integrity and consistent rule processing across the configuration lifecycle.

Key Information Stored

While the provided metadata does not list specific columns, the structure and foreign key relationships indicate its critical data elements. The primary column is ITEM_TYPE_ID, a unique system-generated identifier serving as the primary key for the table. Based on standard Configurator schema patterns, the table typically includes a NAME or CODE column containing the internal name of the item type (e.g., 'MODEL', 'OPTION_CLASS', 'FEATURE', 'RESOURCE'). It often also contains descriptive columns such as DESCRIPTION for user-friendly labels. The table defines the foundational types upon which the entire configurator model structure is built, and these types are referenced extensively by other core Configurator entities.

Common Use Cases and Queries

This table is primarily referenced for validation, reporting, and integration purposes. A common use case is to retrieve the list of all valid item types available in the system for setup or diagnostic reports. Developers and administrators may query this table to understand the type of a specific configurable item by joining it to master data tables. For instance, to list all configurable models and their types, one would join CZ_ITEM_MASTERS to CZ_ITEM_TYPES. Sample queries often follow this pattern:

  • SELECT name, description FROM cz_item_types ORDER BY name;
  • SELECT im.item_id, im.name, it.name as item_type FROM cz_item_masters im, cz_item_types it WHERE im.item_type_id = it.item_type_id;

Direct data manipulation in this table via DML is rare and typically restricted to seed data installation or upgrades, as the item types are fundamental to the application's operation.

Related Objects

As indicated by the foreign key metadata, CZ_ITEM_TYPES is a central reference table with several critical dependencies. The ITEM_TYPE_ID column is referenced by:

  • CZ_ITEM_MASTERS: The master table for all configurable items, linking each item to its defined type.
  • CZ_PS_NODES: The table storing the structure of configuration models, using ITEM_TYPE_BACKPTR to reference the item type of each node in the product structure.
  • CZ_EXPRESSION_NODES: The table storing logic and constraint expressions, where nodes can be associated with specific item types.
  • CZ_ITEM_TYPE_PROPERTIES: A table that stores additional attributes or properties that can be defined for a specific item type, creating a direct extension relationship.

These relationships underscore that CZ_ITEM_TYPES is a foundational metadata table for the Oracle Configurator schema.