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: ViewCE.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 Mandatory 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:

SchemaAPPS
ViewAR_LOOKUPS
SynonymAR_RECEIPT_METHODS
SynonymCE_BANK_ACCOUNTS
SynonymCE_FORECASTS
SynonymCE_FORECAST_CELLS
SynonymCE_FORECAST_COLUMNS
SynonymCE_FORECAST_HEADERS
SynonymCE_FORECAST_ROWS
SynonymCE_FORECAST_TRX_CELLS
ViewCE_LOOKUPS
PL/SQL PackageFND_GLOBAL - show dependent code
SynonymGL_CODE_COMBINATIONS
SynonymGL_ENCUMBRANCE_TYPES
SynonymGL_PERIODS
SynonymGL_PERIOD_TYPES
ViewGL_SETS_OF_BOOKS
SynonymHR_ALL_ORGANIZATION_UNITS
SynonymHR_ORGANIZATION_INFORMATION
SynonymHZ_CUST_PROFILE_CLASSES
SynonymPAY_ALL_PAYROLLS_F
SynonymPAY_EXTERNAL_ACCOUNTS
SynonymPAY_ORG_PAYMENT_METHODS_F
ViewPO_LOOKUP_CODES

APPS.CEBV_CASH_FORECAST_CELLS is not referenced by any database object