VIEW: MSC.MSC_ST_ITEM_ATTRIBUTES#

Source

View Text - Preformatted

select SIMULATION_SET_NAME SIMULATION_SET_NAME, ITEM_NAME ITEM_NAME, ORGANIZATION_CODE ORGANIZATION_CODE, SR_INSTANCE_CODE SR_INSTANCE_CODE, ZONE ZONE, CUSTOMER_NAME CUSTOMER_NAME, CUSTOMER_SITE_NAME CUSTOMER_SITE_NAME, CATEGORY CATEGORY, CRITICAL_COMPONENT_FLAG CRITICAL_COMPONENT_FLAG, FULL_LEAD_TIME FULL_LEAD_TIME, PREPROCESSING_LEAD_TIME PREPROCESSING_LEAD_TIME, POSTPROCESSING_LEAD_TIME POSTPROCESSING_LEAD_TIME, FIXED_LEAD_TIME FIXED_LEAD_TIME, VARIABLE_LEAD_TIME VARIABLE_LEAD_TIME, FIXED_ORDER_QUANTITY FIXED_ORDER_QUANTITY, FIXED_DAYS_SUPPLY FIXED_DAYS_SUPPLY, SHRINKAGE_RATE SHRINKAGE_RATE, FIXED_LOT_MULTIPLIER FIXED_LOT_MULTIPLIER, MINIMUM_ORDER_QUANTITY MINIMUM_ORDER_QUANTITY, MAXIMUM_ORDER_QUANTITY MAXIMUM_ORDER_QUANTITY, SERVICE_LEVEL SERVICE_LEVEL, CARRYING_COST CARRYING_COST, DEMAND_TIME_FENCE_DAYS DEMAND_TIME_FENCE_DAYS, ATO_FORECAST_CONTROL ATO_FORECAST_CONTROL, PLANNING_TIME_FENCE_DAYS PLANNING_TIME_FENCE_DAYS, STANDARD_COST STANDARD_COST, PIP_FLAG PIP_FLAG, LIST_PRICE LIST_PRICE, SUBSTITUTION_WINDOW SUBSTITUTION_WINDOW, SAFETY_STOCK_BUCKET_DAYS SAFETY_STOCK_BUCKET_DAYS, UNIT_WEIGHT UNIT_WEIGHT, UNIT_VOLUME UNIT_VOLUME, SAFETY_STOCK_CODE SAFETY_STOCK_CODE, SAFETY_STOCK_PERCENT SAFETY_STOCK_PERCENT, ABC_CLASS_NAME ABC_CLASS_NAME, MRP_PLANNING_CODE MRP_PLANNING_CODE, DRP_PLANNED DRP_PLANNED, DAYS_MAX_INV_SUPPLY DAYS_MAX_INV_SUPPLY, DAYS_MAX_INV_WINDOW DAYS_MAX_INV_WINDOW, DAYS_TGT_INV_SUPPLY DAYS_TGT_INV_SUPPLY, DAYS_TGT_INV_WINDOW DAYS_TGT_INV_WINDOW, CONTINOUS_TRANSFER CONTINOUS_TRANSFER, CONVERGENCE CONVERGENCE, CREATE_SUPPLY_FLAG CREATE_SUPPLY_FLAG, DIVERGENCE DIVERGENCE, PLANNING_EXCEPTION_SET PLANNING_EXCEPTION_SET, INVENTORY_USE_UP_DATE INVENTORY_USE_UP_DATE, PLANNING_MAKE_BUY_CODE PLANNING_MAKE_BUY_CODE, WEIGHT_UOM WEIGHT_UOM, VOLUME_UOM VOLUME_UOM, ROUNDING_CONTROL_TYPE ROUNDING_CONTROL_TYPE, ATP_FLAG ATP_FLAG, ATP_COMPONENTS_FLAG ATP_COMPONENTS_FLAG, DEMAND_FULFILLMENT_LT DEMAND_FULFILLMENT_LT, LOTS_EXPIRATION LOTS_EXPIRATION, VMI_MINIMUM_UNITS VMI_MINIMUM_UNITS, VMI_MINIMUM_DAYS VMI_MINIMUM_DAYS, VMI_MAXIMUM_UNITS VMI_MAXIMUM_UNITS, VMI_MAXIMUM_DAYS VMI_MAXIMUM_DAYS, VMI_FIXED_ORDER_QUANTITY VMI_FIXED_ORDER_QUANTITY, CONSIGNED_FLAG CONSIGNED_FLAG, LEADTIME_VARIABILITY LEADTIME_VARIABILITY, PLANNER_CODE PLANNER_CODE, EO_FLAG EO_FLAG, EXCESS_HORIZON EXCESS_HORIZON, OBSOLESCENCE_DATE OBSOLESCENCE_DATE, MIN_SHELF_LIFE_DAYS MIN_SHELF_LIFE_DAYS, REPAIR_LEAD_TIME REPAIR_LEAD_TIME, REPAIR_YIELD REPAIR_YIELD, REPAIR_COST REPAIR_COST, RELIABILITY RELIABILITY, FAILURE_IMPACT FAILURE_IMPACT, STANDARD_DEVIATION STANDARD_DEVIATION, COEFFICIENT_OF_VARIATION COEFFICIENT_OF_VARIATION, BASIS_AVG_DAILY_DEMAND BASIS_AVG_DAILY_DEMAND, FORECAST_RULE_FOR_DEMANDS FORECAST_RULE_FOR_DEMANDS, FORECAST_RULE_FOR_RETURNS FORECAST_RULE_FOR_RETURNS, LIFE_TIME_BUY_DATE LIFE_TIME_BUY_DATE, END_OF_LIFE_DATE END_OF_LIFE_DATE, AVG_DEMAND_BEYOND_PH AVG_DEMAND_BEYOND_PH, AVG_RETURNS_BEYOND_PH AVG_RETURNS_BEYOND_PH, RETURN_FORECAST_TIME_FENCE RETURN_FORECAST_TIME_FENCE, AVERAGE_DAILY_DEMAND AVERAGE_DAILY_DEMAND, DEFECTIVE_ITEM_COST DEFECTIVE_ITEM_COST, STD_DEVIATION_FOR_DEMAND STD_DEVIATION_FOR_DEMAND, MEAN_INTER_ARRIVAL MEAN_INTER_ARRIVAL, STD_DEVIATION_INTER_ARRIVAL STD_DEVIATION_INTER_ARRIVAL, INTERARRIVAL_DIST_METHOD INTERARRIVAL_DIST_METHOD, INTERMITTENT_DEMAND INTERMITTENT_DEMAND, MAX_USAGE_FACTOR MAX_USAGE_FACTOR, MIN_REM_SHELF_LIFE_DAYS MIN_REM_SHELF_LIFE_DAYS, UNSATISFIED_DEMAND_FACTOR UNSATISFIED_DEMAND_FACTOR, DMD_SATISFIED_PERCENT DMD_SATISFIED_PERCENT, MIN_SUP_DEM_PERCENT MIN_SUP_DEM_PERCENT, REQUEST_ID REQUEST_ID, ROP_SAFETY_STOCK ROP_SAFETY_STOCK, COMPUTE_SS COMPUTE_SS, COMPUTE_EOQ COMPUTE_EOQ, ORDER_COST ORDER_COST, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY from "MSC"."MSC_ST_ITEM_ATTRIBUTES"

View Text - HTML Formatted

SELECT SIMULATION_SET_NAME SIMULATION_SET_NAME
, ITEM_NAME ITEM_NAME
, ORGANIZATION_CODE ORGANIZATION_CODE
, SR_INSTANCE_CODE SR_INSTANCE_CODE
, ZONE ZONE
, CUSTOMER_NAME CUSTOMER_NAME
, CUSTOMER_SITE_NAME CUSTOMER_SITE_NAME
, CATEGORY CATEGORY
, CRITICAL_COMPONENT_FLAG CRITICAL_COMPONENT_FLAG
, FULL_LEAD_TIME FULL_LEAD_TIME
, PREPROCESSING_LEAD_TIME PREPROCESSING_LEAD_TIME
, POSTPROCESSING_LEAD_TIME POSTPROCESSING_LEAD_TIME
, FIXED_LEAD_TIME FIXED_LEAD_TIME
, VARIABLE_LEAD_TIME VARIABLE_LEAD_TIME
, FIXED_ORDER_QUANTITY FIXED_ORDER_QUANTITY
, FIXED_DAYS_SUPPLY FIXED_DAYS_SUPPLY
, SHRINKAGE_RATE SHRINKAGE_RATE
, FIXED_LOT_MULTIPLIER FIXED_LOT_MULTIPLIER
, MINIMUM_ORDER_QUANTITY MINIMUM_ORDER_QUANTITY
, MAXIMUM_ORDER_QUANTITY MAXIMUM_ORDER_QUANTITY
, SERVICE_LEVEL SERVICE_LEVEL
, CARRYING_COST CARRYING_COST
, DEMAND_TIME_FENCE_DAYS DEMAND_TIME_FENCE_DAYS
, ATO_FORECAST_CONTROL ATO_FORECAST_CONTROL
, PLANNING_TIME_FENCE_DAYS PLANNING_TIME_FENCE_DAYS
, STANDARD_COST STANDARD_COST
, PIP_FLAG PIP_FLAG
, LIST_PRICE LIST_PRICE
, SUBSTITUTION_WINDOW SUBSTITUTION_WINDOW
, SAFETY_STOCK_BUCKET_DAYS SAFETY_STOCK_BUCKET_DAYS
, UNIT_WEIGHT UNIT_WEIGHT
, UNIT_VOLUME UNIT_VOLUME
, SAFETY_STOCK_CODE SAFETY_STOCK_CODE
, SAFETY_STOCK_PERCENT SAFETY_STOCK_PERCENT
, ABC_CLASS_NAME ABC_CLASS_NAME
, MRP_PLANNING_CODE MRP_PLANNING_CODE
, DRP_PLANNED DRP_PLANNED
, DAYS_MAX_INV_SUPPLY DAYS_MAX_INV_SUPPLY
, DAYS_MAX_INV_WINDOW DAYS_MAX_INV_WINDOW
, DAYS_TGT_INV_SUPPLY DAYS_TGT_INV_SUPPLY
, DAYS_TGT_INV_WINDOW DAYS_TGT_INV_WINDOW
, CONTINOUS_TRANSFER CONTINOUS_TRANSFER
, CONVERGENCE CONVERGENCE
, CREATE_SUPPLY_FLAG CREATE_SUPPLY_FLAG
, DIVERGENCE DIVERGENCE
, PLANNING_EXCEPTION_SET PLANNING_EXCEPTION_SET
, INVENTORY_USE_UP_DATE INVENTORY_USE_UP_DATE
, PLANNING_MAKE_BUY_CODE PLANNING_MAKE_BUY_CODE
, WEIGHT_UOM WEIGHT_UOM
, VOLUME_UOM VOLUME_UOM
, ROUNDING_CONTROL_TYPE ROUNDING_CONTROL_TYPE
, ATP_FLAG ATP_FLAG
, ATP_COMPONENTS_FLAG ATP_COMPONENTS_FLAG
, DEMAND_FULFILLMENT_LT DEMAND_FULFILLMENT_LT
, LOTS_EXPIRATION LOTS_EXPIRATION
, VMI_MINIMUM_UNITS VMI_MINIMUM_UNITS
, VMI_MINIMUM_DAYS VMI_MINIMUM_DAYS
, VMI_MAXIMUM_UNITS VMI_MAXIMUM_UNITS
, VMI_MAXIMUM_DAYS VMI_MAXIMUM_DAYS
, VMI_FIXED_ORDER_QUANTITY VMI_FIXED_ORDER_QUANTITY
, CONSIGNED_FLAG CONSIGNED_FLAG
, LEADTIME_VARIABILITY LEADTIME_VARIABILITY
, PLANNER_CODE PLANNER_CODE
, EO_FLAG EO_FLAG
, EXCESS_HORIZON EXCESS_HORIZON
, OBSOLESCENCE_DATE OBSOLESCENCE_DATE
, MIN_SHELF_LIFE_DAYS MIN_SHELF_LIFE_DAYS
, REPAIR_LEAD_TIME REPAIR_LEAD_TIME
, REPAIR_YIELD REPAIR_YIELD
, REPAIR_COST REPAIR_COST
, RELIABILITY RELIABILITY
, FAILURE_IMPACT FAILURE_IMPACT
, STANDARD_DEVIATION STANDARD_DEVIATION
, COEFFICIENT_OF_VARIATION COEFFICIENT_OF_VARIATION
, BASIS_AVG_DAILY_DEMAND BASIS_AVG_DAILY_DEMAND
, FORECAST_RULE_FOR_DEMANDS FORECAST_RULE_FOR_DEMANDS
, FORECAST_RULE_FOR_RETURNS FORECAST_RULE_FOR_RETURNS
, LIFE_TIME_BUY_DATE LIFE_TIME_BUY_DATE
, END_OF_LIFE_DATE END_OF_LIFE_DATE
, AVG_DEMAND_BEYOND_PH AVG_DEMAND_BEYOND_PH
, AVG_RETURNS_BEYOND_PH AVG_RETURNS_BEYOND_PH
, RETURN_FORECAST_TIME_FENCE RETURN_FORECAST_TIME_FENCE
, AVERAGE_DAILY_DEMAND AVERAGE_DAILY_DEMAND
, DEFECTIVE_ITEM_COST DEFECTIVE_ITEM_COST
, STD_DEVIATION_FOR_DEMAND STD_DEVIATION_FOR_DEMAND
, MEAN_INTER_ARRIVAL MEAN_INTER_ARRIVAL
, STD_DEVIATION_INTER_ARRIVAL STD_DEVIATION_INTER_ARRIVAL
, INTERARRIVAL_DIST_METHOD INTERARRIVAL_DIST_METHOD
, INTERMITTENT_DEMAND INTERMITTENT_DEMAND
, MAX_USAGE_FACTOR MAX_USAGE_FACTOR
, MIN_REM_SHELF_LIFE_DAYS MIN_REM_SHELF_LIFE_DAYS
, UNSATISFIED_DEMAND_FACTOR UNSATISFIED_DEMAND_FACTOR
, DMD_SATISFIED_PERCENT DMD_SATISFIED_PERCENT
, MIN_SUP_DEM_PERCENT MIN_SUP_DEM_PERCENT
, REQUEST_ID REQUEST_ID
, ROP_SAFETY_STOCK ROP_SAFETY_STOCK
, COMPUTE_SS COMPUTE_SS
, COMPUTE_EOQ COMPUTE_EOQ
, ORDER_COST ORDER_COST
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
FROM "MSC"."MSC_ST_ITEM_ATTRIBUTES"