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

TABLE: MSC.MSC_FORECAST_RULES

Object Details
Object Name: MSC_FORECAST_RULES
Object Type: TABLE
Owner: MSC
Subobject Name:
Status: VALID


Used to store list of forecast rules.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MSC_FORECAST_RULES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnFORECAST_RULE_ID
MSC_FORECAST_RULES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnFORECAST_RULE_NAME
Columns
Name Datatype Length Mandatory Comments
FORECAST_RULE_ID NUMBER
Yes Forecast Rule ID
FORECAST_RULE_NAME VARCHAR2 (30) Yes Forecast Rule Name
DESCRIPTION VARCHAR2 (80)
Description
HISTORY_BASIS NUMBER

History Basis
HIST_BASIS_TYPE NUMBER

History Basis Type
HIST_BASIS_INTERMITTENCY NUMBER

History Basis Intermitency
FORECAST_METHOD NUMBER
Yes Forecast Method
FCST_FREQUENCY NUMBER

Forecast Frequency
FCST_FREQUENCY_TYPE NUMBER

Forecast Frequence Type
FCST_ACCURACY_METRIC NUMBER

Forecast Accuracy Method
SALES_FORECAST_SOURCE NUMBER

Sales Forecast Source
SALES_FORECAST_FILE VARCHAR2 (250)
Sales Forecast File
SALES_FORECAST_SCHEDULE_ID NUMBER

Sales Forecasrt Schedule ID
SCHEDULE_SR_INSTANCE_ID NUMBER

Scehdule Source Instance ID
SALES_FORECAST_HISTORY_BASIS NUMBER

Sales Forecast History Basis
HIST_BASIS_TYPE_PPF NUMBER

History Basis Type PPF
HIST_BASIS_INTERMITTENCY_PPF NUMBER

History Basis Intermittency
FCST_METHOD_PPF NUMBER

Forecast Method PPF
FCST_FREQUENCY_PPF NUMBER

Forecast Frequency PPF
FCST_FREQUENCY_TYPE_PPF NUMBER

Forecast Frequency Type PPF
FCST_ACCURACY_METRIC_PPF NUMBER

Forecast Accuracy Method
SERV_ADJUSTMENT_FACTOR NUMBER

Serv Adjustment Factor
SERV_ADJUSTMENT_FACTOR_FILE VARCHAR2 (250)
Serv Adjustemtn Factor File
SERV_ADJUSTMENT_FACTOR_VALUE NUMBER

Serv Adjustemtn Factor Value
CREATED_BY NUMBER

Standard Who Column
CREATION_DATE DATE

Standard Who Column
LAST_UPDATE_DATE DATE

Standard Who Column
LAST_UPDATED_BY NUMBER

Standard Who Column
LAST_UPDATE_LOGIN NUMBER

Standard Who Column
CALENDAR_TYPE NUMBER

1 - Gregorian ,2 - Manufacturing
HISTORY_RANGE NUMBER

History Range
HISTORY_RANGE_TYPE NUMBER

1 - Days, 2 - Weeks, 3 - Periods, 4 - Months, 5 - Quarters, 6 - Years
FORECAST_HORIZON NUMBER

Forecast Horizon
FORECAST_HORIZON_TYPE NUMBER

1 - Days, 2 - Weeks, 3 - Periods, 4 - Months, 5 - Quarters, 6 - Years
FORECAST_BUCKET NUMBER

Forecast Bucket
FORECAST_BUCKET_TYPE NUMBER

1 - Days, 2 - Weeks, 3 - Periods, 4 - Months, 5 - Quarters, 6 - Years
ENABLE_USAGE_SHIP_FCST NUMBER

1 - Yes, 2 - No
ENABLE_PROD_POPULATION_FCST NUMBER

1 - Yes, 2 - No
FORECAST_BASIS NUMBER

1 - Install Base, 3 - Usage, 4- Shipment
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 does not reference any database object

MSC.MSC_FORECAST_RULES is referenced by following:

SchemaMSC
ViewMSC_FORECAST_RULES#