View: INL_ALLOCATIONS_V

Product:	INL - Oracle Landed Cost Management
Description:	This view shows all amounts of a Shipment, prorated into its Shipment Lines.
Implementation/DBA Data:	APPS.INL_ALLOCATIONS_V

View Text

SELECT A.ALLOCATION_ID
, A.SHIP_HEADER_ID
, A.ASSOCIATION_ID
, A.PARENT_ALLOCATION_ID
, A.FROM_PARENT_TABLE_NAME
, A.FROM_PARENT_TABLE_ID
, A.TO_PARENT_TABLE_NAME
, A.TO_PARENT_TABLE_ID
, A.SHIP_LINE_ID
, A.ADJUSTMENT_NUM
, (SELECT SUM(NVL(IA.ALLOCATION_AMT
, 0))
FROM INL_ALLOCATIONS IA
, INL_SHIP_LINES_ALL IC
WHERE IC.SHIP_LINE_ID = IA.SHIP_LINE_ID
AND IC.SHIP_LINE_ID = B.PARENT_SHIP_LINE_ID
AND IA.ADJUSTMENT_NUM = 0
AND (IA.ALLOCATION_ID = A.ALLOCATION_ID OR (IA.ADJUSTMENT_NUM <> A.ADJUSTMENT_NUM
AND IA.ALLOCATION_ID = A.PARENT_ALLOCATION_ID))) AS ESTIMATED_AMT
, A.ALLOCATION_AMT
, A.LANDED_COST_FLAG
, A.CREATED_BY
, A.CREATION_DATE
, A.LAST_UPDATED_BY
, A.LAST_UPDATE_DATE
, A.LAST_UPDATE_LOGIN
FROM INL_ALLOCATIONS A
, (SELECT ALLOCATION_ID
, NVL(CC.PARENT_SHIP_LINE_ID
, CC.SHIP_LINE_ID) AS PARENT_SHIP_LINE_ID
FROM INL_ALLOCATIONS CA
, INL_SHIP_LINES_ALL CC
WHERE CC.SHIP_LINE_ID = CA.SHIP_LINE_ID
AND CC.SHIP_HEADER_ID = CA.SHIP_HEADER_ID) B
WHERE B.ALLOCATION_ID = A.ALLOCATION_ID
AND A.LANDED_COST_FLAG = 'Y'

Columns