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

TABLE: INV.MTL_FORECAST_RULES

Object Details
Object Name: MTL_FORECAST_RULES
Object Type: TABLE
Owner: INV
FND Design Data: TableINV.MTL_FORECAST_RULES
Subobject Name:
Status: VALID


MTL_FORECAST_RULES stores rules or options which are used in the
Statistical and Focus forecasting processes. The options can be
classified into Forecast Computation options, Forecast Source options
and Statistical Forecasting Parameters. Computation option governs
which forecast method and bucket type to use. There are two forecast
methods and three bucket types. The forecast methods are statistical
and focus forecastings. Three possible bucket types are days, weeks
and periods.
.
.
Forecast sources consist of the forecast demand elements to be
included or excluded in the forecast process. The demand elements are
sales order shipments, wip issues, miscellaneous issues and inter-
organization transfers. The forecast source options direct forecast
process to include or to exclude the specified sources during
forecasting. For example, if the option only includes sales orders,
then the forecast result will totally depend on the sales order
demand.
.
Statistical Forecasting Parameters store parameters that are
pertaining to Statistical forecasting. The parameters include the
maximum past periods to use, alpha smoothing factor, trend and
seasonality factors, and the option to turn on/off the employment of
trend or seasonality models in the forecast calculation.
.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MTL_FORECAST_RULES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnFORECAST_RULE_ID
MTL_FORECAST_RULES_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnFORECAST_RULE_NAME
Columns
Name Datatype Length Mandatory Comments
FORECAST_RULE_ID NUMBER
Yes Identifier of forecast rule
FORECAST_RULE_NAME VARCHAR2 (80) Yes Name of forecast rule
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
DESCRIPTION VARCHAR2 (240)
Rule description
FORECAST_TYPE NUMBER
Yes Indicates the forecast method used in rule
PERIOD_TYPE NUMBER
Yes Bucket type for forecast
INCLUDE_SALES_ORDERS NUMBER
Yes Flag to indicate if sales order shipments should be included in forecast history
INCLUDE_INTERORG_ISSUES NUMBER
Yes Flag to indicate if inter-organization issues should be included in forecast history
INCLUDE_MISCELLANEOUS_ISSUES NUMBER
Yes Flag to indicate if miscellaneous issues (Account, Account Alias, Miscellaneous, Internal Order and User Defined Issues that are classified as miscellaneous) should be included in forecast
INCLUDE_WIP_ISSUES NUMBER
Yes Flag to indicate if WIP issues (Issue components to WIP, and Issue Primary Assemblies to WIP) should be included
MAXIMUM_PAST_PERIODS NUMBER

The maximum number of past periods that the statistical forecast uses to generate the forecasts
ALPHA_SMOOTHING_FACTOR NUMBER

Factor that determines how much weight to put on past periods, 1=only most recent period, 0=more on the distant past
INCLUDE_TREND_MODEL NUMBER

Flag to indicate if an estimate of the amount of change from period to period should be included in the forecast model
TREND_FACTOR NUMBER

Smoothing factor for the trend model; 1 = only look at most recent, 0 = most weight on distant past
INCLUDE_SEASONALITY_MODEL NUMBER

Flag to indicate if an annual seasonal index should be used in the forecast
SEASONALITY_FACTOR NUMBER

Smoothing factor for the seasonal index, 1 = only look at most recent; O only look at most distant past
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure defining column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
REQUEST_ID NUMBER

Standard Who column
PROGRAM_APPLICATION_ID NUMBER

Standard Who column
PROGRAM_ID NUMBER

Standard Who column
PROGRAM_UPDATE_DATE DATE

Standard Who column
Query Text

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


SELECT FORECAST_RULE_ID
,      FORECAST_RULE_NAME
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      DESCRIPTION
,      FORECAST_TYPE
,      PERIOD_TYPE
,      INCLUDE_SALES_ORDERS
,      INCLUDE_INTERORG_ISSUES
,      INCLUDE_MISCELLANEOUS_ISSUES
,      INCLUDE_WIP_ISSUES
,      MAXIMUM_PAST_PERIODS
,      ALPHA_SMOOTHING_FACTOR
,      INCLUDE_TREND_MODEL
,      TREND_FACTOR
,      INCLUDE_SEASONALITY_MODEL
,      SEASONALITY_FACTOR
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM INV.MTL_FORECAST_RULES;

Dependencies

[top of page]

INV.MTL_FORECAST_RULES does not reference any database object

INV.MTL_FORECAST_RULES is referenced by following:

SchemaINV
ViewMTL_FORECAST_RULES#