Search Results op_cust_shp

Overview

The IC_SHIP_CLS table is a foundational data object within the Oracle Process Manufacturing (OPM) Inventory module (GMI) of Oracle E-Business Suite. It serves as the master repository for defining and storing shipping class codes. A shipping class is a critical classification used to group items with similar shipping, handling, or transportation requirements. This classification is leveraged throughout the OPM suite to standardize and control logistics processes, influencing inventory management, warehouse operations, and order fulfillment. The table's primary role is to provide a validated list of shipping classes that can be assigned to items, thereby ensuring consistency in how shipping rules are applied across the manufacturing and distribution lifecycle.

Key Information Stored

Based on the provided metadata, the central column in the IC_SHIP_CLS table is ICSHIP_CLASS, which serves as the unique identifier (Primary Key: IC_SHIP_CLS_PK) for each shipping class definition. While the full column list is not detailed in the excerpt, typical columns in such a master definition table would include a description field (e.g., SHIP_CLASS_DESC), creation and last update dates, and the user who performed the action. The table also stores a TEXT_CODE column, which is a foreign key to the IC_TEXT_HDR table. This relationship allows for the association of extensive descriptive text or notes with a shipping class, providing detailed handling instructions or compliance information beyond a simple code and description.

Common Use Cases and Queries

The primary use case for the IC_SHIP_CLS table is the maintenance of the shipping class master list via the application's user interface. It is referenced whenever a user creates or updates an item in the IC_ITEM_MST table to assign a shipping class. From a reporting and query perspective, it is frequently joined to item and inventory tables to analyze or report on items based on their shipping characteristics. A common SQL pattern involves joining the item master to the shipping class table to generate a list of items and their shipping classifications:

• SELECT i.item_no, i.item_desc, s.icship_class, s.ship_class_desc FROM ic_item_mst i, ic_ship_cls s WHERE i.ship_class = s.icship_class;

Another critical use case is in warehouse management and shipping execution, where the class can determine packing rules, carrier selection, or freight calculations for inventory in specific warehouses (IC_WHSE_INV) or customer shipments (OP_CUST_SHP).

Related Objects

The IC_SHIP_CLS table has defined relationships with several key OPM tables, as indicated by its foreign keys. The IC_ITEM_MST (Item Master) table references it via the SHIP_CLASS column, making it fundamental to item definition. The IC_WHSE_INV (Warehouse Inventory) table references it, linking the shipping class to specific inventory stock locations. The OP_CUST_SHP (Customer Shipments) table references it, tying the class directly to outbound shipment documents. Furthermore, the relationship with IC_TEXT_HDR allows for extended descriptive text. It is important to note that the provided metadata states this table is "Not implemented in this database," which may indicate it is a legacy table not present in all configurations or its function has been superseded in certain versions; however, its defined relationships outline its intended integration points within the OPM data model.