Search Results cz_item_masters

Overview

The CZ_ITEM_MASTERS table is a core data object within the Oracle E-Business Suite Configurator (CZ) module. It serves as the master repository for all configurable items that define a product's structure. In the context of Oracle EBS 12.1.1 and 12.2.2, this table is fundamental to the product modeling process, where complex, customizable products are broken down into their constituent parts, options, and features. Each record represents a unique, identifiable component that can be used within a configuration model, forming the building blocks from which end-user configurations are dynamically assembled during sales, manufacturing, or service transactions.

Key Information Stored

While the provided metadata does not list specific columns, the primary and foreign key relationships define its critical structure. The table's primary key is the ITEM_ID column, which uniquely identifies every configurable component in the system. A key foreign key is ITEM_TYPE_ID, which links to the CZ_ITEM_TYPES table to classify the nature of each item (e.g., model, option class, standard item, etc.). Other essential columns, inferred from standard practice, would include fields for the item's name, description, effective dates, and status flags to control its lifecycle and usability within configuration models. The data stored here is distinct from inventory items in the INV module, as it specifically supports the logical and rule-based relationships of the Configurator.

Common Use Cases and Queries

This table is central to queries that analyze product structure, validate configurations, and support reporting. A common use case is retrieving the hierarchical breakdown of a product model. This requires joining CZ_ITEM_MASTERS to the CZ_ITEM_PARENTS table to traverse parent-child relationships. Another critical scenario involves troubleshooting configuration rules or pricing, where specific items and their associated properties or expressions must be identified. A typical query pattern would be:

• SELECT item_id, item_name, item_type_id FROM cz.cz_item_masters WHERE effective_date <= SYSDATE AND disable_date IS NULL;

This retrieves all currently active configurable items. For reporting, this table is often joined to CZ_PS_NODES (for published runtime structures) and CZ_ITEM_PROPERTY_VALUES to extract detailed component characteristics.

Related Objects

The CZ_ITEM_MASTERS table has extensive relationships within the Configurator schema, as documented by its foreign keys. Key related objects include:

• CZ_ITEM_TYPES: Joined via CZ_ITEM_MASTERS.ITEM_TYPE_ID to classify the item's role.
• CZ_ITEM_PARENTS: Joined via CZ_ITEM_PARENTS.ITEM_ID and CZ_ITEM_PARENTS.PARENT_ITEM_ID to define the hierarchical product structure.
• CZ_EXPRESSION_NODES, CZ_ITEM_PROPERTY_VALUES, CZ_PRICES, CZ_PS_NODES, CZ_QUOTE_SPARES: All joined via their respective ITEM_ID foreign key columns to store rules, attributes, costs, runtime data, and service parts associated with the master item.

These relationships underscore the table's role as the central hub for configurable item data, referenced throughout the configuration lifecycle from definition to runtime quotation.