eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: MSC.MSC_PLANS#

Source

View Text - Preformatted


select PLAN_ID PLAN_ID, COMPILE_DESIGNATOR COMPILE_DESIGNATOR, SR_INSTANCE_ID SR_INSTANCE_ID, APPEND_PLANNED_ORDERS APPEND_PLANNED_ORDERS, ASSIGNMENT_SET_ID ASSIGNMENT_SET_ID, CURR_APPEND_PLANNED_ORDERS CURR_APPEND_PLANNED_ORDERS, CURR_ASSIGNMENT_SET_ID CURR_ASSIGNMENT_SET_ID, CURR_BILL_OF_RESOURCES CURR_BILL_OF_RESOURCES, CURR_CONSIDER_PO CURR_CONSIDER_PO, CURR_CONSIDER_RESERVATIONS CURR_CONSIDER_RESERVATIONS, CURR_CONSIDER_WIP CURR_CONSIDER_WIP, CURR_CUTOFF_DATE CURR_CUTOFF_DATE, CURR_DEMAND_TIME_FENCE_FLAG CURR_DEMAND_TIME_FENCE_FLAG, CURR_HARD_PEGGING_LEVEL CURR_HARD_PEGGING_LEVEL, CURR_FULL_PEGGING CURR_FULL_PEGGING, CURR_INCLUDED_ITEMS CURR_INCLUDED_ITEMS, CURR_OPERATION_SCHEDULE_TYPE CURR_OPERATION_SCHEDULE_TYPE, CURR_OVERWRITE_OPTION CURR_OVERWRITE_OPTION, CURR_PART_INCLUDE_TYPE CURR_PART_INCLUDE_TYPE, CURR_PLANNING_TIME_FENCE_FLAG CURR_PLANNING_TIME_FENCE_FLAG, CURR_PLAN_CAPACITY_FLAG CURR_PLAN_CAPACITY_FLAG, CURR_PLAN_SAFETY_STOCK CURR_PLAN_SAFETY_STOCK, CURR_PLAN_TYPE CURR_PLAN_TYPE, CURR_RESERVATION_LEVEL CURR_RESERVATION_LEVEL, CURR_SCHEDULE_DESIGNATOR CURR_SCHEDULE_DESIGNATOR, CURR_SCHEDULE_TYPE CURR_SCHEDULE_TYPE, CURR_SIMULATION_SET CURR_SIMULATION_SET, CURR_SNAPSHOT_LOCK CURR_SNAPSHOT_LOCK, CURR_SPLIT_DEMANDS CURR_SPLIT_DEMANDS, CURR_START_DATE CURR_START_DATE, CUTOFF_DATE CUTOFF_DATE, DAILY_CUTOFF_BUCKET DAILY_CUTOFF_BUCKET, DAILY_ITEM_AGGREGATION_LEVEL DAILY_ITEM_AGGREGATION_LEVEL, DAILY_MATERIAL_CONSTRAINTS DAILY_MATERIAL_CONSTRAINTS, DAILY_RESOURCE_CONSTRAINTS DAILY_RESOURCE_CONSTRAINTS, DAILY_RES_AGGREGATION_LEVEL DAILY_RES_AGGREGATION_LEVEL, DAILY_TRANS_CONSTRAINTS DAILY_TRANS_CONSTRAINTS, DATA_COMPLETION_DATE DATA_COMPLETION_DATE, DATA_START_DATE DATA_START_DATE, DEMAND_TIME_FENCE_FLAG DEMAND_TIME_FENCE_FLAG, DESCRIPTION DESCRIPTION, DMD_LATENESS_PENALTY_COST DMD_LATENESS_PENALTY_COST, HARD_PEGGING_LEVEL HARD_PEGGING_LEVEL, FULL_PEGGING FULL_PEGGING, HOUR_CUTOFF_BUCKET HOUR_CUTOFF_BUCKET, INCLUDED_ITEMS INCLUDED_ITEMS, MIN_CUTOFF_BUCKET MIN_CUTOFF_BUCKET, MONTHLY_CUTOFF_BUCKET MONTHLY_CUTOFF_BUCKET, OBJECTIVE_WEIGHT_1 OBJECTIVE_WEIGHT_1, OBJECTIVE_WEIGHT_10 OBJECTIVE_WEIGHT_10, OBJECTIVE_WEIGHT_2 OBJECTIVE_WEIGHT_2, OBJECTIVE_WEIGHT_3 OBJECTIVE_WEIGHT_3, OBJECTIVE_WEIGHT_4 OBJECTIVE_WEIGHT_4, OBJECTIVE_WEIGHT_5 OBJECTIVE_WEIGHT_5, OBJECTIVE_WEIGHT_6 OBJECTIVE_WEIGHT_6, OBJECTIVE_WEIGHT_7 OBJECTIVE_WEIGHT_7, OBJECTIVE_WEIGHT_8 OBJECTIVE_WEIGHT_8, OBJECTIVE_WEIGHT_9 OBJECTIVE_WEIGHT_9, OPERATION_SCHEDULE_TYPE OPERATION_SCHEDULE_TYPE, ORGANIZATION_ID ORGANIZATION_ID, ORGANIZATION_SELECTION ORGANIZATION_SELECTION, OVERWRITE_OPTION OVERWRITE_OPTION, PART_INCLUDE_TYPE PART_INCLUDE_TYPE, PENALTY_COST_1 PENALTY_COST_1, PENALTY_COST_10 PENALTY_COST_10, PENALTY_COST_2 PENALTY_COST_2, PENALTY_COST_3 PENALTY_COST_3, PENALTY_COST_4 PENALTY_COST_4, PENALTY_COST_5 PENALTY_COST_5, PENALTY_COST_6 PENALTY_COST_6, PENALTY_COST_7 PENALTY_COST_7, PENALTY_COST_8 PENALTY_COST_8, PENALTY_COST_9 PENALTY_COST_9, PLANNED_REFRESHES PLANNED_REFRESHES, PLANNING_TIME_FENCE_FLAG PLANNING_TIME_FENCE_FLAG, PLAN_CAPACITY_FLAG PLAN_CAPACITY_FLAG, PLAN_COMPLETION_DATE PLAN_COMPLETION_DATE, PLAN_START_DATE PLAN_START_DATE, PLAN_TYPE PLAN_TYPE, QTRLY_CUTOFF_BUCKET QTRLY_CUTOFF_BUCKET, RESERVATION_LEVEL RESERVATION_LEVEL, RESOURCE_OVER_UTIL_COST RESOURCE_OVER_UTIL_COST, SCHEDULE_DESIGNATOR SCHEDULE_DESIGNATOR, SCHEDULE_TYPE SCHEDULE_TYPE, SLACK_ALLOWED_FLAG_1 SLACK_ALLOWED_FLAG_1, SLACK_ALLOWED_FLAG_10 SLACK_ALLOWED_FLAG_10, SLACK_ALLOWED_FLAG_2 SLACK_ALLOWED_FLAG_2, SLACK_ALLOWED_FLAG_3 SLACK_ALLOWED_FLAG_3, SLACK_ALLOWED_FLAG_4 SLACK_ALLOWED_FLAG_4, SLACK_ALLOWED_FLAG_5 SLACK_ALLOWED_FLAG_5, SLACK_ALLOWED_FLAG_6 SLACK_ALLOWED_FLAG_6, SLACK_ALLOWED_FLAG_7 SLACK_ALLOWED_FLAG_7, SLACK_ALLOWED_FLAG_8 SLACK_ALLOWED_FLAG_8, SLACK_ALLOWED_FLAG_9 SLACK_ALLOWED_FLAG_9, SNAPSHOT_LOCK SNAPSHOT_LOCK, SPLIT_DEMANDS SPLIT_DEMANDS, START_DATE START_DATE, SUPPLIER_CAP_OVER_UTIL_COST SUPPLIER_CAP_OVER_UTIL_COST, WEEKLY_CUTOFF_BUCKET WEEKLY_CUTOFF_BUCKET, WEEKLY_ITEM_AGGREGATION_LEVEL WEEKLY_ITEM_AGGREGATION_LEVEL, WEEKLY_MATERIAL_CONSTRAINTS WEEKLY_MATERIAL_CONSTRAINTS, WEEKLY_RESOURCE_CONSTRAINTS WEEKLY_RESOURCE_CONSTRAINTS, WEEKLY_RES_AGGREGATION_LEVEL WEEKLY_RES_AGGREGATION_LEVEL, WEEKLY_TRANS_CONSTRAINTS WEEKLY_TRANS_CONSTRAINTS, OPTIMIZE_FLAG OPTIMIZE_FLAG, SCHEDULE_FLAG SCHEDULE_FLAG, ONLINE_PLANNER_START_DATE ONLINE_PLANNER_START_DATE, ONLINE_PLANNER_COMPLETION_DATE ONLINE_PLANNER_COMPLETION_DATE, TRANSPORT_CAP_OVER_UTIL_COST TRANSPORT_CAP_OVER_UTIL_COST, BILL_OF_RESOURCES BILL_OF_RESOURCES, SIMULATION_SET SIMULATION_SET, CONSIDER_WIP CONSIDER_WIP, CONSIDER_PO CONSIDER_PO, PLAN_SAFETY_STOCK PLAN_SAFETY_STOCK, CONSIDER_RESERVATIONS CONSIDER_RESERVATIONS, CURR_ENFORCE_DEM_DUE_DATES CURR_ENFORCE_DEM_DUE_DATES, ENFORCE_DEM_DUE_DATES ENFORCE_DEM_DUE_DATES, PLANNED_RESOURCES PLANNED_RESOURCES, CURR_PLANNED_RESOURCES CURR_PLANNED_RESOURCES, DEM_PRIORITY_RULE_ID DEM_PRIORITY_RULE_ID, CURR_DEM_PRIORITY_RULE_ID CURR_DEM_PRIORITY_RULE_ID, DAILY_RTG_AGGREGATION_LEVEL DAILY_RTG_AGGREGATION_LEVEL, WEEKLY_RTG_AGGREGATION_LEVEL WEEKLY_RTG_AGGREGATION_LEVEL, PERIOD_RTG_AGGREGATION_LEVEL PERIOD_RTG_AGGREGATION_LEVEL, PERIOD_CUTOFF_BUCKET PERIOD_CUTOFF_BUCKET, LOT_FOR_LOT_FLAG LOT_FOR_LOT_FLAG, ENFORCE_CAP_CONSTRAINTS ENFORCE_CAP_CONSTRAINTS, CURR_ENFORCE_CAP_CONSTRAINTS CURR_ENFORCE_CAP_CONSTRAINTS, SERVICE_LEVEL SERVICE_LEVEL, BOTTLENECK_RES_GROUP BOTTLENECK_RES_GROUP, CURR_BOTTLENECK_RES_GROUP CURR_BOTTLENECK_RES_GROUP, PERIOD_MATERIAL_CONSTRAINTS PERIOD_MATERIAL_CONSTRAINTS, PERIOD_RESOURCE_CONSTRAINTS PERIOD_RESOURCE_CONSTRAINTS, PERIOD_TRANS_CONSTRAINTS PERIOD_TRANS_CONSTRAINTS, PERIOD_ITEM_AGGREGATION_LEVEL PERIOD_ITEM_AGGREGATION_LEVEL, PERIOD_RES_AGGREGATION_LEVEL PERIOD_RES_AGGREGATION_LEVEL, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, LOT_FOR_LOT LOT_FOR_LOT, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, 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, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, MIN_WF_EXCEPT_ID MIN_WF_EXCEPT_ID, MAX_WF_EXCEPT_ID MAX_WF_EXCEPT_ID, ONLINE_REPLAN ONLINE_REPLAN, REFRESH_NUMBER REFRESH_NUMBER, REVISION REVISION, PARENT_PLAN_ID PARENT_PLAN_ID, STATUS STATUS, PRODUCTION_FLAG PRODUCTION_FLAG, COMPANY_AGG_LEVEL COMPANY_AGG_LEVEL, TP_AGG_LEVEL TP_AGG_LEVEL, PRODUCT_AGG_LEVEL PRODUCT_AGG_LEVEL, PURGE PURGE, ENFORCE_SL_CONSTRAINTS ENFORCE_SL_CONSTRAINTS, CURR_ENFORCE_SL_CONSTRAINTS CURR_ENFORCE_SL_CONSTRAINTS, PLAN_INVENTORY_POINT PLAN_INVENTORY_POINT, ENABLE_CLOSEST_QTY_PEGGING ENABLE_CLOSEST_QTY_PEGGING, CURR_CLOSEST_QTY_PEG CURR_CLOSEST_QTY_PEG, ENABLE_PRIORITY_PEGGING ENABLE_PRIORITY_PEGGING, CURR_PRIORITY_PEGGING CURR_PRIORITY_PEGGING, ENFORCE_SRC_CONSTRAINTS ENFORCE_SRC_CONSTRAINTS, CURR_ENFORCE_SRC_CONSTRAINTS CURR_ENFORCE_SRC_CONSTRAINTS, BACKWARD_DAYS BACKWARD_DAYS, CURR_BACKWARD_DAYS CURR_BACKWARD_DAYS, FORWARD_DAYS FORWARD_DAYS, CURR_FORWARD_DAYS CURR_FORWARD_DAYS, SUMMARY_FLAG SUMMARY_FLAG, USE_ALTERNATE_RESOURCES USE_ALTERNATE_RESOURCES, USE_END_ITEM_SUBSTITUTIONS USE_END_ITEM_SUBSTITUTIONS, USE_ALTERNATE_BOM_ROUTING USE_ALTERNATE_BOM_ROUTING, USE_SUBSTITUTE_COMPONENTS USE_SUBSTITUTE_COMPONENTS, USE_ALTERNATE_SOURCES USE_ALTERNATE_SOURCES, SUBSTITUTION_DESIGNATOR SUBSTITUTION_DESIGNATOR, KPI_REFRESH KPI_REFRESH, DISPLAY_KPI DISPLAY_KPI, FORECAST_ALLOCATION_METHOD FORECAST_ALLOCATION_METHOD, FORECAST_CONSUMPTION_METHOD FORECAST_CONSUMPTION_METHOD, COPY_PLAN_ID COPY_PLAN_ID, EXPLODE_FORECAST EXPLODE_FORECAST, FORECAST_ASSIGNMENT_SET_ID FORECAST_ASSIGNMENT_SET_ID, ENFORCE_SUP_CAP_CONSTRAINTS ENFORCE_SUP_CAP_CONSTRAINTS, ENFORCE_PUR_LT_CONSTRAINTS ENFORCE_PUR_LT_CONSTRAINTS, TGT_TL_UTIL_PCT TGT_TL_UTIL_PCT, MIN_TL_UTIL_PCT MIN_TL_UTIL_PCT, LOAD_SCHED_TIME_FENCE_DAYS LOAD_SCHED_TIME_FENCE_DAYS, LOAD_SCHEDULING_DAYS LOAD_SCHEDULING_DAYS, DAILY_ALLOC_BUCKETS DAILY_ALLOC_BUCKETS, WKS_PER_WKLY_ALLOC_BUCKET WKS_PER_WKLY_ALLOC_BUCKET, DMD_PRI_RULE_SET_ID DMD_PRI_RULE_SET_ID, CIRC_SRCING_SURPLUS_DAYS CIRC_SRCING_SURPLUS_DAYS, SUPPLY_SCHED_ITF SUPPLY_SCHED_ITF, INCLUDE_CRITICAL_COMPONENTS INCLUDE_CRITICAL_COMPONENTS, SCHEDULE_BY SCHEDULE_BY, PUBLISH_FCST_VERSION PUBLISH_FCST_VERSION, RELEASE_RESCHEDULES RELEASE_RESCHEDULES, SAFETY_STK_CHANGE_INTERVAL SAFETY_STK_CHANGE_INTERVAL, SAFETY_STK_THRESHOLD_PCT SAFETY_STK_THRESHOLD_PCT, COPY_PLAN COPY_PLAN, ENFORCE_USER_SAFETY_STOCKS ENFORCE_USER_SAFETY_STOCKS, ENFORCE_BUDGET_CONSTRAINTS ENFORCE_BUDGET_CONSTRAINTS, BUDGET_ID BUDGET_ID, BUDGET_VALUE BUDGET_VALUE, LATEST_REFRESH_NUMBER LATEST_REFRESH_NUMBER, SUPPLIER_ALLOC_METHOD SUPPLIER_ALLOC_METHOD, CUSTOMER_ALLOC_METHOD CUSTOMER_ALLOC_METHOD, DEFAULT_ALLOC_METHOD DEFAULT_ALLOC_METHOD, USE_FIXED_PERIOD_BKTS USE_FIXED_PERIOD_BKTS, SHIPMENT_CONSOLIDATION_DAYS SHIPMENT_CONSOLIDATION_DAYS, ITF_HORIZ_DAYS ITF_HORIZ_DAYS, USE_ORG_PRIORITY_OVERRIDE USE_ORG_PRIORITY_OVERRIDE, USE_FIXED_PERIOD_ALLOC_BKTS USE_FIXED_PERIOD_ALLOC_BKTS, SCHEDULE_BY_DATE_TYPE SCHEDULE_BY_DATE_TYPE, DS_SUBSET_HORIZON_DAYS DS_SUBSET_HORIZON_DAYS, SCHEDULE_DAYS_BEFORE SCHEDULE_DAYS_BEFORE, SCHEDULE_START_TIME SCHEDULE_START_TIME, SCHEDULE_SUBSET_TYPE SCHEDULE_SUBSET_TYPE, INCLUDE_WO INCLUDE_WO, ENFORCE_PURCH_LEAD_TIME ENFORCE_PURCH_LEAD_TIME, USER_UPDATE_FIRM USER_UPDATE_FIRM, DEMAND_PRIORITY_SENSITIVITY DEMAND_PRIORITY_SENSITIVITY, EARLY_BUILD_PENALTY EARLY_BUILD_PENALTY, AUTO_RELEASE_TIME_FENCE AUTO_RELEASE_TIME_FENCE, SUBSET_DESIGNATOR_ID SUBSET_DESIGNATOR_ID, INCLUDE_PLANNED_ORDER INCLUDE_PLANNED_ORDER, CURR_INCLUDE_PLANNED_ORDER CURR_INCLUDE_PLANNED_ORDER, CURR_INCLUDE_WO CURR_INCLUDE_WO, CURR_DS_HORIZON_DAYS CURR_DS_HORIZON_DAYS, CURR_SCHEDULE_SUBSET_TYPE CURR_SCHEDULE_SUBSET_TYPE, CURR_SUBSET_DESIGNATOR_ID CURR_SUBSET_DESIGNATOR_ID, CALCULATE_SDS_DAYS_TIME CALCULATE_SDS_DAYS_TIME, CALCULATE_SDS_WEEKS_TIME CALCULATE_SDS_WEEKS_TIME, CALCULATE_SDS_PERIODS_TIME CALCULATE_SDS_PERIODS_TIME, FIRM_OUTSIDE_SUBSET FIRM_OUTSIDE_SUBSET, ENABLE_SO_SPLIT ENABLE_SO_SPLIT, DS_HORIZON_DAYS DS_HORIZON_DAYS, PLANNING_MODE PLANNING_MODE, SDS_DMD_PENALTY SDS_DMD_PENALTY, CURR_OLS_HORIZON_DAYS CURR_OLS_HORIZON_DAYS, OLS_FROZEN_HORIZON_DAYS OLS_FROZEN_HORIZON_DAYS, CALCULATE_LIABILITY CALCULATE_LIABILITY, CURR_ENF_FULFILLMENT_LT CURR_ENF_FULFILLMENT_LT, ENFORCE_FULFILLMENT_LT ENFORCE_FULFILLMENT_LT, DEMAND_FULFILLMENT_LT DEMAND_FULFILLMENT_LT, MFG_LT_VAR_PERCENT MFG_LT_VAR_PERCENT, SUP_LT_VAR_PERCENT SUP_LT_VAR_PERCENT, TRANSIT_LT_VAR_PERCENT TRANSIT_LT_VAR_PERCENT, SERVICE_LEVEL_SET_ID SERVICE_LEVEL_SET_ID, CURR_SERVICE_LEVEL_SET_ID CURR_SERVICE_LEVEL_SET_ID, PLAN_RUN_DATE PLAN_RUN_DATE, ITEM_SIMULATION_SET_ID ITEM_SIMULATION_SET_ID, PUBLISH_SUPPLY_COMMIT_VERSION PUBLISH_SUPPLY_COMMIT_VERSION, PLANNED_BUCKET PLANNED_BUCKET, PLANNED_BUCKET_TYPE PLANNED_BUCKET_TYPE, ASSIGNMENT_SET_OUT_ID ASSIGNMENT_SET_OUT_ID, CATEGORY_SET_ID CATEGORY_SET_ID, SOP_ENABLED SOP_ENABLED, CONSTRAINED_MODE CONSTRAINED_MODE, MANUAL_FCST_OVERWRITE_OPTION MANUAL_FCST_OVERWRITE_OPTION, ENFORCE_CONSTRAINTS ENFORCE_CONSTRAINTS, SAFETY_STOCK_VALUE_TYPE SAFETY_STOCK_VALUE_TYPE, REALLOC_SURPLUS_DAYS REALLOC_SURPLUS_DAYS, PERFORM_FAIR_SHARE_ALLOC PERFORM_FAIR_SHARE_ALLOC, INCLUDE_ALL_ITEMS INCLUDE_ALL_ITEMS, INCLUDE_ALL_CATEGORIES INCLUDE_ALL_CATEGORIES, AUTO_RELEASE_METHOD AUTO_RELEASE_METHOD, INCLUDE_RESCHEDULES INCLUDE_RESCHEDULES, CALENDAR_TYPE CALENDAR_TYPE, HISTORY_RANGE HISTORY_RANGE, HISTORY_RANGE_UOM HISTORY_RANGE_UOM, FORECAST FORECAST, FORECAST_UOM FORECAST_UOM, FORECAST_BUCKET FORECAST_BUCKET, FORECAST_BUCKET_UOM FORECAST_BUCKET_UOM, GENERATE_INLINE_FORECAST GENERATE_INLINE_FORECAST, CIRCULAR_SRC CIRCULAR_SRC, ARCHIVE_FLAG ARCHIVE_FLAG, APPLIED APPLIED, BASE_PLAN_ID BASE_PLAN_ID, HAS_RUN HAS_RUN, LOADED_FLAG LOADED_FLAG, NEW_PLAN_ID NEW_PLAN_ID, NEW_PLAN_LIST NEW_PLAN_LIST, PLANNING_ENGINE_TYPE PLANNING_ENGINE_TYPE, PREVIOUS_RUN_PLAN_ID PREVIOUS_RUN_PLAN_ID, SAVED_FLAG SAVED_FLAG, SIMULATION_SET_ID SIMULATION_SET_ID, COMPUTE_SS_EOQ COMPUTE_SS_EOQ, PRIVATE_PLAN PRIVATE_PLAN, RELEASE_FLAG RELEASE_FLAG, SAVE_TO_DB SAVE_TO_DB, COMPUTE_CONSTRAINTS COMPUTE_CONSTRAINTS, BUILD_READY_PCT BUILD_READY_PCT, RELEASE_SO RELEASE_SO, AUTO_RELEASE_RP AUTO_RELEASE_RP, PLAN_VERSION PLAN_VERSION, RP_USER_ID RP_USER_ID, DERIVE_RETURN_FCST_FROM_WO DERIVE_RETURN_FCST_FROM_WO, EXCEP_GROUP_ID EXCEP_GROUP_ID, DAILY_MWO_AGGR_LVL DAILY_MWO_AGGR_LVL, WEEKLY_MWO_AGGR_LVL WEEKLY_MWO_AGGR_LVL, PERIOD_MWO_AGGR_LVL PERIOD_MWO_AGGR_LVL, PUB_CAP_TO_CMRO PUB_CAP_TO_CMRO, ENFORCE_WRH_CPTY ENFORCE_WRH_CPTY, ASCP_PLAN_ID ASCP_PLAN_ID, ASCP_PLAN_VERSION ASCP_PLAN_VERSION, SNAPSHOT_SOURCE SNAPSHOT_SOURCE, GENERATE_WORKSHEET GENERATE_WORKSHEET, SUPPLY_INCLUSION_OPTION SUPPLY_INCLUSION_OPTION, CRITERIA_CHANGED CRITERIA_CHANGED, ENABLE_SAFETY_STOCK_RES ENABLE_SAFETY_STOCK_RES from "MSC"."MSC_PLANS"

View Text - HTML Formatted

SELECT PLAN_ID PLAN_ID
, COMPILE_DESIGNATOR COMPILE_DESIGNATOR
, SR_INSTANCE_ID SR_INSTANCE_ID
, APPEND_PLANNED_ORDERS APPEND_PLANNED_ORDERS
, ASSIGNMENT_SET_ID ASSIGNMENT_SET_ID
, CURR_APPEND_PLANNED_ORDERS CURR_APPEND_PLANNED_ORDERS
, CURR_ASSIGNMENT_SET_ID CURR_ASSIGNMENT_SET_ID
, CURR_BILL_OF_RESOURCES CURR_BILL_OF_RESOURCES
, CURR_CONSIDER_PO CURR_CONSIDER_PO
, CURR_CONSIDER_RESERVATIONS CURR_CONSIDER_RESERVATIONS
, CURR_CONSIDER_WIP CURR_CONSIDER_WIP
, CURR_CUTOFF_DATE CURR_CUTOFF_DATE
, CURR_DEMAND_TIME_FENCE_FLAG CURR_DEMAND_TIME_FENCE_FLAG
, CURR_HARD_PEGGING_LEVEL CURR_HARD_PEGGING_LEVEL
, CURR_FULL_PEGGING CURR_FULL_PEGGING
, CURR_INCLUDED_ITEMS CURR_INCLUDED_ITEMS
, CURR_OPERATION_SCHEDULE_TYPE CURR_OPERATION_SCHEDULE_TYPE
, CURR_OVERWRITE_OPTION CURR_OVERWRITE_OPTION
, CURR_PART_INCLUDE_TYPE CURR_PART_INCLUDE_TYPE
, CURR_PLANNING_TIME_FENCE_FLAG CURR_PLANNING_TIME_FENCE_FLAG
, CURR_PLAN_CAPACITY_FLAG CURR_PLAN_CAPACITY_FLAG
, CURR_PLAN_SAFETY_STOCK CURR_PLAN_SAFETY_STOCK
, CURR_PLAN_TYPE CURR_PLAN_TYPE
, CURR_RESERVATION_LEVEL CURR_RESERVATION_LEVEL
, CURR_SCHEDULE_DESIGNATOR CURR_SCHEDULE_DESIGNATOR
, CURR_SCHEDULE_TYPE CURR_SCHEDULE_TYPE
, CURR_SIMULATION_SET CURR_SIMULATION_SET
, CURR_SNAPSHOT_LOCK CURR_SNAPSHOT_LOCK
, CURR_SPLIT_DEMANDS CURR_SPLIT_DEMANDS
, CURR_START_DATE CURR_START_DATE
, CUTOFF_DATE CUTOFF_DATE
, DAILY_CUTOFF_BUCKET DAILY_CUTOFF_BUCKET
, DAILY_ITEM_AGGREGATION_LEVEL DAILY_ITEM_AGGREGATION_LEVEL
, DAILY_MATERIAL_CONSTRAINTS DAILY_MATERIAL_CONSTRAINTS
, DAILY_RESOURCE_CONSTRAINTS DAILY_RESOURCE_CONSTRAINTS
, DAILY_RES_AGGREGATION_LEVEL DAILY_RES_AGGREGATION_LEVEL
, DAILY_TRANS_CONSTRAINTS DAILY_TRANS_CONSTRAINTS
, DATA_COMPLETION_DATE DATA_COMPLETION_DATE
, DATA_START_DATE DATA_START_DATE
, DEMAND_TIME_FENCE_FLAG DEMAND_TIME_FENCE_FLAG
, DESCRIPTION DESCRIPTION
, DMD_LATENESS_PENALTY_COST DMD_LATENESS_PENALTY_COST
, HARD_PEGGING_LEVEL HARD_PEGGING_LEVEL
, FULL_PEGGING FULL_PEGGING
, HOUR_CUTOFF_BUCKET HOUR_CUTOFF_BUCKET
, INCLUDED_ITEMS INCLUDED_ITEMS
, MIN_CUTOFF_BUCKET MIN_CUTOFF_BUCKET
, MONTHLY_CUTOFF_BUCKET MONTHLY_CUTOFF_BUCKET
, OBJECTIVE_WEIGHT_1 OBJECTIVE_WEIGHT_1
, OBJECTIVE_WEIGHT_10 OBJECTIVE_WEIGHT_10
, OBJECTIVE_WEIGHT_2 OBJECTIVE_WEIGHT_2
, OBJECTIVE_WEIGHT_3 OBJECTIVE_WEIGHT_3
, OBJECTIVE_WEIGHT_4 OBJECTIVE_WEIGHT_4
, OBJECTIVE_WEIGHT_5 OBJECTIVE_WEIGHT_5
, OBJECTIVE_WEIGHT_6 OBJECTIVE_WEIGHT_6
, OBJECTIVE_WEIGHT_7 OBJECTIVE_WEIGHT_7
, OBJECTIVE_WEIGHT_8 OBJECTIVE_WEIGHT_8
, OBJECTIVE_WEIGHT_9 OBJECTIVE_WEIGHT_9
, OPERATION_SCHEDULE_TYPE OPERATION_SCHEDULE_TYPE
, ORGANIZATION_ID ORGANIZATION_ID
, ORGANIZATION_SELECTION ORGANIZATION_SELECTION
, OVERWRITE_OPTION OVERWRITE_OPTION
, PART_INCLUDE_TYPE PART_INCLUDE_TYPE
, PENALTY_COST_1 PENALTY_COST_1
, PENALTY_COST_10 PENALTY_COST_10
, PENALTY_COST_2 PENALTY_COST_2
, PENALTY_COST_3 PENALTY_COST_3
, PENALTY_COST_4 PENALTY_COST_4
, PENALTY_COST_5 PENALTY_COST_5
, PENALTY_COST_6 PENALTY_COST_6
, PENALTY_COST_7 PENALTY_COST_7
, PENALTY_COST_8 PENALTY_COST_8
, PENALTY_COST_9 PENALTY_COST_9
, PLANNED_REFRESHES PLANNED_REFRESHES
, PLANNING_TIME_FENCE_FLAG PLANNING_TIME_FENCE_FLAG
, PLAN_CAPACITY_FLAG PLAN_CAPACITY_FLAG
, PLAN_COMPLETION_DATE PLAN_COMPLETION_DATE
, PLAN_START_DATE PLAN_START_DATE
, PLAN_TYPE PLAN_TYPE
, QTRLY_CUTOFF_BUCKET QTRLY_CUTOFF_BUCKET
, RESERVATION_LEVEL RESERVATION_LEVEL
, RESOURCE_OVER_UTIL_COST RESOURCE_OVER_UTIL_COST
, SCHEDULE_DESIGNATOR SCHEDULE_DESIGNATOR
, SCHEDULE_TYPE SCHEDULE_TYPE
, SLACK_ALLOWED_FLAG_1 SLACK_ALLOWED_FLAG_1
, SLACK_ALLOWED_FLAG_10 SLACK_ALLOWED_FLAG_10
, SLACK_ALLOWED_FLAG_2 SLACK_ALLOWED_FLAG_2
, SLACK_ALLOWED_FLAG_3 SLACK_ALLOWED_FLAG_3
, SLACK_ALLOWED_FLAG_4 SLACK_ALLOWED_FLAG_4
, SLACK_ALLOWED_FLAG_5 SLACK_ALLOWED_FLAG_5
, SLACK_ALLOWED_FLAG_6 SLACK_ALLOWED_FLAG_6
, SLACK_ALLOWED_FLAG_7 SLACK_ALLOWED_FLAG_7
, SLACK_ALLOWED_FLAG_8 SLACK_ALLOWED_FLAG_8
, SLACK_ALLOWED_FLAG_9 SLACK_ALLOWED_FLAG_9
, SNAPSHOT_LOCK SNAPSHOT_LOCK
, SPLIT_DEMANDS SPLIT_DEMANDS
, START_DATE START_DATE
, SUPPLIER_CAP_OVER_UTIL_COST SUPPLIER_CAP_OVER_UTIL_COST
, WEEKLY_CUTOFF_BUCKET WEEKLY_CUTOFF_BUCKET
, WEEKLY_ITEM_AGGREGATION_LEVEL WEEKLY_ITEM_AGGREGATION_LEVEL
, WEEKLY_MATERIAL_CONSTRAINTS WEEKLY_MATERIAL_CONSTRAINTS
, WEEKLY_RESOURCE_CONSTRAINTS WEEKLY_RESOURCE_CONSTRAINTS
, WEEKLY_RES_AGGREGATION_LEVEL WEEKLY_RES_AGGREGATION_LEVEL
, WEEKLY_TRANS_CONSTRAINTS WEEKLY_TRANS_CONSTRAINTS
, OPTIMIZE_FLAG OPTIMIZE_FLAG
, SCHEDULE_FLAG SCHEDULE_FLAG
, ONLINE_PLANNER_START_DATE ONLINE_PLANNER_START_DATE
, ONLINE_PLANNER_COMPLETION_DATE ONLINE_PLANNER_COMPLETION_DATE
, TRANSPORT_CAP_OVER_UTIL_COST TRANSPORT_CAP_OVER_UTIL_COST
, BILL_OF_RESOURCES BILL_OF_RESOURCES
, SIMULATION_SET SIMULATION_SET
, CONSIDER_WIP CONSIDER_WIP
, CONSIDER_PO CONSIDER_PO
, PLAN_SAFETY_STOCK PLAN_SAFETY_STOCK
, CONSIDER_RESERVATIONS CONSIDER_RESERVATIONS
, CURR_ENFORCE_DEM_DUE_DATES CURR_ENFORCE_DEM_DUE_DATES
, ENFORCE_DEM_DUE_DATES ENFORCE_DEM_DUE_DATES
, PLANNED_RESOURCES PLANNED_RESOURCES
, CURR_PLANNED_RESOURCES CURR_PLANNED_RESOURCES
, DEM_PRIORITY_RULE_ID DEM_PRIORITY_RULE_ID
, CURR_DEM_PRIORITY_RULE_ID CURR_DEM_PRIORITY_RULE_ID
, DAILY_RTG_AGGREGATION_LEVEL DAILY_RTG_AGGREGATION_LEVEL
, WEEKLY_RTG_AGGREGATION_LEVEL WEEKLY_RTG_AGGREGATION_LEVEL
, PERIOD_RTG_AGGREGATION_LEVEL PERIOD_RTG_AGGREGATION_LEVEL
, PERIOD_CUTOFF_BUCKET PERIOD_CUTOFF_BUCKET
, LOT_FOR_LOT_FLAG LOT_FOR_LOT_FLAG
, ENFORCE_CAP_CONSTRAINTS ENFORCE_CAP_CONSTRAINTS
, CURR_ENFORCE_CAP_CONSTRAINTS CURR_ENFORCE_CAP_CONSTRAINTS
, SERVICE_LEVEL SERVICE_LEVEL
, BOTTLENECK_RES_GROUP BOTTLENECK_RES_GROUP
, CURR_BOTTLENECK_RES_GROUP CURR_BOTTLENECK_RES_GROUP
, PERIOD_MATERIAL_CONSTRAINTS PERIOD_MATERIAL_CONSTRAINTS
, PERIOD_RESOURCE_CONSTRAINTS PERIOD_RESOURCE_CONSTRAINTS
, PERIOD_TRANS_CONSTRAINTS PERIOD_TRANS_CONSTRAINTS
, PERIOD_ITEM_AGGREGATION_LEVEL PERIOD_ITEM_AGGREGATION_LEVEL
, PERIOD_RES_AGGREGATION_LEVEL PERIOD_RES_AGGREGATION_LEVEL
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, LOT_FOR_LOT LOT_FOR_LOT
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, 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
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, MIN_WF_EXCEPT_ID MIN_WF_EXCEPT_ID
, MAX_WF_EXCEPT_ID MAX_WF_EXCEPT_ID
, ONLINE_REPLAN ONLINE_REPLAN
, REFRESH_NUMBER REFRESH_NUMBER
, REVISION REVISION
, PARENT_PLAN_ID PARENT_PLAN_ID
, STATUS STATUS
, PRODUCTION_FLAG PRODUCTION_FLAG
, COMPANY_AGG_LEVEL COMPANY_AGG_LEVEL
, TP_AGG_LEVEL TP_AGG_LEVEL
, PRODUCT_AGG_LEVEL PRODUCT_AGG_LEVEL
, PURGE PURGE
, ENFORCE_SL_CONSTRAINTS ENFORCE_SL_CONSTRAINTS
, CURR_ENFORCE_SL_CONSTRAINTS CURR_ENFORCE_SL_CONSTRAINTS
, PLAN_INVENTORY_POINT PLAN_INVENTORY_POINT
, ENABLE_CLOSEST_QTY_PEGGING ENABLE_CLOSEST_QTY_PEGGING
, CURR_CLOSEST_QTY_PEG CURR_CLOSEST_QTY_PEG
, ENABLE_PRIORITY_PEGGING ENABLE_PRIORITY_PEGGING
, CURR_PRIORITY_PEGGING CURR_PRIORITY_PEGGING
, ENFORCE_SRC_CONSTRAINTS ENFORCE_SRC_CONSTRAINTS
, CURR_ENFORCE_SRC_CONSTRAINTS CURR_ENFORCE_SRC_CONSTRAINTS
, BACKWARD_DAYS BACKWARD_DAYS
, CURR_BACKWARD_DAYS CURR_BACKWARD_DAYS
, FORWARD_DAYS FORWARD_DAYS
, CURR_FORWARD_DAYS CURR_FORWARD_DAYS
, SUMMARY_FLAG SUMMARY_FLAG
, USE_ALTERNATE_RESOURCES USE_ALTERNATE_RESOURCES
, USE_END_ITEM_SUBSTITUTIONS USE_END_ITEM_SUBSTITUTIONS
, USE_ALTERNATE_BOM_ROUTING USE_ALTERNATE_BOM_ROUTING
, USE_SUBSTITUTE_COMPONENTS USE_SUBSTITUTE_COMPONENTS
, USE_ALTERNATE_SOURCES USE_ALTERNATE_SOURCES
, SUBSTITUTION_DESIGNATOR SUBSTITUTION_DESIGNATOR
, KPI_REFRESH KPI_REFRESH
, DISPLAY_KPI DISPLAY_KPI
, FORECAST_ALLOCATION_METHOD FORECAST_ALLOCATION_METHOD
, FORECAST_CONSUMPTION_METHOD FORECAST_CONSUMPTION_METHOD
, COPY_PLAN_ID COPY_PLAN_ID
, EXPLODE_FORECAST EXPLODE_FORECAST
, FORECAST_ASSIGNMENT_SET_ID FORECAST_ASSIGNMENT_SET_ID
, ENFORCE_SUP_CAP_CONSTRAINTS ENFORCE_SUP_CAP_CONSTRAINTS
, ENFORCE_PUR_LT_CONSTRAINTS ENFORCE_PUR_LT_CONSTRAINTS
, TGT_TL_UTIL_PCT TGT_TL_UTIL_PCT
, MIN_TL_UTIL_PCT MIN_TL_UTIL_PCT
, LOAD_SCHED_TIME_FENCE_DAYS LOAD_SCHED_TIME_FENCE_DAYS
, LOAD_SCHEDULING_DAYS LOAD_SCHEDULING_DAYS
, DAILY_ALLOC_BUCKETS DAILY_ALLOC_BUCKETS
, WKS_PER_WKLY_ALLOC_BUCKET WKS_PER_WKLY_ALLOC_BUCKET
, DMD_PRI_RULE_SET_ID DMD_PRI_RULE_SET_ID
, CIRC_SRCING_SURPLUS_DAYS CIRC_SRCING_SURPLUS_DAYS
, SUPPLY_SCHED_ITF SUPPLY_SCHED_ITF
, INCLUDE_CRITICAL_COMPONENTS INCLUDE_CRITICAL_COMPONENTS
, SCHEDULE_BY SCHEDULE_BY
, PUBLISH_FCST_VERSION PUBLISH_FCST_VERSION
, RELEASE_RESCHEDULES RELEASE_RESCHEDULES
, SAFETY_STK_CHANGE_INTERVAL SAFETY_STK_CHANGE_INTERVAL
, SAFETY_STK_THRESHOLD_PCT SAFETY_STK_THRESHOLD_PCT
, COPY_PLAN COPY_PLAN
, ENFORCE_USER_SAFETY_STOCKS ENFORCE_USER_SAFETY_STOCKS
, ENFORCE_BUDGET_CONSTRAINTS ENFORCE_BUDGET_CONSTRAINTS
, BUDGET_ID BUDGET_ID
, BUDGET_VALUE BUDGET_VALUE
, LATEST_REFRESH_NUMBER LATEST_REFRESH_NUMBER
, SUPPLIER_ALLOC_METHOD SUPPLIER_ALLOC_METHOD
, CUSTOMER_ALLOC_METHOD CUSTOMER_ALLOC_METHOD
, DEFAULT_ALLOC_METHOD DEFAULT_ALLOC_METHOD
, USE_FIXED_PERIOD_BKTS USE_FIXED_PERIOD_BKTS
, SHIPMENT_CONSOLIDATION_DAYS SHIPMENT_CONSOLIDATION_DAYS
, ITF_HORIZ_DAYS ITF_HORIZ_DAYS
, USE_ORG_PRIORITY_OVERRIDE USE_ORG_PRIORITY_OVERRIDE
, USE_FIXED_PERIOD_ALLOC_BKTS USE_FIXED_PERIOD_ALLOC_BKTS
, SCHEDULE_BY_DATE_TYPE SCHEDULE_BY_DATE_TYPE
, DS_SUBSET_HORIZON_DAYS DS_SUBSET_HORIZON_DAYS
, SCHEDULE_DAYS_BEFORE SCHEDULE_DAYS_BEFORE
, SCHEDULE_START_TIME SCHEDULE_START_TIME
, SCHEDULE_SUBSET_TYPE SCHEDULE_SUBSET_TYPE
, INCLUDE_WO INCLUDE_WO
, ENFORCE_PURCH_LEAD_TIME ENFORCE_PURCH_LEAD_TIME
, USER_UPDATE_FIRM USER_UPDATE_FIRM
, DEMAND_PRIORITY_SENSITIVITY DEMAND_PRIORITY_SENSITIVITY
, EARLY_BUILD_PENALTY EARLY_BUILD_PENALTY
, AUTO_RELEASE_TIME_FENCE AUTO_RELEASE_TIME_FENCE
, SUBSET_DESIGNATOR_ID SUBSET_DESIGNATOR_ID
, INCLUDE_PLANNED_ORDER INCLUDE_PLANNED_ORDER
, CURR_INCLUDE_PLANNED_ORDER CURR_INCLUDE_PLANNED_ORDER
, CURR_INCLUDE_WO CURR_INCLUDE_WO
, CURR_DS_HORIZON_DAYS CURR_DS_HORIZON_DAYS
, CURR_SCHEDULE_SUBSET_TYPE CURR_SCHEDULE_SUBSET_TYPE
, CURR_SUBSET_DESIGNATOR_ID CURR_SUBSET_DESIGNATOR_ID
, CALCULATE_SDS_DAYS_TIME CALCULATE_SDS_DAYS_TIME
, CALCULATE_SDS_WEEKS_TIME CALCULATE_SDS_WEEKS_TIME
, CALCULATE_SDS_PERIODS_TIME CALCULATE_SDS_PERIODS_TIME
, FIRM_OUTSIDE_SUBSET FIRM_OUTSIDE_SUBSET
, ENABLE_SO_SPLIT ENABLE_SO_SPLIT
, DS_HORIZON_DAYS DS_HORIZON_DAYS
, PLANNING_MODE PLANNING_MODE
, SDS_DMD_PENALTY SDS_DMD_PENALTY
, CURR_OLS_HORIZON_DAYS CURR_OLS_HORIZON_DAYS
, OLS_FROZEN_HORIZON_DAYS OLS_FROZEN_HORIZON_DAYS
, CALCULATE_LIABILITY CALCULATE_LIABILITY
, CURR_ENF_FULFILLMENT_LT CURR_ENF_FULFILLMENT_LT
, ENFORCE_FULFILLMENT_LT ENFORCE_FULFILLMENT_LT
, DEMAND_FULFILLMENT_LT DEMAND_FULFILLMENT_LT
, MFG_LT_VAR_PERCENT MFG_LT_VAR_PERCENT
, SUP_LT_VAR_PERCENT SUP_LT_VAR_PERCENT
, TRANSIT_LT_VAR_PERCENT TRANSIT_LT_VAR_PERCENT
, SERVICE_LEVEL_SET_ID SERVICE_LEVEL_SET_ID
, CURR_SERVICE_LEVEL_SET_ID CURR_SERVICE_LEVEL_SET_ID
, PLAN_RUN_DATE PLAN_RUN_DATE
, ITEM_SIMULATION_SET_ID ITEM_SIMULATION_SET_ID
, PUBLISH_SUPPLY_COMMIT_VERSION PUBLISH_SUPPLY_COMMIT_VERSION
, PLANNED_BUCKET PLANNED_BUCKET
, PLANNED_BUCKET_TYPE PLANNED_BUCKET_TYPE
, ASSIGNMENT_SET_OUT_ID ASSIGNMENT_SET_OUT_ID
, CATEGORY_SET_ID CATEGORY_SET_ID
, SOP_ENABLED SOP_ENABLED
, CONSTRAINED_MODE CONSTRAINED_MODE
, MANUAL_FCST_OVERWRITE_OPTION MANUAL_FCST_OVERWRITE_OPTION
, ENFORCE_CONSTRAINTS ENFORCE_CONSTRAINTS
, SAFETY_STOCK_VALUE_TYPE SAFETY_STOCK_VALUE_TYPE
, REALLOC_SURPLUS_DAYS REALLOC_SURPLUS_DAYS
, PERFORM_FAIR_SHARE_ALLOC PERFORM_FAIR_SHARE_ALLOC
, INCLUDE_ALL_ITEMS INCLUDE_ALL_ITEMS
, INCLUDE_ALL_CATEGORIES INCLUDE_ALL_CATEGORIES
, AUTO_RELEASE_METHOD AUTO_RELEASE_METHOD
, INCLUDE_RESCHEDULES INCLUDE_RESCHEDULES
, CALENDAR_TYPE CALENDAR_TYPE
, HISTORY_RANGE HISTORY_RANGE
, HISTORY_RANGE_UOM HISTORY_RANGE_UOM
, FORECAST FORECAST
, FORECAST_UOM FORECAST_UOM
, FORECAST_BUCKET FORECAST_BUCKET
, FORECAST_BUCKET_UOM FORECAST_BUCKET_UOM
, GENERATE_INLINE_FORECAST GENERATE_INLINE_FORECAST
, CIRCULAR_SRC CIRCULAR_SRC
, ARCHIVE_FLAG ARCHIVE_FLAG
, APPLIED APPLIED
, BASE_PLAN_ID BASE_PLAN_ID
, HAS_RUN HAS_RUN
, LOADED_FLAG LOADED_FLAG
, NEW_PLAN_ID NEW_PLAN_ID
, NEW_PLAN_LIST NEW_PLAN_LIST
, PLANNING_ENGINE_TYPE PLANNING_ENGINE_TYPE
, PREVIOUS_RUN_PLAN_ID PREVIOUS_RUN_PLAN_ID
, SAVED_FLAG SAVED_FLAG
, SIMULATION_SET_ID SIMULATION_SET_ID
, COMPUTE_SS_EOQ COMPUTE_SS_EOQ
, PRIVATE_PLAN PRIVATE_PLAN
, RELEASE_FLAG RELEASE_FLAG
, SAVE_TO_DB SAVE_TO_DB
, COMPUTE_CONSTRAINTS COMPUTE_CONSTRAINTS
, BUILD_READY_PCT BUILD_READY_PCT
, RELEASE_SO RELEASE_SO
, AUTO_RELEASE_RP AUTO_RELEASE_RP
, PLAN_VERSION PLAN_VERSION
, RP_USER_ID RP_USER_ID
, DERIVE_RETURN_FCST_FROM_WO DERIVE_RETURN_FCST_FROM_WO
, EXCEP_GROUP_ID EXCEP_GROUP_ID
, DAILY_MWO_AGGR_LVL DAILY_MWO_AGGR_LVL
, WEEKLY_MWO_AGGR_LVL WEEKLY_MWO_AGGR_LVL
, PERIOD_MWO_AGGR_LVL PERIOD_MWO_AGGR_LVL
, PUB_CAP_TO_CMRO PUB_CAP_TO_CMRO
, ENFORCE_WRH_CPTY ENFORCE_WRH_CPTY
, ASCP_PLAN_ID ASCP_PLAN_ID
, ASCP_PLAN_VERSION ASCP_PLAN_VERSION
, SNAPSHOT_SOURCE SNAPSHOT_SOURCE
, GENERATE_WORKSHEET GENERATE_WORKSHEET
, SUPPLY_INCLUSION_OPTION SUPPLY_INCLUSION_OPTION
, CRITERIA_CHANGED CRITERIA_CHANGED
, ENABLE_SAFETY_STOCK_RES ENABLE_SAFETY_STOCK_RES
FROM "MSC"."MSC_PLANS"