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.

[Home] [Help]

View: CE_FORECAST_LINES_CELLID_V

Product:	CE - Cash Management
Description:	- Retrofitted
Implementation/DBA Data:	APPS.CE_FORECAST_LINES_CELLID_V

View Text

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

Columns

Name
FORECAST_ID
FORECAST_ROW_ID
COLUMN0_CELLID
COLUMN1_CELLID
COLUMN2_CELLID
COLUMN3_CELLID
COLUMN4_CELLID
COLUMN5_CELLID
COLUMN6_CELLID
COLUMN7_CELLID
COLUMN8_CELLID
COLUMN9_CELLID
COLUMN10_CELLID
COLUMN11_CELLID
COLUMN12_CELLID
COLUMN13_CELLID
COLUMN14_CELLID
COLUMN15_CELLID
COLUMN16_CELLID
COLUMN17_CELLID
COLUMN18_CELLID
COLUMN19_CELLID
COLUMN20_CELLID
COLUMN21_CELLID
COLUMN22_CELLID
COLUMN23_CELLID
COLUMN24_CELLID
COLUMN25_CELLID
COLUMN26_CELLID
COLUMN27_CELLID
COLUMN28_CELLID
COLUMN29_CELLID
COLUMN30_CELLID
COLUMN31_CELLID
COLUMN32_CELLID
COLUMN33_CELLID
COLUMN34_CELLID
COLUMN35_CELLID
COLUMN36_CELLID
COLUMN37_CELLID
COLUMN38_CELLID
COLUMN39_CELLID
COLUMN40_CELLID
COLUMN41_CELLID
COLUMN42_CELLID
COLUMN43_CELLID
COLUMN44_CELLID
COLUMN45_CELLID
COLUMN46_CELLID
COLUMN47_CELLID
COLUMN48_CELLID
COLUMN49_CELLID
COLUMN50_CELLID
COLUMN51_CELLID
COLUMN52_CELLID
COLUMN53_CELLID
COLUMN54_CELLID
COLUMN55_CELLID
COLUMN56_CELLID
COLUMN57_CELLID
COLUMN58_CELLID
COLUMN59_CELLID
COLUMN60_CELLID
COLUMN61_CELLID
COLUMN62_CELLID
COLUMN63_CELLID
COLUMN64_CELLID
COLUMN65_CELLID
COLUMN66_CELLID
COLUMN67_CELLID
COLUMN68_CELLID
COLUMN69_CELLID
COLUMN70_CELLID
COLUMN71_CELLID
COLUMN72_CELLID
COLUMN73_CELLID
COLUMN74_CELLID
COLUMN75_CELLID
COLUMN76_CELLID
COLUMN77_CELLID
COLUMN78_CELLID
COLUMN79_CELLID
COLUMN80_CELLID