View: CE_FC_NETFLOW_DISC_V

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

View Text

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

Columns