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
, (SELECT IA.ALLOCATION_ID
FROM INL_ALLOCATIONS IA
, INL_SHIP_LINES_ALL IC
FROM INL_ALLOCATIONS IA
, INL_SHIP_LINES_ALL IC
WHERE IC.SHIP_LINE_ID = IA.SHIP_LINE_ID
AND IC.SHIP_HEADER_ID = IA.SHIP_HEADER_ID
AND IA.FROM_PARENT_TABLE_ID = B.PARENT_FROM_PARENT_TABLE_ID
AND IA.TO_PARENT_TABLE_ID = B.PARENT_TO_PARENT_TABLE_ID
AND IA.FROM_PARENT_TABLE_NAME = A.FROM_PARENT_TABLE_NAME
AND IA.TO_PARENT_TABLE_NAME = A.TO_PARENT_TABLE_NAME
AND IA.SHIP_HEADER_ID = A.SHIP_HEADER_ID
AND NVL(IA.ASSOCIATION_ID
, 0) = NVL(A.ASSOCIATION_ID
, 0)
AND IC.SHIP_LINE_ID = B.PARENT_SHIP_LINE_ID
AND IA.ADJUSTMENT_NUM = 0
AND IA.ALLOCATION_ID <> A.ALLOCATION_ID)AS 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 IA.ALLOCATION_AMT
FROM INL_ALLOCATIONS IA
, INL_SHIP_LINES_ALL IC
WHERE IC.SHIP_LINE_ID = IA.SHIP_LINE_ID
AND IC.SHIP_HEADER_ID = IA.SHIP_HEADER_ID
AND IA.FROM_PARENT_TABLE_ID = B.PARENT_FROM_PARENT_TABLE_ID
AND IA.TO_PARENT_TABLE_ID = B.PARENT_TO_PARENT_TABLE_ID
AND IA.FROM_PARENT_TABLE_NAME = A.FROM_PARENT_TABLE_NAME
AND IA.TO_PARENT_TABLE_NAME = A.TO_PARENT_TABLE_NAME
AND IA.SHIP_HEADER_ID = A.SHIP_HEADER_ID
AND NVL(IA.ASSOCIATION_ID
, 0) = NVL(A.ASSOCIATION_ID
, 0)
AND IC.SHIP_LINE_ID = B.PARENT_SHIP_LINE_ID
AND IA.ADJUSTMENT_NUM = 0 )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
, DECODE(FROM_PARENT_TABLE_NAME
, 'INL_CHARGE_LINES'
, (SELECT NVL(ICC.PARENT_CHARGE_LINE_ID
, CHARGE_LINE_ID)
FROM INL_CHARGE_LINES ICC
WHERE ICC.CHARGE_LINE_ID = CA.FROM_PARENT_TABLE_ID)
, DECODE(FROM_PARENT_TABLE_NAME
, 'INL_SHIP_LINES'
, (SELECT NVL(IOL.PARENT_SHIP_LINE_ID
, SHIP_LINE_ID)
FROM INL_SHIP_LINES_ALL IOL
WHERE IOL.SHIP_LINE_ID = CA.FROM_PARENT_TABLE_ID )
, FROM_PARENT_TABLE_ID)) AS PARENT_FROM_PARENT_TABLE_ID
, DECODE(TO_PARENT_TABLE_NAME
, 'INL_CHARGE_LINES'
, (SELECT NVL(ICC.PARENT_CHARGE_LINE_ID
, CHARGE_LINE_ID)
FROM INL_CHARGE_LINES ICC
WHERE ICC.CHARGE_LINE_ID = CA.TO_PARENT_TABLE_ID)
, DECODE(TO_PARENT_TABLE_NAME
, 'INL_SHIP_LINES'
, (SELECT NVL(IOL.PARENT_SHIP_LINE_ID
, SHIP_LINE_ID)
FROM INL_SHIP_LINES_ALL IOL
WHERE IOL.SHIP_LINE_ID = CA.TO_PARENT_TABLE_ID )
, TO_PARENT_TABLE_ID)) AS PARENT_TO_PARENT_TABLE_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