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.
SELECT m.ITEM_MASTER_ID, m.ITEM_TYPE_ID, t.NAME FROM CZ_ITEM_MASTERS m JOIN CZ_ITEM_TYPES t ON m.ITEM_TYPE_ID = t.ITEM_TYPE_ID;
Example: locate expression nodes bound to a specific type.
SELECT * FROM CZ_EXPRESSION_NODES WHERE ITEM_TYPE_ID = :type_id;
Example: profile item type properties for a given type.
SELECT * FROM CZ_ITEM_TYPE_PROPERTIES WHERE ITEM_TYPE_ID = :type_id;
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:
- CZ_ITEM_MASTERS — via ITEM_TYPE_ID; the model master records.
- CZ_ITEM_TYPE_PROPERTIES — via ITEM_TYPE_ID; per-type property definitions.
- CZ_EXPRESSION_NODES — via ITEM_TYPE_ID; rule expression structures.
- CZ_PS_NODES — via ITEM_TYPE_BACKPTR; compatibility and node references.
- CZ_PSNODE_PROPCOMPAT_GENS — via ITEM_TYPE_ID; generated property compatibility data.
- CZ_IMP_ITEM_TYPE and CZ_IMP_ITEM_MASTER — via ITEM_TYPE_ID; interface/import staging tables.
- MSC_DEMANDS, MSC_SUPPLIES, MSC_SAFETY_STOCKS — via ITEM_TYPE_ID; planning records.
- MSD_ITEM_LIST_PRICE and MSD_ST_ITEM_LIST_PRICE — via ITEM_TYPE_ID; pricing data.
- MSC_SR_ASSIGNMENTS and MSC_ST_DEMANDS / MSC_ST_SUPPLIES — via ITEM_TYPE_ID; planning and sourcing references.
These relationships confirm CZ_ITEM_TYPES as a central hub whose surrogate key propagates across configurator, planning, and pricing data models.
-
Item types
-
Item types
-
TABLE: CZ.CZ_ITEM_TYPES 12.1.1
-
SYNONYM: APPS.CZ_ITEM_TYPES 12.2.2
-
TABLE: CZ.CZ_ITEM_TYPES 12.2.2
-
SYNONYM: APPS.CZ_ITEM_TYPES 12.1.1
-
VIEW: CZ.CZ_ITEM_TYPES# 12.2.2
-
View: CZ_ITEM_ITEM_POP_V 12.1.1
Populator view - from Items
APPS.CZ_ITEM_ITEM_POP_V·↳ CZ_ITEM_MASTERS·↳ CZ_ITEM_TYPES·Explore CZ module →
-
View: CZ_ITEM_PROPERTY_POP_V 12.1.1
Populator view - from Properties
APPS.CZ_ITEM_PROPERTY_POP_V·↳ CZ_ITEM_TYPES·↳ CZ_ITEM_TYPE_PROPERTIES·↳ CZ_PROPERTIES·Explore CZ module →
-
View: CZ_ITEM_ITEM_POP_V 12.2.2
Populator view - from Items
APPS.CZ_ITEM_ITEM_POP_V·↳ CZ_ITEM_MASTERS·↳ CZ_ITEM_TYPES·Explore CZ module →
-
View: CZ_ITEM_ITEMPROPVALS_V 12.1.1
Property values attached to items
APPS.CZ_ITEM_ITEMPROPVALS_V·↳ CZ_ITEM_MASTERS·↳ CZ_ITEM_PROPERTY_VALUES·↳ CZ_ITEM_TYPES·Explore CZ module →
-
View: CZ_IM_ITEM_TYPES_V 12.2.2
APPS.CZ_IM_ITEM_TYPES_V·↳ CZ_ITEM_TYPES·↳ CZ_RPOBJECTTYPES_LKV·↳ CZ_UI_PATHED_IMAGES_V·Explore CZ module →
-
View: CZ_ITEMMASTER_HGRID_V 12.2.2
APPS.CZ_ITEMMASTER_HGRID_V·↳ CZ_ITEM_MASTERS·↳ CZ_ITEM_TYPES·↳ CZ_RPOBJECTTYPES_LKV·Explore CZ module →
-
View: CZ_ITEM_PROPERTY_POP_V 12.2.2
Populator view - from Properties
APPS.CZ_ITEM_PROPERTY_POP_V·↳ CZ_ITEM_TYPES·↳ CZ_ITEM_TYPE_PROPERTIES·↳ CZ_PROPERTIES·Explore CZ module →
-
View: CZ_ITEM_ITEMPROPVALS_V 12.2.2
Property values attached to items
APPS.CZ_ITEM_ITEMPROPVALS_V·↳ CZ_ITEM_MASTERS·↳ CZ_ITEM_PROPERTY_VALUES·↳ CZ_ITEM_TYPES·Explore CZ module →
-
View: CZ_ITEMMASTER_HGRID_V 12.1.1
APPS.CZ_ITEMMASTER_HGRID_V·↳ CZ_ITEM_MASTERS·↳ CZ_ITEM_TYPES·↳ CZ_RPOBJECTTYPES_LKV·Explore CZ module →
-
View: CZ_ITEM_ITEMTYPE_POP_V 12.1.1
Populator view - from Item Types
APPS.CZ_ITEM_ITEMTYPE_POP_V·↳ CZ_ITEM_TYPES·Explore CZ module →
-
View: CZ_ITEM_ITEMTYPE_POP_V 12.2.2
Populator view - from Item Types
APPS.CZ_ITEM_ITEMTYPE_POP_V·↳ CZ_ITEM_TYPES·Explore CZ module →
-
View: CZ_IM_ITEM_TYPES_V 12.1.1
APPS.CZ_IM_ITEM_TYPES_V·↳ CZ_ITEM_TYPES·↳ CZ_RPOBJECTTYPES_LKV·↳ CZ_UI_PATHED_IMAGES_V·Explore CZ module →
-
VIEW: CZ.CZ_ITEM_TYPES# 12.2.2
-
Data to be imported (or rejected) into CZ_ITEM_TYPES