View: INL_ALLOCATION_FLOW_V

Product:	INL - Oracle Landed Cost Management
Description:	This view shows information on the flow of the Shipment amounts to get the corresponding Shipment Lines.
Implementation/DBA Data:	APPS.INL_ALLOCATION_FLOW_V

View Text

SELECT ALLOC.SHIP_HEADER_ID
, ALLOC.ADJUSTMENT_NUM
, ALLOC.ASSOCIATION_ID
, ALLOC.FROM_PARENT_TABLE_NAME PARENT_TABLE_NAME
, ALLOC.FROM_PARENT_TABLE_ID PARENT_TABLE_ID
, SUM(ALLOC.ALLOCATION_AMT) * -1 ALLOCATION_AMT
, ASSOC.FROM_PARENT_TABLE_NAME ASSOC_FROM_PARENT_TABLE_NAME
, ASSOC.FROM_PARENT_TABLE_ID ASSOC_FROM_PARENT_TABLE_ID
FROM INL_ASSOCIATIONS ASSOC
, INL_ALLOCATIONS ALLOC
FROM INL_ASSOCIATIONS ASSOC
, INL_ALLOCATIONS ALLOC
WHERE ASSOC.ASSOCIATION_ID = ALLOC.ASSOCIATION_ID GROUP BY ALLOC.SHIP_HEADER_ID
, ALLOC.ADJUSTMENT_NUM
, ALLOC.ASSOCIATION_ID
, ALLOC.FROM_PARENT_TABLE_NAME
, ALLOC.FROM_PARENT_TABLE_ID
, ASSOC.FROM_PARENT_TABLE_NAME
, ASSOC.FROM_PARENT_TABLE_ID UNION ALL SELECT ALLOC.SHIP_HEADER_ID
, ALLOC.ADJUSTMENT_NUM
, ALLOC.ASSOCIATION_ID
, ALLOC.TO_PARENT_TABLE_NAME PARENT_TABLE_NAME
, ALLOC.TO_PARENT_TABLE_ID PARENT_TABLE_ID
, SUM(ALLOC.ALLOCATION_AMT) ALLOCATION_AMT
, ASSOC.FROM_PARENT_TABLE_NAME ASSOC_FROM_PARENT_TABLE_NAME
, ASSOC.FROM_PARENT_TABLE_ID ASSOC_FROM_PARENT_TABLE_ID
FROM INL_ASSOCIATIONS ASSOC
, INL_ALLOCATIONS ALLOC
WHERE ASSOC.ASSOCIATION_ID = ALLOC.ASSOCIATION_ID GROUP BY ALLOC.SHIP_HEADER_ID
, ALLOC.ADJUSTMENT_NUM
, ALLOC.ASSOCIATION_ID
, ALLOC.TO_PARENT_TABLE_NAME
, ALLOC.TO_PARENT_TABLE_ID
, ASSOC.FROM_PARENT_TABLE_NAME
, ASSOC.FROM_PARENT_TABLE_ID

Columns