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

VIEW: APPS.MRPFV_FORECAST_RULES

Object Details
Object Name: MRPFV_FORECAST_RULES
Object Type: VIEW
Owner: APPS
FND Design Data: ViewMRP.MRPFV_FORECAST_RULES
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


This shows rules which are used in generating forecast based on previous history.


[View Source]

Columns
Name Datatype Length Mandatory Comments
FORECAST_RULE_NAME VARCHAR2 (80) Yes
DESCRIPTION VARCHAR2 (240)

_LA:BUCKET_TYPE CHAR (55)

_LA:INCLUDE_SALES_ORDER_FLAG CHAR (58)
_LA:INCLUDE_WIP_ISSUES_FLAG CHAR (56)
_LA:MISCELLANEOUS_ISSUES CHAR (66)
_LA:INTERORG_ISSUES_FLAG CHAR (61)
_LA:FORECAST_TYPE CHAR (53)
MAXIMUM_PAST_PERIODS NUMBER

ALPHA_SMOOTHING_FACTOR NUMBER


_LA:TREND_MODEL_FLAG CHAR (57)
TREND_FACTOR NUMBER

_LA:SEASONALITY_MODEL_FLAG CHAR (63)
SEASONALITLY_FACTOR NUMBER

FORECAST_RULE_ID NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
Query Text

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


SELECT FORECAST_RULE_NAME
,      DESCRIPTION
,      _LA:BUCKET_TYPE
,      _LA:INCLUDE_SALES_ORDER_FLAG
,      _LA:INCLUDE_WIP_ISSUES_FLAG
,      _LA:MISCELLANEOUS_ISSUES
,      _LA:INTERORG_ISSUES_FLAG
,      _LA:FORECAST_TYPE
,      MAXIMUM_PAST_PERIODS
,      ALPHA_SMOOTHING_FACTOR
,      _LA:TREND_MODEL_FLAG
,      TREND_FACTOR
,      _LA:SEASONALITY_MODEL_FLAG
,      SEASONALITLY_FACTOR
,      FORECAST_RULE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
FROM APPS.MRPFV_FORECAST_RULES;

Dependencies

[top of page]

APPS.MRPFV_FORECAST_RULES references the following:

SchemaAPPS
SynonymMTL_FORECAST_RULES

APPS.MRPFV_FORECAST_RULES is not referenced by any database object