eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: MSC.MSC_FORECAST_RULES#

Object Details

Object Name:	MSC_FORECAST_RULES#
Object Type:	VIEW
Owner:	MSC
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
FORECAST_RULE_ID	NUMBER		Yes
FORECAST_RULE_NAME	VARCHAR2	(30)	Yes
DESCRIPTION	VARCHAR2	(80)
HISTORY_BASIS	NUMBER
HIST_BASIS_TYPE	NUMBER
HIST_BASIS_INTERMITTENCY	NUMBER
FORECAST_METHOD	NUMBER		Yes
FCST_FREQUENCY	NUMBER
FCST_FREQUENCY_TYPE	NUMBER
FCST_ACCURACY_METRIC	NUMBER
SALES_FORECAST_SOURCE	NUMBER
SALES_FORECAST_FILE	VARCHAR2	(250)
SALES_FORECAST_SCHEDULE_ID	NUMBER
SCHEDULE_SR_INSTANCE_ID	NUMBER
SALES_FORECAST_HISTORY_BASIS	NUMBER
HIST_BASIS_TYPE_PPF	NUMBER
HIST_BASIS_INTERMITTENCY_PPF	NUMBER
FCST_METHOD_PPF	NUMBER
FCST_FREQUENCY_PPF	NUMBER
FCST_FREQUENCY_TYPE_PPF	NUMBER
FCST_ACCURACY_METRIC_PPF	NUMBER
SERV_ADJUSTMENT_FACTOR	NUMBER
SERV_ADJUSTMENT_FACTOR_FILE	VARCHAR2	(250)
SERV_ADJUSTMENT_FACTOR_VALUE	NUMBER
CREATED_BY	NUMBER
CREATION_DATE	DATE
LAST_UPDATE_DATE	DATE
LAST_UPDATED_BY	NUMBER
LAST_UPDATE_LOGIN	NUMBER
CALENDAR_TYPE	NUMBER
HISTORY_RANGE	NUMBER
HISTORY_RANGE_TYPE	NUMBER
FORECAST_HORIZON	NUMBER
FORECAST_HORIZON_TYPE	NUMBER
FORECAST_BUCKET	NUMBER
FORECAST_BUCKET_TYPE	NUMBER
ENABLE_USAGE_SHIP_FCST	NUMBER
ENABLE_PROD_POPULATION_FCST	NUMBER
FORECAST_BASIS	NUMBER

Query Text

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


SELECT FORECAST_RULE_ID
,      FORECAST_RULE_NAME
,      DESCRIPTION
,      HISTORY_BASIS
,      HIST_BASIS_TYPE
,      HIST_BASIS_INTERMITTENCY
,      FORECAST_METHOD
,      FCST_FREQUENCY
,      FCST_FREQUENCY_TYPE
,      FCST_ACCURACY_METRIC
,      SALES_FORECAST_SOURCE
,      SALES_FORECAST_FILE
,      SALES_FORECAST_SCHEDULE_ID
,      SCHEDULE_SR_INSTANCE_ID
,      SALES_FORECAST_HISTORY_BASIS
,      HIST_BASIS_TYPE_PPF
,      HIST_BASIS_INTERMITTENCY_PPF
,      FCST_METHOD_PPF
,      FCST_FREQUENCY_PPF
,      FCST_FREQUENCY_TYPE_PPF
,      FCST_ACCURACY_METRIC_PPF
,      SERV_ADJUSTMENT_FACTOR
,      SERV_ADJUSTMENT_FACTOR_FILE
,      SERV_ADJUSTMENT_FACTOR_VALUE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CALENDAR_TYPE
,      HISTORY_RANGE
,      HISTORY_RANGE_TYPE
,      FORECAST_HORIZON
,      FORECAST_HORIZON_TYPE
,      FORECAST_BUCKET
,      FORECAST_BUCKET_TYPE
,      ENABLE_USAGE_SHIP_FCST
,      ENABLE_PROD_POPULATION_FCST
,      FORECAST_BASIS
FROM MSC.MSC_FORECAST_RULES#;

Dependencies

[top of page]

MSC.MSC_FORECAST_RULES# references the following:

MSC: MSC_FORECAST_RULES

MSC.MSC_FORECAST_RULES# is referenced by following:

APPS: MSC_FORECAST_RULES