Search Results cz_quote_orders




Overview
Explore in AI Chat

Overview

The CZ_QUOTE_ORDERS table is a historical data object within the Oracle Configurator (CZ) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. As explicitly noted in its official documentation, this table is OBSOLETE. Its original purpose was to track orders generated from configured quotes that were submitted from the legacy SellingPoint application to the Order Management (OE) module. In modern EBS implementations, this specific tracking mechanism is no longer active, and the table primarily exists for backward compatibility and potential data reference. Its presence in the CZ schema signifies its role in the now-deprecated integration workflow between the configuration engine and the order entry system.

Key Information Stored

The table's structure is defined by its primary and foreign keys, which indicate the core data relationships it was designed to manage. The primary key is a composite of QUOTE_HDR_ID and QUOTE_REV_NBR. These columns store the unique identifier for a quote header and its specific revision number, respectively. This design links each record in CZ_QUOTE_ORDERS to a specific version of a configured quote. While the full column list is not detailed in the provided metadata, the foreign key constraints confirm that the table's essential function was to associate quote revisions from the CZ_QUOTE_HDRS table with their corresponding sales orders in the OE module, thereby creating an audit trail for the order submission process.

Common Use Cases and Queries

Given the table's obsolete status, it is not used in active transaction processing or contemporary reporting within Oracle Configurator. Its primary modern use case is for historical data analysis or migration audits. For instance, a query might be executed to identify all sales orders that originated from a specific historical quote revision before a system upgrade. A sample SQL pattern to retrieve this legacy linkage would be:

  • SELECT qo.quote_hdr_id, qo.quote_rev_nbr, oh.order_number FROM cz.cz_quote_orders qo JOIN oe_order_headers_all oh ON qo.order_id = oh.header_id WHERE qo.quote_hdr_id = <ID>;

Note that the exact join column to the OE tables (e.g., ORDER_ID) is inferred based on the table's described purpose, as the specific column is not listed in the provided excerpt.

Related Objects

The table has defined dependencies within the CZ schema. Its principal relationship is with the CZ_QUOTE_HDRS table, which stores the header information for configured quotes. The foreign key (CZ_QUOTE_ORDERS.QUOTE_HDR_ID, CZ_QUOTE_ORDERS.QUOTE_REV_NBR) references the primary key of CZ_QUOTE_HDRS, enforcing referential integrity. While not listed in the metadata, the table was logically designed to relate to order header tables in the OE schema (such as OE_ORDER_HEADERS_ALL). The primary key constraint CZ_QUOTE_ORDERS_PK is also a directly related database object. No modern CZ APIs or user interfaces interact with this obsolete table.