View: INL_SHIPLN_LANDED_COSTS_V

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

View Text

SELECT ISH.SHIP_HEADER_ID
, ISL.SHIP_LINE_GROUP_ID
, IAL.ADJUSTMENT_NUM
, ISL.SHIP_LINE_ID
, ISL.SHIP_LINE_NUM
, ISH.ORGANIZATION_ID
, ISL.INVENTORY_ITEM_ID
, (SELECT SUM(NVL(A.ALLOCATION_AMT
, 0))
FROM INL_ALLOCATIONS A
, INL_ASSOCIATIONS B
WHERE A.SHIP_HEADER_ID = ISH.SHIP_HEADER_ID
AND A.ADJUSTMENT_NUM = IAL.ADJUSTMENT_NUM
AND A.SHIP_LINE_ID = ISL.SHIP_LINE_ID
AND A.LANDED_COST_FLAG = 'Y'
AND A.ASSOCIATION_ID = B.ASSOCIATION_ID (+)
AND ((B.FROM_PARENT_TABLE_NAME IS NULL) OR (B.FROM_PARENT_TABLE_NAME = 'INL_SHIP_LINES'))) ITEM_PRICE
, (SELECT SUM(NVL(A.ALLOCATION_AMT
, 0))
FROM INL_ALLOCATIONS A
, INL_ASSOCIATIONS B
WHERE A.SHIP_HEADER_ID = ISH.SHIP_HEADER_ID
AND A.ADJUSTMENT_NUM = IAL.ADJUSTMENT_NUM
AND A.SHIP_LINE_ID = ISL.SHIP_LINE_ID
AND A.LANDED_COST_FLAG = 'Y'
AND A.ASSOCIATION_ID = B.ASSOCIATION_ID (+)
AND B.FROM_PARENT_TABLE_NAME = 'INL_CHARGE_LINES') CHARGES
, (SELECT SUM(NVL(A.ALLOCATION_AMT
, 0))
FROM INL_ALLOCATIONS A
, INL_ASSOCIATIONS B
WHERE A.SHIP_HEADER_ID = ISH.SHIP_HEADER_ID
AND A.ADJUSTMENT_NUM = IAL.ADJUSTMENT_NUM
AND A.SHIP_LINE_ID = ISL.SHIP_LINE_ID
AND A.LANDED_COST_FLAG = 'Y'
AND A.ASSOCIATION_ID = B.ASSOCIATION_ID (+)
AND B.FROM_PARENT_TABLE_NAME = 'INL_TAX_LINES') TAXES
, SUM(NVL(ISL.PRIMARY_QTY
, 0)) PRIMARY_QTY
, ISL.PRIMARY_UOM_CODE
, (SELECT SUM(NVL(A.ALLOCATION_AMT
, 0))
FROM INL_ALLOCATIONS A
, INL_ASSOCIATIONS B
WHERE A.SHIP_HEADER_ID = ISH.SHIP_HEADER_ID
AND A.ADJUSTMENT_NUM = IAL.ADJUSTMENT_NUM
AND A.SHIP_LINE_ID = ISL.SHIP_LINE_ID
AND A.LANDED_COST_FLAG = 'Y'
AND A.ASSOCIATION_ID = B.ASSOCIATION_ID (+)) / SUM(NVL(ISL.PRIMARY_QTY
, 0)) UNIT_LANDED_COST
FROM INL_SHIP_HEADERS_ALL ISH
, INL_SHIP_LINES_ALL ISL
, INL_ALLOCATIONS IAL
, INL_ASSOCIATIONS IAS
WHERE ISH.SHIP_HEADER_ID = ISL.SHIP_HEADER_ID
AND ISH.SHIP_HEADER_ID = IAL.SHIP_HEADER_ID
AND ISL.SHIP_LINE_ID (+) = IAL.SHIP_LINE_ID
AND IAS.ASSOCIATION_ID (+) = IAL.ASSOCIATION_ID
AND IAL.LANDED_COST_FLAG = 'Y'
AND IAL.ASSOCIATION_ID IS NULL GROUP BY ISH.SHIP_HEADER_ID
, ISL.SHIP_LINE_GROUP_ID
, IAL.ADJUSTMENT_NUM
, ISL.SHIP_LINE_ID
, ISL.SHIP_LINE_NUM
, ISH.ORGANIZATION_ID
, ISL.INVENTORY_ITEM_ID
, ISL.PRIMARY_UOM_CODE
, IAS.FROM_PARENT_TABLE_NAME

Columns