[Home] [Help]
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
Name |
SHIP_HEADER_ID |
ADJUSTMENT_NUM |
ASSOCIATION_ID |
PARENT_TABLE_NAME |
PARENT_TABLE_ID |
ALLOCATION_AMT |
ASSOC_FROM_PARENT_TABLE_NAME |
ASSOC_FROM_PARENT_TABLE_ID |