VIEW: MSC.MSC_ANALYSIS_AGGREGATE#

Source

View Text - Preformatted

select PLAN_ID PLAN_ID, RECORD_TYPE RECORD_TYPE, SAFETY_STOCK_QTY SAFETY_STOCK_QTY, SAFETY_STOCK_DOLLARS SAFETY_STOCK_DOLLARS, SAFETY_STOCK_DOS SAFETY_STOCK_DOS, TARGET_SAFETY_STOCK_QTY TARGET_SAFETY_STOCK_QTY, TARGET_SAFETY_STOCK_DOLLARS TARGET_SAFETY_STOCK_DOLLARS, TARGET_SAFETY_STOCK_DOS TARGET_SAFETY_STOCK_DOS, USERDEF_SAFETY_STOCK_QTY USERDEF_SAFETY_STOCK_QTY, USERDEF_SAFETY_STOCK_DOLLARS USERDEF_SAFETY_STOCK_DOLLARS, USERDEF_SAFETY_STOCK_DOS USERDEF_SAFETY_STOCK_DOS, ACHIEVED_SERVICE_LEVEL ACHIEVED_SERVICE_LEVEL, ACHIEVED_SERVICE_LEVEL_QTY1 ACHIEVED_SERVICE_LEVEL_QTY1, ACHIEVED_SERVICE_LEVEL_QTY2 ACHIEVED_SERVICE_LEVEL_QTY2, TARGET_SERVICE_LEVEL TARGET_SERVICE_LEVEL, INVENTORY_VALUE_DOLLARS INVENTORY_VALUE_DOLLARS, PERIOD_TYPE PERIOD_TYPE, WEEK_START_DATE WEEK_START_DATE, PERIOD_START_DATE PERIOD_START_DATE, SR_INSTANCE_ID SR_INSTANCE_ID, ORGANIZATION_ID ORGANIZATION_ID, SR_CAT_INSTANCE_ID SR_CAT_INSTANCE_ID, SR_CATEGORY_ID SR_CATEGORY_ID, CATEGORY_NAME CATEGORY_NAME, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, TOTAL_UNPOOLED_SAFETY_STOCK TOTAL_UNPOOLED_SAFETY_STOCK, DEMAND_VAR_SS_PERCENT DEMAND_VAR_SS_PERCENT, MFG_LTVAR_SS_PERCENT MFG_LTVAR_SS_PERCENT, TRANSIT_LTVAR_SS_PERCENT TRANSIT_LTVAR_SS_PERCENT, SUP_LTVAR_SS_PERCENT SUP_LTVAR_SS_PERCENT, DEMAND_CLASS DEMAND_CLASS, CATEGORY_SET_ID CATEGORY_SET_ID, PLANNED_PRODUCTION_COST PLANNED_PRODUCTION_COST, PLANNED_CARRYING_COST PLANNED_CARRYING_COST, PLANNED_PURCHASING_COST PLANNED_PURCHASING_COST, PLANNED_TP_COST PLANNED_TP_COST, PLANNED_TOTAL_COST PLANNED_TOTAL_COST, PLANNED_REVENUE PLANNED_REVENUE, PLAN_NAME PLAN_NAME, DETAIL_LEVEL DETAIL_LEVEL, CATEGORY_ID CATEGORY_ID from "MSC"."MSC_ANALYSIS_AGGREGATE"

View Text - HTML Formatted

SELECT PLAN_ID PLAN_ID
, RECORD_TYPE RECORD_TYPE
, SAFETY_STOCK_QTY SAFETY_STOCK_QTY
, SAFETY_STOCK_DOLLARS SAFETY_STOCK_DOLLARS
, SAFETY_STOCK_DOS SAFETY_STOCK_DOS
, TARGET_SAFETY_STOCK_QTY TARGET_SAFETY_STOCK_QTY
, TARGET_SAFETY_STOCK_DOLLARS TARGET_SAFETY_STOCK_DOLLARS
, TARGET_SAFETY_STOCK_DOS TARGET_SAFETY_STOCK_DOS
, USERDEF_SAFETY_STOCK_QTY USERDEF_SAFETY_STOCK_QTY
, USERDEF_SAFETY_STOCK_DOLLARS USERDEF_SAFETY_STOCK_DOLLARS
, USERDEF_SAFETY_STOCK_DOS USERDEF_SAFETY_STOCK_DOS
, ACHIEVED_SERVICE_LEVEL ACHIEVED_SERVICE_LEVEL
, ACHIEVED_SERVICE_LEVEL_QTY1 ACHIEVED_SERVICE_LEVEL_QTY1
, ACHIEVED_SERVICE_LEVEL_QTY2 ACHIEVED_SERVICE_LEVEL_QTY2
, TARGET_SERVICE_LEVEL TARGET_SERVICE_LEVEL
, INVENTORY_VALUE_DOLLARS INVENTORY_VALUE_DOLLARS
, PERIOD_TYPE PERIOD_TYPE
, WEEK_START_DATE WEEK_START_DATE
, PERIOD_START_DATE PERIOD_START_DATE
, SR_INSTANCE_ID SR_INSTANCE_ID
, ORGANIZATION_ID ORGANIZATION_ID
, SR_CAT_INSTANCE_ID SR_CAT_INSTANCE_ID
, SR_CATEGORY_ID SR_CATEGORY_ID
, CATEGORY_NAME CATEGORY_NAME
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, TOTAL_UNPOOLED_SAFETY_STOCK TOTAL_UNPOOLED_SAFETY_STOCK
, DEMAND_VAR_SS_PERCENT DEMAND_VAR_SS_PERCENT
, MFG_LTVAR_SS_PERCENT MFG_LTVAR_SS_PERCENT
, TRANSIT_LTVAR_SS_PERCENT TRANSIT_LTVAR_SS_PERCENT
, SUP_LTVAR_SS_PERCENT SUP_LTVAR_SS_PERCENT
, DEMAND_CLASS DEMAND_CLASS
, CATEGORY_SET_ID CATEGORY_SET_ID
, PLANNED_PRODUCTION_COST PLANNED_PRODUCTION_COST
, PLANNED_CARRYING_COST PLANNED_CARRYING_COST
, PLANNED_PURCHASING_COST PLANNED_PURCHASING_COST
, PLANNED_TP_COST PLANNED_TP_COST
, PLANNED_TOTAL_COST PLANNED_TOTAL_COST
, PLANNED_REVENUE PLANNED_REVENUE
, PLAN_NAME PLAN_NAME
, DETAIL_LEVEL DETAIL_LEVEL
, CATEGORY_ID CATEGORY_ID
FROM "MSC"."MSC_ANALYSIS_AGGREGATE"