View: INL_DET_LANDED_COSTS_V

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

View Text

SELECT CAS.SHIP_HEADER_ID
, CAS.ADJUSTMENT_NUM
, CAS.SHIP_LINE_GROUP_ID
, CAS.SHIP_LINE_ID
, CAS.ORGANIZATION_ID
, CAS.INVENTORY_ITEM_ID
, MSI.CONCATENATED_SEGMENTS AS INV_ITEM
, CAS.PRIMARY_QTY
, MUO.UNIT_OF_MEASURE
, SUM(CAS.ALLOCATION_AMT) AS ALLOCATED_AMT
, SUM((SELECT (CAS.ALLOCATION_AMT*100)/SUM(NVL(A.ALLOCATION_AMT
, 0))
FROM INL_ALLOCATION_SUMMARY_V A
FROM INL_ALLOCATION_SUMMARY_V A
WHERE A.SHIP_LINE_ID = CAS.SHIP_LINE_ID
AND A.INVENTORY_ITEM_ID = CAS.INVENTORY_ITEM_ID
AND A.ORGANIZATION_ID = CAS.ORGANIZATION_ID
AND A.SHIP_HEADER_ID = CAS.SHIP_HEADER_ID
AND A.ADJUSTMENT_NUM = CAS.ADJUSTMENT_NUM
AND A.LANDED_COST_FLAG = 'Y')) AS ALLOCATION_PERCENT
, DECODE(CAS.ASSOC_FROM_PARENT_TABLE_NAME
, 'INL_CHARGE_LINES'
, 'CHARGE'
, 'INL_TAX_LINES'
, 'TAX'
, 'ITEM PRICE') AS COMPONENT_TYPE
, DECODE(CAS.ASSOC_FROM_PARENT_TABLE_NAME
, 'INL_SHIP_HEADERS'
, 'OTHERS'
, 'INL_SHIP_LINES'
, 'OTHERS'
, 'INL_CHARGE_LINES'
, CLT.CHARGE_LINE_TYPE_NAME
, 'INL_TAX_LINES'
, CTA.TAX_CODE
, MSI.CONCATENATED_SEGMENTS) AS COMPONENT_NAME
FROM INL_ALLOCATION_SUMMARY_V CAS
, INL_SHIP_LANDED_COSTS_V CUC
, INL_TAX_LINES CTA
, INL_CHARGE_LINE_TYPES_VL CLT
, INL_CHARGE_LINES CCH
, MTL_SYSTEM_ITEMS_VL MSI
, MTL_UNITS_OF_MEASURE_VL MUO
WHERE CAS.SHIP_HEADER_ID = CUC.SHIP_HEADER_ID
AND CAS.ADJUSTMENT_NUM = CUC.ADJUSTMENT_NUM
AND CAS.INVENTORY_ITEM_ID = CUC.INVENTORY_ITEM_ID
AND MSI.INVENTORY_ITEM_ID = CAS.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID = CAS.ORGANIZATION_ID
AND MUO.UOM_CODE = CUC.PRIMARY_UOM_CODE
AND CTA.TAX_LINE_ID (+) = DECODE(CAS.ASSOC_FROM_PARENT_TABLE_NAME
, 'INL_TAX_LINES'
, CAS.ASSOC_FROM_PARENT_TABLE_ID
, NULL)
AND CLT.CHARGE_LINE_TYPE_ID (+) = CCH.CHARGE_LINE_TYPE_ID
AND CCH.CHARGE_LINE_ID (+) = DECODE(CAS.ASSOC_FROM_PARENT_TABLE_NAME
, 'INL_CHARGE_LINES'
, CAS.ASSOC_FROM_PARENT_TABLE_ID
, NULL)
AND CAS.LANDED_COST_FLAG = 'Y' GROUP BY CAS.SHIP_HEADER_ID
, CAS.ADJUSTMENT_NUM
, CAS.SHIP_LINE_GROUP_ID
, CAS.SHIP_LINE_ID
, CAS.PRIMARY_QTY
, CAS.ORGANIZATION_ID
, CAS.INVENTORY_ITEM_ID
, MSI.CONCATENATED_SEGMENTS
, CAS.ORGANIZATION_ID
, CUC.PRIMARY_UOM_CODE
, MSI.SEGMENT1
, MUO.UNIT_OF_MEASURE
, CCH.CHARGE_LINE_TYPE_ID
, CTA.TAX_CODE
, DECODE(CAS.ASSOC_FROM_PARENT_TABLE_NAME
, 'INL_CHARGE_LINES'
, 'CHARGE'
, 'INL_TAX_LINES'
, 'TAX'
, 'ITEM PRICE')
, DECODE(CAS.ASSOC_FROM_PARENT_TABLE_NAME
, 'INL_SHIP_HEADERS'
, 'OTHERS'
, 'INL_SHIP_LINES'
, 'OTHERS'
, 'INL_CHARGE_LINES'
, CLT.CHARGE_LINE_TYPE_NAME
, 'INL_TAX_LINES'
, CTA.TAX_CODE
, MSI.CONCATENATED_SEGMENTS)

Columns