Results for “ref_part_nbr”

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

Overview

CZ_ITEM_MASTERS is a Configurator (CZ) module table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores the items used to structure a configurable product. Within the Oracle Configurator model, this table represents the master list of item records that participate in product configuration — the building blocks that define what can be selected, quoted, or assembled when a user configures a model. Each row corresponds to a single configurator item, identified by its surrogate primary key and classified by an item type.

The table resides in the CZ schema and is documented in ETRM 12.2.2 with 32 physical columns. Its primary key is CZ_ITEM_MASTERS_PK, defined on ITEM_ID. In Data Vault terms, the mined FK structure classifies this object heuristically as a hub: ITEM_ID is a stable surrogate key referenced by many dependent tables, while descriptive and status attributes behave like satellite data. This classification is a modeling suggestion derived from the FK topology, not a physical design constraint.

Key Information Stored

The most significant columns fall into identification, classification, and descriptive groups:

• ITEM_ID — surrogate primary key (CZ_ITEM_MASTERS_PK); the join key used throughout the Configurator schema.
• ITEM_TYPE_ID — foreign key to CZ_ITEM_TYPES; classifies the item within the configuration model. Along with ITEM_ID and DELETED_FLAG, it forms the unique index CZ_ITEM_MASTERS_U1, making it the principal business-key candidate.
• DESC_TEXT — descriptive text for the item.
• REF_PART_NBR — the reference part number associated with the item.
• QUOTEABLE_FLAG — indicates whether the item may appear in a quote.
• ITEM_STATUS — lifecycle or availability status of the item.
• PRIMARY_UOM_CODE — the primary unit of measure.
• LEAD_TIME — procurement or build lead time.
• DECIMAL_QTY_FLAG — whether fractional quantities are permitted.
• EFF_FROM / EFF_TO — effective dating range for the record.
• DELETED_FLAG — logical delete indicator used in the unique index.
• ORIG_SYS_REF, SRC_APPLICATION_ID, SRC_TYPE_CODE — source-system lineage for imported or interfaced items.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY — standard audit columns.
• USER_NUM01–04 and USER_STR01–04 — extensibility columns for customer-specific attributes.

Common Use Cases and Queries

Typical reporting retrieves configurator items by type, status, or part number, often joining to CZ_ITEM_TYPES for classification:

• List quoteable items with their type: SELECT m.ITEM_ID, m.REF_PART_NBR, t.ITEM_TYPE_NAME FROM CZ_ITEM_MASTERS m, CZ_ITEM_TYPES t WHERE m.ITEM_TYPE_ID = t.ITEM_TYPE_ID AND m.QUOTEABLE_FLAG = 'Y' AND m.DELETED_FLAG = 'N';
• Find items by part number: filter on REF_PART_NBR.
• Audit effective-dated records using EFF_FROM and EFF_TO.
• Review status and lead-time exposure by joining pricing and property-value tables.

Related Objects

CZ_ITEM_MASTERS is a central hub referenced by multiple Configurator tables:

• CZ_ITEM_TYPES — parent of ITEM_TYPE_ID.
• CZ_ITEM_PARENTS — joins on ITEM_ID and PARENT_ITEM_ID to define the item hierarchy.
• CZ_ITEM_PROPERTY_VALUES — joins on ITEM_ID for property values.
• CZ_EXPRESSION_NODES — joins on ITEM_ID for rules and expressions.
• CZ_PRICES — joins on ITEM_ID for pricing.
• CZ_PS_NODES — joins on ITEM_ID for configuration structure nodes.
• CZ_QUOTE_SPARES — joins on ITEM_ID for spare items.