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_AMTS_SRC_GLCP_V

Source

View Text - Preformatted


SELECT FROW.FORECAST_ROW_ID, FROW.ROW_NUMBER, FROW.TRX_TYPE, CEL.MEANING, FROW.DESCRIPTION, FCELL.FORECAST_ID, NVL(GLCC.CONCATENATED_SEGMENTS, 'Others'), NVL(FCELL.CODE_COMBINATION_ID, -999), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 0, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 0, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 1, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 1, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 2, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 2, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 3, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 3, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 4, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 4, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 5, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 5, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 6, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 6, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 7, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 7, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 8, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 8, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 9, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 9, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 10, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 10, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 11, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 11, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 12, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 12, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 13, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 13, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 14, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 14, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 15, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 15, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 16, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 16, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 17, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 17, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 18, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 18, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 19, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 19, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 20, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 20, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 21, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 21, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 22, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 22, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 23, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 23, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 24, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 24, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 25, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 25, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 26, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 26, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 27, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 27, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 28, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 28, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 29, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 29, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 30, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 30, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 31, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 31, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 32, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 32, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 33, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 33, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 34, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 34, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 35, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 35, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 36, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 36, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 37, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 37, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 38, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 38, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 39, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 39, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 40, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 40, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 41, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 41, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 42, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 42, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 43, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 43, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 44, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 44, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 45, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 45, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 46, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 46, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 47, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 47, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 48, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 48, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 49, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 49, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 50, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 50, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 51, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 51, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 52, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 52, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 53, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 53, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 54, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 54, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 55, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 55, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 56, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 56, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 57, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 57, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 58, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 58, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 59, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 59, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 60, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 60, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 61, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 61, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 62, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 62, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 63, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 63, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 64, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 64, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 65, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 65, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 66, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 66, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 67, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 67, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 68, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 68, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 69, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 69, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 70, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 70, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 71, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 71, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 72, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 72, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 73, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 73, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 74, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 74, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 75, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 75, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 76, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 76, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 77, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 77, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 78, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 78, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 79, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 79, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 80, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 80, DECODE(FCELL.INCLUDE_FLAG,'N',0,FCELL.AMOUNT), 0))/F.FACTOR)), DECODE(FROW.TRX_TYPE, 'XTI', 'Y', 'XTO', 'Y', 'N') FROM CE_FORECAST_TRX_CELLS FCELL, CE_FORECAST_COLUMNS FCOL, CE_FORECAST_ROWS FROW, CE_LOOKUPS CEL, GL_CODE_COMBINATIONS_KFV GLCC, CE_FORECASTS F WHERE FCELL.FORECAST_COLUMN_ID = FCOL.FORECAST_COLUMN_ID AND FCELL.FORECAST_ROW_ID = FROW.FORECAST_ROW_ID AND CEL.LOOKUP_TYPE = 'FORECAST_TRX_TYPE' AND CEL.LOOKUP_CODE = FROW.TRX_TYPE AND FCELL.CODE_COMBINATION_ID = GLCC.CODE_COMBINATION_ID(+) AND FCELL.FORECAST_ID = F.FORECAST_ID AND (FCELL.ORG_ID is null OR EXISTS (select null from ce_security_profiles_v sec where sec.organization_id = FCELL.ORG_ID and sec.organization_type = decode(FROW.TRX_TYPE, 'PAY', 'BUSINESS_GROUP', 'XTI', 'LEGAL_ENTITY', 'XTO', 'LEGAL_ENTITY', 'XTR', 'LEGAL_ENTITY', 'OPERATING_UNIT'))) GROUP BY FCELL.FORECAST_ID, F.FACTOR, FCELL.CODE_COMBINATION_ID, GLCC.CONCATENATED_SEGMENTS, FROW.FORECAST_ROW_ID, FROW.ROW_NUMBER, FROW.TRX_TYPE, CEL.MEANING, FROW.DESCRIPTION

View Text - HTML Formatted

SELECT FROW.FORECAST_ROW_ID
, FROW.ROW_NUMBER
, FROW.TRX_TYPE
, CEL.MEANING
, FROW.DESCRIPTION
, FCELL.FORECAST_ID
, NVL(GLCC.CONCATENATED_SEGMENTS
, 'OTHERS')
, NVL(FCELL.CODE_COMBINATION_ID
, -999)
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 0
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 0
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 1
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 1
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 2
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 2
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 3
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 3
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 4
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 4
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 5
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 5
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 6
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 6
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 7
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 7
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 8
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 8
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 9
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 9
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 10
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 10
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 11
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 11
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 12
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 12
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 13
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 13
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 14
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 14
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 15
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 15
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 16
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 16
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 17
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 17
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 18
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 18
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 19
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 19
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 20
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 20
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 21
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 21
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 22
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 22
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 23
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 23
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 24
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 24
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 25
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 25
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 26
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 26
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 27
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 27
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 28
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 28
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 29
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 29
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 30
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 30
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 31
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 31
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 32
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 32
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 33
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 33
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 34
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 34
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 35
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 35
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 36
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 36
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 37
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 37
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 38
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 38
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 39
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 39
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 40
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 40
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 41
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 41
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 42
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 42
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 43
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 43
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 44
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 44
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 45
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 45
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 46
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 46
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 47
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 47
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 48
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 48
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 49
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 49
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 50
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 50
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 51
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 51
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 52
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 52
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 53
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 53
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 54
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 54
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 55
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 55
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 56
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 56
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 57
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 57
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 58
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 58
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 59
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 59
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 60
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 60
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 61
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 61
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 62
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 62
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 63
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 63
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 64
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 64
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 65
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 65
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 66
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 66
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 67
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 67
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 68
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 68
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 69
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 69
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 70
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 70
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 71
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 71
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 72
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 72
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 73
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 73
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 74
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 74
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 75
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 75
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 76
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 76
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 77
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 77
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 78
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 78
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 79
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 79
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 80
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 80
, DECODE(FCELL.INCLUDE_FLAG
, 'N'
, 0
, FCELL.AMOUNT)
, 0))/F.FACTOR))
, DECODE(FROW.TRX_TYPE
, 'XTI'
, 'Y'
, 'XTO'
, 'Y'
, 'N')
FROM CE_FORECAST_TRX_CELLS FCELL
, CE_FORECAST_COLUMNS FCOL
, CE_FORECAST_ROWS FROW
, CE_LOOKUPS CEL
, GL_CODE_COMBINATIONS_KFV GLCC
, CE_FORECASTS F
WHERE FCELL.FORECAST_COLUMN_ID = FCOL.FORECAST_COLUMN_ID
AND FCELL.FORECAST_ROW_ID = FROW.FORECAST_ROW_ID
AND CEL.LOOKUP_TYPE = 'FORECAST_TRX_TYPE'
AND CEL.LOOKUP_CODE = FROW.TRX_TYPE
AND FCELL.CODE_COMBINATION_ID = GLCC.CODE_COMBINATION_ID(+)
AND FCELL.FORECAST_ID = F.FORECAST_ID
AND (FCELL.ORG_ID IS NULL OR EXISTS (SELECT NULL
FROM CE_SECURITY_PROFILES_V SEC
WHERE SEC.ORGANIZATION_ID = FCELL.ORG_ID
AND SEC.ORGANIZATION_TYPE = DECODE(FROW.TRX_TYPE
, 'PAY'
, 'BUSINESS_GROUP'
, 'XTI'
, 'LEGAL_ENTITY'
, 'XTO'
, 'LEGAL_ENTITY'
, 'XTR'
, 'LEGAL_ENTITY'
, 'OPERATING_UNIT'))) GROUP BY FCELL.FORECAST_ID
, F.FACTOR
, FCELL.CODE_COMBINATION_ID
, GLCC.CONCATENATED_SEGMENTS
, FROW.FORECAST_ROW_ID
, FROW.ROW_NUMBER
, FROW.TRX_TYPE
, CEL.MEANING
, FROW.DESCRIPTION