Search Results cz_price_groups_pk




Overview
Explore in AI Chat

Overview

The CZ_PRICE_GROUPS table is a core data object within the Oracle Configurator (CZ) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It serves as the master repository for price lists utilized specifically within the Oracle SellingPoint Quote module. This table is fundamental to the pricing engine of the Configurator, enabling the association of specific price lists with configurable items and customer quotes. Its primary role is to define distinct pricing structures that can be applied during the interactive configuration and quotation process, ensuring consistent and accurate pricing for complex, configurable products.

Key Information Stored

The central piece of information stored is the unique identifier for a price list, held in the PRICE_GROUP_ID column, which serves as the table's primary key. While the provided ETRM metadata does not list all columns, the table's relationships and purpose imply it stores descriptive attributes for each price list. This typically includes a name or description for the price group, effective date ranges, currency information, and potentially flags indicating its default or active status. The PRICE_GROUP_ID is the critical foreign key referenced by other transactional tables to link specific prices and quotes to a defined pricing structure.

Common Use Cases and Queries

The primary use case is retrieving the valid price list applicable to a specific customer quote or configuration session. A common reporting need is to list all active price groups available for assignment. Developers often query this table to validate price list IDs or to join pricing data for custom reports. Sample SQL patterns include fetching price group details for a specific quote or listing all price groups with their associated item prices.

  • Retrieve the price list for a specific quote header: SELECT qh.quote_id, pg.* FROM cz_quote_hdrs qh, cz_price_groups pg WHERE qh.price_group_id = pg.price_group_id AND qh.quote_id = :p_quote_id;
  • List all price groups and a count of associated price entries: SELECT pg.price_group_id, pg.name, COUNT(p.price_id) FROM cz_price_groups pg LEFT JOIN cz_prices p ON pg.price_group_id = p.price_group_id GROUP BY pg.price_group_id, pg.name;

Related Objects

The CZ_PRICE_GROUPS table has defined foreign key relationships with two key transactional tables in the Configurator schema, as documented in the ETRM metadata.

  • CZ_PRICES: This table stores the individual price entries for configurable items. Its PRICE_GROUP_ID column references CZ_PRICE_GROUPS.PRICE_GROUP_ID, linking each specific price to a master price list.
  • CZ_QUOTE_HDRS: This table stores header information for quotes generated in the SellingPoint module. Its PRICE_GROUP_ID column references CZ_PRICE_GROUPS.PRICE_GROUP_ID, defining which price list is in effect for the entire quotation.

These relationships establish CZ_PRICE_GROUPS as a parent table, with CZ_PRICES and CZ_QUOTE_HDRS as dependent children. The primary key constraint CZ_PRICE_GROUPS_PK on PRICE_GROUP_ID enforces the integrity of these relationships.