eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.CE_FORECAST_LINES_AMT_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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