Search Results op_ctrd_cls




Overview
Explore in AI Chat

Overview

The OP_CTRD_CLS table is a core reference data object within the Oracle E-Business Suite (EBS) Process Manufacturing Logistics (GML) module. It serves as the master repository for defining and storing Customer Trade Classes. A trade class is a categorization mechanism used to segment customers based on commercial or logistical criteria, such as market channel, business relationship type, or pricing tier. This classification is integral to configuring and enforcing business rules across various logistics and order management processes, enabling differentiated handling, pricing, and reporting for distinct customer groups.

Key Information Stored

While the provided metadata does not list specific columns beyond the primary key, the table's structure is designed to support trade class definition and management. The primary column is CUSTTRADE_CLASS, which serves as the unique identifier (primary key) for each trade class record. Based on standard EBS design patterns, the table likely contains descriptive columns such as a name or description field, enabled flag, creation and last update date columns, and potentially attributes for classification hierarchy or assignment rules. The presence of a foreign key relationship to the OP_TEXT_HDR table via a TEXT_CODE column suggests the table supports attaching descriptive, long-text notes to each trade class definition.

Common Use Cases and Queries

The primary use case for OP_CTRD_CLS is the setup and maintenance of customer segmentation within Process Manufacturing. Administrators use this table to define the valid list of trade classes before they can be assigned to customer master records. Common operational queries involve listing all active trade classes or retrieving the classification for a specific customer to drive process logic. For reporting, the table is frequently joined to customer and transactional data to analyze performance, sales, or logistics metrics by trade class segment. A typical query pattern is:

  • SELECT ctc.custtrade_class, ctc.description, COUNT(cust.customer_id) FROM gml.op_ctrd_cls ctc, op_cust_mst_opm cust WHERE ctc.custtrade_class = cust.custtrade_class GROUP BY ctc.custtrade_class, ctc.description;

This SQL would provide a count of customers assigned to each defined trade class, useful for validating setup and understanding customer distribution.

Related Objects

The OP_CTRD_CLS table has defined foreign key relationships with several key transactional and master tables in the GML and Order Management domains, as documented in the metadata:

  • OP_CUST_MST_OPM and OP_CUST_MST: These customer master tables reference OP_CTRD_CLS via their CUSTTRADE_CLASS column, storing the assigned trade class for each customer record.
  • OP_PRSL_HDR: The Price List Header table references OP_CTRD_CLS via its CUSTTRADE_CLASS column, indicating that price lists can be associated with specific customer trade classes for targeted pricing.
  • OP_TEXT_HDR: This text header table is referenced by OP_CTRD_CLS via the TEXT_CODE column, allowing for the storage of extended descriptive text or notes associated with a trade class definition.

These relationships establish OP_CTRD_CLS as a central control point for customer segmentation, directly influencing customer master data, pricing, and by extension, sales orders and shipments that originate from these related entities.