[Home] [Help] [Dependency Information]
Object Name: | CE_FORECAST_CELLS |
---|---|
Object Type: | TABLE |
Owner: | CE |
FND Design Data: | CE.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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CE_FORECAST_CELLS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | FORECAST_CELL_ID |
CE_FORECAST_CELLS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
FORECAST_ID
FORECAST_COLUMN_ID |
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 |
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;
CE.CE_FORECAST_CELLS does not reference any database object
CE.CE_FORECAST_CELLS is referenced by following:
|
|
|