View: INL_SHIP_LANDED_COSTS_V

Product:	INL - Oracle Landed Cost Management
Description:	This view shows landed cost information for a Shipment.
Implementation/DBA Data:	APPS.INL_SHIP_LANDED_COSTS_V

View Text

SELECT SHIP_HEADER_ID
, ADJUSTMENT_NUM
, ORGANIZATION_ID
, INVENTORY_ITEM_ID
, SUM(NVL(ITEM_PRICE
, 0)) ITEM_PRICE
, SUM(NVL(CHARGES
, 0)) CHARGES
, SUM(NVL(TAXES
, 0)) TAXES
, SUM(NVL(PRIMARY_QTY
, 0)) PRIMARY_QTY
, PRIMARY_UOM_CODE
, (SUM(NVL(ITEM_PRICE
, 0))+SUM(NVL(CHARGES
, 0))+SUM(NVL(TAXES
, 0)))/SUM(NVL(PRIMARY_QTY
, 0)) UNIT_LANDED_COST
FROM INL_SHIPLN_LANDED_COSTS_V
FROM INL_SHIPLN_LANDED_COSTS_V GROUP BY SHIP_HEADER_ID
, ADJUSTMENT_NUM
, ORGANIZATION_ID
, INVENTORY_ITEM_ID
, PRIMARY_UOM_CODE

Columns