Results for “cz_item_type_properties”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

CZ_ITEM_TYPE_PROPERTIES is a Configurator (CZ) module table in the Oracle E-Business Suite 12.1.1 and 12.2.2 environments that records the association between item types and the properties (characteristics) that can be assigned to them. In the Oracle Configurator data model, it functions as the binding structure that determines which configurable properties are valid for a given item type, effectively driving the rules used by the Configurator runtime and the model-building user interface. The table resides in the CZ schema and is documented as valid in the ETRM repository.

From a data-modeling perspective, the metadata provided by ETRM includes a heuristic Data Vault classification of link. This is a modeling suggestion: because the table's primary key is composed entirely of foreign-key references and the table carries no independent descriptive identity of its own, it naturally behaves as an intersection (link) entity that resolves a many-to-many relationship between item types and properties.

Key Information Stored

The table is documented with 15 physical columns. The most significant are the composite key members and the referential columns that define the relationship, together with the standard EBS who-columns and effectivity attributes.

• ITEM_TYPE_ID — Foreign key into CZ_ITEM_TYPES, identifying the item type being configured. This is the first column of the composite primary key.
• PROPERTY_ID — Foreign key into CZ_PROPERTIES, identifying the property/characteristic associated with the item type. This is the second column of the composite primary key.
• DELETED_FLAG — Indicates soft-deleted rows; participates in the unique index CZ_ITEM_TYPE_PROPERTIES_U1.
• EFF_FROM and EFF_TO — Effective date range controlling when the item-type/property binding is valid.
• CREATION_DATE, LAST_UPDATE_DATE, CREATED_BY, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard EBS audit columns.
• SECURITY_MASK, EFF_MASK, CHECKOUT_USER — Configurator control attributes governing security visibility, effectivity handling, and concurrent-model checkout.
• ORIG_SYS_REF, SRC_APPLICATION_ID — Source-system reference and originating application identifiers, used when configuration data is imported or synchronized.

Two unique indexes are documented. CZ_ITEM_TYPE_PROPS_PK is the primary key on (ITEM_TYPE_ID, PROPERTY_ID). CZ_ITEM_TYPE_PROPERTIES_U1 on (DELETED_FLAG, PROPERTY_ID, ITEM_TYPE_ID) is the business-key candidate.

Common Use Cases and Queries

Typical use cases center on model definition validation and reporting on which properties are available to which item types. A simple join retrieves the property names associated with an item type:

• SELECT ctp.item_type_id, cp.property_id, cp.property_name FROM cz.cz_item_type_properties ctp, cz.cz_properties cp WHERE ctp.property_id = cp.property_id AND ctp.deleted_flag = 'N';
• Identify all item types sharing a given property to detect duplication or reuse across models.
• Audit effective-dated bindings using EFF_FROM/EFF_TO to determine which associations are current.
• Locate rows soft-deleted (DELETED_FLAG = 'Y') during data-cleanup or migration reviews.

Related Objects

The following objects are most significant and are confirmed by the documented FK relationships.

• CZ_ITEM_TYPES — Parent of ITEM_TYPE_ID; defines the configurable item types.
• CZ_PROPERTIES — Parent of PROPERTY_ID; defines the properties/characteristics available for association.
• CZ_ITEM_TYPE_PROPS_PK — Primary-key constraint/index on (ITEM_TYPE_ID, PROPERTY_ID).
• CZ_ITEM_TYPE_PROPERTIES_U1 — Unique business-key index on (DELETED_FLAG, PROPERTY_ID, ITEM_TYPE_ID).
• Configurator model and user-interface objects in the CZ schema that consume item-type/property bindings at model build and runtime.