Search Results cz_quote_hdrs




Overview
Explore in AI Chat

Overview

The CZ_QUOTE_HDRS 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 header table for storing metadata and transactional context for configurable product quotes generated through the application. Its role is to act as the parent record for all quote-specific data, linking customer, opportunity, pricing, and address information to the detailed line items of a configured quote. Critically, the official ETRM documentation explicitly marks this table as "obsolete," indicating it is part of a legacy data model that may have been superseded by other transactional tables in later application development, though it remains present in the schema.

Key Information Stored

The table's primary key is a composite of QUOTE_HDR_ID and QUOTE_REV_NBR, enabling version control for quote revisions. As evidenced by its foreign key relationships, the table stores essential header-level attributes that define the quote's context. Key foreign key columns include BILLTO_CUSTOMER_ID and SHIPTO_CUSTOMER_ID (linking to CZ_CUSTOMERS), BILLTO_ADDRESS_ID and SHIPTO_ADDRESS_ID (linking to CZ_ADDRESSES), and associated CONTACT_IDs. It also links to an OPPORTUNITY_HDR_ID (CZ_OPPORTUNITY_HDRS) for sales tracking and a PRICE_GROUP_ID (CZ_PRICE_GROUPS) for pricing rules. Additional columns track creation metadata, such as USER_ID_CREATED and USER_ID_FOR_WHOM_CREATED, referencing the CZ_END_USERS table.

Common Use Cases and Queries

Primary use cases involve retrieving comprehensive quote headers for reporting, integration, or data migration purposes, especially concerning legacy data. Common SQL patterns include joining to related customer and address tables to build a complete quote snapshot. A typical query might be:

  • SELECT qh.QUOTE_HDR_ID, qh.QUOTE_REV_NBR, c.CUSTOMER_NAME, o.OPPORTUNITY_NAME FROM CZ.CZ_QUOTE_HDRS qh JOIN CZ.CZ_CUSTOMERS c ON qh.BILLTO_CUSTOMER_ID = c.CUSTOMER_ID LEFT JOIN CZ.CZ_OPPORTUNITY_HDRS o ON qh.OPPORTUNITY_HDR_ID = o.OPPORTUNITY_HDR_ID WHERE qh.QUOTE_HDR_ID = :p_quote_id;

Given its obsolete status, new development should avoid direct dependencies on this table. Its main contemporary use is for historical reporting on quotes created before a potential migration to a newer quote management structure within EBS.

Related Objects

The CZ_QUOTE_HDRS table has extensive relationships within the Configurator schema. It is the parent table for several key detail tables, including CZ_QUOTE_MAIN_ITEMS (for configured components), CZ_SPARES_SPECIALS, CZ_QUOTE_ORDERS, and CZ_EXP_TMP_LINES. The CZ_PROP_QUOTE_HDRS table also references it, likely for proposal management. As shown in the metadata, it is a child table to master data tables such as CZ_CUSTOMERS, CZ_ADDRESSES, CZ_CONTACTS, CZ_OPPORTUNITY_HDRS, CZ_PRICE_GROUPS, and CZ_END_USERS, forming a central node in the legacy Configurator transactional model.