View: INL_ADJ_ASSOCIATIONS_V

Product:	INL - Oracle Landed Cost Management
Description:	This view shows adjusted associations between landed cost components of the same or different Shipments.
Implementation/DBA Data:	APPS.INL_ADJ_ASSOCIATIONS_V

View Text

SELECT A.ASSOCIATION_ID ASSOCIATION_ID
, A.SHIP_HEADER_ID SHIP_HEADER_ID
, A.FROM_PARENT_TABLE_NAME FROM_PARENT_TABLE_NAME
, DECODE (A.FROM_PARENT_TABLE_NAME
, 'INL_SHIP_LINES'
, (SELECT MAX(SL.SHIP_LINE_ID)
FROM INL_SHIP_LINES_ALL SL
WHERE CONNECT_BY_ISLEAF = 1 START WITH SL.SHIP_LINE_ID = A.FROM_PARENT_TABLE_ID CONNECT BY PRIOR SL.SHIP_LINE_ID = SL.PARENT_SHIP_LINE_ID)
, 'INL_CHARGE_LINES'
, (SELECT MAX(CL.CHARGE_LINE_ID)
FROM INL_CHARGE_LINES CL
WHERE CONNECT_BY_ISLEAF = 1 START WITH CL.CHARGE_LINE_ID = A.FROM_PARENT_TABLE_ID CONNECT BY PRIOR CL.CHARGE_LINE_ID = CL.PARENT_CHARGE_LINE_ID)
, 'INL_TAX_LINES'
, (SELECT MAX(TL.TAX_LINE_ID)
FROM INL_TAX_LINES TL
WHERE CONNECT_BY_ISLEAF = 1 START WITH TL.TAX_LINE_ID = A.FROM_PARENT_TABLE_ID CONNECT BY PRIOR TL.TAX_LINE_ID = TL.PARENT_TAX_LINE_ID)
, A.FROM_PARENT_TABLE_ID) FROM_PARENT_TABLE_ID
, A.TO_PARENT_TABLE_NAME
, DECODE(A.TO_PARENT_TABLE_NAME
, 'INL_SHIP_LINES'
, (SELECT MAX(SL.SHIP_LINE_ID)
FROM INL_SHIP_LINES_ALL SL
WHERE CONNECT_BY_ISLEAF = 1 START WITH SL.SHIP_LINE_ID = A.TO_PARENT_TABLE_ID CONNECT BY PRIOR SL.SHIP_LINE_ID = SL.PARENT_SHIP_LINE_ID)
, 'INL_CHARGE_LINES'
, (SELECT MAX(CL.CHARGE_LINE_ID)
FROM INL_CHARGE_LINES CL
WHERE CONNECT_BY_ISLEAF = 1 START WITH CL.CHARGE_LINE_ID = A.TO_PARENT_TABLE_ID CONNECT BY PRIOR CL.CHARGE_LINE_ID = CL.PARENT_CHARGE_LINE_ID)
, A.TO_PARENT_TABLE_ID) TO_PARENT_TABLE_ID
, A.ALLOCATION_BASIS ALLOCATION_BASIS
, A.ALLOCATION_UOM_CODE ALLOCATION_UOM_CODE
, A.ADJUSTMENT_TYPE_FLAG ADJUSTMENT_TYPE_FLAG
FROM INL_ASSOCIATIONS A

Columns