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


TABLE: CE.CE_FORECAST_CELLS

Object Details
Object Name: CE_FORECAST_CELLS
Object Type: TABLE
Owner: CE
FND Design Data: TableCE.CE_FORECAST_CELLS
Subobject Name:
Status: VALID


The CE_FORECAST_CELLS table stores information about forecast amounts generated from a forecast run. Each row includes forecast reference information such as forecast ID, template ID, template row ID, template column ID, and the actual forecast amount.
A record is generated for each cell of a forecast at the time of the forecast run, or you can enter an amount on the Cash Forecasts form. This table corresponds to the Cash Forecast Amounts
window of the Cash Forecasts form.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
CE_FORECAST_CELLS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnFORECAST_CELL_ID
CE_FORECAST_CELLS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnFORECAST_ID
ColumnFORECAST_COLUMN_ID
Columns
Name Datatype Length Mandatory Comments
FORECAST_CELL_ID NUMBER (15) Yes System-assigned forecast cell identifier
FORECAST_ID NUMBER (15) Yes Forecast identifier
AMOUNT NUMBER
Yes Forecast amount
CREATED_BY NUMBER (15) Yes Standard WHO column
CREATION_DATE DATE
Yes Standard WHO column
LAST_UPDATED_BY NUMBER (15) Yes Standard WHO column
LAST_UPDATE_DATE DATE
Yes Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column
FORECAST_HEADER_ID NUMBER (15)
Obsolete column
FORECAST_ROW_ID NUMBER (15)
Forecast template row identifier
FORECAST_COLUMN_ID NUMBER (15)
Forecast template column identifier
Query Text

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


SELECT FORECAST_CELL_ID
,      FORECAST_ID
,      AMOUNT
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      FORECAST_HEADER_ID
,      FORECAST_ROW_ID
,      FORECAST_COLUMN_ID
FROM CE.CE_FORECAST_CELLS;

Dependencies

[top of page]

CE.CE_FORECAST_CELLS does not reference any database object

CE.CE_FORECAST_CELLS is referenced by following:

SchemaAPPS
SynonymCE_FORECAST_CELLS