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_FC_RX_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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