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.

VIEW: MSC.MSC_FORECAST_RULES#

Source

View Text - Preformatted


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

View Text - HTML Formatted

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