VIEW: APPS.INL_ALLOCATION_FLOW_V

Source

View Text - Preformatted

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 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

View Text - HTML Formatted

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
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