VIEW: APPS.CE_FORECAST_LINES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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