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_V

Source

View Text - Preformatted


SELECT FROW.FORECAST_ROW_ID, FROW.ROW_NUMBER, FROW.TRX_TYPE, CEL.MEANING, FROW.DESCRIPTION, FCELL.FORECAST_ID, DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 0, FCELL.AMOUNT, 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 0, FCELL.AMOUNT, 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 1, FCELL.AMOUNT, 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 1, FCELL.AMOUNT, 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 2, FCELL.AMOUNT, 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 2, FCELL.AMOUNT, 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 3, FCELL.AMOUNT, 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 3, FCELL.AMOUNT, 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 4, FCELL.AMOUNT, 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 4, FCELL.AMOUNT, 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 5, FCELL.AMOUNT, 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 5, FCELL.AMOUNT, 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 6, FCELL.AMOUNT, 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 6, FCELL.AMOUNT, 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 7, FCELL.AMOUNT, 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 7, FCELL.AMOUNT, 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 8, FCELL.AMOUNT, 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 8, FCELL.AMOUNT, 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 9, FCELL.AMOUNT, 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 9, FCELL.AMOUNT, 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 10, FCELL.AMOUNT, 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 10, FCELL.AMOUNT, 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 11, FCELL.AMOUNT, 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 11, FCELL.AMOUNT, 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 12, FCELL.AMOUNT, 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 12, FCELL.AMOUNT, 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 13, FCELL.AMOUNT, 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 13, FCELL.AMOUNT, 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 14, FCELL.AMOUNT, 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 14, FCELL.AMOUNT, 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 15, FCELL.AMOUNT, 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 15, FCELL.AMOUNT, 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 16, FCELL.AMOUNT, 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 16, FCELL.AMOUNT, 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 17, FCELL.AMOUNT, 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 17, FCELL.AMOUNT, 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 18, FCELL.AMOUNT, 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 18, FCELL.AMOUNT, 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 19, FCELL.AMOUNT, 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 19, FCELL.AMOUNT, 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 20, FCELL.AMOUNT, 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 20, FCELL.AMOUNT, 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 21, FCELL.AMOUNT, 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 21, FCELL.AMOUNT, 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 22, FCELL.AMOUNT, 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 22, FCELL.AMOUNT, 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 23, FCELL.AMOUNT, 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 23, FCELL.AMOUNT, 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 24, FCELL.AMOUNT, 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 24, FCELL.AMOUNT, 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 25, FCELL.AMOUNT, 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 25, FCELL.AMOUNT, 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 26, FCELL.AMOUNT, 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 26, FCELL.AMOUNT, 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 27, FCELL.AMOUNT, 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 27, FCELL.AMOUNT, 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 28, FCELL.AMOUNT, 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 28, FCELL.AMOUNT, 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 29, FCELL.AMOUNT, 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 29, FCELL.AMOUNT, 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 30, FCELL.AMOUNT, 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 30, FCELL.AMOUNT, 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 31, FCELL.AMOUNT, 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 31, FCELL.AMOUNT, 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 32, FCELL.AMOUNT, 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 32, FCELL.AMOUNT, 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 33, FCELL.AMOUNT, 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 33, FCELL.AMOUNT, 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 34, FCELL.AMOUNT, 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 34, FCELL.AMOUNT, 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 35, FCELL.AMOUNT, 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 35, FCELL.AMOUNT, 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 36, FCELL.AMOUNT, 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 36, FCELL.AMOUNT, 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 37, FCELL.AMOUNT, 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 37, FCELL.AMOUNT, 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 38, FCELL.AMOUNT, 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 38, FCELL.AMOUNT, 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 39, FCELL.AMOUNT, 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 39, FCELL.AMOUNT, 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 40, FCELL.AMOUNT, 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 40, FCELL.AMOUNT, 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 41, FCELL.AMOUNT, 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 41, FCELL.AMOUNT, 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 42, FCELL.AMOUNT, 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 42, FCELL.AMOUNT, 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 43, FCELL.AMOUNT, 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 43, FCELL.AMOUNT, 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 44, FCELL.AMOUNT, 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 44, FCELL.AMOUNT, 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 45, FCELL.AMOUNT, 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 45, FCELL.AMOUNT, 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 46, FCELL.AMOUNT, 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 46, FCELL.AMOUNT, 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 47, FCELL.AMOUNT, 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 47, FCELL.AMOUNT, 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 48, FCELL.AMOUNT, 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 48, FCELL.AMOUNT, 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 49, FCELL.AMOUNT, 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 49, FCELL.AMOUNT, 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 50, FCELL.AMOUNT, 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 50, FCELL.AMOUNT, 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 51, FCELL.AMOUNT, 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 51, FCELL.AMOUNT, 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 52, FCELL.AMOUNT, 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 52, FCELL.AMOUNT, 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 53, FCELL.AMOUNT, 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 53, FCELL.AMOUNT, 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 54, FCELL.AMOUNT, 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 54, FCELL.AMOUNT, 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 55, FCELL.AMOUNT, 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 55, FCELL.AMOUNT, 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 56, FCELL.AMOUNT, 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 56, FCELL.AMOUNT, 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 57, FCELL.AMOUNT, 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 57, FCELL.AMOUNT, 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 58, FCELL.AMOUNT, 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 58, FCELL.AMOUNT, 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 59, FCELL.AMOUNT, 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 59, FCELL.AMOUNT, 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 60, FCELL.AMOUNT, 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 60, FCELL.AMOUNT, 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 61, FCELL.AMOUNT, 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 61, FCELL.AMOUNT, 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 62, FCELL.AMOUNT, 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 62, FCELL.AMOUNT, 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 63, FCELL.AMOUNT, 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 63, FCELL.AMOUNT, 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 64, FCELL.AMOUNT, 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 64, FCELL.AMOUNT, 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 65, FCELL.AMOUNT, 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 65, FCELL.AMOUNT, 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 66, FCELL.AMOUNT, 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 66, FCELL.AMOUNT, 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 67, FCELL.AMOUNT, 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 67, FCELL.AMOUNT, 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 68, FCELL.AMOUNT, 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 68, FCELL.AMOUNT, 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 69, FCELL.AMOUNT, 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 69, FCELL.AMOUNT, 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 70, FCELL.AMOUNT, 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 70, FCELL.AMOUNT, 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 71, FCELL.AMOUNT, 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 71, FCELL.AMOUNT, 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 72, FCELL.AMOUNT, 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 72, FCELL.AMOUNT, 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 73, FCELL.AMOUNT, 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 73, FCELL.AMOUNT, 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 74, FCELL.AMOUNT, 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 74, FCELL.AMOUNT, 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 75, FCELL.AMOUNT, 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 75, FCELL.AMOUNT, 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 76, FCELL.AMOUNT, 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 76, FCELL.AMOUNT, 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 77, FCELL.AMOUNT, 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 77, FCELL.AMOUNT, 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 78, FCELL.AMOUNT, 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 78, FCELL.AMOUNT, 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 79, FCELL.AMOUNT, 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 79, FCELL.AMOUNT, 0))/F.FACTOR)), DECODE(F.FACTOR,0,SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 80, FCELL.AMOUNT, 0)),ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM, 80, 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, 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.FORECAST_ID = F.FORECAST_ID AND NVL(FCELL.INCLUDE_FLAG,'Y') = 'Y' 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, 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
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 0
, FCELL.AMOUNT
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 0
, FCELL.AMOUNT
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 1
, FCELL.AMOUNT
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 1
, FCELL.AMOUNT
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 2
, FCELL.AMOUNT
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 2
, FCELL.AMOUNT
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 3
, FCELL.AMOUNT
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 3
, FCELL.AMOUNT
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 4
, FCELL.AMOUNT
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 4
, FCELL.AMOUNT
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 5
, FCELL.AMOUNT
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 5
, FCELL.AMOUNT
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 6
, FCELL.AMOUNT
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 6
, FCELL.AMOUNT
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 7
, FCELL.AMOUNT
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 7
, FCELL.AMOUNT
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 8
, FCELL.AMOUNT
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 8
, FCELL.AMOUNT
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 9
, FCELL.AMOUNT
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 9
, FCELL.AMOUNT
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 10
, FCELL.AMOUNT
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 10
, FCELL.AMOUNT
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 11
, FCELL.AMOUNT
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 11
, FCELL.AMOUNT
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 12
, FCELL.AMOUNT
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 12
, FCELL.AMOUNT
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 13
, FCELL.AMOUNT
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 13
, FCELL.AMOUNT
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 14
, FCELL.AMOUNT
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 14
, FCELL.AMOUNT
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 15
, FCELL.AMOUNT
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 15
, FCELL.AMOUNT
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 16
, FCELL.AMOUNT
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 16
, FCELL.AMOUNT
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 17
, FCELL.AMOUNT
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 17
, FCELL.AMOUNT
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 18
, FCELL.AMOUNT
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 18
, FCELL.AMOUNT
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 19
, FCELL.AMOUNT
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 19
, FCELL.AMOUNT
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 20
, FCELL.AMOUNT
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 20
, FCELL.AMOUNT
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 21
, FCELL.AMOUNT
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 21
, FCELL.AMOUNT
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 22
, FCELL.AMOUNT
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 22
, FCELL.AMOUNT
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 23
, FCELL.AMOUNT
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 23
, FCELL.AMOUNT
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 24
, FCELL.AMOUNT
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 24
, FCELL.AMOUNT
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 25
, FCELL.AMOUNT
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 25
, FCELL.AMOUNT
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 26
, FCELL.AMOUNT
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 26
, FCELL.AMOUNT
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 27
, FCELL.AMOUNT
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 27
, FCELL.AMOUNT
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 28
, FCELL.AMOUNT
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 28
, FCELL.AMOUNT
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 29
, FCELL.AMOUNT
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 29
, FCELL.AMOUNT
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 30
, FCELL.AMOUNT
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 30
, FCELL.AMOUNT
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 31
, FCELL.AMOUNT
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 31
, FCELL.AMOUNT
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 32
, FCELL.AMOUNT
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 32
, FCELL.AMOUNT
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 33
, FCELL.AMOUNT
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 33
, FCELL.AMOUNT
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 34
, FCELL.AMOUNT
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 34
, FCELL.AMOUNT
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 35
, FCELL.AMOUNT
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 35
, FCELL.AMOUNT
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 36
, FCELL.AMOUNT
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 36
, FCELL.AMOUNT
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 37
, FCELL.AMOUNT
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 37
, FCELL.AMOUNT
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 38
, FCELL.AMOUNT
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 38
, FCELL.AMOUNT
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 39
, FCELL.AMOUNT
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 39
, FCELL.AMOUNT
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 40
, FCELL.AMOUNT
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 40
, FCELL.AMOUNT
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 41
, FCELL.AMOUNT
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 41
, FCELL.AMOUNT
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 42
, FCELL.AMOUNT
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 42
, FCELL.AMOUNT
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 43
, FCELL.AMOUNT
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 43
, FCELL.AMOUNT
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 44
, FCELL.AMOUNT
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 44
, FCELL.AMOUNT
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 45
, FCELL.AMOUNT
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 45
, FCELL.AMOUNT
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 46
, FCELL.AMOUNT
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 46
, FCELL.AMOUNT
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 47
, FCELL.AMOUNT
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 47
, FCELL.AMOUNT
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 48
, FCELL.AMOUNT
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 48
, FCELL.AMOUNT
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 49
, FCELL.AMOUNT
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 49
, FCELL.AMOUNT
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 50
, FCELL.AMOUNT
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 50
, FCELL.AMOUNT
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 51
, FCELL.AMOUNT
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 51
, FCELL.AMOUNT
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 52
, FCELL.AMOUNT
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 52
, FCELL.AMOUNT
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 53
, FCELL.AMOUNT
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 53
, FCELL.AMOUNT
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 54
, FCELL.AMOUNT
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 54
, FCELL.AMOUNT
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 55
, FCELL.AMOUNT
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 55
, FCELL.AMOUNT
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 56
, FCELL.AMOUNT
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 56
, FCELL.AMOUNT
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 57
, FCELL.AMOUNT
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 57
, FCELL.AMOUNT
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 58
, FCELL.AMOUNT
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 58
, FCELL.AMOUNT
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 59
, FCELL.AMOUNT
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 59
, FCELL.AMOUNT
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 60
, FCELL.AMOUNT
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 60
, FCELL.AMOUNT
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 61
, FCELL.AMOUNT
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 61
, FCELL.AMOUNT
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 62
, FCELL.AMOUNT
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 62
, FCELL.AMOUNT
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 63
, FCELL.AMOUNT
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 63
, FCELL.AMOUNT
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 64
, FCELL.AMOUNT
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 64
, FCELL.AMOUNT
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 65
, FCELL.AMOUNT
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 65
, FCELL.AMOUNT
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 66
, FCELL.AMOUNT
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 66
, FCELL.AMOUNT
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 67
, FCELL.AMOUNT
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 67
, FCELL.AMOUNT
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 68
, FCELL.AMOUNT
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 68
, FCELL.AMOUNT
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 69
, FCELL.AMOUNT
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 69
, FCELL.AMOUNT
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 70
, FCELL.AMOUNT
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 70
, FCELL.AMOUNT
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 71
, FCELL.AMOUNT
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 71
, FCELL.AMOUNT
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 72
, FCELL.AMOUNT
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 72
, FCELL.AMOUNT
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 73
, FCELL.AMOUNT
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 73
, FCELL.AMOUNT
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 74
, FCELL.AMOUNT
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 74
, FCELL.AMOUNT
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 75
, FCELL.AMOUNT
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 75
, FCELL.AMOUNT
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 76
, FCELL.AMOUNT
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 76
, FCELL.AMOUNT
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 77
, FCELL.AMOUNT
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 77
, FCELL.AMOUNT
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 78
, FCELL.AMOUNT
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 78
, FCELL.AMOUNT
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 79
, FCELL.AMOUNT
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 79
, FCELL.AMOUNT
, 0))/F.FACTOR))
, DECODE(F.FACTOR
, 0
, SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 80
, FCELL.AMOUNT
, 0))
, ROUND(SUM(DECODE(FCOL.DEVELOPER_COLUMN_NUM
, 80
, 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
, 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.FORECAST_ID = F.FORECAST_ID
AND NVL(FCELL.INCLUDE_FLAG
, 'Y') = 'Y'
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
, FROW.FORECAST_ROW_ID
, FROW.ROW_NUMBER
, FROW.TRX_TYPE
, CEL.MEANING
, FROW.DESCRIPTION