Search Results op_ship_mth




Overview
Explore in AI Chat

Overview

The OP_SHIP_MTH table is a core reference data object within Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It is owned by the GML (Process Manufacturing Logistics) product family and serves as the master repository for shipping method codes. Its primary role is to standardize and centralize the definition of all available shipping modes—such as air freight, ground, or ocean—across the logistics and procurement modules. By maintaining a single source of truth for shipping methods, this table ensures data integrity and consistency in order processing, shipment planning, and procurement activities throughout the application.

Key Information Stored

While the provided metadata does not list all columns, the structure indicates the table's critical components. The primary key column is SHIP_MTHD, which stores the unique identifier for each shipping method code. The table also includes a foreign key column, PREFERRED_SHIPPER, which references the OP_SHIP_MST table to link a shipping method with a default carrier or service provider. Another foreign key, TEXT_CODE, links to the OP_TEXT_HDR table, allowing for descriptive text or notes to be associated with each shipping method. This setup facilitates the management of essential shipping attributes and their relationships.

Common Use Cases and Queries

This table is fundamental for transactional and reporting functions. Common use cases include populating list of values (LOVs) for shipping method selection during sales order entry, purchase order creation, and shipment scheduling. For reporting, analysts query this table to categorize and analyze logistics performance by shipping method. A typical query might join OP_SHIP_MTH with order tables to summarize freight costs or delivery times. For instance, to list all active shipping methods and their associated default shipper, a query would be: SELECT s.SHIP_MTHD, m.SHIPPER_NAME FROM GML.OP_SHIP_MTH s, GML.OP_SHIP_MST m WHERE s.PREFERRED_SHIPPER = m.SHIPPER_ID(+); Data maintenance tasks, such as adding a new expedited shipping code, are performed directly against this table, often via the application's front-end interface to maintain referential integrity.

Related Objects

As evidenced by the extensive foreign key relationships, OP_SHIP_MTH is a pivotal reference table integrated across multiple EBS modules. Key related objects include:

This wide integration underscores the table's critical role in unifying logistics data across the supply chain.