Search Results cz_prices




Overview
Explore in AI Chat

Overview

The CZ_PRICES 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 functions as the master repository for storing list prices used specifically by the Oracle SellingPoint and Quote modules. This table enables the association of predefined price lists with configurable items, providing the foundational pricing data required for generating accurate quotes and proposals for configured products. Its existence is critical for ensuring that price calculations within the configurator runtime are consistent and aligned with established commercial policies.

Key Information Stored

The table's structure is designed to link price lists with specific items. Its primary key is a composite of PRICE_GROUP_ID and ITEM_ID, enforcing uniqueness for each price record. The PRICE_GROUP_ID column references a specific price list or pricing scheme defined in the CZ_PRICE_GROUPS table. The ITEM_ID column references a configurable item master record stored in the CZ_ITEM_MASTERS table. While the provided metadata does not list all columns, the core data stored includes the relationship between these two entities, and the table would typically contain at least one column for the actual price value (e.g., a LIST_PRICE column), which is applied when the referenced item is selected within the specified price group during a configuration or quoting session.

Common Use Cases and Queries

The primary use case for the CZ_PRICES table is to support the retrieval of list prices during the interactive configuration and quote generation processes. A common operational query involves fetching the price for a specific item within a given price list, which is essential for real-time price calculation. For reporting and maintenance, administrators often query the table to audit price assignments or to bulk update prices for a set of items within a particular price group.

  • Price Retrieval for Configuration: SELECT list_price FROM cz.cz_prices WHERE price_group_id = :p_price_list AND item_id = :p_item_id;
  • Audit of Price Assignments: SELECT pg.name, im.item_key, cp.list_price FROM cz.cz_prices cp, cz.cz_price_groups pg, cz.cz_item_masters im WHERE cp.price_group_id = pg.price_group_id AND cp.item_id = im.item_id ORDER BY pg.name;

Related Objects

The CZ_PRICES table is centrally linked to two other fundamental Configurator tables through foreign key constraints, forming a key part of the pricing data model.

  • CZ_PRICE_GROUPS: This table defines the price lists or pricing schemes themselves. The CZ_PRICES.PRICE_GROUP_ID column is a foreign key to CZ_PRICE_GROUPS.PRICE_GROUP_ID.
  • CZ_ITEM_MASTERS: This table stores the master definitions of all configurable items and components. The CZ_PRICES.ITEM_ID column is a foreign key to CZ_ITEM_MASTERS.ITEM_ID.

Data from CZ_PRICES is utilized by the Configurator runtime engine and the Quote module's APIs to resolve and apply correct pricing during business transactions.