Search Results cz_item_parents




Overview
Explore in AI Chat

Overview

The CZ_ITEM_PARENTS table is a data object within the Oracle E-Business Suite Configurator (CZ) module. According to the official ETRM documentation, its primary description is "NOT USED." This indicates that while the table structure exists in the CZ schema, it is not actively populated or leveraged by the standard Configurator application logic in releases 12.1.1 and 12.2.2. Its intended historical or conceptual role was likely to define hierarchical relationships between configurable items (parents and children) within a product model, governed by specific relationship types. However, this functionality is implemented through other core Configurator tables in the production system.

Key Information Stored

The table's structure is designed to capture relational data between items. Its primary key is a composite of three columns: PARENT_ITEM_ID, ITEM_ID, and REL_TYPE_ID. The PARENT_ITEM_ID column stores the identifier for the superior item in a relationship. The ITEM_ID column stores the identifier for the subordinate or child item. The REL_TYPE_ID column stores a foreign key reference to the CZ_REL_TYPES table, which would define the nature of the relationship (e.g., component, substitute, optional feature) between the two specified items. This design suggests a model where an item can be related to another through multiple, explicitly typed relationships.

Common Use Cases and Queries

Given its documented "NOT USED" status, there are no standard application use cases or business processes that interact with this table in a live EBS environment. It should not be used for custom reporting or integration. If encountered during data analysis or debugging, its presence should be noted as inert. A theoretical query to select all defined relationships, though not operational, would follow this pattern:

  • SELECT parent_item_id, item_id, rel_type_id FROM cz.cz_item_parents;

Any attempt to join this table to active configuration data in CZ_ITEM_MASTERS or CZ_MODELS would yield no meaningful application data.

Related Objects

The ETRM metadata explicitly defines the following foreign key relationships for the CZ_ITEM_PARENTS table, which are structural despite the table's unused status:

  • CZ_REL_TYPES: Related via the column CZ_ITEM_PARENTS.REL_TYPE_ID. This links a relationship instance to its definition.
  • CZ_ITEM_MASTERS (for ITEM_ID): Related via the column CZ_ITEM_PARENTS.ITEM_ID. This validates the child item identifier against the master list of configurable items.
  • CZ_ITEM_MASTERS (for PARENT_ITEM_ID): Related via the column CZ_ITEM_PARENTS.PARENT_ITEM_ID. This validates the parent item identifier against the master list of configurable items.

The primary key constraint CZ_ITEM_PARENTS_PK enforces uniqueness on the combination of these three foreign key columns.