VIEW: MSC.MSC_ITEM_ATTRIBUTES#

Source

View Text - Preformatted

select SIMULATION_SET_ID SIMULATION_SET_ID, PLAN_ID PLAN_ID, ORGANIZATION_ID ORGANIZATION_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, SR_INSTANCE_ID SR_INSTANCE_ID, CRITICAL_COMPONENT_FLAG CRITICAL_COMPONENT_FLAG, 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_PERCENT SAFETY_STOCK_PERCENT, ABC_CLASS ABC_CLASS, 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, UPDATED_COLUMNS_COUNT UPDATED_COLUMNS_COUNT, FULL_LEAD_TIME FULL_LEAD_TIME, SAFETY_STOCK_CODE SAFETY_STOCK_CODE, ABC_CLASS_NAME ABC_CLASS_NAME, VMI_MAXIMUM_UNITS VMI_MAXIMUM_UNITS, VMI_MINIMUM_UNITS VMI_MINIMUM_UNITS, VMI_MINIMUM_DAYS VMI_MINIMUM_DAYS, VMI_MAXIMUM_DAYS VMI_MAXIMUM_DAYS, VMI_FIXED_ORDER_QUANTITY VMI_FIXED_ORDER_QUANTITY, CONSIGNED_FLAG CONSIGNED_FLAG, LOTS_EXPIRATION LOTS_EXPIRATION, 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, 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, REPAIR_LEAD_TIME REPAIR_LEAD_TIME, REPAIR_YIELD REPAIR_YIELD, REPAIR_COST REPAIR_COST, CRITICALITY_CATEGORY CRITICALITY_CATEGORY, RELIABILITY RELIABILITY, FAILURE_IMPACT FAILURE_IMPACT, STANDARD_DEVIATION STANDARD_DEVIATION, COEFFICIENT_OF_VARIATION COEFFICIENT_OF_VARIATION, USER_ATTRIBUTE1 USER_ATTRIBUTE1, USER_ATTRIBUTE2 USER_ATTRIBUTE2, USER_ATTRIBUTE3 USER_ATTRIBUTE3, USER_ATTRIBUTE4 USER_ATTRIBUTE4, USER_ATTRIBUTE5 USER_ATTRIBUTE5, USER_ATTRIBUTE6 USER_ATTRIBUTE6, USER_ATTRIBUTE7 USER_ATTRIBUTE7, USER_ATTRIBUTE8 USER_ATTRIBUTE8, USER_ATTRIBUTE9 USER_ATTRIBUTE9, USER_ATTRIBUTE10 USER_ATTRIBUTE10, USER_ATTRIBUTE11 USER_ATTRIBUTE11, USER_ATTRIBUTE12 USER_ATTRIBUTE12, USER_ATTRIBUTE13 USER_ATTRIBUTE13, USER_ATTRIBUTE14 USER_ATTRIBUTE14, USER_ATTRIBUTE15 USER_ATTRIBUTE15, BASIS_AVG_DAILY_DEMAND BASIS_AVG_DAILY_DEMAND, REGION_ID REGION_ID, 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, REGION REGION, REGION_INSTANCE_ID REGION_INSTANCE_ID, SAFETY_LEAD_TIME SAFETY_LEAD_TIME, UNSATISFIED_DEMAND_FACTOR UNSATISFIED_DEMAND_FACTOR, INTERMITTENT_DEMAND INTERMITTENT_DEMAND, CUSTOMER_ID CUSTOMER_ID, CUSTOMER_SITE_ID CUSTOMER_SITE_ID, CUSTOMER_INSTANCE_ID CUSTOMER_INSTANCE_ID, MIN_REM_SHELF_LIFE_DAYS MIN_REM_SHELF_LIFE_DAYS, MAX_USAGE_FACTOR MAX_USAGE_FACTOR, DMD_SATISFIED_PERCENT DMD_SATISFIED_PERCENT, MIN_SUP_DEM_PERCENT MIN_SUP_DEM_PERCENT, PICK_PACK_LT PICK_PACK_LT, REPAIR_PROGRAM REPAIR_PROGRAM, PRE_POSITION_POINT PRE_POSITION_POINT, NEW_PLANNED_ORDER NEW_PLANNED_ORDER, ROP_SAFETY_STOCK ROP_SAFETY_STOCK, ORDER_COST ORDER_COST, COMPUTE_SS COMPUTE_SS, COMPUTE_EOQ COMPUTE_EOQ, ANNUAL_USAGE ANNUAL_USAGE, ANNUAL_CARRYING_COST ANNUAL_CARRYING_COST, BUYER_NAME BUYER_NAME, INTERMITTENCY_THRESHOLD INTERMITTENCY_THRESHOLD, REPAIR_MODULE REPAIR_MODULE, SCRAP_RATE SCRAP_RATE, REBUILD_ACTIVITY REBUILD_ACTIVITY, ORDER_PERIOD ORDER_PERIOD, INV_DAYS_INCREMENT INV_DAYS_INCREMENT from "MSC"."MSC_ITEM_ATTRIBUTES"

View Text - HTML Formatted

SELECT SIMULATION_SET_ID SIMULATION_SET_ID
, PLAN_ID PLAN_ID
, ORGANIZATION_ID ORGANIZATION_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, SR_INSTANCE_ID SR_INSTANCE_ID
, CRITICAL_COMPONENT_FLAG CRITICAL_COMPONENT_FLAG
, 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_PERCENT SAFETY_STOCK_PERCENT
, ABC_CLASS ABC_CLASS
, 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
, UPDATED_COLUMNS_COUNT UPDATED_COLUMNS_COUNT
, FULL_LEAD_TIME FULL_LEAD_TIME
, SAFETY_STOCK_CODE SAFETY_STOCK_CODE
, ABC_CLASS_NAME ABC_CLASS_NAME
, VMI_MAXIMUM_UNITS VMI_MAXIMUM_UNITS
, VMI_MINIMUM_UNITS VMI_MINIMUM_UNITS
, VMI_MINIMUM_DAYS VMI_MINIMUM_DAYS
, VMI_MAXIMUM_DAYS VMI_MAXIMUM_DAYS
, VMI_FIXED_ORDER_QUANTITY VMI_FIXED_ORDER_QUANTITY
, CONSIGNED_FLAG CONSIGNED_FLAG
, LOTS_EXPIRATION LOTS_EXPIRATION
, 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
, 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
, REPAIR_LEAD_TIME REPAIR_LEAD_TIME
, REPAIR_YIELD REPAIR_YIELD
, REPAIR_COST REPAIR_COST
, CRITICALITY_CATEGORY CRITICALITY_CATEGORY
, RELIABILITY RELIABILITY
, FAILURE_IMPACT FAILURE_IMPACT
, STANDARD_DEVIATION STANDARD_DEVIATION
, COEFFICIENT_OF_VARIATION COEFFICIENT_OF_VARIATION
, USER_ATTRIBUTE1 USER_ATTRIBUTE1
, USER_ATTRIBUTE2 USER_ATTRIBUTE2
, USER_ATTRIBUTE3 USER_ATTRIBUTE3
, USER_ATTRIBUTE4 USER_ATTRIBUTE4
, USER_ATTRIBUTE5 USER_ATTRIBUTE5
, USER_ATTRIBUTE6 USER_ATTRIBUTE6
, USER_ATTRIBUTE7 USER_ATTRIBUTE7
, USER_ATTRIBUTE8 USER_ATTRIBUTE8
, USER_ATTRIBUTE9 USER_ATTRIBUTE9
, USER_ATTRIBUTE10 USER_ATTRIBUTE10
, USER_ATTRIBUTE11 USER_ATTRIBUTE11
, USER_ATTRIBUTE12 USER_ATTRIBUTE12
, USER_ATTRIBUTE13 USER_ATTRIBUTE13
, USER_ATTRIBUTE14 USER_ATTRIBUTE14
, USER_ATTRIBUTE15 USER_ATTRIBUTE15
, BASIS_AVG_DAILY_DEMAND BASIS_AVG_DAILY_DEMAND
, REGION_ID REGION_ID
, 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
, REGION REGION
, REGION_INSTANCE_ID REGION_INSTANCE_ID
, SAFETY_LEAD_TIME SAFETY_LEAD_TIME
, UNSATISFIED_DEMAND_FACTOR UNSATISFIED_DEMAND_FACTOR
, INTERMITTENT_DEMAND INTERMITTENT_DEMAND
, CUSTOMER_ID CUSTOMER_ID
, CUSTOMER_SITE_ID CUSTOMER_SITE_ID
, CUSTOMER_INSTANCE_ID CUSTOMER_INSTANCE_ID
, MIN_REM_SHELF_LIFE_DAYS MIN_REM_SHELF_LIFE_DAYS
, MAX_USAGE_FACTOR MAX_USAGE_FACTOR
, DMD_SATISFIED_PERCENT DMD_SATISFIED_PERCENT
, MIN_SUP_DEM_PERCENT MIN_SUP_DEM_PERCENT
, PICK_PACK_LT PICK_PACK_LT
, REPAIR_PROGRAM REPAIR_PROGRAM
, PRE_POSITION_POINT PRE_POSITION_POINT
, NEW_PLANNED_ORDER NEW_PLANNED_ORDER
, ROP_SAFETY_STOCK ROP_SAFETY_STOCK
, ORDER_COST ORDER_COST
, COMPUTE_SS COMPUTE_SS
, COMPUTE_EOQ COMPUTE_EOQ
, ANNUAL_USAGE ANNUAL_USAGE
, ANNUAL_CARRYING_COST ANNUAL_CARRYING_COST
, BUYER_NAME BUYER_NAME
, INTERMITTENCY_THRESHOLD INTERMITTENCY_THRESHOLD
, REPAIR_MODULE REPAIR_MODULE
, SCRAP_RATE SCRAP_RATE
, REBUILD_ACTIVITY REBUILD_ACTIVITY
, ORDER_PERIOD ORDER_PERIOD
, INV_DAYS_INCREMENT INV_DAYS_INCREMENT
FROM "MSC"."MSC_ITEM_ATTRIBUTES"