Product: | CE - Cash Management |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.CE_FORECAST_LINES_AMT_V |
SELECT FCELL.FORECAST_ID
, FCELL.FORECAST_ROW_ID
, SUM(DECODE(FC.DEVELOPER_COLUMN_NUM
, 0
, FCELL.AMOUNT
, 0 ))
, SUM(DECODE(FC.DEVELOPER_COLUMN_NUM
, 1
, FCELL.AMOUNT
, 0 ))
, SUM(DECODE(FC.DEVELOPER_COLUMN_NUM
, 2
, FCELL.AMOUNT
, 0 ))
, SUM(DECODE(FC.DEVELOPER_COLUMN_NUM
, 3
, FCELL.AMOUNT
, 0 ))
, SUM(DECODE(FC.DEVELOPER_COLUMN_NUM
, 4
, FCELL.AMOUNT
, 0 ))
, SUM(DECODE(FC.DEVELOPER_COLUMN_NUM
, 5
, FCELL.AMOUNT
, 0 ))
, SUM(DECODE(FC.DEVELOPER_COLUMN_NUM
, 6
, FCELL.AMOUNT
, 0 ))
, SUM(DECODE(FC.DEVELOPER_COLUMN_NUM
, 7
, FCELL.AMOUNT
, 0 ))
, SUM(DECODE(FC.DEVELOPER_COLUMN_NUM
, 8
, FCELL.AMOUNT
, 0 ))
, SUM(DECODE(FC.DEVELOPER_COLUMN_NUM
, 9
, FCELL.AMOUNT
, 0 ))
, SUM(DECODE(FC.DEVELOPER_COLUMN_NUM
, 10
, FCELL.AMOUNT
, 0 ))
, SUM(DECODE(FC.DEVELOPER_COLUMN_NUM
, 11
, FCELL.AMOUNT
, 0 ))
, SUM(DECODE(FC.DEVELOPER_COLUMN_NUM
, 12
, FCELL.AMOUNT
, 0 ))
, SUM(DECODE(FC.DEVELOPER_COLUMN_NUM
, 13
, FCELL.AMOUNT
, 0 ))
, SUM(DECODE(FC.DEVELOPER_COLUMN_NUM
, 14
, FCELL.AMOUNT
, 0 ))
, SUM(DECODE(FC.DEVELOPER_COLUMN_NUM
, 15
, FCELL.AMOUNT
, 0 ))
, SUM(DECODE(FC.DEVELOPER_COLUMN_NUM
, 16
, FCELL.AMOUNT
, 0 ))
, SUM(DECODE(FC.DEVELOPER_COLUMN_NUM
, 17
, FCELL.AMOUNT
, 0 ))
, SUM(DECODE(FC.DEVELOPER_COLUMN_NUM
, 18
, FCELL.AMOUNT
, 0 ))
, SUM(DECODE(FC.DEVELOPER_COLUMN_NUM
, 19
, FCELL.AMOUNT
, 0 ))
, SUM(DECODE(FC.DEVELOPER_COLUMN_NUM
, 20
, FCELL.AMOUNT
, 0 ))
, SUM(DECODE(FC.DEVELOPER_COLUMN_NUM
, 21
, FCELL.AMOUNT
, 0 ))
, SUM(DECODE(FC.DEVELOPER_COLUMN_NUM
, 22
, FCELL.AMOUNT
, 0 ))
, SUM(DECODE(FC.DEVELOPER_COLUMN_NUM
, 23
, FCELL.AMOUNT
, 0 ))
, SUM(DECODE(FC.DEVELOPER_COLUMN_NUM
, 24
, FCELL.AMOUNT
, 0 ))
, SUM(DECODE(FC.DEVELOPER_COLUMN_NUM
, 25
, FCELL.AMOUNT
, 0 ))
, SUM(DECODE(FC.DEVELOPER_COLUMN_NUM
, 26
, FCELL.AMOUNT
, 0 ))
, SUM(DECODE(FC.DEVELOPER_COLUMN_NUM
, 27
, FCELL.AMOUNT
, 0 ))
, SUM(DECODE(FC.DEVELOPER_COLUMN_NUM
, 28
, FCELL.AMOUNT
, 0 ))
, SUM(DECODE(FC.DEVELOPER_COLUMN_NUM
, 29
, FCELL.AMOUNT
, 0 ))
, SUM(DECODE(FC.DEVELOPER_COLUMN_NUM
, 30
, FCELL.AMOUNT
, 0 ))
, SUM(DECODE(FC.DEVELOPER_COLUMN_NUM
, 31
, FCELL.AMOUNT
, 0 ))
, SUM(DECODE(FC.DEVELOPER_COLUMN_NUM
, 32
, FCELL.AMOUNT
, 0 ))
, SUM(DECODE(FC.DEVELOPER_COLUMN_NUM
, 33
, FCELL.AMOUNT
, 0 ))
, SUM(DECODE(FC.DEVELOPER_COLUMN_NUM
, 34
, FCELL.AMOUNT
, 0 ))
, SUM(DECODE(FC.DEVELOPER_COLUMN_NUM
, 35
, FCELL.AMOUNT
, 0 ))
, SUM(DECODE(FC.DEVELOPER_COLUMN_NUM
, 36
, FCELL.AMOUNT
, 0 ))
, SUM(DECODE(FC.DEVELOPER_COLUMN_NUM
, 37
, FCELL.AMOUNT
, 0 ))
, SUM(DECODE(FC.DEVELOPER_COLUMN_NUM
, 38
, FCELL.AMOUNT
, 0 ))
, SUM(DECODE(FC.DEVELOPER_COLUMN_NUM
, 39
, FCELL.AMOUNT
, 0 ))
, SUM(DECODE(FC.DEVELOPER_COLUMN_NUM
, 40
, FCELL.AMOUNT
, 0 ))
, SUM(DECODE(FC.DEVELOPER_COLUMN_NUM
, 41
, FCELL.AMOUNT
, 0 ))
, SUM(DECODE(FC.DEVELOPER_COLUMN_NUM
, 42
, FCELL.AMOUNT
, 0 ))
, SUM(DECODE(FC.DEVELOPER_COLUMN_NUM
, 43
, FCELL.AMOUNT
, 0 ))
, SUM(DECODE(FC.DEVELOPER_COLUMN_NUM
, 44
, FCELL.AMOUNT
, 0 ))
, SUM(DECODE(FC.DEVELOPER_COLUMN_NUM
, 45
, FCELL.AMOUNT
, 0 ))
, SUM(DECODE(FC.DEVELOPER_COLUMN_NUM
, 46
, FCELL.AMOUNT
, 0 ))
, SUM(DECODE(FC.DEVELOPER_COLUMN_NUM
, 47
, FCELL.AMOUNT
, 0 ))
, SUM(DECODE(FC.DEVELOPER_COLUMN_NUM
, 48
, FCELL.AMOUNT
, 0 ))
, SUM(DECODE(FC.DEVELOPER_COLUMN_NUM
, 49
, FCELL.AMOUNT
, 0 ))
, SUM(DECODE(FC.DEVELOPER_COLUMN_NUM
, 50
, FCELL.AMOUNT
, 0 ))
, SUM(DECODE(FC.DEVELOPER_COLUMN_NUM
, 51
, FCELL.AMOUNT
, 0 ))
, SUM(DECODE(FC.DEVELOPER_COLUMN_NUM
, 52
, FCELL.AMOUNT
, 0 ))
, SUM(DECODE(FC.DEVELOPER_COLUMN_NUM
, 53
, FCELL.AMOUNT
, 0 ))
, SUM(DECODE(FC.DEVELOPER_COLUMN_NUM
, 54
, FCELL.AMOUNT
, 0 ))
, SUM(DECODE(FC.DEVELOPER_COLUMN_NUM
, 55
, FCELL.AMOUNT
, 0 ))
, SUM(DECODE(FC.DEVELOPER_COLUMN_NUM
, 56
, FCELL.AMOUNT
, 0 ))
, SUM(DECODE(FC.DEVELOPER_COLUMN_NUM
, 57
, FCELL.AMOUNT
, 0 ))
, SUM(DECODE(FC.DEVELOPER_COLUMN_NUM
, 58
, FCELL.AMOUNT
, 0 ))
, SUM(DECODE(FC.DEVELOPER_COLUMN_NUM
, 59
, FCELL.AMOUNT
, 0 ))
, SUM(DECODE(FC.DEVELOPER_COLUMN_NUM
, 60
, FCELL.AMOUNT
, 0 ))
, SUM(DECODE(FC.DEVELOPER_COLUMN_NUM
, 61
, FCELL.AMOUNT
, 0 ))
, SUM(DECODE(FC.DEVELOPER_COLUMN_NUM
, 62
, FCELL.AMOUNT
, 0 ))
, SUM(DECODE(FC.DEVELOPER_COLUMN_NUM
, 63
, FCELL.AMOUNT
, 0 ))
, SUM(DECODE(FC.DEVELOPER_COLUMN_NUM
, 64
, FCELL.AMOUNT
, 0 ))
, SUM(DECODE(FC.DEVELOPER_COLUMN_NUM
, 65
, FCELL.AMOUNT
, 0 ))
, SUM(DECODE(FC.DEVELOPER_COLUMN_NUM
, 66
, FCELL.AMOUNT
, 0 ))
, SUM(DECODE(FC.DEVELOPER_COLUMN_NUM
, 67
, FCELL.AMOUNT
, 0 ))
, SUM(DECODE(FC.DEVELOPER_COLUMN_NUM
, 68
, FCELL.AMOUNT
, 0 ))
, SUM(DECODE(FC.DEVELOPER_COLUMN_NUM
, 69
, FCELL.AMOUNT
, 0 ))
, SUM(DECODE(FC.DEVELOPER_COLUMN_NUM
, 70
, FCELL.AMOUNT
, 0 ))
, SUM(DECODE(FC.DEVELOPER_COLUMN_NUM
, 71
, FCELL.AMOUNT
, 0 ))
, SUM(DECODE(FC.DEVELOPER_COLUMN_NUM
, 72
, FCELL.AMOUNT
, 0 ))
, SUM(DECODE(FC.DEVELOPER_COLUMN_NUM
, 73
, FCELL.AMOUNT
, 0 ))
, SUM(DECODE(FC.DEVELOPER_COLUMN_NUM
, 74
, FCELL.AMOUNT
, 0 ))
, SUM(DECODE(FC.DEVELOPER_COLUMN_NUM
, 75
, FCELL.AMOUNT
, 0 ))
, SUM(DECODE(FC.DEVELOPER_COLUMN_NUM
, 76
, FCELL.AMOUNT
, 0 ))
, SUM(DECODE(FC.DEVELOPER_COLUMN_NUM
, 77
, FCELL.AMOUNT
, 0 ))
, SUM(DECODE(FC.DEVELOPER_COLUMN_NUM
, 78
, FCELL.AMOUNT
, 0 ))
, SUM(DECODE(FC.DEVELOPER_COLUMN_NUM
, 79
, FCELL.AMOUNT
, 0 ))
, SUM(DECODE(FC.DEVELOPER_COLUMN_NUM
, 80
, FCELL.AMOUNT
, 0 ))
FROM CE_FORECAST_COLUMNS FC
, CE_FORECAST_CELLS FCELL
WHERE FC.FORECAST_COLUMN_ID = FCELL.FORECAST_COLUMN_ID GROUP BY FCELL.FORECAST_ROW_ID
, FCELL.FORECAST_ID