Search Results op_cprc_cls




Overview
Explore in AI Chat

Overview

The OP_CPRC_CLS table is a core master data table within Oracle E-Business Suite 12.1.1 and 12.2.2, specifically for the Process Manufacturing Logistics (GML) product. It serves as the central repository for defining and maintaining Customer Price Classes. A price class is a categorization mechanism that groups customers based on shared pricing criteria, enabling the streamlined application of pricing rules, discounts, and promotions across multiple customer accounts. This table's primary role is to provide a standardized reference point for pricing logic within the order management and sales modules of the Process Manufacturing suite, ensuring consistent price application and simplifying pricing maintenance.

Key Information Stored

While the provided metadata does not list individual columns, the structure and relationships indicate the key data elements. The table's primary key is the column CUSTPRICE_CLASS, which stores the unique identifier or code for each price class definition. Based on standard EBS patterns and the table's foreign key relationships, it likely contains descriptive columns such as a name, an effective date range (from/to), an inactive date, and a text code for associating descriptive flexfields or long descriptions. The TEXT_CODE column, referenced by a foreign key to OP_TEXT_HDR, is particularly important for storing extended, user-defined descriptive text for the price class.

Common Use Cases and Queries

This table is central to pricing configuration and customer setup. Common operational and reporting use cases include assigning a price class to a customer master record, defining price lists or price adjustments specific to a price class, and generating reports analyzing sales or margins by customer price segment. A typical query would join OP_CPRC_CLS to customer or pricing tables to retrieve all pricing rules applicable to a specific class.

  • Finding Customers in a Price Class: SELECT cust_name FROM op_cust_mst_opm c, op_cprc_cls p WHERE c.custprice_class = p.custprice_class AND p.custprice_class = '&PRICE_CLASS_CODE';
  • Listing All Active Price Classes: SELECT custprice_class, description FROM op_cprc_cls WHERE SYSDATE BETWEEN effective_from AND NVL(effective_to, SYSDATE);
  • Identifying Price Effects by Class: SELECT e.price_effect_name FROM op_prce_eff e, op_cprc_cls c WHERE e.custprice_class = c.custprice_class;

Related Objects

The OP_CPRC_CLS table has defined integration points with several key tables, as per the provided metadata. The primary key (CUSTPRICE_CLASS) is referenced by foreign keys in customer master tables and pricing tables, establishing its role as a controlling entity.

  • OP_CUST_MST_OPM & OP_CUST_MST: Customer master tables where a customer record is assigned a price class via the CUSTPRICE_CLASS column.
  • OP_PRCE_EFF: The Price Effects table, which defines specific pricing rules or adjustments linked to a customer price class.
  • OP_TEXT_HDR: The Text Header table, linked via OP_CPRC_CLS.TEXT_CODE, which stores descriptive flexfield or long text information for the price class definition.