VIEW: MSC.MSC_PLANS_OTHER#

Source

View Text - Preformatted

select PLAN_ID PLAN_ID, MODEL_HORIZON MODEL_HORIZON, DATA_HORIZON DATA_HORIZON, HORIZON_UNITS HORIZON_UNITS, REF_PLAN_ID REF_PLAN_ID, DECIMAL_PRECISION DECIMAL_PRECISION, OFFLOAD_THRESHOLD OFFLOAD_THRESHOLD, OFFLOAD_THRESHOLD_WINDOW OFFLOAD_THRESHOLD_WINDOW, WORKDAY_TIME WORKDAY_TIME, WORKDAY_DAY WORKDAY_DAY, COST_TIME_UNIT COST_TIME_UNIT, FIXED_PRODUCTION_FENCE FIXED_PRODUCTION_FENCE, FIXED_PRODUCTION_UNITS FIXED_PRODUCTION_UNITS, CRITICAL_COMPONENTS_FLAG CRITICAL_COMPONENTS_FLAG, ALLOW_WO_OFFLOAD_FLAG ALLOW_WO_OFFLOAD_FLAG, INCLUDE_PAST_DUE_SALESORDERS INCLUDE_PAST_DUE_SALESORDERS, DEMAND_BUILD_STRATEGY DEMAND_BUILD_STRATEGY, GLOBAL_BUILD_STRATEGY GLOBAL_BUILD_STRATEGY, SHIP_COMPLETE_FLAG SHIP_COMPLETE_FLAG, CREATE_ITEM_FOLDERS CREATE_ITEM_FOLDERS, CREATE_SUPPLY_FOLDERS CREATE_SUPPLY_FOLDERS, CREATE_WORKORDER_FOLDERS CREATE_WORKORDER_FOLDERS, USE_RMO_FLAG USE_RMO_FLAG, MINIMUM_CYCLE_TIME MINIMUM_CYCLE_TIME, MINIMIZE_CHANGEOVER_FLAG MINIMIZE_CHANGEOVER_FLAG, IDEAL_SEQUENCE_BASE IDEAL_SEQUENCE_BASE, INVENTORY_COST_FACTOR INVENTORY_COST_FACTOR, STOCKOUT_COST_FACTOR STOCKOUT_COST_FACTOR, CHANGEOVER_COST_FACTOR CHANGEOVER_COST_FACTOR, SAFETY_COST_FACTOR SAFETY_COST_FACTOR, START_TIME START_TIME, OFFSET_DAYS OFFSET_DAYS, DEMAND_FORECAST_FENCE DEMAND_FORECAST_FENCE, BOTTLENECK_RESOURCE_GROUP BOTTLENECK_RESOURCE_GROUP, SIMULATION_SET SIMULATION_SET, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_ID PROGRAM_ID, PRGRAM_APPLICATION_ID PRGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, CREATE_DEMAND_FOLDERS CREATE_DEMAND_FOLDERS, USE_UNITS_OF_EFFORT USE_UNITS_OF_EFFORT, USE_ADJACENT_OPERATIONS USE_ADJACENT_OPERATIONS, PURCHASE_LEAD_TIME_OFFSET PURCHASE_LEAD_TIME_OFFSET, ENABLE_SAFETY_COVER ENABLE_SAFETY_COVER, RELEASE_FLAG RELEASE_FLAG, FIRST_CYCLE_START_DATE FIRST_CYCLE_START_DATE, ENFORCE_CRO_CYCLE ENFORCE_CRO_CYCLE, REM_CRO_RESI_PRODN REM_CRO_RESI_PRODN, INCLUDE_CMRO_WORKORDERS INCLUDE_CMRO_WORKORDERS, INCLUDE_EAM_WORKORDERS INCLUDE_EAM_WORKORDERS, CONSIDER_EAM_SCHEDULE CONSIDER_EAM_SCHEDULE, INCLUDE_DEMANDS INCLUDE_DEMANDS, INCLUDE_SUPPLIES INCLUDE_SUPPLIES, ACTIVE_ITEM_FILTER ACTIVE_ITEM_FILTER, SUPPLY_TOL_OFFSET SUPPLY_TOL_OFFSET, INC_SCENARIO_FILE INC_SCENARIO_FILE, ENFORCE_HORIZON_START ENFORCE_HORIZON_START, IMP_CLOSED_VISIT_WO IMP_CLOSED_VISIT_WO from "MSC"."MSC_PLANS_OTHER"

View Text - HTML Formatted

SELECT PLAN_ID PLAN_ID
, MODEL_HORIZON MODEL_HORIZON
, DATA_HORIZON DATA_HORIZON
, HORIZON_UNITS HORIZON_UNITS
, REF_PLAN_ID REF_PLAN_ID
, DECIMAL_PRECISION DECIMAL_PRECISION
, OFFLOAD_THRESHOLD OFFLOAD_THRESHOLD
, OFFLOAD_THRESHOLD_WINDOW OFFLOAD_THRESHOLD_WINDOW
, WORKDAY_TIME WORKDAY_TIME
, WORKDAY_DAY WORKDAY_DAY
, COST_TIME_UNIT COST_TIME_UNIT
, FIXED_PRODUCTION_FENCE FIXED_PRODUCTION_FENCE
, FIXED_PRODUCTION_UNITS FIXED_PRODUCTION_UNITS
, CRITICAL_COMPONENTS_FLAG CRITICAL_COMPONENTS_FLAG
, ALLOW_WO_OFFLOAD_FLAG ALLOW_WO_OFFLOAD_FLAG
, INCLUDE_PAST_DUE_SALESORDERS INCLUDE_PAST_DUE_SALESORDERS
, DEMAND_BUILD_STRATEGY DEMAND_BUILD_STRATEGY
, GLOBAL_BUILD_STRATEGY GLOBAL_BUILD_STRATEGY
, SHIP_COMPLETE_FLAG SHIP_COMPLETE_FLAG
, CREATE_ITEM_FOLDERS CREATE_ITEM_FOLDERS
, CREATE_SUPPLY_FOLDERS CREATE_SUPPLY_FOLDERS
, CREATE_WORKORDER_FOLDERS CREATE_WORKORDER_FOLDERS
, USE_RMO_FLAG USE_RMO_FLAG
, MINIMUM_CYCLE_TIME MINIMUM_CYCLE_TIME
, MINIMIZE_CHANGEOVER_FLAG MINIMIZE_CHANGEOVER_FLAG
, IDEAL_SEQUENCE_BASE IDEAL_SEQUENCE_BASE
, INVENTORY_COST_FACTOR INVENTORY_COST_FACTOR
, STOCKOUT_COST_FACTOR STOCKOUT_COST_FACTOR
, CHANGEOVER_COST_FACTOR CHANGEOVER_COST_FACTOR
, SAFETY_COST_FACTOR SAFETY_COST_FACTOR
, START_TIME START_TIME
, OFFSET_DAYS OFFSET_DAYS
, DEMAND_FORECAST_FENCE DEMAND_FORECAST_FENCE
, BOTTLENECK_RESOURCE_GROUP BOTTLENECK_RESOURCE_GROUP
, SIMULATION_SET SIMULATION_SET
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_ID PROGRAM_ID
, PRGRAM_APPLICATION_ID PRGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, CREATE_DEMAND_FOLDERS CREATE_DEMAND_FOLDERS
, USE_UNITS_OF_EFFORT USE_UNITS_OF_EFFORT
, USE_ADJACENT_OPERATIONS USE_ADJACENT_OPERATIONS
, PURCHASE_LEAD_TIME_OFFSET PURCHASE_LEAD_TIME_OFFSET
, ENABLE_SAFETY_COVER ENABLE_SAFETY_COVER
, RELEASE_FLAG RELEASE_FLAG
, FIRST_CYCLE_START_DATE FIRST_CYCLE_START_DATE
, ENFORCE_CRO_CYCLE ENFORCE_CRO_CYCLE
, REM_CRO_RESI_PRODN REM_CRO_RESI_PRODN
, INCLUDE_CMRO_WORKORDERS INCLUDE_CMRO_WORKORDERS
, INCLUDE_EAM_WORKORDERS INCLUDE_EAM_WORKORDERS
, CONSIDER_EAM_SCHEDULE CONSIDER_EAM_SCHEDULE
, INCLUDE_DEMANDS INCLUDE_DEMANDS
, INCLUDE_SUPPLIES INCLUDE_SUPPLIES
, ACTIVE_ITEM_FILTER ACTIVE_ITEM_FILTER
, SUPPLY_TOL_OFFSET SUPPLY_TOL_OFFSET
, INC_SCENARIO_FILE INC_SCENARIO_FILE
, ENFORCE_HORIZON_START ENFORCE_HORIZON_START
, IMP_CLOSED_VISIT_WO IMP_CLOSED_VISIT_WO
FROM "MSC"."MSC_PLANS_OTHER"