Search Results cz_spares_specials




Overview
Explore in AI Chat

Overview

The CZ_SPARES_SPECIALS table is a historical data object within the Oracle E-Business Suite Configurator (CZ) module. As explicitly noted in the official documentation, its status is "OBSOLETE." The table was originally part of the MDApp (Model-Driven Application) architecture, specifically designed to manage spares and special items associated with configured product quotes. In the context of Oracle EBS 12.1.1 and 12.2.2, this table is a legacy artifact and is not part of the active, supported data model for new implementations or customizations. Its primary role was to serve as a junction or reference table linking quote headers and revisions to specific spare or special item line details.

Key Information Stored

The table's structure centers on identifiers that link it to core Configurator quote entities. Its composite primary key consists of four columns: PACKAGE_SEQ, QUOTE_HDR_ID, QUOTE_REV_NBR, and TYPE_FLAG. These columns collectively define a unique record, likely distinguishing between different packages of items within a specific quote revision. The QUOTE_HDR_ID and QUOTE_REV_NBR columns are foreign keys pointing to the CZ_QUOTE_HDRS table, anchoring the data to a specific commercial quote and its version. The TYPE_FLAG column is a critical attribute, presumably indicating whether the linked record pertains to a "spare" item or a "special" item, which would determine which detail table (CZ_QUOTE_SPARES or CZ_QUOTE_SPECIAL_ITEMS) holds the item's specific attributes.

Common Use Cases and Queries

Given its obsolete status, there are no recommended new use cases for this table in EBS 12.1.1 or 12.2.2. Its use is confined to historical data analysis or supporting legacy customizations that have not been migrated. Practical scenarios would involve auditing or reconciling old quote data. A sample query to retrieve all spares/specials linkages for a specific quote header might be structured as follows:

  • SELECT * FROM cz.cz_spares_specials WHERE quote_hdr_id = <header_id> ORDER BY quote_rev_nbr, package_seq;

Reporting use cases are strictly historical. Analysts might join this table to CZ_QUOTE_SPARES and CZ_QUOTE_SPECIAL_ITEMS to generate a complete list of all ancillary items from legacy quotes, though such reporting should be phased out in favor of current data models.

Related Objects

The CZ_SPARES_SPECIALS table maintains defined foreign key relationships with several core Configurator tables, illustrating its former integration. It references the CZ_QUOTE_HDRS table for quote header information and the CZ_QUOTE_MAIN_ITEMS table via item sequence. More importantly, it is referenced by two key detail tables: CZ_QUOTE_SPARES and CZ_QUOTE_SPECIAL_ITEMS. These relationships indicate that CZ_SPARES_SPECIALS acted as a parent table, with the TYPE_FLAG determining which child table (SPARES or SPECIAL_ITEMS) contained the extended line details for a given PACKAGE_SEQ. This design allowed for a normalized structure to manage different types of ancillary quote items.