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: APPS.MSC_FORECAST_RULES_V

Object Details

Object Name:	MSC_FORECAST_RULES_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory
ROW_ID	ROWID	(10)
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
SALES_FORECAST_SCHEDULE_NAME	VARCHAR2	(45)
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
FORECAST_BUCKET	NUMBER
FORECAST_BUCKET_TYPE	NUMBER
CALENDAR_TYPE	NUMBER
HISTORY_RANGE	NUMBER
HISTORY_RANGE_TYPE	NUMBER
FORECAST_HORIZON	NUMBER
FORECAST_HORIZON_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 ROW_ID
,      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
,      SALES_FORECAST_SCHEDULE_NAME
,      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
,      FORECAST_BUCKET
,      FORECAST_BUCKET_TYPE
,      CALENDAR_TYPE
,      HISTORY_RANGE
,      HISTORY_RANGE_TYPE
,      FORECAST_HORIZON
,      FORECAST_HORIZON_TYPE
,      ENABLE_USAGE_SHIP_FCST
,      ENABLE_PROD_POPULATION_FCST
,      FORECAST_BASIS
FROM APPS.MSC_FORECAST_RULES_V;

Dependencies

[top of page]

APPS.MSC_FORECAST_RULES_V references the following:

APPS: MSC_FORECAST_RULES; MSD_COMMON_UTILITIES - show dependent code; MSD_DEM_UPLOAD_FORECAST - show dependent code; MSD_DP_ASCP_SCENARIOS_V

APPS.MSC_FORECAST_RULES_V is not referenced by any database object