Results for “applied_to_charge_id”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

WSH_FREIGHT_COSTS_V is a shipped, seeded Oracle E-Business Suite view owned by the APPS schema and defined in the Shipping Execution (WSH) product. It exposes freight cost records generated against deliveries, delivery legs, stops, and trips, presenting denormalized descriptive information alongside the raw cost amounts. The view acts as the primary reporting and integration surface for freight charges that originate either manually or through the Oracle Transportation/Advanced Pricing freight rating engine. Because it consolidates cost type names, lookup meanings, trip names, and delivery names into a single row per freight cost, it removes the need for report authors and interface developers to perform repeated joins across WSH_FREIGHT_COSTS and its reference tables.

The view is particularly significant for users searching on pricing_list_line_id, since that column is exposed directly from the base freight cost table and identifies the pricing list line applied during pricing engine rating. Note that the view filters out records whose charge source is neither PRICING_ENGINE nor MANUAL.

Underlying Base Objects

The view is defined over five documented objects:

• WSH_FREIGHT_COSTS (synonym) — the driving table, referenced by alias FC; supplies all cost amounts, identifiers, currency attributes, descriptive flexfields, and the pricing list references.
• WSH_FREIGHT_COST_TYPES (synonym) — alias FCT; supplies the cost type identifier, name, and code joined on FREIGHT_COST_TYPE_ID.
• WSH_TRIPS (synonym) — alias TR; supplies the trip name and is joined with an outer join on TRIP_ID.
• WSH_NEW_DELIVERIES (synonym) — alias DEL; supplies the delivery name and is outer-joined on DELIVERY_ID.
• WSH_LOOKUPS (view, lookup type FREIGHT_COST_TYPE) — alias WSHLU; supplies the meaning for the cost type code.

Inner joins to WSH_FREIGHT_COST_TYPES and WSH_LOOKUPS are mandatory, so only freight costs with a valid cost type and lookup mapping are returned. The view restricts results to standard, outbound or internal outbound deliveries, and excludes charges whose source is null or any value other than MANUAL or PRICING_ENGINE.

Key Columns

• FREIGHT_COST_ID — primary key of the underlying freight cost record; ROW_ID is also exposed.
• FREIGHT_COST_TYPE_ID / FREIGHT_COST_TYPE / FREIGHT_COST_TYPE_CODE / FREIGHT_COST_TYPE_MEANING — the cost type identity, name, code, and user-facing meaning.
• UNIT_AMOUNT, QUANTITY, UOM, TOTAL_AMOUNT — the rating computation values.
• CURRENCY_CODE, CONVERSION_RATE, CONVERSION_DATE, CONVERSION_TYPE_CODE — currency and conversion attributes.
• PRICING_LIST_HEADER_ID and PRICING_LIST_LINE_ID — the pricing list header and the specific pricing list line that produced the charge; the latter is the object of the search term and is the join key back to pricing list line definitions.
• CHARGE_SOURCE_CODE, CHARGE_UNIT_VALUE, ESTIMATED_FLAG, BILLABLE_QUANTITY, BILLABLE_UOM, BILLABLE_BASIS — charge origin, estimation status, and billable measures.
• TRIP_ID/TRIP_NAME, STOP_ID, DELIVERY_ID/DELIVERY_NAME, DELIVERY_LEG_ID, DELIVERY_DETAIL_ID — shipment hierarchy context.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–15 — descriptive flexfield values.

Common Use Cases and Queries

The view is commonly used to report freight spend by delivery or trip, to reconcile estimated versus actual charges, and to trace charges back to the pricing list line that rated them.

• Locating charges derived from a specific pricing line:

  SELECT freight_cost_id, delivery_id, delivery_name, total_amount, currency_code FROM wsh_freight_costs_v WHERE pricing_list_line_id = :pricing_list_line_id;

• Aggregating freight spend by cost type for a trip:

  SELECT trip_name, freight_cost_type_meaning, SUM(total_amount) FROM wsh_freight_costs_v WHERE trip_id = :trip_id GROUP BY trip_name, freight_cost_type_meaning;

• Comparing estimated versus actual charges:

  SELECT delivery_id, estimated_flag, SUM(total_amount) FROM wsh_freight_costs_v GROUP BY delivery_id, estimated_flag;