Search Results op_frgt_mth_pk




Overview
Explore in AI Chat

Overview

The OP_FRGT_MTH table is a core reference data table within the Oracle E-Business Suite Process Manufacturing Logistics (GML) module. It functions as a master repository for freight bill method codes, which define the contractual terms and conditions for how freight charges are calculated and billed by carriers. These codes are critical for logistics and financial operations, as they determine the cost structure applied to shipments for both inbound and outbound logistics. The table's primary role is to provide a standardized, validated list of methods that can be consistently applied across purchase orders, sales orders, contracts, and other transactional documents within the integrated EBS environment, ensuring accurate freight cost allocation and accounting.

Key Information Stored

While the provided ETRM excerpt does not list all columns, the structure indicates the essential data elements. The table's primary key is the column `FRTBILL_MTHD`, which stores the unique alphanumeric identifier for each freight billing method (e.g., PREPAID, COLLECT, THIRD_PARTY). The primary key constraint is named `OP_FRGT_MTH_PK`. Another significant column is `TEXT_CODE`, which is referenced by the `OP_TEXT_HDR` table, suggesting a link to descriptive, long-text explanations for each method code. The table likely contains additional descriptive columns such as a name or description field (`FRTBILL_MTHD_DESC`) and standard Who columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY) for audit purposes.

Common Use Cases and Queries

This table is central to any process involving freight cost management. A common use case is the configuration and maintenance of freight terms for trading partners, where codes from OP_FRGT_MTH are assigned to customer and vendor master records. During order entry, the system defaults the freight method from the master record to the order header and line, which subsequently flows to shipment and invoicing documents. For reporting, analysts often join this table to transactional data to analyze freight costs by billing method. A typical query would retrieve all active methods or list the freight method used on specific transactions:

  • SELECT frtbill_mthd FROM gml.op_frgt_mth ORDER BY frtbill_mthd;
  • SELECT o.ordr_no, o.frtbill_mthd, m.description FROM op_ordr_hdr o, op_frgt_mth m WHERE o.frtbill_mthd = m.frtbill_mthd;

Related Objects

The OP_FRGT_MTH table is extensively referenced as a foreign key constraint across the Process Manufacturing (OP) and Purchasing (PO) modules, highlighting its integration significance. Key relationships include: