Product: | CE - Cash Management |
---|---|
Description: | This is a new view created to track the cash inflow per forecast period by bank account |
Implementation/DBA Data: | APPS.CE_FC_BANK_NETFLOW_V |
SELECT FCELL.FORECAST_ID
, NVL(FCELL.BANK_ACCOUNT_ID
, -999)
, 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))
, DECODE(FROW.TRX_TYPE
, 'XTI'
, 'Y'
, 'XTO'
, 'Y'
, 'N')
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 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
, FCELL.BANK_ACCOUNT_ID
, FROW.TRX_TYPE