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


VIEW: APPS.CEFV_CASH_FORECAST_CELLS

Object Details
Object Name: CEFV_CASH_FORECAST_CELLS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCE.CEFV_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

Cash forecast cell identifier.
SOURCE_TYPE VARCHAR2 (80)
Identifies what type of source transactions this forecast cell amount was generated from.
START_PERIOD_DATE DATE

Start date of forecast period.
END_PERIOD_DATE DATE

End date of forecast period.
AMOUNT NUMBER

Forecast amount for given source transaction type and forecast period.
SOURCE_DESCRIPTION VARCHAR2 (255)
A brief description of the transaction source.
LEAD_TIME NUMBER (15)
Amount of time added to the transaction date to project cash activity date.
SET_OF_BOOKS_NAME VARCHAR2 (30)
Indicates the set of books the forecast amount represents.
FORECAST_METHOD VARCHAR2 (80)
Indicates the method of the forecast being generated for AP payment, AR receipt, or Payroll expense source types, either by selecting Historical transactions or Future transactions.
BANK_ACCOUNT_ID NUMBER (15)
The bank account id which uniquely identifiers the bank the forecast amount represents for AP payment, AR receipt, or Payroll expense source type.
BANK_ACCOUNT_NAME VARCHAR2 (100)
Indicates the bank account name the forecast amount represents for AP payment or AR receipt source types.
BANK_ACCOUNT_NUMBER VARCHAR2 (30)
Bank account selection criterion for Supplier Payments and Customer Receipts.
_KF:PAYROLL_BANK_ACCOUNT CHAR (15)
Bank account selection criterion for Payroll Expenses.
RECEIPT_METHOD VARCHAR2 (30)
Receipt class payment method for Customer Receipts.
CUSTOMER_PROFILE_CLASS VARCHAR2 (30)
Customer Profile Class selection criterion for Customer Invoices.
PAYMENT_METHOD VARCHAR2 (80)
Payment Method selection criterion.
DISPUTE_OPTION VARCHAR2 (80)
Indicates whether disputed amounts are included or excluded when the forecast amount is generated from AR invoices.
PAY_GROUP VARCHAR2 (25)
Payment Group selection criterion for Supplier Invoices and Purchase Orders.
SUPPLIER_TYPE VARCHAR2 (25)
Supplier Type selection criterion for Supplier Invoices and Purchase Orders.
PAYMENT_PRIORITY NUMBER (15)
Indicates the lowest payment priority the forecast amount represents for AP invoice or Purchase order source type.
DISCOUNT_OPTION VARCHAR2 (80)
Indicates whether discounted amounts are included or excluded when the forecast amount is generated from AP invoices.
PO_AUTHORIZATION_STATUS VARCHAR2 (240)
Authorization Status selection criterion for Oracle Purchasing source types.
ROLL_FORWARD_TYPE VARCHAR2 (80)
The type of periods to roll forward when forecasting from historical transactions: by days, by months, or by accounting periods.
ROLL_FORWARD_PERIOD NUMBER (15)
The number of periods to roll forward when forecasting from historical transactions.
ORDER_STATUS VARCHAR2 (80)
Order Status selection criterion for Sales Orders.
ORDER_DATE_TYPE VARCHAR2 (80)
Date Type selection criterion for Sales Orders.
PAYROLL_NAME VARCHAR2 (80)
Payroll name selection criterion for Payroll expense source type.
PAYROLL_LEGISLATION VARCHAR2 (150)
Indicates the legislation the forecast amount represents for Payroll expense source type.
CODE_COMBINATION_ID NUMBER (15)
GL Account selection criterion for GL source types.
_KF:GL_ACCOUNT_NUMBER CHAR (16)
Indicates the GL account number the forecast amount represents for GL source types.
ENCUMBRANCE_TYPE VARCHAR2 (30)
Encumbrance type selection criterion for GL Encumbrances.
BUDGET_NAME VARCHAR2 (15)
Budget Name selection criterion for GL Budgets.
EXTERNAL_SOURCE_TYPE VARCHAR2 (30)
Indicates the external source type the forecast amount represents for Open Interface Inflow or Outflow source type.
EXTERNAL_SOURCE_CRITERIA1 VARCHAR2 (150)
Selection criterion for Open Interface Inflow or Outflow source types.
EXTERNAL_SOURCE_CRITERIA2 VARCHAR2 (150)
Selection criterion for Open Interface Inflow or Outflow source types.
EXTERNAL_SOURCE_CRITERIA3 VARCHAR2 (150)
Selection criterion for Open Interface Inflow or Outflow source types.
EXTERNAL_SOURCE_CRITERIA4 VARCHAR2 (150)
Selection criterion for Open Interface Inflow or Outflow source types.
EXTERNAL_SOURCE_CRITERIA5 VARCHAR2 (150)
Selection criterion for Open Interface Inflow or Outflow source types.
EXTERNAL_SOURCE_CRITERIA6 VARCHAR2 (150)
Selection criterion for Open Interface Inflow or Outflow source types.
EXTERNAL_SOURCE_CRITERIA7 VARCHAR2 (150)
Selection criterion for Open Interface Inflow or Outflow source types.
EXTERNAL_SOURCE_CRITERIA8 VARCHAR2 (150)
Selection criterion for Open Interface Inflow or Outflow source types.
EXTERNAL_SOURCE_CRITERIA9 VARCHAR2 (150)
Selection criterion for Open Interface Inflow or Outflow source types.
EXTERNAL_SOURCE_CRITERIA10 VARCHAR2 (150)
Selection criterion for Open Interface Inflow or Outflow source types.
EXTERNAL_SOURCE_CRITERIA11 VARCHAR2 (150)
Selection criterion for Open Interface Inflow or Outflow source types.
EXTERNAL_SOURCE_CRITERIA12 VARCHAR2 (150)
Selection criterion for Open Interface Inflow or Outflow source types.
EXTERNAL_SOURCE_CRITERIA13 VARCHAR2 (150)
Selection criterion for Open Interface Inflow or Outflow source types.
EXTERNAL_SOURCE_CRITERIA14 VARCHAR2 (150)
Selection criterion for Open Interface Inflow or Outflow source types.
EXTERNAL_SOURCE_CRITERIA15 VARCHAR2 (150)
Selection criterion for Open Interface Inflow or Outflow source types.
FORECAST_ID NUMBER (15)
An id which uniquely identifies the forecast to which this 'cell' belongs.
FORECAST_NAME VARCHAR2 (100)
The name of the forecast to which this 'cell' belongs.
FORECAST_TYPE VARCHAR2 (80)
The type of forecast, by days or GL periods, to which this 'cell' belongs.
FORECAST_DESCRIPTION VARCHAR2 (255)
A brief description of the forecast to which this 'cell' belongs.
CREATED_DATE DATE

Standard WHO column.
CREATED_BY NUMBER

Standard WHO column.
LAST_UPDATED_DATE DATE

Standard WHO column.
LAST_UPDATED_BY NUMBER

Standard WHO column.
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
,      EXTERNAL_SOURCE_CRITERIA15
,      FORECAST_ID
,      FORECAST_NAME
,      FORECAST_TYPE
,      FORECAST_DESCRIPTION
,      CREATED_DATE
,      CREATED_BY
,      LAST_UPDATED_DATE
,      LAST_UPDATED_BY
FROM APPS.CEFV_CASH_FORECAST_CELLS;

Dependencies

[top of page]

APPS.CEFV_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.CEFV_CASH_FORECAST_CELLS is not referenced by any database object