View: CEFV_CASH_FORECASTS

Product:	CE - Cash Management
Description:	Business View
Implementation/DBA Data:	APPS.CEFV_CASH_FORECASTS

View Text

SELECT CF.FORECAST_ID
, CF.NAME
, L1.MEANING
, CF.FORECAST_CURRENCY
, L2.MEANING
, DC.USER_CONVERSION_TYPE
, CF.EXCHANGE_DATE
, CF.EXCHANGE_RATE
, CF.DESCRIPTION
, CF.START_DATE
, CF.START_PERIOD
, CF.PERIOD_SET_NAME
, CF.SOURCE_CURRENCY
, CF.ERROR_STATUS
, CF.AMOUNT_THRESHOLD
, FH.NAME
, FH.DESCRIPTION
, L3.MEANING
, FH.CUTOFF_PERIOD
, TC.NAME
, CF.CREATION_DATE
, CF.CREATED_BY
, CF.LAST_UPDATE_DATE
, CF.LAST_UPDATED_BY
, CF.PROJECT_ID
, PA.SEGMENT1
FROM CE_FORECASTS CF
, CE_FORECAST_HEADERS FH
, CE_LOOKUPS L1
, CE_LOOKUPS L2
, CE_LOOKUPS L3
, GL_DAILY_CONVERSION_TYPES DC
, GL_TRANSACTION_CALENDAR TC
, PA_PROJECTS_ALL PA
WHERE FH.FORECAST_HEADER_ID = CF.FORECAST_HEADER_ID
AND L1.LOOKUP_TYPE = 'FORECAST_AGING_TYPE'
AND L1.LOOKUP_CODE = FH.AGING_TYPE
AND L2.LOOKUP_TYPE = 'FORECAST_CURRENCY_TYPE'
AND L2.LOOKUP_CODE = CF.CURRENCY_TYPE
AND L3.LOOKUP_TYPE = 'FORECAST_OVERDUE_TRX'
AND L3.LOOKUP_CODE = FH.OVERDUE_TRANSACTIONS
AND DC.CONVERSION_TYPE (+) = CF.EXCHANGE_RATE_TYPE
AND PA.PROJECT_ID (+) = CF.PROJECT_ID
AND TC.TRANSACTION_CALENDAR_ID (+) = FH.TRANSACTION_CALENDAR_ID WITH READ ONLY

Columns