View: CE_FC_RX_V

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

View Text

SELECT F1.FORECAST_NAME
, 0
, NULL
, NULL
, F7.COLUMN0
, F1.COLUMN1
, F1.COLUMN2
, F1.COLUMN3
, F1.COLUMN4
, F1.COLUMN5
, F1.COLUMN6
, F1.COLUMN7
, F1.COLUMN8
, F1.COLUMN9
, F1.COLUMN10
, F1.COLUMN11
, F1.COLUMN12
, F2.COLUMN13
, F2.COLUMN14
, F2.COLUMN15
, F2.COLUMN16
, F2.COLUMN17
, F2.COLUMN18
, F2.COLUMN19
, F2.COLUMN20
, F2.COLUMN21
, F2.COLUMN22
, F2.COLUMN23
, F2.COLUMN24
, F3.COLUMN25
, F3.COLUMN26
, F3.COLUMN27
, F3.COLUMN28
, F3.COLUMN29
, F3.COLUMN30
, F3.COLUMN31
, F3.COLUMN32
, F3.COLUMN33
, F3.COLUMN34
, F3.COLUMN35
, F3.COLUMN36
, F4.COLUMN37
, F4.COLUMN38
, F4.COLUMN39
, F4.COLUMN40
, F4.COLUMN41
, F4.COLUMN42
, F4.COLUMN43
, F4.COLUMN44
, F4.COLUMN45
, F4.COLUMN46
, F4.COLUMN47
, F4.COLUMN48
, F5.COLUMN49
, F5.COLUMN50
, F5.COLUMN51
, F5.COLUMN52
, F5.COLUMN53
, F5.COLUMN54
, F5.COLUMN55
, F5.COLUMN56
, F5.COLUMN57
, F5.COLUMN58
, F5.COLUMN59
, F5.COLUMN60
, F6.COLUMN61
, F6.COLUMN62
, F6.COLUMN63
, F6.COLUMN64
, F6.COLUMN65
, F6.COLUMN66
, F6.COLUMN67
, F6.COLUMN68
, F6.COLUMN69
, F6.COLUMN70
, F7.COLUMN71
, F7.COLUMN72
, F7.COLUMN73
, F7.COLUMN74
, F7.COLUMN75
, F7.COLUMN76
, F7.COLUMN77
, F7.COLUMN78
, F7.COLUMN79
, F7.COLUMN80
FROM CE_FC_RX_TITLE1_V F1
, CE_FC_RX_TITLE2_V F2
, CE_FC_RX_TITLE3_V F3
, CE_FC_RX_TITLE4_V F4
, CE_FC_RX_TITLE5_V F5
, CE_FC_RX_TITLE6_V F6
, CE_FC_RX_TITLE7_V F7
WHERE F1.FORECAST_NAME = F2.FORECAST_NAME
AND F2.FORECAST_NAME = F3.FORECAST_NAME
AND F3.FORECAST_NAME = F4.FORECAST_NAME
AND F4.FORECAST_NAME = F5.FORECAST_NAME
AND F5.FORECAST_NAME = F6.FORECAST_NAME
AND F6.FORECAST_NAME = F7.FORECAST_NAME UNION SELECT F.NAME
, FR.ROW_NUMBER
, L.MEANING
, FR.DESCRIPTION
, TO_CHAR(FL.COLUMN0)
, TO_CHAR(FL.COLUMN1)
, TO_CHAR(FL.COLUMN2)
, TO_CHAR(FL.COLUMN3)
, TO_CHAR(FL.COLUMN4)
, TO_CHAR(FL.COLUMN5)
, TO_CHAR(FL.COLUMN6)
, TO_CHAR(FL.COLUMN7)
, TO_CHAR(FL.COLUMN8)
, TO_CHAR(FL.COLUMN9)
, TO_CHAR(FL.COLUMN10)
, TO_CHAR(FL.COLUMN11)
, TO_CHAR(FL.COLUMN12)
, TO_CHAR(FL.COLUMN13)
, TO_CHAR(FL.COLUMN14)
, TO_CHAR(FL.COLUMN15)
, TO_CHAR(FL.COLUMN16)
, TO_CHAR(FL.COLUMN17)
, TO_CHAR(FL.COLUMN18)
, TO_CHAR(FL.COLUMN19)
, TO_CHAR(FL.COLUMN20)
, TO_CHAR(FL.COLUMN21)
, TO_CHAR(FL.COLUMN22)
, TO_CHAR(FL.COLUMN23)
, TO_CHAR(FL.COLUMN24)
, TO_CHAR(FL.COLUMN25)
, TO_CHAR(FL.COLUMN26)
, TO_CHAR(FL.COLUMN27)
, TO_CHAR(FL.COLUMN28)
, TO_CHAR(FL.COLUMN29)
, TO_CHAR(FL.COLUMN30)
, TO_CHAR(FL.COLUMN31)
, TO_CHAR(FL.COLUMN32)
, TO_CHAR(FL.COLUMN33)
, TO_CHAR(FL.COLUMN34)
, TO_CHAR(FL.COLUMN35)
, TO_CHAR(FL.COLUMN36)
, TO_CHAR(FL.COLUMN37)
, TO_CHAR(FL.COLUMN38)
, TO_CHAR(FL.COLUMN39)
, TO_CHAR(FL.COLUMN40)
, TO_CHAR(FL.COLUMN41)
, TO_CHAR(FL.COLUMN42)
, TO_CHAR(FL.COLUMN43)
, TO_CHAR(FL.COLUMN44)
, TO_CHAR(FL.COLUMN45)
, TO_CHAR(FL.COLUMN46)
, TO_CHAR(FL.COLUMN47)
, TO_CHAR(FL.COLUMN48)
, TO_CHAR(FL.COLUMN49)
, TO_CHAR(FL.COLUMN50)
, TO_CHAR(FL.COLUMN51)
, TO_CHAR(FL.COLUMN52)
, TO_CHAR(FL.COLUMN53)
, TO_CHAR(FL.COLUMN54)
, TO_CHAR(FL.COLUMN55)
, TO_CHAR(FL.COLUMN56)
, TO_CHAR(FL.COLUMN57)
, TO_CHAR(FL.COLUMN58)
, TO_CHAR(FL.COLUMN59)
, TO_CHAR(FL.COLUMN60)
, TO_CHAR(FL.COLUMN61)
, TO_CHAR(FL.COLUMN62)
, TO_CHAR(FL.COLUMN63)
, TO_CHAR(FL.COLUMN64)
, TO_CHAR(FL.COLUMN65)
, TO_CHAR(FL.COLUMN66)
, TO_CHAR(FL.COLUMN67)
, TO_CHAR(FL.COLUMN68)
, TO_CHAR(FL.COLUMN69)
, TO_CHAR(FL.COLUMN70)
, TO_CHAR(FL.COLUMN71)
, TO_CHAR(FL.COLUMN72)
, TO_CHAR(FL.COLUMN73)
, TO_CHAR(FL.COLUMN74)
, TO_CHAR(FL.COLUMN75)
, TO_CHAR(FL.COLUMN76)
, TO_CHAR(FL.COLUMN77)
, TO_CHAR(FL.COLUMN78)
, TO_CHAR(FL.COLUMN79)
, TO_CHAR(FL.COLUMN80)
FROM CE_FORECASTS F
, CE_FORECAST_ROWS FR
, CE_LOOKUPS L
, CE_FORECAST_LINES_AMT_V FL
WHERE FR.FORECAST_ROW_ID = FL.FORECAST_ROW_ID
AND FL.FORECAST_ID = F.FORECAST_ID
AND L.LOOKUP_TYPE = 'FORECAST_TRX_TYPE'
AND L.LOOKUP_CODE = FR.TRX_TYPE UNION SELECT F.NAME
, 1000
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
FROM CE_FORECASTS F UNION SELECT F.NAME
, 1001
, LK.MEANING
, NULL
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN0)
, 1
, FS.SIGNED_COLUMN0
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN1)
, 1
, FS.SIGNED_COLUMN1
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN2)
, 1
, FS.SIGNED_COLUMN2
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN3)
, 1
, FS.SIGNED_COLUMN3
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN4)
, 1
, FS.SIGNED_COLUMN4
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN5)
, 1
, FS.SIGNED_COLUMN5
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN6)
, 1
, FS.SIGNED_COLUMN6
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN7)
, 1
, FS.SIGNED_COLUMN7
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN8)
, 1
, FS.SIGNED_COLUMN8
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN9)
, 1
, FS.SIGNED_COLUMN9
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN10)
, 1
, FS.SIGNED_COLUMN10
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN11)
, 1
, FS.SIGNED_COLUMN11
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN12)
, 1
, FS.SIGNED_COLUMN12
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN13)
, 1
, FS.SIGNED_COLUMN13
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN14)
, 1
, FS.SIGNED_COLUMN14
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN15)
, 1
, FS.SIGNED_COLUMN15
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN16)
, 1
, FS.SIGNED_COLUMN16
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN17)
, 1
, FS.SIGNED_COLUMN17
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN18)
, 1
, FS.SIGNED_COLUMN18
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN19)
, 1
, FS.SIGNED_COLUMN19
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN20)
, 1
, FS.SIGNED_COLUMN20
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN21)
, 1
, FS.SIGNED_COLUMN21
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN22)
, 1
, FS.SIGNED_COLUMN22
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN23)
, 1
, FS.SIGNED_COLUMN23
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN24)
, 1
, FS.SIGNED_COLUMN24
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN25)
, 1
, FS.SIGNED_COLUMN25
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN26)
, 1
, FS.SIGNED_COLUMN26
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN27)
, 1
, FS.SIGNED_COLUMN27
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN28)
, 1
, FS.SIGNED_COLUMN28
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN29)
, 1
, FS.SIGNED_COLUMN29
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN30)
, 1
, FS.SIGNED_COLUMN30
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN31)
, 1
, FS.SIGNED_COLUMN31
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN32)
, 1
, FS.SIGNED_COLUMN32
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN33)
, 1
, FS.SIGNED_COLUMN33
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN34)
, 1
, FS.SIGNED_COLUMN34
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN35)
, 1
, FS.SIGNED_COLUMN35
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN36)
, 1
, FS.SIGNED_COLUMN36
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN37)
, 1
, FS.SIGNED_COLUMN37
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN38)
, 1
, FS.SIGNED_COLUMN38
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN39)
, 1
, FS.SIGNED_COLUMN39
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN40)
, 1
, FS.SIGNED_COLUMN40
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN41)
, 1
, FS.SIGNED_COLUMN41
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN42)
, 1
, FS.SIGNED_COLUMN42
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN43)
, 1
, FS.SIGNED_COLUMN43
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN44)
, 1
, FS.SIGNED_COLUMN44
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN45)
, 1
, FS.SIGNED_COLUMN45
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN46)
, 1
, FS.SIGNED_COLUMN46
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN47)
, 1
, FS.SIGNED_COLUMN47
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN48)
, 1
, FS.SIGNED_COLUMN48
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN49)
, 1
, FS.SIGNED_COLUMN49
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN50)
, 1
, FS.SIGNED_COLUMN50
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN51)
, 1
, FS.SIGNED_COLUMN51
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN52)
, 1
, FS.SIGNED_COLUMN52
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN53)
, 1
, FS.SIGNED_COLUMN53
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN54)
, 1
, FS.SIGNED_COLUMN54
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN55)
, 1
, FS.SIGNED_COLUMN55
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN56)
, 1
, FS.SIGNED_COLUMN56
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN57)
, 1
, FS.SIGNED_COLUMN57
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN58)
, 1
, FS.SIGNED_COLUMN58
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN59)
, 1
, FS.SIGNED_COLUMN59
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN60)
, 1
, FS.SIGNED_COLUMN60
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN61)
, 1
, FS.SIGNED_COLUMN61
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN62)
, 1
, FS.SIGNED_COLUMN62
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN63)
, 1
, FS.SIGNED_COLUMN63
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN64)
, 1
, FS.SIGNED_COLUMN64
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN65)
, 1
, FS.SIGNED_COLUMN65
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN66)
, 1
, FS.SIGNED_COLUMN66
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN67)
, 1
, FS.SIGNED_COLUMN67
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN68)
, 1
, FS.SIGNED_COLUMN68
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN69)
, 1
, FS.SIGNED_COLUMN69
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN70)
, 1
, FS.SIGNED_COLUMN70
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN71)
, 1
, FS.SIGNED_COLUMN71
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN72)
, 1
, FS.SIGNED_COLUMN72
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN73)
, 1
, FS.SIGNED_COLUMN73
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN74)
, 1
, FS.SIGNED_COLUMN74
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN75)
, 1
, FS.SIGNED_COLUMN75
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN76)
, 1
, FS.SIGNED_COLUMN76
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN77)
, 1
, FS.SIGNED_COLUMN77
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN78)
, 1
, FS.SIGNED_COLUMN78
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN79)
, 1
, FS.SIGNED_COLUMN79
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN80)
, 1
, FS.SIGNED_COLUMN80
, 0)))
FROM CE_FORECASTS F
, CE_FC_RX_SUMMARY_V FS
, CE_LOOKUPS LK
WHERE FS.FORECAST_ID = F.FORECAST_ID
AND LK.LOOKUP_TYPE = 'RX_SUMMARY_TITLE'
AND LK.LOOKUP_CODE = 'INFLOW' GROUP BY F.NAME
, LK.MEANING UNION SELECT F.NAME
, 1002
, LK.MEANING
, NULL
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN0)
, -1
, -FS.SIGNED_COLUMN0
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN1)
, -1
, -FS.SIGNED_COLUMN1
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN2)
, -1
, -FS.SIGNED_COLUMN2
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN3)
, -1
, -FS.SIGNED_COLUMN3
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN4)
, -1
, -FS.SIGNED_COLUMN4
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN5)
, -1
, -FS.SIGNED_COLUMN5
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN6)
, -1
, -FS.SIGNED_COLUMN6
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN7)
, -1
, -FS.SIGNED_COLUMN7
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN8)
, -1
, -FS.SIGNED_COLUMN8
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN9)
, -1
, -FS.SIGNED_COLUMN9
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN10)
, -1
, -FS.SIGNED_COLUMN10
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN11)
, -1
, -FS.SIGNED_COLUMN11
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN12)
, -1
, -FS.SIGNED_COLUMN12
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN13)
, -1
, -FS.SIGNED_COLUMN13
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN14)
, -1
, -FS.SIGNED_COLUMN14
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN15)
, -1
, -FS.SIGNED_COLUMN15
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN16)
, -1
, -FS.SIGNED_COLUMN16
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN17)
, -1
, -FS.SIGNED_COLUMN17
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN18)
, -1
, -FS.SIGNED_COLUMN18
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN19)
, -1
, -FS.SIGNED_COLUMN19
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN20)
, -1
, -FS.SIGNED_COLUMN20
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN21)
, -1
, -FS.SIGNED_COLUMN21
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN22)
, -1
, -FS.SIGNED_COLUMN22
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN23)
, -1
, -FS.SIGNED_COLUMN23
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN24)
, -1
, -FS.SIGNED_COLUMN24
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN25)
, -1
, -FS.SIGNED_COLUMN25
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN26)
, -1
, -FS.SIGNED_COLUMN26
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN27)
, -1
, -FS.SIGNED_COLUMN27
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN28)
, -1
, -FS.SIGNED_COLUMN28
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN29)
, -1
, -FS.SIGNED_COLUMN29
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN30)
, -1
, -FS.SIGNED_COLUMN30
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN31)
, -1
, -FS.SIGNED_COLUMN31
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN32)
, -1
, -FS.SIGNED_COLUMN32
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN33)
, -1
, -FS.SIGNED_COLUMN33
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN34)
, -1
, -FS.SIGNED_COLUMN34
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN35)
, -1
, -FS.SIGNED_COLUMN35
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN36)
, -1
, -FS.SIGNED_COLUMN36
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN37)
, -1
, -FS.SIGNED_COLUMN37
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN38)
, -1
, -FS.SIGNED_COLUMN38
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN39)
, -1
, -FS.SIGNED_COLUMN39
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN40)
, -1
, -FS.SIGNED_COLUMN40
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN41)
, -1
, -FS.SIGNED_COLUMN41
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN42)
, -1
, -FS.SIGNED_COLUMN42
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN43)
, -1
, -FS.SIGNED_COLUMN43
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN44)
, -1
, -FS.SIGNED_COLUMN44
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN45)
, -1
, -FS.SIGNED_COLUMN45
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN46)
, -1
, -FS.SIGNED_COLUMN46
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN47)
, -1
, -FS.SIGNED_COLUMN47
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN48)
, -1
, -FS.SIGNED_COLUMN48
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN49)
, -1
, -FS.SIGNED_COLUMN49
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN50)
, -1
, -FS.SIGNED_COLUMN50
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN51)
, -1
, -FS.SIGNED_COLUMN51
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN52)
, -1
, -FS.SIGNED_COLUMN52
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN53)
, -1
, -FS.SIGNED_COLUMN53
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN54)
, -1
, -FS.SIGNED_COLUMN54
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN55)
, -1
, -FS.SIGNED_COLUMN55
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN56)
, -1
, -FS.SIGNED_COLUMN56
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN57)
, -1
, -FS.SIGNED_COLUMN57
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN58)
, -1
, -FS.SIGNED_COLUMN58
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN59)
, -1
, -FS.SIGNED_COLUMN59
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN60)
, -1
, -FS.SIGNED_COLUMN60
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN61)
, -1
, -FS.SIGNED_COLUMN61
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN62)
, -1
, -FS.SIGNED_COLUMN62
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN63)
, -1
, -FS.SIGNED_COLUMN63
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN64)
, -1
, -FS.SIGNED_COLUMN64
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN65)
, -1
, -FS.SIGNED_COLUMN65
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN66)
, -1
, -FS.SIGNED_COLUMN66
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN67)
, -1
, -FS.SIGNED_COLUMN67
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN68)
, -1
, -FS.SIGNED_COLUMN68
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN69)
, -1
, -FS.SIGNED_COLUMN69
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN70)
, -1
, -FS.SIGNED_COLUMN70
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN71)
, -1
, -FS.SIGNED_COLUMN71
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN72)
, -1
, -FS.SIGNED_COLUMN72
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN73)
, -1
, -FS.SIGNED_COLUMN73
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN74)
, -1
, -FS.SIGNED_COLUMN74
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN75)
, -1
, -FS.SIGNED_COLUMN75
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN76)
, -1
, -FS.SIGNED_COLUMN76
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN77)
, -1
, -FS.SIGNED_COLUMN77
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN78)
, -1
, -FS.SIGNED_COLUMN78
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN79)
, -1
, -FS.SIGNED_COLUMN79
, 0)))
, TO_CHAR(SUM(DECODE(SIGN(FS.SIGNED_COLUMN80)
, -1
, -FS.SIGNED_COLUMN80
, 0)))
FROM CE_FORECASTS F
, CE_FC_RX_SUMMARY_V FS
, CE_LOOKUPS LK
WHERE FS.FORECAST_ID = F.FORECAST_ID
AND LK.LOOKUP_TYPE = 'RX_SUMMARY_TITLE'
AND LK.LOOKUP_CODE = 'OUTFLOW' GROUP BY F.NAME
, LK.MEANING UNION SELECT F.NAME
, 1003
, LK.MEANING
, NULL
, TO_CHAR(SUM(FS.SIGNED_COLUMN0))
, TO_CHAR(SUM(FS.SIGNED_COLUMN1))
, TO_CHAR(SUM(FS.SIGNED_COLUMN2))
, TO_CHAR(SUM(FS.SIGNED_COLUMN3))
, TO_CHAR(SUM(FS.SIGNED_COLUMN4))
, TO_CHAR(SUM(FS.SIGNED_COLUMN5))
, TO_CHAR(SUM(FS.SIGNED_COLUMN6))
, TO_CHAR(SUM(FS.SIGNED_COLUMN7))
, TO_CHAR(SUM(FS.SIGNED_COLUMN8))
, TO_CHAR(SUM(FS.SIGNED_COLUMN9))
, TO_CHAR(SUM(FS.SIGNED_COLUMN10))
, TO_CHAR(SUM(FS.SIGNED_COLUMN11))
, TO_CHAR(SUM(FS.SIGNED_COLUMN12))
, TO_CHAR(SUM(FS.SIGNED_COLUMN13))
, TO_CHAR(SUM(FS.SIGNED_COLUMN14))
, TO_CHAR(SUM(FS.SIGNED_COLUMN15))
, TO_CHAR(SUM(FS.SIGNED_COLUMN16))
, TO_CHAR(SUM(FS.SIGNED_COLUMN17))
, TO_CHAR(SUM(FS.SIGNED_COLUMN18))
, TO_CHAR(SUM(FS.SIGNED_COLUMN19))
, TO_CHAR(SUM(FS.SIGNED_COLUMN20))
, TO_CHAR(SUM(FS.SIGNED_COLUMN21))
, TO_CHAR(SUM(FS.SIGNED_COLUMN22))
, TO_CHAR(SUM(FS.SIGNED_COLUMN23))
, TO_CHAR(SUM(FS.SIGNED_COLUMN24))
, TO_CHAR(SUM(FS.SIGNED_COLUMN25))
, TO_CHAR(SUM(FS.SIGNED_COLUMN26))
, TO_CHAR(SUM(FS.SIGNED_COLUMN27))
, TO_CHAR(SUM(FS.SIGNED_COLUMN28))
, TO_CHAR(SUM(FS.SIGNED_COLUMN29))
, TO_CHAR(SUM(FS.SIGNED_COLUMN30))
, TO_CHAR(SUM(FS.SIGNED_COLUMN31))
, TO_CHAR(SUM(FS.SIGNED_COLUMN32))
, TO_CHAR(SUM(FS.SIGNED_COLUMN33))
, TO_CHAR(SUM(FS.SIGNED_COLUMN34))
, TO_CHAR(SUM(FS.SIGNED_COLUMN35))
, TO_CHAR(SUM(FS.SIGNED_COLUMN36))
, TO_CHAR(SUM(FS.SIGNED_COLUMN37))
, TO_CHAR(SUM(FS.SIGNED_COLUMN38))
, TO_CHAR(SUM(FS.SIGNED_COLUMN39))
, TO_CHAR(SUM(FS.SIGNED_COLUMN40))
, TO_CHAR(SUM(FS.SIGNED_COLUMN41))
, TO_CHAR(SUM(FS.SIGNED_COLUMN42))
, TO_CHAR(SUM(FS.SIGNED_COLUMN43))
, TO_CHAR(SUM(FS.SIGNED_COLUMN44))
, TO_CHAR(SUM(FS.SIGNED_COLUMN45))
, TO_CHAR(SUM(FS.SIGNED_COLUMN46))
, TO_CHAR(SUM(FS.SIGNED_COLUMN47))
, TO_CHAR(SUM(FS.SIGNED_COLUMN48))
, TO_CHAR(SUM(FS.SIGNED_COLUMN49))
, TO_CHAR(SUM(FS.SIGNED_COLUMN50))
, TO_CHAR(SUM(FS.SIGNED_COLUMN51))
, TO_CHAR(SUM(FS.SIGNED_COLUMN52))
, TO_CHAR(SUM(FS.SIGNED_COLUMN53))
, TO_CHAR(SUM(FS.SIGNED_COLUMN54))
, TO_CHAR(SUM(FS.SIGNED_COLUMN55))
, TO_CHAR(SUM(FS.SIGNED_COLUMN56))
, TO_CHAR(SUM(FS.SIGNED_COLUMN57))
, TO_CHAR(SUM(FS.SIGNED_COLUMN58))
, TO_CHAR(SUM(FS.SIGNED_COLUMN59))
, TO_CHAR(SUM(FS.SIGNED_COLUMN60))
, TO_CHAR(SUM(FS.SIGNED_COLUMN61))
, TO_CHAR(SUM(FS.SIGNED_COLUMN62))
, TO_CHAR(SUM(FS.SIGNED_COLUMN63))
, TO_CHAR(SUM(FS.SIGNED_COLUMN64))
, TO_CHAR(SUM(FS.SIGNED_COLUMN65))
, TO_CHAR(SUM(FS.SIGNED_COLUMN66))
, TO_CHAR(SUM(FS.SIGNED_COLUMN67))
, TO_CHAR(SUM(FS.SIGNED_COLUMN68))
, TO_CHAR(SUM(FS.SIGNED_COLUMN69))
, TO_CHAR(SUM(FS.SIGNED_COLUMN70))
, TO_CHAR(SUM(FS.SIGNED_COLUMN71))
, TO_CHAR(SUM(FS.SIGNED_COLUMN72))
, TO_CHAR(SUM(FS.SIGNED_COLUMN73))
, TO_CHAR(SUM(FS.SIGNED_COLUMN74))
, TO_CHAR(SUM(FS.SIGNED_COLUMN75))
, TO_CHAR(SUM(FS.SIGNED_COLUMN76))
, TO_CHAR(SUM(FS.SIGNED_COLUMN77))
, TO_CHAR(SUM(FS.SIGNED_COLUMN78))
, TO_CHAR(SUM(FS.SIGNED_COLUMN79))
, TO_CHAR(SUM(FS.SIGNED_COLUMN80))
FROM CE_FORECASTS F
, CE_FC_RX_SUMMARY_V FS
, CE_LOOKUPS LK
WHERE FS.FORECAST_ID = F.FORECAST_ID
AND LK.LOOKUP_TYPE = 'RX_SUMMARY_TITLE'
AND LK.LOOKUP_CODE = 'NET' GROUP BY F.NAME
, LK.MEANING

Columns