Search Results aso_freight_charges_pk

Overview

The ASO_FREIGHT_CHARGES table is a core data object within the Oracle E-Business Suite (EBS) Order Capture (ASO) module. It functions as the central repository for storing freight-related monetary charges associated with shipments on a sales quote. Its primary role is to capture and persist the calculated freight cost details, which are essential for accurate quote pricing, order fulfillment costing, and financial integration. The table supports the storage of multiple charge amounts for a single shipment, contingent upon the freight charge type, enabling a detailed breakdown of shipping costs.

Key Information Stored

While the full column list is not detailed in the provided metadata, the documented structure indicates several critical data points. The primary key, FREIGHT_CHARGE_ID, uniquely identifies each freight charge record. The foreign key column, QUOTE_SHIPMENT_ID, links each charge to its parent shipment record in the ASO_SHIPMENTS table. The table's description explicitly states it stores "charge amount(s)," implying the presence of at least one column for the monetary value (e.g., CHARGE_AMOUNT). Furthermore, the mention of storage "depending on freight charge type" strongly suggests a column (e.g., CHARGE_TYPE_CODE) to categorize the charge, such as base freight, fuel surcharge, or handling fees. Additional columns likely include the currency code and links to pricing modifiers or freight carriers.

Common Use Cases and Queries

This table is pivotal for reporting and data extraction related to quoted shipping costs. A common use case is generating a detailed freight cost analysis for a specific quote or a set of quotes within a date range. Development and support activities often involve querying this table to troubleshoot quote pricing discrepancies or to validate freight calculations. A typical SQL pattern involves joining to the ASO_SHIPMENTS and higher-level quote headers to retrieve a consolidated view.

• Sample Query: Retrieving all freight charges for a specific quote shipment.
  SELECT afc.freight_charge_id, afc.charge_amount, afc.charge_type_code
FROM aso.aso_freight_charges afc
WHERE afc.quote_shipment_id = <shipment_id>
ORDER BY afc.freight_charge_id;
• Reporting Use Case: Aggregating total freight costs by quote for a sales period, which feeds into profitability or shipping cost trend reports.

Related Objects

The ASO_FREIGHT_CHARGES table exists within a well-defined hierarchy in the ASO schema. Its primary relationship, as documented by the foreign key, is with the ASO_SHIPMENTS table. This relationship is established via the QUOTE_SHIPMENT_ID column in ASO_FREIGHT_CHARGES, which references the primary key (likely SHIPMENT_ID) in ASO_SHIPMENTS. This enforces that every freight charge must be associated with a valid shipment record. Consequently, ASO_SHIPMENTS is the immediate parent table. To access higher-level quote information, one would typically join from ASO_FREIGHT_CHARGES to ASO_SHIPMENTS, and then to the main quote header table, ASO_QUOTE_HEADERS. The table is also referenced by its primary key constraint, ASO_FREIGHT_CHARGES_PK.