Results for “item_comment”

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

Overview

The CZ_QUOTE_SPECIAL_ITEMS table resides in the CZ schema, which belongs to the Oracle Configurator module within Oracle E-Business Suite 12.1.1 and 12.2.2. Its documented purpose is to associate special order items with a quote, acting as the persistence layer for non-standard or one-off items a customer requests outside of the standard configurable bill of materials. Within a Configure-to-Order flow, these rows represent specials that have been captured against a specific quote header, revision, and package, allowing sales and order management personnel to price, discount, and lead-time these ad hoc items alongside configured components.

From a dimensional modeling perspective, the heuristic Data Vault classification for this table is satellite-leaning. This reflects the fact that the object carries descriptive attributes and effectivity data tied to a parent business key rather than serving as a standalone hub of unique entities or a pure many-to-many link. It is best understood as a dependent child storing the mutable descriptive detail of specials requested on a quote.

Key Information Stored

The table contains 25 documented columns. The most operationally significant are summarized below.

• Primary key columns: PACKAGE_SEQ, QUOTE_HDR_ID, QUOTE_REV_NBR, SEQ_NUMBER, and TYPE_FLAG together form the composite unique index CZ_QUOTE_SPEC_ITEMS_PK. These columns uniquely identify each special item record and represent the business key candidates for this entity.
• TYPE_FLAG: Distinguishes the kind of special item, and is part of both the primary key and the foreign key relationship to CZ_SPARES_SPECIALS. This is the column most directly implicated by the user's search term.
• SPEC_ITEM_NAME and SPEC_ITEM_TEXT: Store the descriptive identity and free-form narrative of the special item.
• ITEM_QTY and LEAD_TIME: Capture the requested quantity and the anticipated lead time for fulfillment.
• SPEC_ITEM_PRICE, QUOTED_LIST_PRICE, DISC_PERCENTAGE, and DISC_TYPE: Hold the pricing and discounting attributes applied to the special item.
• ITEM_COMMENT: Provides an annotation field for the line.
• DELETED_FLAG, EFF_FROM, EFF_TO, EFF_MASK, and SECURITY_MASK: Support logical deletion, effectivity dating, and row-level security masking.
• Audit columns: CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, and CHECKOUT_USER record the standard EBS auditing and checkout metadata.

Common Use Cases and Queries

A frequent requirement is to retrieve all special items attached to a given quote and revision, filtered by type. A representative query follows:

• SELECT SEQ_NUMBER, TYPE_FLAG, SPEC_ITEM_NAME, ITEM_QTY, SPEC_ITEM_PRICE, LEAD_TIME FROM CZ.CZ_QUOTE_SPECIAL_ITEMS WHERE QUOTE_HDR_ID = :p_quote_id AND QUOTE_REV_NBR = :p_rev AND DELETED_FLAG = 'N' ORDER BY SEQ_NUMBER;
• Reporting pricing roll-ups by discount type: SELECT DISC_TYPE, SUM(SPEC_ITEM_PRICE) FROM CZ.CZ_QUOTE_SPECIAL_ITEMS WHERE QUOTE_HDR_ID = :p_quote_id GROUP BY DISC_TYPE;
• Effectivity-aware lookups: filtering on EFF_FROM and EFF_TO to return only currently active specials.

Analysts commonly join these rows to CZ_SPARES_SPECIALS on PACKAGE_SEQ, QUOTE_HDR_ID, QUOTE_REV_NBR, and TYPE_FLAG to enrich specials with their parent spares definitions for quotation and order-entry reporting.

Related Objects

• CZ_SPARES_SPECIALS: The direct foreign key target, joined on PACKAGE_SEQ, QUOTE_HDR_ID, QUOTE_REV_NBR, and TYPE_FLAG. This is the most significant related object because it supplies the spares definition context for each special item.
• CZ_QUOTE_HEADERS: Referenced through QUOTE_HDR_ID, supplying the parent quote context.
• The composite primary key CZ_QUOTE_SPEC_ITEMS_PK is the authoritative link used by dependent tables and Configurator UI regions that fetch specials for a quote revision.

Because the metadata enumerates only a single FK path, additional related objects beyond CZ_SPARES_SPECIALS are inferred from the quote and spares relationships rather than explicitly documented.