VIEW: APPS.MSC_FORECAST_RULES_V

Source

View Text - Preformatted

SELECT FCR.ROWID ROW_ID , FCR.FORECAST_RULE_ID , FCR.FORECAST_RULE_NAME , FCR.DESCRIPTION , FCR.HISTORY_BASIS , FCR.HIST_BASIS_TYPE , FCR.HIST_BASIS_INTERMITTENCY , FCR.FORECAST_METHOD , FCR.FCST_FREQUENCY , FCR.FCST_FREQUENCY_TYPE , FCR.FCST_ACCURACY_METRIC , FCR.SALES_FORECAST_SOURCE , FCR.SALES_FORECAST_FILE , FCR.SALES_FORECAST_SCHEDULE_id , SCN.SCENARIO_NAME SALES_FORECAST_SCHEDULE_NAME, FCR.SCHEDULE_SR_INSTANCE_ID , FCR.SALES_FORECAST_HISTORY_BASIS , FCR.HIST_BASIS_TYPE_PPF , FCR.HIST_BASIS_INTERMITTENCY_PPF , FCR.FCST_METHOD_PPF , FCR.FCST_FREQUENCY_PPF , FCR.FCST_FREQUENCY_TYPE_PPF , FCR.FCST_ACCURACY_METRIC_PPF , FCR.SERV_ADJUSTMENT_FACTOR , FCR.SERV_ADJUSTMENT_FACTOR_FILE , FCR.SERV_ADJUSTMENT_FACTOR_VALUE , FCR.CREATED_BY , FCR.CREATION_DATE , FCR.LAST_UPDATE_DATE , FCR.LAST_UPDATED_BY , FCR.LAST_UPDATE_LOGIN ,FCR.FORECAST_BUCKET ,FCR.FORECAST_BUCKET_TYPE ,FCR.CALENDAR_TYPE ,FCR.HISTORY_RANGE ,FCR.HISTORY_RANGE_TYPE ,FCR.FORECAST_HORIZON ,FCR.FORECAST_HORIZON_TYPE ,ENABLE_USAGE_SHIP_FCST ,ENABLE_PROD_POPULATION_FCST ,FORECAST_BASIS FROM MSC_FORECAST_RULES fcr, MSD_DP_ASCP_SCENARIOS_V SCN WHERE fcr.SALES_FORECAST_SCHEDULE_id = SCN.SCENARIO_ID (+)

View Text - HTML Formatted

SELECT FCR.ROWID ROW_ID
, FCR.FORECAST_RULE_ID
, FCR.FORECAST_RULE_NAME
, FCR.DESCRIPTION
, FCR.HISTORY_BASIS
, FCR.HIST_BASIS_TYPE
, FCR.HIST_BASIS_INTERMITTENCY
, FCR.FORECAST_METHOD
, FCR.FCST_FREQUENCY
, FCR.FCST_FREQUENCY_TYPE
, FCR.FCST_ACCURACY_METRIC
, FCR.SALES_FORECAST_SOURCE
, FCR.SALES_FORECAST_FILE
, FCR.SALES_FORECAST_SCHEDULE_ID
, SCN.SCENARIO_NAME SALES_FORECAST_SCHEDULE_NAME
, FCR.SCHEDULE_SR_INSTANCE_ID
, FCR.SALES_FORECAST_HISTORY_BASIS
, FCR.HIST_BASIS_TYPE_PPF
, FCR.HIST_BASIS_INTERMITTENCY_PPF
, FCR.FCST_METHOD_PPF
, FCR.FCST_FREQUENCY_PPF
, FCR.FCST_FREQUENCY_TYPE_PPF
, FCR.FCST_ACCURACY_METRIC_PPF
, FCR.SERV_ADJUSTMENT_FACTOR
, FCR.SERV_ADJUSTMENT_FACTOR_FILE
, FCR.SERV_ADJUSTMENT_FACTOR_VALUE
, FCR.CREATED_BY
, FCR.CREATION_DATE
, FCR.LAST_UPDATE_DATE
, FCR.LAST_UPDATED_BY
, FCR.LAST_UPDATE_LOGIN
, FCR.FORECAST_BUCKET
, FCR.FORECAST_BUCKET_TYPE
, FCR.CALENDAR_TYPE
, FCR.HISTORY_RANGE
, FCR.HISTORY_RANGE_TYPE
, FCR.FORECAST_HORIZON
, FCR.FORECAST_HORIZON_TYPE
, ENABLE_USAGE_SHIP_FCST
, ENABLE_PROD_POPULATION_FCST
, FORECAST_BASIS
FROM MSC_FORECAST_RULES FCR
, MSD_DP_ASCP_SCENARIOS_V SCN
WHERE FCR.SALES_FORECAST_SCHEDULE_ID = SCN.SCENARIO_ID (+)