Search Results ic_sale_cls




Overview
Explore in AI Chat

Overview

The IC_SALE_CLS table is a core master data table within the Process Manufacturing Inventory (GMI) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It serves as the central repository for defining and maintaining sales classes for items. In Oracle Process Manufacturing (OPM), a sales class is a classification attribute assigned to inventory items, enabling grouping, reporting, and business rule application based on sales characteristics. This table's definitions are referenced throughout the OPM suite to ensure consistent categorization and processing of items in sales-related transactions and analyses.

Key Information Stored

While the full column list is not detailed in the provided metadata, the foreign key relationships and primary key structure reveal critical data points. The primary key column is ICSALES_CLASS, which uniquely identifies each sales class code. Another significant column is TEXT_CODE, which links to the IC_TEXT_HDR table to store descriptive text or notes for the sales class definition. The REPORTING_UOM column establishes a default unit of measure for reporting purposes by linking to the SY_UOMS_MST table. This allows sales performance and inventory to be analyzed in a standardized measurement for each class.

Common Use Cases and Queries

The primary use case is the classification and retrieval of items based on their sales class. This supports critical business functions such as sales reporting, pricing strategies, and inventory analysis segmented by market or product line. A common query would involve joining IC_SALE_CLS to the item master to list all items within a specific class. For example, to find all items and their descriptions for a given sales class 'BULK', one might use:

Another frequent scenario is generating a simple list of all defined sales classes for setup or maintenance purposes, querying the primary key and associated text description via the foreign key to IC_TEXT_HDR.

Related Objects

The IC_SALE_CLS table has defined relationships with several other key OPM tables, as indicated by its foreign keys. The IC_ITEM_MST table (Item Master) references it via the SALES_CLASS column, making it a fundamental parent table for item classification. For descriptive text, it relates to the IC_TEXT_HDR table. For unit of measure standardization, it links to the SY_UOMS_MST table. These relationships ensure data integrity and propagate the sales class definition consistently across the Process Manufacturing system.