View: CE_FORECAST_LINES_V

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

View Text

SELECT FR.ROWID
, FL.FORECAST_ID
, FID.FORECAST_ID
, FR.FORECAST_HEADER_ID
, FR.ROW_NUMBER
, FR.TRX_TYPE
, LK.MEANING
, FR.FORECAST_METHOD
, FR.DESCRIPTION
, FL.COLUMN0
, FL.COLUMN1
, FL.COLUMN2
, FL.COLUMN3
, FL.COLUMN4
, FL.COLUMN5
, FL.COLUMN6
, FL.COLUMN7
, FL.COLUMN8
, FL.COLUMN9
, FL.COLUMN10
, FL.COLUMN11
, FL.COLUMN12
, FL.COLUMN13
, FL.COLUMN14
, FL.COLUMN15
, FL.COLUMN16
, FL.COLUMN17
, FL.COLUMN18
, FL.COLUMN19
, FL.COLUMN20
, FL.COLUMN21
, FL.COLUMN22
, FL.COLUMN23
, FL.COLUMN24
, FL.COLUMN25
, FL.COLUMN26
, FL.COLUMN27
, FL.COLUMN28
, FL.COLUMN29
, FL.COLUMN30
, FL.COLUMN31
, FL.COLUMN32
, FL.COLUMN33
, FL.COLUMN34
, FL.COLUMN35
, FL.COLUMN36
, FL.COLUMN37
, FL.COLUMN38
, FL.COLUMN39
, FL.COLUMN40
, FL.COLUMN41
, FL.COLUMN42
, FL.COLUMN43
, FL.COLUMN44
, FL.COLUMN45
, FL.COLUMN46
, FL.COLUMN47
, FL.COLUMN48
, FL.COLUMN49
, FL.COLUMN50
, FL.COLUMN51
, FL.COLUMN52
, FL.COLUMN53
, FL.COLUMN54
, FL.COLUMN55
, FL.COLUMN56
, FL.COLUMN57
, FL.COLUMN58
, FL.COLUMN59
, FL.COLUMN60
, FL.COLUMN61
, FL.COLUMN62
, FL.COLUMN63
, FL.COLUMN64
, FL.COLUMN65
, FL.COLUMN66
, FL.COLUMN67
, FL.COLUMN68
, FL.COLUMN69
, FL.COLUMN70
, FL.COLUMN71
, FL.COLUMN72
, FL.COLUMN73
, FL.COLUMN74
, FL.COLUMN75
, FL.COLUMN76
, FL.COLUMN77
, FL.COLUMN78
, FL.COLUMN79
, FL.COLUMN80
, DECODE(FR.TRX_TYPE
, 'GLB'
, NULL
, 'GLC'
, NULL
, 'GLE'
, NULL
, 'PAY'
, NULL
, 'APP'
, DECODE(FR.FORECAST_METHOD
, 'P'
, NULL
, FL.COLUMN0/CE_FORECASTS_PKG.GET_FACTOR)
, 'ARR'
, DECODE(FR.FORECAST_METHOD
, 'P'
, NULL
, FL.COLUMN0/CE_FORECASTS_PKG.GET_FACTOR)
, FL.COLUMN0/CE_FORECASTS_PKG.GET_FACTOR)
, FL.COLUMN1/CE_FORECASTS_PKG.GET_FACTOR
, FL.COLUMN2/CE_FORECASTS_PKG.GET_FACTOR
, FL.COLUMN3/CE_FORECASTS_PKG.GET_FACTOR
, FL.COLUMN4/CE_FORECASTS_PKG.GET_FACTOR
, FL.COLUMN5/CE_FORECASTS_PKG.GET_FACTOR
, FL.COLUMN6/CE_FORECASTS_PKG.GET_FACTOR
, FL.COLUMN7/CE_FORECASTS_PKG.GET_FACTOR
, FL.COLUMN8/CE_FORECASTS_PKG.GET_FACTOR
, FL.COLUMN9/CE_FORECASTS_PKG.GET_FACTOR
, FL.COLUMN10/CE_FORECASTS_PKG.GET_FACTOR
, FL.COLUMN11/CE_FORECASTS_PKG.GET_FACTOR
, FL.COLUMN12/CE_FORECASTS_PKG.GET_FACTOR
, FL.COLUMN13/CE_FORECASTS_PKG.GET_FACTOR
, FL.COLUMN14/CE_FORECASTS_PKG.GET_FACTOR
, FL.COLUMN15/CE_FORECASTS_PKG.GET_FACTOR
, FL.COLUMN16/CE_FORECASTS_PKG.GET_FACTOR
, FL.COLUMN17/CE_FORECASTS_PKG.GET_FACTOR
, FL.COLUMN18/CE_FORECASTS_PKG.GET_FACTOR
, FL.COLUMN19/CE_FORECASTS_PKG.GET_FACTOR
, FL.COLUMN20/CE_FORECASTS_PKG.GET_FACTOR
, FL.COLUMN21/CE_FORECASTS_PKG.GET_FACTOR
, FL.COLUMN22/CE_FORECASTS_PKG.GET_FACTOR
, FL.COLUMN23/CE_FORECASTS_PKG.GET_FACTOR
, FL.COLUMN24/CE_FORECASTS_PKG.GET_FACTOR
, FL.COLUMN25/CE_FORECASTS_PKG.GET_FACTOR
, FL.COLUMN26/CE_FORECASTS_PKG.GET_FACTOR
, FL.COLUMN27/CE_FORECASTS_PKG.GET_FACTOR
, FL.COLUMN28/CE_FORECASTS_PKG.GET_FACTOR
, FL.COLUMN29/CE_FORECASTS_PKG.GET_FACTOR
, FL.COLUMN30/CE_FORECASTS_PKG.GET_FACTOR
, FL.COLUMN31/CE_FORECASTS_PKG.GET_FACTOR
, FL.COLUMN32/CE_FORECASTS_PKG.GET_FACTOR
, FL.COLUMN33/CE_FORECASTS_PKG.GET_FACTOR
, FL.COLUMN34/CE_FORECASTS_PKG.GET_FACTOR
, FL.COLUMN35/CE_FORECASTS_PKG.GET_FACTOR
, FL.COLUMN36/CE_FORECASTS_PKG.GET_FACTOR
, FL.COLUMN37/CE_FORECASTS_PKG.GET_FACTOR
, FL.COLUMN38/CE_FORECASTS_PKG.GET_FACTOR
, FL.COLUMN39/CE_FORECASTS_PKG.GET_FACTOR
, FL.COLUMN40/CE_FORECASTS_PKG.GET_FACTOR
, FL.COLUMN41/CE_FORECASTS_PKG.GET_FACTOR
, FL.COLUMN42/CE_FORECASTS_PKG.GET_FACTOR
, FL.COLUMN43/CE_FORECASTS_PKG.GET_FACTOR
, FL.COLUMN44/CE_FORECASTS_PKG.GET_FACTOR
, FL.COLUMN45/CE_FORECASTS_PKG.GET_FACTOR
, FL.COLUMN46/CE_FORECASTS_PKG.GET_FACTOR
, FL.COLUMN47/CE_FORECASTS_PKG.GET_FACTOR
, FL.COLUMN48/CE_FORECASTS_PKG.GET_FACTOR
, FL.COLUMN49/CE_FORECASTS_PKG.GET_FACTOR
, FL.COLUMN50/CE_FORECASTS_PKG.GET_FACTOR
, FL.COLUMN51/CE_FORECASTS_PKG.GET_FACTOR
, FL.COLUMN52/CE_FORECASTS_PKG.GET_FACTOR
, FL.COLUMN53/CE_FORECASTS_PKG.GET_FACTOR
, FL.COLUMN54/CE_FORECASTS_PKG.GET_FACTOR
, FL.COLUMN55/CE_FORECASTS_PKG.GET_FACTOR
, FL.COLUMN56/CE_FORECASTS_PKG.GET_FACTOR
, FL.COLUMN57/CE_FORECASTS_PKG.GET_FACTOR
, FL.COLUMN58/CE_FORECASTS_PKG.GET_FACTOR
, FL.COLUMN59/CE_FORECASTS_PKG.GET_FACTOR
, FL.COLUMN60/CE_FORECASTS_PKG.GET_FACTOR
, FL.COLUMN61/CE_FORECASTS_PKG.GET_FACTOR
, FL.COLUMN62/CE_FORECASTS_PKG.GET_FACTOR
, FL.COLUMN63/CE_FORECASTS_PKG.GET_FACTOR
, FL.COLUMN64/CE_FORECASTS_PKG.GET_FACTOR
, FL.COLUMN65/CE_FORECASTS_PKG.GET_FACTOR
, FL.COLUMN66/CE_FORECASTS_PKG.GET_FACTOR
, FL.COLUMN67/CE_FORECASTS_PKG.GET_FACTOR
, FL.COLUMN68/CE_FORECASTS_PKG.GET_FACTOR
, FL.COLUMN69/CE_FORECASTS_PKG.GET_FACTOR
, FL.COLUMN70/CE_FORECASTS_PKG.GET_FACTOR
, FL.COLUMN71/CE_FORECASTS_PKG.GET_FACTOR
, FL.COLUMN72/CE_FORECASTS_PKG.GET_FACTOR
, FL.COLUMN73/CE_FORECASTS_PKG.GET_FACTOR
, FL.COLUMN74/CE_FORECASTS_PKG.GET_FACTOR
, FL.COLUMN75/CE_FORECASTS_PKG.GET_FACTOR
, FL.COLUMN76/CE_FORECASTS_PKG.GET_FACTOR
, FL.COLUMN77/CE_FORECASTS_PKG.GET_FACTOR
, FL.COLUMN78/CE_FORECASTS_PKG.GET_FACTOR
, FL.COLUMN79/CE_FORECASTS_PKG.GET_FACTOR
, FL.COLUMN80/CE_FORECASTS_PKG.GET_FACTOR
, FID.COLUMN0_CELLID
, FID.COLUMN1_CELLID
, FID.COLUMN2_CELLID
, FID.COLUMN3_CELLID
, FID.COLUMN4_CELLID
, FID.COLUMN5_CELLID
, FID.COLUMN6_CELLID
, FID.COLUMN7_CELLID
, FID.COLUMN8_CELLID
, FID.COLUMN9_CELLID
, FID.COLUMN10_CELLID
, FID.COLUMN11_CELLID
, FID.COLUMN12_CELLID
, FID.COLUMN13_CELLID
, FID.COLUMN14_CELLID
, FID.COLUMN15_CELLID
, FID.COLUMN16_CELLID
, FID.COLUMN17_CELLID
, FID.COLUMN18_CELLID
, FID.COLUMN19_CELLID
, FID.COLUMN20_CELLID
, FID.COLUMN21_CELLID
, FID.COLUMN22_CELLID
, FID.COLUMN23_CELLID
, FID.COLUMN24_CELLID
, FID.COLUMN25_CELLID
, FID.COLUMN26_CELLID
, FID.COLUMN27_CELLID
, FID.COLUMN28_CELLID
, FID.COLUMN29_CELLID
, FID.COLUMN30_CELLID
, FID.COLUMN31_CELLID
, FID.COLUMN32_CELLID
, FID.COLUMN33_CELLID
, FID.COLUMN34_CELLID
, FID.COLUMN35_CELLID
, FID.COLUMN36_CELLID
, FID.COLUMN37_CELLID
, FID.COLUMN38_CELLID
, FID.COLUMN39_CELLID
, FID.COLUMN40_CELLID
, FID.COLUMN41_CELLID
, FID.COLUMN42_CELLID
, FID.COLUMN43_CELLID
, FID.COLUMN44_CELLID
, FID.COLUMN45_CELLID
, FID.COLUMN46_CELLID
, FID.COLUMN47_CELLID
, FID.COLUMN48_CELLID
, FID.COLUMN49_CELLID
, FID.COLUMN50_CELLID
, FID.COLUMN51_CELLID
, FID.COLUMN52_CELLID
, FID.COLUMN53_CELLID
, FID.COLUMN54_CELLID
, FID.COLUMN55_CELLID
, FID.COLUMN56_CELLID
, FID.COLUMN57_CELLID
, FID.COLUMN58_CELLID
, FID.COLUMN59_CELLID
, FID.COLUMN60_CELLID
, FID.COLUMN61_CELLID
, FID.COLUMN62_CELLID
, FID.COLUMN63_CELLID
, FID.COLUMN64_CELLID
, FID.COLUMN65_CELLID
, FID.COLUMN66_CELLID
, FID.COLUMN67_CELLID
, FID.COLUMN68_CELLID
, FID.COLUMN69_CELLID
, FID.COLUMN70_CELLID
, FID.COLUMN71_CELLID
, FID.COLUMN72_CELLID
, FID.COLUMN73_CELLID
, FID.COLUMN74_CELLID
, FID.COLUMN75_CELLID
, FID.COLUMN76_CELLID
, FID.COLUMN77_CELLID
, FID.COLUMN78_CELLID
, FID.COLUMN79_CELLID
, FID.COLUMN80_CELLID
FROM CE_FORECAST_ROWS FR
, CE_LOOKUPS LK
, CE_FORECAST_LINES_CELLID_V FID
, CE_FORECAST_LINES_AMT_V FL
WHERE FID.FORECAST_ROW_ID = FR.FORECAST_ROW_ID AND FL.FORECAST_ROW_ID = FR.FORECAST_ROW_ID AND LK.LOOKUP_CODE = FR.TRX_TYPE AND LK.LOOKUP_TYPE = 'FORECAST_TRX_TYPE' AND FID.FORECAST_ID = FL.FORECAST_ID

Columns