VIEW: MSC.MSC_SAFETY_STOCKS#

Source

View Text - Preformatted

select PLAN_ID PLAN_ID, ORGANIZATION_ID ORGANIZATION_ID, SR_INSTANCE_ID SR_INSTANCE_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, PERIOD_START_DATE PERIOD_START_DATE, SAFETY_STOCK_QUANTITY SAFETY_STOCK_QUANTITY, UPDATED UPDATED, STATUS STATUS, REFRESH_NUMBER REFRESH_NUMBER, 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, REQUEST_ID REQUEST_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, TARGET_SAFETY_STOCK TARGET_SAFETY_STOCK, PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, PLANNING_GROUP PLANNING_GROUP, USER_DEFINED_SAFETY_STOCKS USER_DEFINED_SAFETY_STOCKS, USER_DEFINED_DOS USER_DEFINED_DOS, TARGET_DAYS_OF_SUPPLY TARGET_DAYS_OF_SUPPLY, ACHIEVED_DAYS_OF_SUPPLY ACHIEVED_DAYS_OF_SUPPLY, UNIT_NUMBER UNIT_NUMBER, 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, TOTAL_UNPOOLED_SAFETY_STOCK TOTAL_UNPOOLED_SAFETY_STOCK, ITEM_TYPE_ID ITEM_TYPE_ID, ITEM_TYPE_VALUE ITEM_TYPE_VALUE, NEW_PLAN_ID NEW_PLAN_ID, SIMULATION_SET_ID SIMULATION_SET_ID, NEW_PLAN_LIST NEW_PLAN_LIST, APPLIED APPLIED from "MSC"."MSC_SAFETY_STOCKS"

View Text - HTML Formatted

SELECT PLAN_ID PLAN_ID
, ORGANIZATION_ID ORGANIZATION_ID
, SR_INSTANCE_ID SR_INSTANCE_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, PERIOD_START_DATE PERIOD_START_DATE
, SAFETY_STOCK_QUANTITY SAFETY_STOCK_QUANTITY
, UPDATED UPDATED
, STATUS STATUS
, REFRESH_NUMBER REFRESH_NUMBER
, 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
, REQUEST_ID REQUEST_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, TARGET_SAFETY_STOCK TARGET_SAFETY_STOCK
, PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
, PLANNING_GROUP PLANNING_GROUP
, USER_DEFINED_SAFETY_STOCKS USER_DEFINED_SAFETY_STOCKS
, USER_DEFINED_DOS USER_DEFINED_DOS
, TARGET_DAYS_OF_SUPPLY TARGET_DAYS_OF_SUPPLY
, ACHIEVED_DAYS_OF_SUPPLY ACHIEVED_DAYS_OF_SUPPLY
, UNIT_NUMBER UNIT_NUMBER
, 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
, TOTAL_UNPOOLED_SAFETY_STOCK TOTAL_UNPOOLED_SAFETY_STOCK
, ITEM_TYPE_ID ITEM_TYPE_ID
, ITEM_TYPE_VALUE ITEM_TYPE_VALUE
, NEW_PLAN_ID NEW_PLAN_ID
, SIMULATION_SET_ID SIMULATION_SET_ID
, NEW_PLAN_LIST NEW_PLAN_LIST
, APPLIED APPLIED
FROM "MSC"."MSC_SAFETY_STOCKS"