Search Results wsh_freight_cost_types

Overview

The WSH_FREIGHT_COST_TYPES table is a foundational reference table within the Oracle E-Business Suite Shipping Execution (WSH) module. It serves as a master repository for defining and managing the different categories or classifications of freight costs that can be applied to shipments. This table is critical for standardizing freight cost capture and analysis across the logistics and financial processes of the application. By providing a controlled list of cost types, it ensures consistency in how freight charges—such as base freight, fuel surcharges, accessorial fees, or taxes—are recorded against individual freight costs in the system, enabling accurate freight accruals, allocation, and reporting.

Key Information Stored

The table's primary function is to store unique identifiers and descriptive information for each freight cost type. While the full column list is not detailed in the provided metadata, the structure is defined by its primary key and its relationship to the WSH_FREIGHT_COSTS table. The core column is FREIGHT_COST_TYPE_ID, which is the primary key (WSH_FREIGHT_COST_TYPES_PK) and serves as a unique numeric identifier for each cost type record. Typically, such reference tables also include columns for a user-defined name (e.g., NAME), a description (DESCRIPTION), enabled flags, and who/when columns for auditing (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE). The data in this table is typically seeded during installation and can be extended by implementers to meet specific business requirements.

Common Use Cases and Queries

This table is primarily referenced in transactional and reporting contexts. A common use case is during the freight cost entry process, where a user selects a valid cost type from a list of values (LOV) populated from this table. For reporting, it is essential for categorizing and summarizing freight expenses. A typical analytical query would join this table to the transactional WSH_FREIGHT_COSTS table to produce a report of all freight charges broken down by type.

• Sample Query to List All Active Cost Types:
  SELECT freight_cost_type_id, name, description FROM wsh_freight_cost_types WHERE enabled_flag = 'Y' ORDER BY name;
• Sample Query for Freight Cost Analysis:
  SELECT fct.name cost_type, SUM(fc.amount) total_amount FROM wsh_freight_costs fc, wsh_freight_cost_types fct WHERE fc.freight_cost_type_id = fct.freight_cost_type_id GROUP BY fct.name;

Related Objects

The WSH_FREIGHT_COST_TYPES table has a direct parent-child relationship with the primary transactional table for freight charges. As documented in the provided metadata:

• WSH_FREIGHT_COSTS: This is the key foreign key relationship. The column WSH_FREIGHT_COSTS.FREIGHT_COST_TYPE_ID references WSH_FREIGHT_COST_TYPES.FREIGHT_COST_TYPE_ID. Every freight cost recorded in the system must be associated with a valid type defined in this reference table. This relationship enforces data integrity and is fundamental for all freight costing operations.