Results for “cz_drill_down_items”

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

Overview

CZ_DRILL_DOWN_ITEMS is a table in the CZ (Configurator) schema of Oracle E-Business Suite, present and marked VALID in both release 12.1.1 and 12.2.2. Its documented description identifies it as OBSOLETE and states that it historically described items in a quote. In the Configurator data model, drill-down items represented the selectable components surfaced beneath a configured parent item — the options a user expands and chooses while building a configuration against a quote line.

Because the object is flagged obsolete, it is retained principally for backward compatibility and for the preservation of historical quote data written by earlier Configurator releases. New development should treat it as read-only. The table conforms to standard EBS audit conventions, carrying WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) together with effective-dating and security columns.

Applying a heuristic Data Vault classification to the mined foreign-key structure, CZ_DRILL_DOWN_ITEMS is best modeled as a link table. It resolves a many-to-many association between quote main items and configurable items: each row ties a quote line (CZ_QUOTE_MAIN_ITEMS) to a configuration item (CZ_CONFIG_ITEMS) at a specific drill-down position. The suggestion is a modeling heuristic, not an Oracle-supplied designation.

Key Information Stored

The table exposes 25 documented columns. The most significant are:

• QUOTE_REV_NBR, QUOTE_HDR_ID, ITEM_SEQ_NUMBER — the composite business key identifying the owning quote revision and quote line. Together these form the foreign key to CZ_QUOTE_MAIN_ITEMS.
• DD_SEQ_NBR — the drill-down sequence number, ordering the item within its parent quote line.
• CONFIG_HDR_ID, CONFIG_REV_NBR, CONFIG_ITEM_ID — the composite foreign key to CZ_CONFIG_ITEMS, identifying the configured parent and the specific configuration item referenced.
• ITEM_QTY, CONFIG_ITEM_QTY — the quantity of the item and of the underlying configuration item.
• QUOTED_LIST_PRICE, DISC_PERCENTAGE, DISC_TYPE — pricing and discount attributes captured at quote time.
• FROZEN_FLAG — indicates whether the item was locked against further configuration changes.
• ITEM_COMMENT — free-text annotation on the quoted item.
• DELETED_FLAG — soft-delete indicator, allowing obsolete rows to be logically removed without physical purge.
• EFF_FROM, EFF_TO, EFF_MASK, SECURITY_MASK — effective-dating and row-level security columns typical of the CZ schema.

The surrogate-style primary key is CZ_DRILL_DOWN_ITEMS_PK, defined over (QUOTE_REV_NBR, QUOTE_HDR_ID, ITEM_SEQ_NUMBER, DD_SEQ_NBR). No separate single-column surrogate exists, so the unique index serves simultaneously as the business-key candidate and the FK propagation path. DD_SEQ_NBR is the discriminator that permits multiple drill-down items per quote line.

Common Use Cases and Queries

Reporting against this table typically reconstructs the composition of historical quotes. A representative join pattern is:

• Quote drill-down detail: join CZ_DRILL_DOWN_ITEMS to CZ_QUOTE_MAIN_ITEMS on QUOTE_HDR_ID, QUOTE_REV_NBR, and ITEM_SEQ_NUMBER to attach configuration detail to each quote line.
• Configuration cross-reference: join to CZ_CONFIG_ITEMS on CONFIG_HDR_ID, CONFIG_REV_NBR, and CONFIG_ITEM_ID to resolve the configured item selected.
• Pricing analysis: aggregate ITEM_QTY, QUOTED_LIST_PRICE, and DISC_PERCENTAGE by QUOTE_HDR_ID to reconcile quoted totals.
• Active-row filtering: filter with DELETED_FLAG = 'N' and, where effective dating applies, constrain EFF_FROM/EFF_TO to the reporting date.

Because the object is obsolete, queries are most reliable when scoped to historical data sets; current configuration logic should be sourced from the active Configurator tables.

Related Objects

• CZ_QUOTE_MAIN_ITEMS — parent of the quote-side FK via QUOTE_HDR_ID, QUOTE_REV_NBR, ITEM_SEQ_NUMBER.
• CZ_CONFIG_ITEMS — parent of the configuration-side FK via CONFIG_HDR_ID, CONFIG_REV_NBR, CONFIG_ITEM_ID.
• CZ_DRILL_DOWN_ITEMS_PK — the unique index enforcing the composite key.
• Other CZ schema tables in the quote/configuration family, which reference the same composite keys and are commonly queried alongside this object for end-to-end Configurator reporting.