[Home] [Help]
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
Name |
SHIP_HEADER_ID |
ADJUSTMENT_NUM |
ORGANIZATION_ID |
INVENTORY_ITEM_ID |
ITEM_PRICE |
CHARGES |
TAXES |
PRIMARY_QTY |
PRIMARY_UOM_CODE |
UNIT_LANDED_COST |