View: CE_FORECASTS_V

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

View Text

SELECT F.ROWID ROW_ID
, F.FORECAST_ID FORECAST_ID
, F.FORECAST_HEADER_ID FORECAST_HEADER_ID
, F.NAME NAME
, F.DESCRIPTION DESCRIPTION
, DECODE(H.AGING_TYPE
, 'D'
, TO_CHAR(F.START_DATE
, 'DD-MON-YYYY')
, F.START_PERIOD) START_TIME
, F.START_PERIOD START_PERIOD
, F.START_DATE START_DATE
, F.PERIOD_SET_NAME PERIOD_SET_NAME
, GP.START_DATE PERIOD_START_DATE
, F.FORECAST_CURRENCY FORECAST_CURRENCY
, F.CURRENCY_TYPE CURRENCY_TYPE
, F.SOURCE_CURRENCY SOURCE_CURRENCY
, F.EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE
, G.USER_CONVERSION_TYPE USER_EXCHANGE_RATE_TYPE
, F.EXCHANGE_DATE EXCHANGE_DATE
, F.EXCHANGE_RATE EXCHANGE_RATE
, H.NAME HEADER_NAME
, H.DESCRIPTION HEADER_DSP
, H.OVERDUE_TRANSACTIONS OVERDUE_TRANSACTIONS
, F.ERROR_STATUS ERROR_STATUS
, F.AMOUNT_THRESHOLD AMOUNT_THRESHOLD
, H.AGING_TYPE AGING_TYPE
, L1.MEANING AGING_TYPE_DSP
, F.CREATED_BY CREATED_BY
, F.CREATION_DATE CREATION_DATE
, F.LAST_UPDATED_BY LAST_UPDATED_BY
, F.LAST_UPDATE_DATE LAST_UPDATE_DATE
, F.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, F.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, F.ATTRIBUTE1 ATTRIBUTE1
, F.ATTRIBUTE2 ATTRIBUTE2
, F.ATTRIBUTE3 ATTRIBUTE3
, F.ATTRIBUTE4 ATTRIBUTE4
, F.ATTRIBUTE5 ATTRIBUTE5
, F.ATTRIBUTE6 ATTRIBUTE6
, F.ATTRIBUTE7 ATTRIBUTE7
, F.ATTRIBUTE8 ATTRIBUTE8
, F.ATTRIBUTE9 ATTRIBUTE9
, F.ATTRIBUTE10 ATTRIBUTE10
, F.ATTRIBUTE11 ATTRIBUTE11
, F.ATTRIBUTE12 ATTRIBUTE12
, F.ATTRIBUTE13 ATTRIBUTE13
, F.ATTRIBUTE14 ATTRIBUTE14
, F.ATTRIBUTE15 ATTRIBUTE15
, F.PROJECT_ID PROJECT_ID
, P.SEGMENT1 PROJECT_NUMBER
, F.DRILLDOWN_FLAG DRILLDOWN_FLAG
, F.BANK_BALANCE_TYPE BANK_BALANCE_TYPE
, F.FLOAT_TYPE FLOAT_TYPE
, F.VIEW_BY VIEW_BY
, F.INCLUDE_SUB_ACCOUNT INCLUDE_SUB_ACCOUNT
, F.FACTOR FACTOR
, F.REQUEST_ID REQUEST_ID
FROM CE_FORECASTS F
, CE_FORECAST_HEADERS H
, GL_PERIODS GP
, GL_DAILY_CONVERSION_TYPES G
, CE_LOOKUPS L1
, PA_PROJECTS_ALL P
WHERE H.FORECAST_HEADER_ID = F.FORECAST_HEADER_ID AND G.CONVERSION_TYPE(+) = F.EXCHANGE_RATE_TYPE AND GP.PERIOD_NAME(+) = F.START_PERIOD AND GP.PERIOD_SET_NAME(+) = F.PERIOD_SET_NAME AND L1.LOOKUP_TYPE = 'FORECAST_AGING_TYPE' AND L1.LOOKUP_CODE = H.AGING_TYPE AND P.PROJECT_ID(+) = F.PROJECT_ID

Columns