Results for “cz_item_types”

50+ results




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

Overview

CZ_ITEM_TYPES is a core configuration table within the Oracle Configurator (CZ) module, owned by the CZ schema. It defines the item type classifications that Oracle Configurator uses to organize configurable items, drive model structure, and govern how configuration rules and properties are applied across the configuration hierarchy. Because item types act as a stable, reusable classification dimension referenced by a wide range of dependent structures — model masters, property definitions, expression nodes, and node compatibility generators — the table functions as a foundational reference object rather than a transactional one.

Under the heuristic Data Vault classification supplied in the metadata, CZ_ITEM_TYPES is characterized as hub-leaning. As a modeling suggestion, this indicates that ITEM_TYPE_ID behaves as a durable business key around which dependent attributes and relationships are organized, while the remaining descriptive and audit columns act in a satellite capacity. The presence of EFF_FROM and EFF_TO columns further suggests that type definitions may be effective-dated, permitting historical tracking of item type status over time.

Key Information Stored

The table contains 24 documented columns. The most significant are:

  • ITEM_TYPE_ID — The surrogate primary key, enforced by the unique index CZ_ITEM_TYPES_PK. It is the join key to every dependent table.
  • NAME — The business-key candidate, protected by the unique index CZ_ITEM_TYPES_U1. This is the human-readable identifier for the item type.
  • DESC_TEXT — Descriptive text explaining the purpose of the item type.
  • ORIG_SYS_REF — External system reference, supporting integration and import scenarios.
  • DELETED_FLAG — Soft-delete indicator that preserves historical data while excluding inactive types from active use.
  • EFF_FROM / EFF_TO — Effective date range controlling when a type definition is valid.
  • SECURITY_MASK — Security partitioning attribute; EFF_MASK — effective-dating mask used by the Configurator framework.
  • CHECKOUT_USER and LAST_UPDATE_LOGIN — Concurrency and audit tracking for checkout and session activity.
  • SRC_APPLICATION_ID — Identifies the source application that created or last updated the row.
  • CREATION_DATE, LAST_UPDATE_DATE, CREATED_BY, LAST_UPDATED_BY — Standard Oracle audit columns.
  • USER_NUM01–USER_NUM04 and USER_STR01–USER_STR04 — DFF-style user extensibility attributes for customer-specific data.

Common Use Cases and Queries

Typical scenarios include reporting on all active item types, joining to masters and properties to audit configuration models, and validating import data before loading.

Example: retrieve active item types with descriptions.

  • SELECT ITEM_TYPE_ID, NAME, DESC_TEXT FROM CZ_ITEM_TYPES WHERE DELETED_FLAG = 'N';

Example: join masters to their governing item type.

Example: locate expression nodes bound to a specific type.

Example: profile item type properties for a given type.

Because planning and pricing tables such as MSC_DEMANDS, MSC_SUPPLIES, MSC_SAFETY_STOCKS, and MSD_ITEM_LIST_PRICE also carry ITEM_TYPE_ID, cross-module reporting that links supply chain planning records back to configurator classifications is a common downstream use case.

Related Objects

The table is referenced by numerous dependent objects, the most significant being:

These relationships confirm CZ_ITEM_TYPES as a central hub whose surrogate key propagates across configurator, planning, and pricing data models.