Search Results item_seq_number

Overview

The CZ_QUOTE_MAIN_ITEMS table is a core data structure within the Oracle Configurator (CZ) module of Oracle E-Business Suite (EBS) releases 12.1.1 and 12.2.2. It serves as the primary repository for storing the main, or top-level, configurable items that are listed within a sales quote. Each record in this table represents a distinct configured product or service included in a specific revision of a quote. The table's primary function is to maintain the link between a quote header, its revision, and the sequence of configured items within it. Crucially, the official ETRM documentation explicitly marks this table as OBSOLETE, indicating that while it exists in the schema, its use in new development is deprecated, and it may be subject to removal or functional replacement in future releases.

Key Information Stored

The table's structure is defined by a composite primary key and several foreign key relationships that enforce data integrity. The primary key uniquely identifies each main quote item through three columns: QUOTE_HDR_ID (the identifier of the parent quote), QUOTE_REV_NBR (the specific revision number of that quote), and ITEM_SEQ_NUMBER (the sequence order of the item within the quote). Key columns include CONFIG_HDR_ID and CONFIG_REV_NBR, which form a foreign key relationship to the CZ_CONFIG_HDRS table. This link associates the quoted item with its specific configuration definition and revision, which stores the complete set of rules, components, and options that define the product as it was configured for the quote.

Common Use Cases and Queries

Given its obsolete status, direct operational use of this table in new customizations or integrations is strongly discouraged. Its primary historical use case was for reporting and data extraction related to quoted configurations. Common queries would involve joining to the CZ_QUOTE_HDRS table for quote metadata and to the CZ_CONFIG_HDRS table for configuration details. A typical reporting pattern might retrieve all main items for a specific quote to generate a line item summary. An example SQL pattern is:

• SELECT qmi.ITEM_SEQ_NUMBER, ch.CONFIG_HDR_ID, qh.QUOTE_NUMBER FROM CZ_QUOTE_MAIN_ITEMS qmi JOIN CZ_QUOTE_HDRS qh ON qmi.QUOTE_HDR_ID = qh.QUOTE_HDR_ID AND qmi.QUOTE_REV_NBR = qh.QUOTE_REV_NBR JOIN CZ_CONFIG_HDRS ch ON qmi.CONFIG_HDR_ID = ch.CONFIG_HDR_ID AND qmi.CONFIG_REV_NBR = ch.CONFIG_REV_NBR WHERE qh.QUOTE_NUMBER = '<Quote_Number>' ORDER BY qmi.ITEM_SEQ_NUMBER;

For current functionality, developers should consult Oracle's official APIs and public views.

Related Objects

The CZ_QUOTE_MAIN_ITEMS table is centrally connected to several other key Configurator tables, as defined by its foreign key constraints. The CZ_QUOTE_HDRS table is its direct parent, containing the header information for the quote. The CZ_CONFIG_HDRS table is referenced to obtain the master configuration data for each item. Furthermore, this table acts as a parent to at least two detail tables: CZ_DRILL_DOWN_ITEMS and CZ_SPARES_SPECIALS. These child tables store more granular information related to the main quoted item, such as detailed component breakdowns (drill-down) or special spare parts specifications, inheriting the quote header ID, revision number, and item sequence as part of their foreign key relationships.