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