Search Results cz_item_type_properties




Overview
Explore in AI Chat

Overview

The CZ_ITEM_TYPE_PROPERTIES table is a core repository table within the Oracle E-Business Suite Configurator (CZ) module. It functions as a junction table that establishes and manages the permissible relationships between item types and their associated properties. This table is fundamental to the configuration model, as it defines which properties can be assigned to which types of configurable items. By enforcing these relationships at the data level, it ensures data integrity and governs the structure of the configuration knowledge base, enabling the accurate definition and validation of complex, rule-based products.

Key Information Stored

The table's structure is straightforward, consisting primarily of two key foreign key columns that form its composite primary key. The ITEM_TYPE_ID column stores a reference to a specific item type defined in the CZ_ITEM_TYPES table. The PROPERTY_ID column stores a reference to a specific property defined in the CZ_PROPERTIES table. The combination of these two IDs creates a unique record that authorizes the assignment of a particular property to a particular item type. This design allows for a many-to-many relationship, where one item type can have multiple properties, and a single property can be applicable to multiple item types.

Common Use Cases and Queries

A primary use case is the validation and administration of the configuration model. Before a property can be assigned to an item instance, the system checks this table to confirm the relationship is allowed. Common queries involve listing all properties available for a given item type or identifying which item types can utilize a specific property. For reporting and troubleshooting, administrators often join this table to its parent tables to generate human-readable lists.

  • Sample Query: Retrieve all properties for a specific item type name: 
    SELECT p.PROPERTY_NAME
FROM CZ_ITEM_TYPE_PROPERTIES itp,
     CZ_ITEM_TYPES it,
     CZ_PROPERTIES p
WHERE it.ITEM_TYPE_NAME = '&ITEM_TYPE_NAME'
  AND it.ITEM_TYPE_ID = itp.ITEM_TYPE_ID
  AND itp.PROPERTY_ID = p.PROPERTY_ID;

Related Objects

The CZ_ITEM_TYPE_PROPERTIES table has direct, documented foreign key relationships with two primary master tables in the Configurator schema, as per the provided metadata.

  • CZ_ITEM_TYPES: The table is linked via the ITEM_TYPE_ID column. This relationship ensures that every entry in CZ_ITEM_TYPE_PROPERTIES references a valid, existing item type.
  • CZ_PROPERTIES: The table is linked via the PROPERTY_ID column. This relationship ensures that every property assigned to an item type is a valid, defined property within the system.

These relationships are critical for maintaining referential integrity. The table itself is a parent to no other documented foreign keys but is a central reference point for the runtime engine and model administration interfaces within the Configurator module.