Search Results cz_drill_down_items




Overview
Explore in AI Chat

Overview

The CZ_DRILL_DOWN_ITEMS table is a historical data object within the Oracle E-Business Suite (EBS) Configurator (CZ) module. As explicitly noted in its official ETRM documentation, this table is marked as OBSOLETE. Its original purpose was to store detailed information describing items within a sales quote generated by the Configurator. In the context of Oracle EBS 12.1.1 and 12.2.2, this table represents legacy functionality that is no longer actively developed or enhanced. Its presence in the database schema is primarily for backward compatibility, and it is not intended for use in new customizations, integrations, or reports. Administrators and developers should treat any references to this table with caution, as its data model and relationships may not align with current Configurator architecture.

Key Information Stored

The table's structure, as defined by its primary and foreign keys, reveals its historical role in linking quote items to their underlying configuration data. The primary key is a composite of QUOTE_REV_NBR, QUOTE_HDR_ID, ITEM_SEQ_NUMBER, and DD_SEQ_NBR, indicating it stored multiple drill-down records (DD_SEQ_NBR) for each line item in a specific quote revision. Key columns include QUOTE_HDR_ID and QUOTE_REV_NBR, which uniquely identify the parent quote header. The ITEM_SEQ_NUMBER links to the specific line item within that quote. The foreign key relationships show critical links to CONFIG_HDR_ID, CONFIG_REV_NBR, and CONFIG_ITEM_ID, connecting the quoted item back to its source configuration instance stored in the CZ_CONFIG_ITEMS table. This design allowed for a detailed breakdown of how a configured product's components and options were represented in a final sales quotation.

Common Use Cases and Queries

Given its obsolete status, there are no recommended new use cases for this table. Historically, it may have been queried for auditing or analytical purposes to understand the composition of historical quotes. Any existing queries should be considered for migration to supported data models. A sample historical query pattern to retrieve drill-down details for a specific quote might have resembled:

  • SELECT * FROM cz.cz_drill_down_items WHERE quote_hdr_id = &header_id AND quote_rev_nbr = &revision;

For reporting in current implementations, developers must utilize the supported public interfaces and data models provided by the Oracle Configurator, avoiding direct SQL access to obsolete tables like CZ_DRILL_DOWN_ITEMS. Any custom code referencing this table should be reviewed and redesigned.

Related Objects

The ETRM metadata specifies two primary foreign key relationships, defining this table's position in the obsolete data model. It was directly dependent on the CZ_QUOTE_MAIN_ITEMS table, which stored the primary line items of a quote. Its most significant relationship was with the CZ_CONFIG_ITEMS table, which holds the detailed runtime configuration instances. This link was essential for tracing a quoted item's price and components back to the exact configuration session that generated it. While these related tables may also be subject to change or obsolescence, their documented relationship clarifies the historical data flow from a configuration (CZ_CONFIG_ITEMS) to a quote line (CZ_QUOTE_MAIN_ITEMS) and its detailed breakdown (CZ_DRILL_DOWN_ITEMS).