Results for “item_qty”

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

Overview

CZ_QUOTE_SPARES is a table owned by the CZ schema within the Oracle E-Business Suite Configurator module (CZ). According to the documented ETRM metadata for releases 12.1.1 and 12.2.2, the table associates spare parts with quotes, serving as a supporting structure for the SellingPoint quoting functionality. The object carries an explicit OBSOLETE designation in the ETRM documentation, which is a critical caveat: although the object remains VALID in the data dictionary, Oracle has flagged it as superseded. Implementations performing upgrades or customizations against SellingPoint quoting should confirm whether this structure is still actively populated before developing dependencies on it.

From a modeling perspective, the heuristic Data Vault classification mined from the foreign key structure is link. This is consistent with the table's evident purpose: it records associations (between a quote, a spare item, and a spares/specials package) rather than describing a single business entity. In Data Vault terms, CZ_QUOTE_SPARES behaves as a relationship table connecting a quote header hub to item and package reference structures, with a degenerate business key composed of its unique index columns.

Key Information Stored

The table contains 22 documented columns. The most significant are listed below.

• QUOTE_HDR_ID, QUOTE_REV_NBR — Identify the parent quote header and revision to which the spare line belongs. These form the leading components of the primary key and the business key.
• SEQ_NUMBER — Sequences the spares lines within a given quote header/revision combination.
• TYPE_FLAG — Distinguishes the type of spare record; part of the composite primary key.
• PACKAGE_SEQ — References the spares/specials package; also part of the primary key and a foreign key to CZ_SPARES_SPECIALS.
• ITEM_ID — The spare item identifier, foreign keyed to CZ_ITEM_MASTERS.
• ITEM_QTY, QUOTED_LIST_PRICE — Quantity and the list price quoted for the spare line.
• DISC_TYPE, DISC_PERCENTAGE — Discount type and percentage applied to the line.
• ITEM_COMMENT — Free-text comment attached to the spare line.
• EFF_FROM, EFF_TO, EFF_MASK — Effective-dating columns controlling the visibility window of the record.
• DELETED_FLAG — Soft-delete indicator used instead of physical row removal.
• SECURITY_MASK, CHECKOUT_USER — Security and checkout control columns typical of Configurator objects.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard Oracle audit columns.

The surrogate-style primary key is defined by the unique index CZ_QUOTE_SPARES_PK over (QUOTE_HDR_ID, QUOTE_REV_NBR, SEQ_NUMBER, TYPE_FLAG, PACKAGE_SEQ). This same column set is the documented business-key candidate; there is no separate single-column surrogate identifier in the metadata.

Common Use Cases and Queries

Typical usage centers on reconstructing quoted spare-part content for a SellingPoint quote, and on reporting spares attach rates and discounting behavior. A representative query joins the table to its reference structures:

• SELECT qs.QUOTE_HDR_ID, qs.QUOTE_REV_NBR, qs.SEQ_NUMBER, im.ITEM_NAME, qs.ITEM_QTY, qs.QUOTED_LIST_PRICE, qs.DISC_PERCENTAGE FROM CZ_QUOTE_SPARES qs, CZ_ITEM_MASTERS im WHERE qs.ITEM_ID = im.ITEM_ID AND qs.DELETED_FLAG = 'N' AND qs.QUOTE_HDR_ID = :quote_id;
• Join to CZ_SPARES_SPECIALS on PACKAGE_SEQ to resolve package-level grouping of spares.
• Filter on EFF_FROM/EFF_TO when the effective window is relevant to the reporting period.

Given the OBSOLETE status, any report or interface should first validate row counts and freshness against live quote data.

Related Objects

• CZ_ITEM_MASTERS — joined via CZ_QUOTE_SPARES.ITEM_ID; resolves item descriptions and attributes.
• CZ_SPARES_SPECIALS — joined via CZ_QUOTE_SPARES.PACKAGE_SEQ; defines the spares/specials package.
• Quote header structures in the CZ schema — referenced through QUOTE_HDR_ID and QUOTE_REV_NBR.
• Configurator SellingPoint APIs — the runtime interfaces that historically populated this table.