Search Results op_prce_itm




Overview
Explore in AI Chat

Overview

The IC_PRCE_CLS table is a master data table within the Process Manufacturing Inventory (GMI) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It serves as a foundational repository for defining and maintaining price classes used throughout Oracle Process Manufacturing (OPM). A price class is a classification code that groups items or transactions for pricing, costing, and financial analysis purposes. This table enables standardized pricing rules and cost management by providing a central reference point. Its role is critical for ensuring consistent financial treatment across manufacturing, inventory, and sales operations within the OPM footprint.

Key Information Stored

While the provided ETRM excerpt does not list specific column details, the table's primary key is documented as ICPRICE_CLASS. Based on standard OPM table design patterns and the table's purpose, it typically stores descriptive and control information for each price class. Common columns in such a master table would include the unique price class code (ICPRICE_CLASS), a description, an inactive date flag, who created and last updated the record, and associated control attributes. The table may also include a TEXT_CODE column, as indicated by its foreign key relationship to IC_TEXT_HDR, which links to descriptive flexfield or long text definitions for the price class.

Common Use Cases and Queries

This table is primarily referenced for setup validation, reporting, and as a lookup in transactional processes. Common operational scenarios include validating a price class assigned to an item during item master maintenance or ensuring a price class used in a sales order or production transaction is active. A typical query would retrieve all active price classes for a user interface list of values (LOV). For example:

  • SELECT icprice_class, description FROM ic_prce_cls WHERE NVL(inactive_ind, 'N') = 'N' ORDER BY 1;

Reporting use cases often involve joining IC_PRCE_CLS to transactional tables like OP_PRCE_ITM to analyze pricing by class or to IC_ITEM_MST to generate a list of items categorized by their assigned price class for cost roll-up analysis.

Related Objects

The IC_PRCE_CLS table has defined relationships with several key OPM tables, as per the foreign key metadata. The IC_ITEM_MST (Item Master) table references it via the PRICE_CLASS column, linking the classification to items. Transactionally, it is referenced by OP_PRCE_ITM (Sales Order Price Items) and OP_CHRG_ITM (Sales Order Charge Items) for pricing, and by OP_CNTR_DTL (Contract Detail) for contractual pricing agreements. The relationship with IC_TEXT_HDR allows for extended descriptive text. Crucially, the ETRM notes this table is "Not implemented in this database," which may indicate it is a legacy object or its function is superseded in certain deployments, though its structure remains defined for referential integrity.