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_FORECAST_CELLS

Object Details

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

View Type

A Business Intelligence System view

A cash forecast cell is a projected cashflow amount for each transaction source and forecast period, along with information applicable to that amount.

[View Source]

Columns

Name	Datatype	Length	Comments
FORECAST_CELL_ID	NUMBER		System-assigned forecast cell identifier
SOURCE_TYPE	VARCHAR2	(80)	Lookup meaning, the value shown on screen as code
START_PERIOD_DATE	DATE
END_PERIOD_DATE	DATE
AMOUNT	NUMBER
SOURCE_DESCRIPTION	VARCHAR2	(255)
LEAD_TIME	NUMBER	(15)
SET_OF_BOOKS_NAME	VARCHAR2	(30)
FORECAST_METHOD	VARCHAR2	(80)
BANK_ACCOUNT_ID	NUMBER	(15)
BANK_ACCOUNT_NAME	VARCHAR2	(100)
BANK_ACCOUNT_NUMBER	VARCHAR2	(30)
_KF:PAYROLL_BANK_ACCOUNT	CHAR	(15)
RECEIPT_METHOD	VARCHAR2	(30)
CUSTOMER_PROFILE_CLASS	VARCHAR2	(30)
PAYMENT_METHOD	VARCHAR2	(80)
DISPUTE_OPTION	VARCHAR2	(80)
PAY_GROUP	VARCHAR2	(25)
SUPPLIER_TYPE	VARCHAR2	(25)
PAYMENT_PRIORITY	NUMBER	(15)
DISCOUNT_OPTION	VARCHAR2	(80)
PO_AUTHORIZATION_STATUS	VARCHAR2	(240)
ROLL_FORWARD_TYPE	VARCHAR2	(80)
ROLL_FORWARD_PERIOD	NUMBER	(15)
ORDER_STATUS	VARCHAR2	(80)
ORDER_DATE_TYPE	VARCHAR2	(80)
PAYROLL_NAME	VARCHAR2	(80)
PAYROLL_LEGISLATION	VARCHAR2	(150)
CODE_COMBINATION_ID	NUMBER	(15)
_KF:GL_ACCOUNT_NUMBER	CHAR	(16)
ENCUMBRANCE_TYPE	VARCHAR2	(30)
BUDGET_NAME	VARCHAR2	(15)
EXTERNAL_SOURCE_TYPE	VARCHAR2	(30)
EXTERNAL_SOURCE_CRITERIA1	VARCHAR2	(150)
EXTERNAL_SOURCE_CRITERIA2	VARCHAR2	(150)
EXTERNAL_SOURCE_CRITERIA3	VARCHAR2	(150)
EXTERNAL_SOURCE_CRITERIA4	VARCHAR2	(150)
EXTERNAL_SOURCE_CRITERIA5	VARCHAR2	(150)
EXTERNAL_SOURCE_CRITERIA6	VARCHAR2	(150)
EXTERNAL_SOURCE_CRITERIA7	VARCHAR2	(150)
EXTERNAL_SOURCE_CRITERIA8	VARCHAR2	(150)
EXTERNAL_SOURCE_CRITERIA9	VARCHAR2	(150)
EXTERNAL_SOURCE_CRITERIA10	VARCHAR2	(150)
EXTERNAL_SOURCE_CRITERIA11	VARCHAR2	(150)
EXTERNAL_SOURCE_CRITERIA12	VARCHAR2	(150)
EXTERNAL_SOURCE_CRITERIA13	VARCHAR2	(150)
EXTERNAL_SOURCE_CRITERIA14	VARCHAR2	(150)
FORECAST_ID	NUMBER	(15)
CREATED_DATE	DATE
CREATED_BY	NUMBER
LAST_UPDATED_DATE	DATE
LAST_UPDATED_BY	NUMBER

Query Text

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


SELECT FORECAST_CELL_ID
,      SOURCE_TYPE
,      START_PERIOD_DATE
,      END_PERIOD_DATE
,      AMOUNT
,      SOURCE_DESCRIPTION
,      LEAD_TIME
,      SET_OF_BOOKS_NAME
,      FORECAST_METHOD
,      BANK_ACCOUNT_ID
,      BANK_ACCOUNT_NAME
,      BANK_ACCOUNT_NUMBER
,      _KF:PAYROLL_BANK_ACCOUNT
,      RECEIPT_METHOD
,      CUSTOMER_PROFILE_CLASS
,      PAYMENT_METHOD
,      DISPUTE_OPTION
,      PAY_GROUP
,      SUPPLIER_TYPE
,      PAYMENT_PRIORITY
,      DISCOUNT_OPTION
,      PO_AUTHORIZATION_STATUS
,      ROLL_FORWARD_TYPE
,      ROLL_FORWARD_PERIOD
,      ORDER_STATUS
,      ORDER_DATE_TYPE
,      PAYROLL_NAME
,      PAYROLL_LEGISLATION
,      CODE_COMBINATION_ID
,      _KF:GL_ACCOUNT_NUMBER
,      ENCUMBRANCE_TYPE
,      BUDGET_NAME
,      EXTERNAL_SOURCE_TYPE
,      EXTERNAL_SOURCE_CRITERIA1
,      EXTERNAL_SOURCE_CRITERIA2
,      EXTERNAL_SOURCE_CRITERIA3
,      EXTERNAL_SOURCE_CRITERIA4
,      EXTERNAL_SOURCE_CRITERIA5
,      EXTERNAL_SOURCE_CRITERIA6
,      EXTERNAL_SOURCE_CRITERIA7
,      EXTERNAL_SOURCE_CRITERIA8
,      EXTERNAL_SOURCE_CRITERIA9
,      EXTERNAL_SOURCE_CRITERIA10
,      EXTERNAL_SOURCE_CRITERIA11
,      EXTERNAL_SOURCE_CRITERIA12
,      EXTERNAL_SOURCE_CRITERIA13
,      EXTERNAL_SOURCE_CRITERIA14
,      FORECAST_ID
,      CREATED_DATE
,      CREATED_BY
,      LAST_UPDATED_DATE
,      LAST_UPDATED_BY
FROM APPS.CEBV_CASH_FORECAST_CELLS;

Dependencies

[top of page]

APPS.CEBV_CASH_FORECAST_CELLS references the following:

APPS: AR_LOOKUPS; AR_RECEIPT_METHODS; CE_BANK_ACCOUNTS; CE_FORECASTS; CE_FORECAST_CELLS; CE_FORECAST_COLUMNS; CE_FORECAST_HEADERS; CE_FORECAST_ROWS; CE_FORECAST_TRX_CELLS; CE_LOOKUPS; FND_GLOBAL - show dependent code; GL_CODE_COMBINATIONS; GL_ENCUMBRANCE_TYPES; GL_PERIODS; GL_PERIOD_TYPES; GL_SETS_OF_BOOKS; HR_ALL_ORGANIZATION_UNITS; HR_ORGANIZATION_INFORMATION; HZ_CUST_PROFILE_CLASSES; PAY_ALL_PAYROLLS_F; PAY_EXTERNAL_ACCOUNTS; PAY_ORG_PAYMENT_METHODS_F; PO_LOOKUP_CODES

APPS.CEBV_CASH_FORECAST_CELLS is not referenced by any database object