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.

[Home] [Help]

View: CE_FC_AMTS_SRC_BANK_V

Product:	CE - Cash Management
Description:	This is a new view created to group forecast results for a particular bank account by transaction source type
Implementation/DBA Data:	APPS.CE_FC_AMTS_SRC_BANK_V

View Text

SELECT FROW.FORECAST_ROW_ID
, FROW.ROW_NUMBER
, FROW.TRX_TYPE
, CEL.MEANING
, FROW.DESCRIPTION
, FCELL.FORECAST_ID
, NVL(BA.BANK_ACCOUNT_ID
, -999)
, NVL(BA.BANK_ACCOUNT_NAME
, 'OTHERS')
, NVL(BA.BANK_ACCOUNT_NUM
, '')
, NVL(BA.CURRENCY_CODE
, '')
, 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
, CE_BANK_ACCOUNTS BA
, 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.BANK_ACCOUNT_ID = BA.BANK_ACCOUNT_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
, BA.BANK_ACCOUNT_ID
, BA.BANK_ACCOUNT_NAME
, BA.BANK_ACCOUNT_NUM
, BA.CURRENCY_CODE
, FROW.FORECAST_ROW_ID
, FROW.ROW_NUMBER
, FROW.TRX_TYPE
, CEL.MEANING
, FROW.DESCRIPTION

Columns

Name
FORECAST_ROW_ID
ROW_NUMBER
TRX_TYPE
TRX_TYPE_DSP
DESCRIPTION
FORECAST_ID
BANK_ACCOUNT_ID
BANK_ACCOUNT_NAME
BANK_ACCOUNT_NUM
BANK_CURRENCY_CODE
FCAMT0
FCAMT1
FCAMT2
FCAMT3
FCAMT4
FCAMT5
FCAMT6
FCAMT7
FCAMT8
FCAMT9
FCAMT10
FCAMT11
FCAMT12
FCAMT13
FCAMT14
FCAMT15
FCAMT16
FCAMT17
FCAMT18
FCAMT19
FCAMT20
FCAMT21
FCAMT22
FCAMT23
FCAMT24
FCAMT25
FCAMT26
FCAMT27
FCAMT28
FCAMT29
FCAMT30
FCAMT31
FCAMT32
FCAMT33
FCAMT34
FCAMT35
FCAMT36
FCAMT37
FCAMT38
FCAMT39
FCAMT40
FCAMT41
FCAMT42
FCAMT43
FCAMT44
FCAMT45
FCAMT46
FCAMT47
FCAMT48
FCAMT49
FCAMT50
FCAMT51
FCAMT52
FCAMT53
FCAMT54
FCAMT55
FCAMT56
FCAMT57
FCAMT58
FCAMT59
FCAMT60
FCAMT61
FCAMT62
FCAMT63
FCAMT64
FCAMT65
FCAMT66
FCAMT67
FCAMT68
FCAMT69
FCAMT70
FCAMT71
FCAMT72
FCAMT73
FCAMT74
FCAMT75
FCAMT76
FCAMT77
FCAMT78
FCAMT79
FCAMT80
XTR_USER