VIEW: MSC.MSC_SYSTEM_ITEMS#

Source

View Text - Preformatted

select PLAN_ID PLAN_ID, ORGANIZATION_ID ORGANIZATION_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, SR_INSTANCE_ID SR_INSTANCE_ID, SR_INVENTORY_ITEM_ID SR_INVENTORY_ITEM_ID, ITEM_NAME ITEM_NAME, LOTS_EXPIRATION LOTS_EXPIRATION, LOT_CONTROL_CODE LOT_CONTROL_CODE, SHRINKAGE_RATE SHRINKAGE_RATE, FIXED_DAYS_SUPPLY FIXED_DAYS_SUPPLY, FIXED_ORDER_QUANTITY FIXED_ORDER_QUANTITY, FIXED_LOT_MULTIPLIER FIXED_LOT_MULTIPLIER, MINIMUM_ORDER_QUANTITY MINIMUM_ORDER_QUANTITY, MAXIMUM_ORDER_QUANTITY MAXIMUM_ORDER_QUANTITY, ROUNDING_CONTROL_TYPE ROUNDING_CONTROL_TYPE, PLANNING_TIME_FENCE_DAYS PLANNING_TIME_FENCE_DAYS, PLANNING_TIME_FENCE_DATE PLANNING_TIME_FENCE_DATE, DEMAND_TIME_FENCE_DAYS DEMAND_TIME_FENCE_DAYS, DEMAND_TIME_FENCE_DATE DEMAND_TIME_FENCE_DATE, DESCRIPTION DESCRIPTION, RELEASE_TIME_FENCE_CODE RELEASE_TIME_FENCE_CODE, RELEASE_TIME_FENCE_DAYS RELEASE_TIME_FENCE_DAYS, IN_SOURCE_PLAN IN_SOURCE_PLAN, REVISION REVISION, SR_CATEGORY_ID SR_CATEGORY_ID, ABC_CLASS ABC_CLASS, CATEGORY_NAME CATEGORY_NAME, MRP_PLANNING_CODE MRP_PLANNING_CODE, FIXED_LEAD_TIME FIXED_LEAD_TIME, VARIABLE_LEAD_TIME VARIABLE_LEAD_TIME, PREPROCESSING_LEAD_TIME PREPROCESSING_LEAD_TIME, POSTPROCESSING_LEAD_TIME POSTPROCESSING_LEAD_TIME, FULL_LEAD_TIME FULL_LEAD_TIME, CUMULATIVE_TOTAL_LEAD_TIME CUMULATIVE_TOTAL_LEAD_TIME, CUM_MANUFACTURING_LEAD_TIME CUM_MANUFACTURING_LEAD_TIME, UOM_CODE UOM_CODE, UNIT_WEIGHT UNIT_WEIGHT, UNIT_VOLUME UNIT_VOLUME, WEIGHT_UOM WEIGHT_UOM, VOLUME_UOM VOLUME_UOM, PRODUCT_FAMILY_ID PRODUCT_FAMILY_ID, ATP_RULE_ID ATP_RULE_ID, ATP_COMPONENTS_FLAG ATP_COMPONENTS_FLAG, BUILD_IN_WIP_FLAG BUILD_IN_WIP_FLAG, PURCHASING_ENABLED_FLAG PURCHASING_ENABLED_FLAG, PLANNING_MAKE_BUY_CODE PLANNING_MAKE_BUY_CODE, REPETITIVE_TYPE REPETITIVE_TYPE, REPETITIVE_VARIANCE REPETITIVE_VARIANCE, STANDARD_COST STANDARD_COST, CARRYING_COST CARRYING_COST, ORDER_COST ORDER_COST, MATERIAL_COST MATERIAL_COST, DMD_LATENESS_COST DMD_LATENESS_COST, RESOURCE_COST RESOURCE_COST, SS_PENALTY_COST SS_PENALTY_COST, SUPPLIER_CAP_OVERUTIL_COST SUPPLIER_CAP_OVERUTIL_COST, LIST_PRICE LIST_PRICE, AVERAGE_DISCOUNT AVERAGE_DISCOUNT, ENGINEERING_ITEM_FLAG ENGINEERING_ITEM_FLAG, WIP_SUPPLY_TYPE WIP_SUPPLY_TYPE, SAFETY_STOCK_CODE SAFETY_STOCK_CODE, SAFETY_STOCK_PERCENT SAFETY_STOCK_PERCENT, SAFETY_STOCK_BUCKET_DAYS SAFETY_STOCK_BUCKET_DAYS, INVENTORY_USE_UP_DATE INVENTORY_USE_UP_DATE, BUYER_NAME BUYER_NAME, PLANNER_CODE PLANNER_CODE, PLANNING_EXCEPTION_SET PLANNING_EXCEPTION_SET, EXCESS_QUANTITY EXCESS_QUANTITY, EXCEPTION_SHORTAGE_DAYS EXCEPTION_SHORTAGE_DAYS, EXCEPTION_EXCESS_DAYS EXCEPTION_EXCESS_DAYS, EXCEPTION_OVERPROMISED_DAYS EXCEPTION_OVERPROMISED_DAYS, EXCEPTION_CODE EXCEPTION_CODE, BOM_ITEM_TYPE BOM_ITEM_TYPE, ATO_FORECAST_CONTROL ATO_FORECAST_CONTROL, EFFECTIVITY_CONTROL EFFECTIVITY_CONTROL, ORGANIZATION_CODE ORGANIZATION_CODE, ACCEPTABLE_RATE_INCREASE ACCEPTABLE_RATE_INCREASE, ACCEPTABLE_RATE_DECREASE ACCEPTABLE_RATE_DECREASE, EXCEPTION_REP_VARIANCE_DAYS EXCEPTION_REP_VARIANCE_DAYS, OVERRUN_PERCENTAGE OVERRUN_PERCENTAGE, INVENTORY_PLANNING_CODE INVENTORY_PLANNING_CODE, ACCEPTABLE_EARLY_DELIVERY ACCEPTABLE_EARLY_DELIVERY, CALCULATE_ATP CALCULATE_ATP, END_ASSEMBLY_PEGGING_FLAG END_ASSEMBLY_PEGGING_FLAG, END_ASSEMBLY_PEGGING END_ASSEMBLY_PEGGING, FULL_PEGGING FULL_PEGGING, INVENTORY_ITEM_FLAG INVENTORY_ITEM_FLAG, SOURCE_ORG_ID SOURCE_ORG_ID, BASE_ITEM_ID BASE_ITEM_ID, ABC_CLASS_NAME ABC_CLASS_NAME, FIXED_SAFETY_STOCK_QTY FIXED_SAFETY_STOCK_QTY, PRIMARY_SUPPLIER_ID PRIMARY_SUPPLIER_ID, ATP_FLAG ATP_FLAG, LOW_LEVEL_CODE LOW_LEVEL_CODE, PLANNER_STATUS_CODE PLANNER_STATUS_CODE, NETTABLE_INVENTORY_QUANTITY NETTABLE_INVENTORY_QUANTITY, NONNETTABLE_INVENTORY_QUANTITY NONNETTABLE_INVENTORY_QUANTITY, 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_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, REVISION_QTY_CONTROL_CODE REVISION_QTY_CONTROL_CODE, EXPENSE_ACCOUNT EXPENSE_ACCOUNT, INVENTORY_ASSET_FLAG INVENTORY_ASSET_FLAG, BUYER_ID BUYER_ID, REPETITIVE_PLANNING_FLAG REPETITIVE_PLANNING_FLAG, PICK_COMPONENTS_FLAG PICK_COMPONENTS_FLAG, SERVICE_LEVEL SERVICE_LEVEL, REPLENISH_TO_ORDER_FLAG REPLENISH_TO_ORDER_FLAG, PIP_FLAG PIP_FLAG, YIELD_CONV_FACTOR YIELD_CONV_FACTOR, MIN_MINMAX_QUANTITY MIN_MINMAX_QUANTITY, MAX_MINMAX_QUANTITY MAX_MINMAX_QUANTITY, NEW_ATP_FLAG NEW_ATP_FLAG, SOURCE_TYPE SOURCE_TYPE, SUBSTITUTION_WINDOW SUBSTITUTION_WINDOW, CREATE_SUPPLY_FLAG CREATE_SUPPLY_FLAG, REORDER_POINT REORDER_POINT, AVERAGE_ANNUAL_DEMAND AVERAGE_ANNUAL_DEMAND, ECONOMIC_ORDER_QUANTITY ECONOMIC_ORDER_QUANTITY, SERIAL_NUMBER_CONTROL_CODE SERIAL_NUMBER_CONTROL_CODE, CONVERGENCE CONVERGENCE, DIVERGENCE DIVERGENCE, CONTINOUS_TRANSFER CONTINOUS_TRANSFER, CRITICAL_COMPONENT_FLAG CRITICAL_COMPONENT_FLAG, REDUCE_MPS REDUCE_MPS, CONSIGNED_FLAG CONSIGNED_FLAG, VMI_MINIMUM_UNITS VMI_MINIMUM_UNITS, VMI_MINIMUM_DAYS VMI_MINIMUM_DAYS, VMI_MAXIMUM_UNITS VMI_MAXIMUM_UNITS, VMI_MAXIMUM_DAYS VMI_MAXIMUM_DAYS, AVERAGE_DAILY_DEMAND AVERAGE_DAILY_DEMAND, VMI_FIXED_ORDER_QUANTITY VMI_FIXED_ORDER_QUANTITY, SO_AUTHORIZATION_FLAG SO_AUTHORIZATION_FLAG, VMI_FORECAST_TYPE VMI_FORECAST_TYPE, FORECAST_HORIZON FORECAST_HORIZON, ASN_AUTOEXPIRE_FLAG ASN_AUTOEXPIRE_FLAG, VMI_REFRESH_FLAG VMI_REFRESH_FLAG, BUDGET_CONSTRAINED BUDGET_CONSTRAINED, MAX_QUANTITY MAX_QUANTITY, MAX_QUANTITY_DOS MAX_QUANTITY_DOS, DAYS_TGT_INV_WINDOW DAYS_TGT_INV_WINDOW, DAYS_MAX_INV_WINDOW DAYS_MAX_INV_WINDOW, DAYS_TGT_INV_SUPPLY DAYS_TGT_INV_SUPPLY, DAYS_MAX_INV_SUPPLY DAYS_MAX_INV_SUPPLY, DRP_PLANNED DRP_PLANNED, AGGREGATE_TIME_FENCE_DATE AGGREGATE_TIME_FENCE_DATE, INFERRED_CRITICAL_FLAG INFERRED_CRITICAL_FLAG, SS_WINDOW_SIZE SS_WINDOW_SIZE, LOWEST_LEVEL_SRC LOWEST_LEVEL_SRC, EAM_ITEM_TYPE EAM_ITEM_TYPE, LOTS_EXIST LOTS_EXIST, LEADTIME_VARIABILITY LEADTIME_VARIABILITY, MIN_SHELF_LIFE_DAYS MIN_SHELF_LIFE_DAYS, GROUP_ID GROUP_ID, REPAIR_YIELD REPAIR_YIELD, REPAIR_PROGRAM REPAIR_PROGRAM, REPAIR_LEAD_TIME REPAIR_LEAD_TIME, PRE_POSITION_INVENTORY PRE_POSITION_INVENTORY, PREPOSITION_POINT PREPOSITION_POINT, REPAIR_LEADTIME REPAIR_LEADTIME, DEMAND_FULFILLMENT_LT DEMAND_FULFILLMENT_LT, ITEM_CREATION_DATE ITEM_CREATION_DATE, SHORTAGE_TYPE SHORTAGE_TYPE, EXCESS_TYPE EXCESS_TYPE, PLANNING_TIME_FENCE_CODE PLANNING_TIME_FENCE_CODE, PEGGING_DEMAND_WINDOW_DAYS PEGGING_DEMAND_WINDOW_DAYS, PEGGING_SUPPLY_WINDOW_DAYS PEGGING_SUPPLY_WINDOW_DAYS, FORECAST_RULE_FOR_DEMANDS FORECAST_RULE_FOR_DEMANDS, FORECAST_RULE_FOR_RETURNS FORECAST_RULE_FOR_RETURNS, DEMAND_DISTRIBUTION DEMAND_DISTRIBUTION, INTERARRIVAL_TIME INTERARRIVAL_TIME, END_OF_LIFE_DATE END_OF_LIFE_DATE, STD_DMD_OVER_HORIZON STD_DMD_OVER_HORIZON, LIFE_TIME_BUY_DATE LIFE_TIME_BUY_DATE, REPAIR_COST REPAIR_COST, CRITICALITY_CATEGORY CRITICALITY_CATEGORY, AVG_DEMAND_BEYOND_PH AVG_DEMAND_BEYOND_PH, AVG_RETURNS_BEYOND_PH AVG_RETURNS_BEYOND_PH, RETURN_FORECAST_TIME_FENCE RETURN_FORECAST_TIME_FENCE, 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, BASIS_AVG_DAILY_DEMAND BASIS_AVG_DAILY_DEMAND, COEFFICIENT_OF_VARIATION COEFFICIENT_OF_VARIATION, STANDARD_DEVIATION STANDARD_DEVIATION, LAST_REPLAN_DATE LAST_REPLAN_DATE, NETCHANGE_REPLAN_FLAG NETCHANGE_REPLAN_FLAG, REPLAN_PERIOD REPLAN_PERIOD, SAFETY_LEAD_TIME SAFETY_LEAD_TIME, UNSATISFIED_DEMAND_FACTOR UNSATISFIED_DEMAND_FACTOR, MAX_USAGE_FACTOR MAX_USAGE_FACTOR, MIN_SUP_DEM_PERCENT MIN_SUP_DEM_PERCENT, DMD_SATISFIED_PERCENT DMD_SATISFIED_PERCENT, NEW_PLAN_ID NEW_PLAN_ID, NEW_PLAN_LIST NEW_PLAN_LIST, SIMULATION_SET_ID SIMULATION_SET_ID, NO_PL_ORD_BEFORE_WIP_WIN NO_PL_ORD_BEFORE_WIP_WIN, PLANNING_UNITS_OF_WORK PLANNING_UNITS_OF_WORK, EXCESS_HORIZON EXCESS_HORIZON, OBSOLESCENCE_DATE OBSOLESCENCE_DATE, COMPUTE_EOQ COMPUTE_EOQ, COMPUTE_SS COMPUTE_SS, ROP_SAFETY_STOCK ROP_SAFETY_STOCK, CONSIDER_IN_CTB_FLAG CONSIDER_IN_CTB_FLAG, CALCULATE_CTB_FLAG CALCULATE_CTB_FLAG, CTB_KPI_HORIZON CTB_KPI_HORIZON, APPLIED APPLIED, IS_MODIFIED IS_MODIFIED, INTERMITTENT_DEMAND INTERMITTENT_DEMAND, REPAIR_MODULE REPAIR_MODULE, SCRAP_RATE SCRAP_RATE, REBUILD_ACTIVITY REBUILD_ACTIVITY, ORDER_PERIOD ORDER_PERIOD, INV_DAYS_INCREMENT INV_DAYS_INCREMENT, AVERAGE_CYCLE_STOCK AVERAGE_CYCLE_STOCK, COMP_SUBSTITUTION_FLAG COMP_SUBSTITUTION_FLAG, CONSUME_BEF_PRIMARY_FLAG CONSUME_BEF_PRIMARY_FLAG from "MSC"."MSC_SYSTEM_ITEMS"

View Text - HTML Formatted

SELECT PLAN_ID PLAN_ID
, ORGANIZATION_ID ORGANIZATION_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, SR_INSTANCE_ID SR_INSTANCE_ID
, SR_INVENTORY_ITEM_ID SR_INVENTORY_ITEM_ID
, ITEM_NAME ITEM_NAME
, LOTS_EXPIRATION LOTS_EXPIRATION
, LOT_CONTROL_CODE LOT_CONTROL_CODE
, SHRINKAGE_RATE SHRINKAGE_RATE
, FIXED_DAYS_SUPPLY FIXED_DAYS_SUPPLY
, FIXED_ORDER_QUANTITY FIXED_ORDER_QUANTITY
, FIXED_LOT_MULTIPLIER FIXED_LOT_MULTIPLIER
, MINIMUM_ORDER_QUANTITY MINIMUM_ORDER_QUANTITY
, MAXIMUM_ORDER_QUANTITY MAXIMUM_ORDER_QUANTITY
, ROUNDING_CONTROL_TYPE ROUNDING_CONTROL_TYPE
, PLANNING_TIME_FENCE_DAYS PLANNING_TIME_FENCE_DAYS
, PLANNING_TIME_FENCE_DATE PLANNING_TIME_FENCE_DATE
, DEMAND_TIME_FENCE_DAYS DEMAND_TIME_FENCE_DAYS
, DEMAND_TIME_FENCE_DATE DEMAND_TIME_FENCE_DATE
, DESCRIPTION DESCRIPTION
, RELEASE_TIME_FENCE_CODE RELEASE_TIME_FENCE_CODE
, RELEASE_TIME_FENCE_DAYS RELEASE_TIME_FENCE_DAYS
, IN_SOURCE_PLAN IN_SOURCE_PLAN
, REVISION REVISION
, SR_CATEGORY_ID SR_CATEGORY_ID
, ABC_CLASS ABC_CLASS
, CATEGORY_NAME CATEGORY_NAME
, MRP_PLANNING_CODE MRP_PLANNING_CODE
, FIXED_LEAD_TIME FIXED_LEAD_TIME
, VARIABLE_LEAD_TIME VARIABLE_LEAD_TIME
, PREPROCESSING_LEAD_TIME PREPROCESSING_LEAD_TIME
, POSTPROCESSING_LEAD_TIME POSTPROCESSING_LEAD_TIME
, FULL_LEAD_TIME FULL_LEAD_TIME
, CUMULATIVE_TOTAL_LEAD_TIME CUMULATIVE_TOTAL_LEAD_TIME
, CUM_MANUFACTURING_LEAD_TIME CUM_MANUFACTURING_LEAD_TIME
, UOM_CODE UOM_CODE
, UNIT_WEIGHT UNIT_WEIGHT
, UNIT_VOLUME UNIT_VOLUME
, WEIGHT_UOM WEIGHT_UOM
, VOLUME_UOM VOLUME_UOM
, PRODUCT_FAMILY_ID PRODUCT_FAMILY_ID
, ATP_RULE_ID ATP_RULE_ID
, ATP_COMPONENTS_FLAG ATP_COMPONENTS_FLAG
, BUILD_IN_WIP_FLAG BUILD_IN_WIP_FLAG
, PURCHASING_ENABLED_FLAG PURCHASING_ENABLED_FLAG
, PLANNING_MAKE_BUY_CODE PLANNING_MAKE_BUY_CODE
, REPETITIVE_TYPE REPETITIVE_TYPE
, REPETITIVE_VARIANCE REPETITIVE_VARIANCE
, STANDARD_COST STANDARD_COST
, CARRYING_COST CARRYING_COST
, ORDER_COST ORDER_COST
, MATERIAL_COST MATERIAL_COST
, DMD_LATENESS_COST DMD_LATENESS_COST
, RESOURCE_COST RESOURCE_COST
, SS_PENALTY_COST SS_PENALTY_COST
, SUPPLIER_CAP_OVERUTIL_COST SUPPLIER_CAP_OVERUTIL_COST
, LIST_PRICE LIST_PRICE
, AVERAGE_DISCOUNT AVERAGE_DISCOUNT
, ENGINEERING_ITEM_FLAG ENGINEERING_ITEM_FLAG
, WIP_SUPPLY_TYPE WIP_SUPPLY_TYPE
, SAFETY_STOCK_CODE SAFETY_STOCK_CODE
, SAFETY_STOCK_PERCENT SAFETY_STOCK_PERCENT
, SAFETY_STOCK_BUCKET_DAYS SAFETY_STOCK_BUCKET_DAYS
, INVENTORY_USE_UP_DATE INVENTORY_USE_UP_DATE
, BUYER_NAME BUYER_NAME
, PLANNER_CODE PLANNER_CODE
, PLANNING_EXCEPTION_SET PLANNING_EXCEPTION_SET
, EXCESS_QUANTITY EXCESS_QUANTITY
, EXCEPTION_SHORTAGE_DAYS EXCEPTION_SHORTAGE_DAYS
, EXCEPTION_EXCESS_DAYS EXCEPTION_EXCESS_DAYS
, EXCEPTION_OVERPROMISED_DAYS EXCEPTION_OVERPROMISED_DAYS
, EXCEPTION_CODE EXCEPTION_CODE
, BOM_ITEM_TYPE BOM_ITEM_TYPE
, ATO_FORECAST_CONTROL ATO_FORECAST_CONTROL
, EFFECTIVITY_CONTROL EFFECTIVITY_CONTROL
, ORGANIZATION_CODE ORGANIZATION_CODE
, ACCEPTABLE_RATE_INCREASE ACCEPTABLE_RATE_INCREASE
, ACCEPTABLE_RATE_DECREASE ACCEPTABLE_RATE_DECREASE
, EXCEPTION_REP_VARIANCE_DAYS EXCEPTION_REP_VARIANCE_DAYS
, OVERRUN_PERCENTAGE OVERRUN_PERCENTAGE
, INVENTORY_PLANNING_CODE INVENTORY_PLANNING_CODE
, ACCEPTABLE_EARLY_DELIVERY ACCEPTABLE_EARLY_DELIVERY
, CALCULATE_ATP CALCULATE_ATP
, END_ASSEMBLY_PEGGING_FLAG END_ASSEMBLY_PEGGING_FLAG
, END_ASSEMBLY_PEGGING END_ASSEMBLY_PEGGING
, FULL_PEGGING FULL_PEGGING
, INVENTORY_ITEM_FLAG INVENTORY_ITEM_FLAG
, SOURCE_ORG_ID SOURCE_ORG_ID
, BASE_ITEM_ID BASE_ITEM_ID
, ABC_CLASS_NAME ABC_CLASS_NAME
, FIXED_SAFETY_STOCK_QTY FIXED_SAFETY_STOCK_QTY
, PRIMARY_SUPPLIER_ID PRIMARY_SUPPLIER_ID
, ATP_FLAG ATP_FLAG
, LOW_LEVEL_CODE LOW_LEVEL_CODE
, PLANNER_STATUS_CODE PLANNER_STATUS_CODE
, NETTABLE_INVENTORY_QUANTITY NETTABLE_INVENTORY_QUANTITY
, NONNETTABLE_INVENTORY_QUANTITY NONNETTABLE_INVENTORY_QUANTITY
, 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_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, REVISION_QTY_CONTROL_CODE REVISION_QTY_CONTROL_CODE
, EXPENSE_ACCOUNT EXPENSE_ACCOUNT
, INVENTORY_ASSET_FLAG INVENTORY_ASSET_FLAG
, BUYER_ID BUYER_ID
, REPETITIVE_PLANNING_FLAG REPETITIVE_PLANNING_FLAG
, PICK_COMPONENTS_FLAG PICK_COMPONENTS_FLAG
, SERVICE_LEVEL SERVICE_LEVEL
, REPLENISH_TO_ORDER_FLAG REPLENISH_TO_ORDER_FLAG
, PIP_FLAG PIP_FLAG
, YIELD_CONV_FACTOR YIELD_CONV_FACTOR
, MIN_MINMAX_QUANTITY MIN_MINMAX_QUANTITY
, MAX_MINMAX_QUANTITY MAX_MINMAX_QUANTITY
, NEW_ATP_FLAG NEW_ATP_FLAG
, SOURCE_TYPE SOURCE_TYPE
, SUBSTITUTION_WINDOW SUBSTITUTION_WINDOW
, CREATE_SUPPLY_FLAG CREATE_SUPPLY_FLAG
, REORDER_POINT REORDER_POINT
, AVERAGE_ANNUAL_DEMAND AVERAGE_ANNUAL_DEMAND
, ECONOMIC_ORDER_QUANTITY ECONOMIC_ORDER_QUANTITY
, SERIAL_NUMBER_CONTROL_CODE SERIAL_NUMBER_CONTROL_CODE
, CONVERGENCE CONVERGENCE
, DIVERGENCE DIVERGENCE
, CONTINOUS_TRANSFER CONTINOUS_TRANSFER
, CRITICAL_COMPONENT_FLAG CRITICAL_COMPONENT_FLAG
, REDUCE_MPS REDUCE_MPS
, CONSIGNED_FLAG CONSIGNED_FLAG
, VMI_MINIMUM_UNITS VMI_MINIMUM_UNITS
, VMI_MINIMUM_DAYS VMI_MINIMUM_DAYS
, VMI_MAXIMUM_UNITS VMI_MAXIMUM_UNITS
, VMI_MAXIMUM_DAYS VMI_MAXIMUM_DAYS
, AVERAGE_DAILY_DEMAND AVERAGE_DAILY_DEMAND
, VMI_FIXED_ORDER_QUANTITY VMI_FIXED_ORDER_QUANTITY
, SO_AUTHORIZATION_FLAG SO_AUTHORIZATION_FLAG
, VMI_FORECAST_TYPE VMI_FORECAST_TYPE
, FORECAST_HORIZON FORECAST_HORIZON
, ASN_AUTOEXPIRE_FLAG ASN_AUTOEXPIRE_FLAG
, VMI_REFRESH_FLAG VMI_REFRESH_FLAG
, BUDGET_CONSTRAINED BUDGET_CONSTRAINED
, MAX_QUANTITY MAX_QUANTITY
, MAX_QUANTITY_DOS MAX_QUANTITY_DOS
, DAYS_TGT_INV_WINDOW DAYS_TGT_INV_WINDOW
, DAYS_MAX_INV_WINDOW DAYS_MAX_INV_WINDOW
, DAYS_TGT_INV_SUPPLY DAYS_TGT_INV_SUPPLY
, DAYS_MAX_INV_SUPPLY DAYS_MAX_INV_SUPPLY
, DRP_PLANNED DRP_PLANNED
, AGGREGATE_TIME_FENCE_DATE AGGREGATE_TIME_FENCE_DATE
, INFERRED_CRITICAL_FLAG INFERRED_CRITICAL_FLAG
, SS_WINDOW_SIZE SS_WINDOW_SIZE
, LOWEST_LEVEL_SRC LOWEST_LEVEL_SRC
, EAM_ITEM_TYPE EAM_ITEM_TYPE
, LOTS_EXIST LOTS_EXIST
, LEADTIME_VARIABILITY LEADTIME_VARIABILITY
, MIN_SHELF_LIFE_DAYS MIN_SHELF_LIFE_DAYS
, GROUP_ID GROUP_ID
, REPAIR_YIELD REPAIR_YIELD
, REPAIR_PROGRAM REPAIR_PROGRAM
, REPAIR_LEAD_TIME REPAIR_LEAD_TIME
, PRE_POSITION_INVENTORY PRE_POSITION_INVENTORY
, PREPOSITION_POINT PREPOSITION_POINT
, REPAIR_LEADTIME REPAIR_LEADTIME
, DEMAND_FULFILLMENT_LT DEMAND_FULFILLMENT_LT
, ITEM_CREATION_DATE ITEM_CREATION_DATE
, SHORTAGE_TYPE SHORTAGE_TYPE
, EXCESS_TYPE EXCESS_TYPE
, PLANNING_TIME_FENCE_CODE PLANNING_TIME_FENCE_CODE
, PEGGING_DEMAND_WINDOW_DAYS PEGGING_DEMAND_WINDOW_DAYS
, PEGGING_SUPPLY_WINDOW_DAYS PEGGING_SUPPLY_WINDOW_DAYS
, FORECAST_RULE_FOR_DEMANDS FORECAST_RULE_FOR_DEMANDS
, FORECAST_RULE_FOR_RETURNS FORECAST_RULE_FOR_RETURNS
, DEMAND_DISTRIBUTION DEMAND_DISTRIBUTION
, INTERARRIVAL_TIME INTERARRIVAL_TIME
, END_OF_LIFE_DATE END_OF_LIFE_DATE
, STD_DMD_OVER_HORIZON STD_DMD_OVER_HORIZON
, LIFE_TIME_BUY_DATE LIFE_TIME_BUY_DATE
, REPAIR_COST REPAIR_COST
, CRITICALITY_CATEGORY CRITICALITY_CATEGORY
, AVG_DEMAND_BEYOND_PH AVG_DEMAND_BEYOND_PH
, AVG_RETURNS_BEYOND_PH AVG_RETURNS_BEYOND_PH
, RETURN_FORECAST_TIME_FENCE RETURN_FORECAST_TIME_FENCE
, 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
, BASIS_AVG_DAILY_DEMAND BASIS_AVG_DAILY_DEMAND
, COEFFICIENT_OF_VARIATION COEFFICIENT_OF_VARIATION
, STANDARD_DEVIATION STANDARD_DEVIATION
, LAST_REPLAN_DATE LAST_REPLAN_DATE
, NETCHANGE_REPLAN_FLAG NETCHANGE_REPLAN_FLAG
, REPLAN_PERIOD REPLAN_PERIOD
, SAFETY_LEAD_TIME SAFETY_LEAD_TIME
, UNSATISFIED_DEMAND_FACTOR UNSATISFIED_DEMAND_FACTOR
, MAX_USAGE_FACTOR MAX_USAGE_FACTOR
, MIN_SUP_DEM_PERCENT MIN_SUP_DEM_PERCENT
, DMD_SATISFIED_PERCENT DMD_SATISFIED_PERCENT
, NEW_PLAN_ID NEW_PLAN_ID
, NEW_PLAN_LIST NEW_PLAN_LIST
, SIMULATION_SET_ID SIMULATION_SET_ID
, NO_PL_ORD_BEFORE_WIP_WIN NO_PL_ORD_BEFORE_WIP_WIN
, PLANNING_UNITS_OF_WORK PLANNING_UNITS_OF_WORK
, EXCESS_HORIZON EXCESS_HORIZON
, OBSOLESCENCE_DATE OBSOLESCENCE_DATE
, COMPUTE_EOQ COMPUTE_EOQ
, COMPUTE_SS COMPUTE_SS
, ROP_SAFETY_STOCK ROP_SAFETY_STOCK
, CONSIDER_IN_CTB_FLAG CONSIDER_IN_CTB_FLAG
, CALCULATE_CTB_FLAG CALCULATE_CTB_FLAG
, CTB_KPI_HORIZON CTB_KPI_HORIZON
, APPLIED APPLIED
, IS_MODIFIED IS_MODIFIED
, INTERMITTENT_DEMAND INTERMITTENT_DEMAND
, REPAIR_MODULE REPAIR_MODULE
, SCRAP_RATE SCRAP_RATE
, REBUILD_ACTIVITY REBUILD_ACTIVITY
, ORDER_PERIOD ORDER_PERIOD
, INV_DAYS_INCREMENT INV_DAYS_INCREMENT
, AVERAGE_CYCLE_STOCK AVERAGE_CYCLE_STOCK
, COMP_SUBSTITUTION_FLAG COMP_SUBSTITUTION_FLAG
, CONSUME_BEF_PRIMARY_FLAG CONSUME_BEF_PRIMARY_FLAG
FROM "MSC"."MSC_SYSTEM_ITEMS"