Results for “disc_percentage”

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

Overview

The CZ_QUOTE_MAIN_ITEMS table resides in the CZ (Configurator) schema within Oracle E-Business Suite and is documented as OBSOLETE, having historically stored the list of main items associated with a configured quote. In earlier releases of Oracle Configurator, this table captured the top-level item lines generated from a configuration model and tied them to a specific quote header and revision, forming part of the quote-to-order data model used by the Configurator runtime and its integration with Oracle Quoting and Order Management.

The primary key CZ_QUOTE_MAIN_ITEMS_PK is composed of QUOTE_HDR_ID, QUOTE_REV_NBR, and ITEM_SEQ_NUMBER, providing a composite key that uniquely identifies each main item line within a quote revision. Two foreign key relationships anchor the table: QUOTE_HDR_ID and QUOTE_REV_NBR resolve to CZ_QUOTE_HDRS, while CONFIG_HDR_ID and CONFIG_REV_NBR resolve to CZ_CONFIG_HDRS. Based on the mined foreign key structure, the heuristic Data Vault classification is satellite-leaning, suggesting this object behaves primarily as a descriptive, key-dependent table attached to a quote hub rather than as an independent hub or a pure link. This classification should be treated as a modeling suggestion only.

Key Information Stored

Among the 21 documented columns, the most significant are the composite key elements QUOTE_HDR_ID, QUOTE_REV_NBR, and ITEM_SEQ_NUMBER, which together constitute the unique index and primary key. Rather than a single surrogate key column, this table uses a natural composite business key.

• CONFIG_HDR_ID and CONFIG_REV_NBR — link each main item to the originating configuration header and revision in CZ_CONFIG_HDRS.
• CONFIG_VIOLATION_FLAG — indicates whether a configuration rule violation was detected for the item.
• ITEM_QTY — quantity of the main item on the quote.
• DISC_PERCENTAGE and DISC_TYPE — discount percentage applied and the discount category used.
• EFF_FROM, EFF_TO, and EFF_MASK — effective dating columns supporting date-tracked records.
• DELETED_FLAG — soft-delete indicator for logically removed rows.
• SECURITY_MASK and CHECKOUT_USER — access control and concurrent checkout metadata.
• NOTE — free-text annotation.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard EBS who-column audit attributes.

Common Use Cases and Queries

Because the table is obsolete, its principal modern use is historical reporting and data migration auditing. Analysts reconstruct the item composition of legacy configured quotes by joining this table to its parent quote and configuration headers. A representative query joining to the quote header is:

• SELECT m.QUOTE_HDR_ID, m.QUOTE_REV_NBR, m.ITEM_SEQ_NUMBER, m.ITEM_QTY, m.CONFIG_VIOLATION_FLAG FROM CZ.CZ_QUOTE_MAIN_ITEMS m WHERE m.QUOTE_HDR_ID = :p_quote_id AND m.QUOTE_REV_NBR = :p_rev AND NVL(m.DELETED_FLAG,'N') = 'N';
• Joining to CZ_QUOTE_HDRS on QUOTE_HDR_ID and QUOTE_REV_NBR for quote-level context.
• Joining to CZ_CONFIG_HDRS on CONFIG_HDR_ID and CONFIG_REV_NBR for configuration detail.
• Aggregating ITEM_QTY or applying DISC_PERCENTAGE for historical pricing reconciliation.

Filtering on DELETED_FLAG and effective dating columns (EFF_FROM, EFF_TO) is advisable to avoid retrieving stale rows.

Related Objects

• CZ_QUOTE_HDRS — parent quote header; joined via QUOTE_HDR_ID and QUOTE_REV_NBR.
• CZ_CONFIG_HDRS — configuration header; joined via CONFIG_HDR_ID and CONFIG_REV_NBR.
• CZ_DRILL_DOWN_ITEMS — references this table via QUOTE_HDR_ID, QUOTE_REV_NBR, and ITEM_SEQ_NUMBER.
• CZ_SPARES_SPECIALS — references this table via the same composite columns.

These dependent tables carry the same composite identifier, confirming the central role of CZ_QUOTE_MAIN_ITEMS as the anchor for related item records within the Configurator quote model.