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.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.CEBV_CASH_FORECASTS

Object Details

Object Name:	CEBV_CASH_FORECASTS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CE.CEBV_CASH_FORECASTS
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

This shows cash forecast information. A cash forecast is a projection of your cash inflows and outflows. This shows information applicable to the entire forecast.

[View Source]

Columns

Name	Datatype	Length	Mandatory
FORECAST_ID	NUMBER	(15)	Yes
NAME	VARCHAR2	(100)	Yes
TYPE	VARCHAR2	(80)	Yes
FORECAST_CURRENCY	VARCHAR2	(15)	Yes
CURRENCY_TYPE	VARCHAR2	(80)	Yes
EXCHANGE_RATE_TYPE	VARCHAR2	(30)
EXCHANGE_DATE	DATE
EXCHANGE_RATE	NUMBER
DESCRIPTION	VARCHAR2	(255)
START_DATE	DATE
START_PERIOD	VARCHAR2	(15)
CALENDAR_NAME	VARCHAR2	(15)
SOURCE_CURRENCY	VARCHAR2	(15)
ERROR_STATUS	VARCHAR2	(1)
AMOUNT_THRESHOLD	NUMBER	(15)
TEMPLATE_NAME	VARCHAR2	(30)	Yes
TEMPLATE_DESCRIPTION	VARCHAR2	(255)
OVERDUE_TRANSACTION_OPTION	VARCHAR2	(80)	Yes
OVERDUE_TXN_CUTOFF_PERIOD	NUMBER	(15)
BUSINESS_CALENDAR	VARCHAR2	(25)
CREATED_DATE	DATE		Yes
CREATED_BY	NUMBER	(15)	Yes
LAST_UPDATED_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
PROJECT_ID	NUMBER	(15)
PROJECT_NUMBER	VARCHAR2	(25)

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT FORECAST_ID
,      NAME
,      TYPE
,      FORECAST_CURRENCY
,      CURRENCY_TYPE
,      EXCHANGE_RATE_TYPE
,      EXCHANGE_DATE
,      EXCHANGE_RATE
,      DESCRIPTION
,      START_DATE
,      START_PERIOD
,      CALENDAR_NAME
,      SOURCE_CURRENCY
,      ERROR_STATUS
,      AMOUNT_THRESHOLD
,      TEMPLATE_NAME
,      TEMPLATE_DESCRIPTION
,      OVERDUE_TRANSACTION_OPTION
,      OVERDUE_TXN_CUTOFF_PERIOD
,      BUSINESS_CALENDAR
,      CREATED_DATE
,      CREATED_BY
,      LAST_UPDATED_DATE
,      LAST_UPDATED_BY
,      PROJECT_ID
,      PROJECT_NUMBER
FROM APPS.CEBV_CASH_FORECASTS;

Dependencies

[top of page]

APPS.CEBV_CASH_FORECASTS references the following:

APPS: CE_FORECASTS; CE_FORECAST_HEADERS; CE_LOOKUPS; GL_DAILY_CONVERSION_TYPES; GL_TRANSACTION_CALENDAR; PA_PROJECTS_ALL

APPS.CEBV_CASH_FORECASTS is not referenced by any database object