DBA Data[Home] [Help]

VIEW: MSC.MSC_DMD_SCN_METRICS#

Source

View Text - Preformatted

select PLAN_ID PLAN_ID, SCENARIO_ID SCENARIO_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ORGANIZATION_ID ORGANIZATION_ID, SR_INSTANCE_ID SR_INSTANCE_ID, MAPE_IN_SAMPLE MAPE_IN_SAMPLE, MAPE_OUT_SAMPLE MAPE_OUT_SAMPLE, FORECAST_VOLATILITY FORECAST_VOLATILITY, AVG_DEMAND AVG_DEMAND, 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 from "MSC"."MSC_DMD_SCN_METRICS"
View Text - HTML Formatted

SELECT PLAN_ID PLAN_ID
, SCENARIO_ID SCENARIO_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ORGANIZATION_ID ORGANIZATION_ID
, SR_INSTANCE_ID SR_INSTANCE_ID
, MAPE_IN_SAMPLE MAPE_IN_SAMPLE
, MAPE_OUT_SAMPLE MAPE_OUT_SAMPLE
, FORECAST_VOLATILITY FORECAST_VOLATILITY
, AVG_DEMAND AVG_DEMAND
, 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
FROM "MSC"."MSC_DMD_SCN_METRICS"