Search Results item_price




Overview
Explore in AI Chat

Overview

APPS.INL_SHIP_LANDED_COSTS_V is a reporting view in the Oracle E-Business Suite Logistics/Inventory (INL) schema that consolidates landed cost information at the shipment header level. Its purpose is to aggregate the individual landed cost components — item price, charges, and taxes — that are captured on shipment lines, and to present them alongside a derived per-unit landed cost. In the context of Oracle EBS 12.1.1 and 12.2.2, this view serves as the summary layer that supports landed cost analysis, receipt valuation reporting, and integration extracts where a single, header-level landed cost figure per item and organization is required.

The view is defined over the more granular shipment-line view INL_SHIPLN_LANDED_COSTS_V, rolling the line-level detail up to the shipment header dimension. This two-tier design (detail view feeding summary view) is characteristic of ETRM and landed cost reporting structures, allowing operational detail to be retained in the base view while presenting a consolidated figure for downstream consumption.

Underlying Base Objects

Per the documented metadata, the only referenced base object is INL_SHIPLN_LANDED_COSTS_V, itself a view. There are no direct base-table references recorded for INL_SHIP_LANDED_COSTS_V. The relationship is aggregational rather than join-based: the summary view selects from the line-level view and applies GROUP BY and SUM functions to collapse multiple shipment-line landed cost records into a single row per grouping key.

Because the underlying object is a view and not a physical table, the query cost of INL_SHIP_LANDED_COSTS_V depends entirely on the definition and performance characteristics of INL_SHIPLN_LANDED_COSTS_V. This is an important consideration for report design and any programmatic reads.

Key Columns

  • SHIP_HEADER_ID — The shipment header identifier; the primary grouping key linking the aggregated costs to the shipment.
  • ADJUSTMENT_NUM — The landed cost adjustment number, identifying the cost adjustment transaction involved.
  • ORGANIZATION_ID — The inventory organization under which the landed costs are accounted.
  • INVENTORY_ITEM_ID — The item being costed.
  • ITEM_PRICE — Sum of NVL(ITEM_PRICE,0) across contributing lines; the aggregate item price component.
  • CHARGES — Sum of NVL(CHARGES,0); the aggregate landed cost charges.
  • TAXES — Sum of NVL(TAXES,0); the aggregate tax component.
  • PRIMARY_QTY — Sum of NVL(PRIMARY_QTY,0); the total quantity in the primary unit of measure. This is the column most relevant to a search for "primary_qty", and it is central to the view because it serves as the denominator of the UNIT_LANDED_COST calculation.
  • PRIMARY_UOM_CODE — The primary unit of measure for the aggregated quantity.
  • UNIT_LANDED_COST — Derived as (ITEM_PRICE + CHARGES + TAXES) / PRIMARY_QTY, expressing the blended per-unit landed cost.

The grouping is performed on SHIP_HEADER_ID, ADJUSTMENT_NUM, ORGANIZATION_ID, INVENTORY_ITEM_ID, and PRIMARY_UOM_CODE, so each returned row represents a unique combination of those five attributes.

Common Use Cases and Queries

Typical uses include verifying landed cost roll-up for a shipment, reconciling receipt valuation, and exposing landed cost data to external systems. A representative query retrieving all costs for a shipment is:

SELECT ship_header_id, adjustment_num, organization_id,
       inventory_item_id, item_price, charges, taxes,
       primary_qty, primary_uom_code, unit_landed_cost
FROM   apps.inl_ship_landed_costs_v
WHERE  ship_header_id = :p_ship_header_id;

To isolate a specific item's landed cost position:

SELECT inventory_item_id, SUM(primary_qty) primary_qty,
       SUM(item_price + charges + taxes) total_cost
FROM   apps.inl_ship_landed_costs_v
WHERE  organization_id = :p_org_id
GROUP  BY inventory_item_id;

Because PRIMARY_QTY acts as the divisor in UNIT_LANDED_COST, reviews frequently filter or flag rows where PRIMARY_QTY is zero or null to avoid division-related anomalies, even though NVL guards are applied throughout the view definition.