Search Results op_chrg_itm




Overview
Explore in AI Chat

Overview

The OP_CHRG_ITM table is a core data object within the Oracle E-Business Suite (EBS) Process Manufacturing Logistics (GML) module. It functions as a transactional repository for defining and storing specific charges associated with items or item classes for designated customers. This table enables the configuration of customer-specific pricing and surcharge structures, which is fundamental for generating accurate sales orders, invoices, and other commercial documents. Its role is to link master data for charges, customers, and items, thereby providing the granular detail necessary for the application of complex pricing rules within the supply chain and order management processes.

Key Information Stored

The table's primary purpose is to establish relationships between its key foreign key columns. The central identifier is the CHARGEITEM_ID, which serves as the table's unique primary key. The table stores the linkage between a specific CHARGE_ID (from OP_CHRG_MST), a CUST_ID (from OP_CUST_MST), and either a specific ITEM_ID (from IC_ITEM_MST) or an ICPRICE_CLASS (from IC_PRCE_CLS). This structure allows a single charge definition to be applied broadly to an item price class for a customer or very specifically to a single item for a customer. The combination of CHARGE_ID, CUST_ID, and ITEM_ID is also enforced as a unique key (OP_CHRG_ITM_U1), preventing duplicate charge assignments.

Common Use Cases and Queries

A primary use case is querying all active charges applicable to a specific customer and item for pricing calculations during order entry. For example, a report to list all charges for a customer across item price classes would be essential for customer contract reviews. Common SQL patterns involve joining to the related master tables to retrieve descriptive information.

  • Finding charges for a specific customer and item: 
    SELECT c.charge_name, i.item_no, ci.*
FROM gml.op_chrg_itm ci,
     gml.op_chrg_mst c,
     gml.ic_item_mst_b i
WHERE ci.cust_id = 12345
  AND ci.item_id = i.item_id
  AND ci.charge_id = c.charge_id;
  • Identifying charges defined at the price class level: 
    SELECT cust_id, icprice_class, charge_id
FROM gml.op_chrg_itm
WHERE item_id IS NULL
  AND icprice_class IS NOT NULL;

Related Objects

OP_CHRG_ITM is a central junction table with documented foreign key relationships to several critical master tables. These relationships enforce data integrity and define the table's context within the GML data model.

  • OP_CHRG_MST: Links via CHARGE_ID to retrieve the master definition and attributes of the charge being applied.
  • OP_CUST_MST: Links via CUST_ID to identify the customer for whom the charge is configured.
  • IC_ITEM_MST_B and IC_ITEM_MST: Both link via ITEM_ID to the item master, allowing the charge to be associated with a specific inventory item.
  • IC_PRCE_CLS: Links via ICPRICE_CLASS to a price class, enabling the charge to be applied to all items belonging to that classification.