MSC_PLANS
This table stores different plans, with their names, and settings in the Oracle Advanced Planning and Scheduling(APS) and Oracle Supply Chain Hub products.
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Primary Key
| Name | Columns |
|---|---|
|
MSC_PLANS_PK |
PLAN_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PLAN_ID | NUMBER | 18 | Yes | Plan identifier | |
| COMPILE_DESIGNATOR | VARCHAR2 | 10 | Yes | Name of the plan | |
| SR_INSTANCE_ID | NUMBER | 18 | Yes | Source instance id for the org | |
| APPEND_PLANNED_ORDERS | NUMBER | Flag to indicate whether to create new planned orders - or just redo allocation | |||
| ASSIGNMENT_SET_ID | NUMBER | Assignment set identifier | |||
| CURR_APPEND_PLANNED_ORDERS | NUMBER | Yes | Flag to indicate whether to create new planned orders - or just redo allocation | ||
| CURR_ASSIGNMENT_SET_ID | NUMBER | 18 | Current assignment set identifier | ||
| CURR_BILL_OF_RESOURCES | VARCHAR2 | 10 | Current value of bill of resources | ||
| CURR_CONSIDER_PO | NUMBER | Current value of consider po flag | |||
| CURR_CONSIDER_RESERVATIONS | NUMBER | Current value of consider reservations flag | |||
| CURR_CONSIDER_WIP | NUMBER | Current value of consider wip flag | |||
| CURR_CUTOFF_DATE | DATE | Yes | End date of the planning horizon | ||
| CURR_DEMAND_TIME_FENCE_FLAG | NUMBER | Yes | Flag to indicate whether to use the demand time fence. The Demand Time Fence is defined at the item level | ||
| CURR_HARD_PEGGING_LEVEL | NUMBER | Current value of hard pegging level | |||
| CURR_INCLUDED_ITEMS | NUMBER | Complementary item to decide which item to plan. MRP(1), MRP and DRP(2), MPS(3), MRP and MPS(4), all items(5) | |||
| CURR_OPERATION_SCHEDULE_TYPE | NUMBER | Yes | Lead-time offset type | ||
| CURR_OVERWRITE_OPTION | NUMBER | Yes | Flag to indicate whether to overwrite existing plan. All(1), Outside planning time fence(2), None(3) | ||
| CURR_PART_INCLUDE_TYPE | NUMBER | What items to plan: all(1), MDS an MPS only(2), or MDS, MPS, and WIP components(3) | |||
| CURR_PLANNING_TIME_FENCE_FLAG | NUMBER | Yes | Flag to indicate whether to use the planning time fence. The Planning Time Fence is defined at the item level | ||
| CURR_PLAN_CAPACITY_FLAG | NUMBER | Current flag to indicate whether to plan capacity requirements | |||
| CURR_PLAN_SAFETY_STOCK | NUMBER | Current value of plan safety stock flag | |||
| CURR_PLAN_TYPE | NUMBER | Yes | Specify whether the plan is MRP, DRP or MPS plan | ||
| CURR_RESERVATION_LEVEL | NUMBER | Current value of reservation level | |||
| CURR_SCHEDULE_DESIGNATOR | VARCHAR2 | 10 | Current schedule designator code | ||
| CURR_SCHEDULE_TYPE | NUMBER | MDS(1) or MPS(2). Used for single organization. Option to schedule against only MDS or only MPS | |||
| CURR_SIMULATION_SET | VARCHAR2 | 10 | Current value of simulation set | ||
| CURR_SNAPSHOT_LOCK | NUMBER | Current value of the flag that determines whether the Snapshot tries to lock tables | |||
| CURR_SPLIT_DEMANDS | NUMBER | Flag to indicate whether to allow demand splitting | |||
| CURR_START_DATE | DATE | Yes | Start date of the planning horizon | ||
| CUTOFF_DATE | DATE | End date of the planning horizon | |||
| DAILY_CUTOFF_DATE | DATE | End date of the planning horizon | |||
| DAILY_ITEM_AGGREGATION_LEVEL | NUMBER | Yes | Daily aggregation for material in this term (should be at least as aggregated as the preceding term) | ||
| DAILY_MATERIAL_CONSTRAINTS | NUMBER | Yes | Flag to indicate whether to use constraint on material availability | ||
| DAILY_RESOURCE_CONSTRAINTS | NUMBER | Yes | Flag to indicate whether to use constraint on resource availability | ||
| DAILY_RES_AGGREGATION_LEVEL | NUMBER | Yes | Daily aggregation for resources in this term (should be at least as aggregated as the preceding term) | ||
| DAILY_TRANS_CONSTRAINTS | NUMBER | Flag to indicate whether to use transportation constraints | |||
| DATA_COMPLETION_DATE | DATE | Data completion date | |||
| DATA_START_DATE | DATE | Data start date | |||
| DEMAND_TIME_FENCE_FLAG | NUMBER | Flag to indicate whether to use the demand time fence. The Demand Time Fence is defined at the item level | |||
| DESCRIPTION | VARCHAR2 | 50 | Textual description of the plan | ||
| DMD_LATENESS_PENALTY_COST | NUMBER | Demand lateness penalty cost | |||
| HARD_PEGGING_LEVEL | NUMBER | Plan level option that determines the pegging granularity of planned orders | |||
| HOUR_CUTOFF_DATE | DATE | HOUR_CUTOFF_DATE | |||
| INCLUDED_ITEMS | NUMBER | Complementary item to decide which item to plan. MRP(1), MRP and DRP(2), MPS(3), MRP and MPS(4), all items(5) | |||
| MIN_CUTOFF_DATE | DATE | MIN_CUTOFF_DATE | |||
| MONTHLY_CUTOFF_DATE | DATE | MONTHLY_CUTOFF_DATE | |||
| MONTHLY_ITEM_AGGREGATION_LEVEL | NUMBER | Monthly aggregation for material in this term (should be at least as aggregated as the preceding term) | |||
| MONTHLY_MATERIAL_CONSTRAINTS | NUMBER | Material constraints at the monthly level | |||
| MONTHLY_RESOURCE_CONSTRAINTS | NUMBER | Resource constraints at the monthly level | |||
| MONTHLY_RES_AGGREGATION_LEVEL | NUMBER | Monthly aggregation for resource in this term (should be at least as aggregated as the preceding term) | |||
| MONTHLY_TRANS_CONSTRAINTS | NUMBER | Transportaion contraints at the monthly level | |||
| OBJECTIVE_WEIGHT_1 | NUMBER | Weight of the first objective | |||
| OBJECTIVE_WEIGHT_10 | NUMBER | Weight of the tenth objective | |||
| OBJECTIVE_WEIGHT_2 | NUMBER | Weight of the second objective | |||
| OBJECTIVE_WEIGHT_3 | NUMBER | Weight of the third objective | |||
| OBJECTIVE_WEIGHT_4 | NUMBER | Weight of the fourth objective | |||
| OBJECTIVE_WEIGHT_5 | NUMBER | Weight of the fifth objective | |||
| OBJECTIVE_WEIGHT_6 | NUMBER | Weight of the sixth objective | |||
| OBJECTIVE_WEIGHT_7 | NUMBER | Weight of the seventh objective | |||
| OBJECTIVE_WEIGHT_8 | NUMBER | Weight of the eighth objective | |||
| OBJECTIVE_WEIGHT_9 | NUMBER | Weight of the ninth objective | |||
| OPERATION_SCHEDULE_TYPE | NUMBER | Lead-time offset type | |||
| ORGANIZATION_ID | NUMBER | Yes | Organization identifier of the organization owning the plan | ||
| ORGANIZATION_SELECTION | NUMBER | Organizition selection flag | |||
| OVERWRITE_OPTION | NUMBER | Flag to indicate whether to overwrite existing plan. All(1), Outside planning time fence(2), None(3) | |||
| PART_INCLUDE_TYPE | NUMBER | What items to plan: all(1), MDS an MPS only(2), or MDS, MPS, and WIP components(3) | |||
| PENALTY_COST_1 | NUMBER | Penalty cost for objective 1 | |||
| PENALTY_COST_10 | NUMBER | Penalty cost for objective 10 | |||
| PENALTY_COST_2 | NUMBER | Penalty cost for objective 2 | |||
| PENALTY_COST_3 | NUMBER | Penalty cost for objective 3 | |||
| PENALTY_COST_4 | NUMBER | Penalty cost for objective 4 | |||
| PENALTY_COST_5 | NUMBER | Penalty cost for objective 5 | |||
| PENALTY_COST_6 | NUMBER | Penalty cost for objective 6 | |||
| PENALTY_COST_7 | NUMBER | Penalty cost for objective 7 | |||
| PENALTY_COST_8 | NUMBER | Penalty cost for objective 8 | |||
| PENALTY_COST_9 | NUMBER | Penalty cost for objective 9 | |||
| PLANNED_REFRESHES | VARCHAR2 | 10 | Plan refresh flag | ||
| PLANNING_TIME_FENCE_FLAG | NUMBER | Flag to indicate whether to use the planning time fence. The Planning Time Fence is defined at the item level | |||
| PLAN_CAPACITY_FLAG | NUMBER | Current flag to indicate whether to plan capacity requirements | |||
| PLAN_COMPLETION_DATE | DATE | Plan completion date | |||
| PLAN_START_DATE | DATE | Plan start date | |||
| PLAN_TYPE | NUMBER | Specify whether the plan is MRP, DRP or MPS plan | |||
| QTRLY_CUTOFF_DATE | DATE | End date of the planning horizon | |||
| QTRLY_ITEM_AGGREGATION_LEVEL | NUMBER | Quaterly aggregation for material in this term (should be at least as aggregated as the preceding term) | |||
| QTRLY_MATERIAL_CONSTRAINTS | NUMBER | Material constraints at the quater level | |||
| QTRLY_RESOURCE_CONSTRAINTS | NUMBER | Resource constraints at the quater level | |||
| QTRLY_RES_AGGREGATION_LEVEL | NUMBER | Quaterly aggregation for resource in this term (should be at least as aggregated as the preceding term) | |||
| QTRLY_TRANS_CONTRAINTS | NUMBER | Transportation constraints at the quater level | |||
| RESERVATION_LEVEL | NUMBER | Plan level option which indicates at what level MRP will reserve supply against demand | |||
| RESOURCE_OVER_UTIL_COST | NUMBER | Resource overutilization cost | |||
| SCHEDULE_DESIGNATOR | VARCHAR2 | 10 | Schedule designator | ||
| SCHEDULE_TYPE | NUMBER | MDS(1) or MPS(2). Used for single organization. Option to schedule against only MDS or only MPS | |||
| SLACK_ALLOWED_FLAG_1 | NUMBER | Flag to indicate whether Slack allowed for objective 1 | |||
| SLACK_ALLOWED_FLAG_10 | NUMBER | Flag to indicate whether Slack allowed for objective 10 | |||
| SLACK_ALLOWED_FLAG_2 | NUMBER | Flag to indicate whether Slack allowed for objective 2 | |||
| SLACK_ALLOWED_FLAG_3 | NUMBER | Flag to indicate whether Slack allowed for objective 3 | |||
| SLACK_ALLOWED_FLAG_4 | NUMBER | Flag to indicate whether Slack allowed for objective 4 | |||
| SLACK_ALLOWED_FLAG_5 | NUMBER | Flag to indicate whether Slack allowed for objective 5 | |||
| SLACK_ALLOWED_FLAG_6 | NUMBER | Flag to indicate whether Slack allowed for objective 6 | |||
| SLACK_ALLOWED_FLAG_7 | NUMBER | Flag to indicate whether Slack allowed for objective 7 | |||
| SLACK_ALLOWED_FLAG_8 | NUMBER | Flag to indicate whether Slack allowed for objective 8 | |||
| SLACK_ALLOWED_FLAG_9 | NUMBER | Flag to indicate whether Slack allowed for objective 9 | |||
| SNAPSHOT_LOCK | NUMBER | Flag to determine whether the Snapshot should try to lock tables | |||
| SPLIT_DEMANDS | NUMBER | Flag to indicate whether to allow demand splitting | |||
| SS_PENALTY_COST | NUMBER | Penalty cost for safety stock | |||
| START_DATE | DATE | Start date of the planning horizon | |||
| SUPPLIER_CAP_OVER_UTIL_COST | NUMBER | Supplier capacity overutilization cost | |||
| WEEKLY_CUTOFF_DATE | DATE | End date of the planning horizon | |||
| WEEKLY_ITEM_AGGREGATION_LEVEL | NUMBER | Yes | Weekly aggregation for material in this term (should be at least as aggregated as the preceding term) | ||
| WEEKLY_MATERIAL_CONSTRAINTS | NUMBER | Yes | Material constraints at the weekly level | ||
| WEEKLY_RESOURCE_CONSTRAINTS | NUMBER | Yes | Resource constraints at the weekly level | ||
| WEEKLY_RES_AGGREGATION_LEVEL | NUMBER | Yes | Weekly aggregation for resources in this term (should be at least as aggregated as the preceding term) | ||
| WEEKLY_TRANS_CONSTRAINTS | NUMBER | Transportation constraints at the weekly level | |||
| WO_LATENESS_COST | NUMBER | Lateness cost for work order | |||
| OPTIMIZE_FLAG | NUMBER | Yes | Optimize flag | ||
| SCHEDULE_FLAG | NUMBER | Yes | Schedule flag | ||
| ONLINE_PLANNER_START_DATE | DATE | Online Planner start date and time | |||
| ONLINE_PLANNER_COMPLETION_DATE | DATE | Online Planner completion date and time | |||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| CURR_FULL_PEGGING | NUMBER | Current value of full pegging flag | |||
| DAILY_CUTOFF_BUCKET | NUMBER | Yes | Daily end date of the planning horizon | ||
| FULL_PEGGING | NUMBER | Full pegging flag | |||
| HOUR_CUTOFF_BUCKET | NUMBER | End date of the planning horizon in hours | |||
| MIN_CUTOFF_BUCKET | NUMBER | End date of the planning horizon in minutes | |||
| MONTHLY_CUTOFF_BUCKET | NUMBER | Monthly end date of the planning horizon | |||
| QTRLY_CUTOFF_BUCKET | NUMBER | Quaterly end date of the planning horizon | |||
| WEEKLY_CUTOFF_BUCKET | NUMBER | Yes | Weekly end date of the planning horizon | ||
| TRANSPORT_CAP_OVER_UTIL_COST | NUMBER | The Penalty cost for transportation capacity | |||
| BILL_OF_RESOURCES | VARCHAR2 | 10 | Bill of resource code | ||
| SIMULATION_SET | VARCHAR2 | 10 | Simulation set identifier | ||
| CONSIDER_WIP | NUMBER | Consider work in process flag | |||
| CONSIDER_PO | NUMBER | Consider purchase orders flag | |||
| PLAN_SAFETY_STOCK | NUMBER | Plan safety stock flag | |||
| CONSIDER_RESERVATIONS | NUMBER | Plan material reservations | |||
| CURR_ENFORCE_DEM_DUE_DATES | NUMBER | Yes | Current value of enforce demand due dates | ||
| ENFORCE_DEM_DUE_DATES | NUMBER | Enforce demand due dates | |||
| PLANNED_RESOURCES | NUMBER | Planned resources flag | |||
| CURR_PLANNED_RESOURCES | NUMBER | Yes | Current value of planned resource flag | ||
| DEM_PRIORITY_RULE_ID | NUMBER | Demand priority rule identifier | |||
| CURR_DEM_PRIORITY_RULE_ID | NUMBER | Current value of demand priority rule identifier | |||
| DAILY_RTG_AGGREGATION_LEVEL | NUMBER | Yes | Daily aggregation for routings | ||
| WEEKLY_RTG_AGGREGATION_LEVEL | NUMBER | Yes | Weekly aggregation for routings | ||
| PERIOD_RTG_AGGREGATION_LEVEL | NUMBER | Period aggregation for routings | |||
| PERIOD_CUTOFF_BUCKET | NUMBER | Yes | Period cutoff bucket | ||
| LOT_FOR_LOT_FLAG | NUMBER | Lot for lot flag | |||
| ENFORCE_CAP_CONSTRAINTS | NUMBER | Enforce cap constraints flag | |||
| CURR_ENFORCE_CAP_CONSTRAINTS | NUMBER | Current enforce cap constraints | |||
| SERVICE_LEVEL | NUMBER | Service level | |||
| BOTTLENECK_RES_GROUP | VARCHAR2 | 30 | Bottleneck resource group | ||
| CURR_BOTTLENECK_RES_GROUP | VARCHAR2 | 30 | Current value of bottleneck resource group | ||
| PERIOD_MATERIAL_CONSTRAINTS | NUMBER | Yes | Material constraints at the period level | ||
| PERIOD_RESOURCE_CONSTRAINTS | NUMBER | Yes | Period aggregation for resources in this term (should be at least as aggregated as the preceeding term) | ||
| PERIOD_TRANS_CONSTRAINTS | NUMBER | Transfortaion contraints at the period level | |||
| PERIOD_ITEM_AGGREGATION_LEVEL | NUMBER | Yes | Period aggregation for material in this term (should be at least as aggregated as the preceding term) | ||
| PERIOD_RES_AGGREGATION_LEVEL | NUMBER | Yes | Period aggregation for resources in this term (should be at least as aggregated as the preceeding term) | ||
| LOT_FOR_LOT | NUMBER | 1 | Lot for lot flag | ||
| MIN_WF_EXCEPT_ID | NUMBER | 18 | Minimum workflow exception identifier | ||
| MAX_WF_EXCEPT_ID | NUMBER | 18 | Maximum workflow exception identifier | ||
| ENFORCE_SL_CONSTRAINTS | NUMBER | Enforce SL constraints | |||
| CURR_ENFORCE_SL_CONSTRAINTS | NUMBER | Current enforce SL constraints | |||
| ONLINE_REPLAN | NUMBER | Online replan | |||
| REFRESH_NUMBER | NUMBER | Refresh number | |||
| REVISION | VARCHAR2 | 30 | Revision | ||
| PARENT_PLAN_ID | NUMBER | 18 | Parent plan identifier | ||
| STATUS | NUMBER | Status | |||
| PRODUCTION_FLAG | NUMBER | Production flag | |||
| COMPANY_AGG_LEVEL | NUMBER | Company Aggregation level | |||
| TP_AGG_LEVEL | NUMBER | Trading partner aggregation level | |||
| PRODUCT_AGG_LEVEL | NUMBER | Product aggregation level | |||
| PURGE | NUMBER | Purge | |||
| PLAN_INVENTORY_POINT | NUMBER | Flag to indicate whether to create and schedule orders till next planned inventory point | |||
| ENABLE_CLOSEST_QTY_PEGGING | NUMBER | Enable Closest Qty Pegging | |||
| CURR_CLOSEST_QTY_PEG | NUMBER | Curr Enable Closest Qty Peg | |||
| ENABLE_PRIORITY_PEGGING | NUMBER | Enable Priority Pegging | |||
| CURR_PRIORITY_PEGGING | NUMBER | Curr Enable Priority Pegging | |||
| ENFORCE_SRC_CONSTRAINTS | NUMBER | Enforce Src Constraints | |||
| CURR_ENFORCE_SRC_CONSTRAINTS | NUMBER | Curr Enforce Src Constraints | |||
| BACKWARD_DAYS | NUMBER | Backward Days | |||
| CURR_BACKWARD_DAYS | NUMBER | Curr Backward Days | |||
| FORWARD_DAYS | NUMBER | Forward Days | |||
| CURR_FORWARD_DAYS | NUMBER | Curr Forward Days | |||
| SUMMARY_FLAG | NUMBER | summary flag | |||
| USE_ALTERNATE_RESOURCES | NUMBER | use alternate resources. | |||
| USE_END_ITEM_SUBSTITUTIONS | NUMBER | use end item substitutions | |||
| USE_ALTERNATE_BOM_ROUTING | NUMBER | use alternate bom routing | |||
| USE_SUBSTITUTE_COMPONENTS | NUMBER | use substitute component | |||
| USE_ALTERNATE_SOURCES | NUMBER | use alternate resources | |||
| SUBSTITUTION_DESIGNATOR | VARCHAR2 | 50 | substitution designator | ||
| KPI_REFRESH | NUMBER | kpi refresh option | |||
| DISPLAY_KPI | NUMBER | display kpi option | |||
| FORECAST_ALLOCATION_METHOD | NUMBER | 1- Donot Spread forecast2- Spread forecast evenly, the system spreads the forecasts evenly among the workdays in the week or period | |||
| FORECAST_CONSUMPTION_METHOD | NUMBER | Determines whether the forecast bucket is always used as the consumption bucket | |||
| COPY_PLAN_ID | NUMBER | Stores the link between the original plan and the temp plan in case of 24x7 ATP | |||
| EXPLODE_FORECAST | NUMBER | Explode Forecast | |||
| FORECAST_ASSIGNMENT_SET_ID | NUMBER | 18 | Assignment set id for global forecast distribution | ||
| ENFORCE_SUP_CAP_CONSTRAINTS | NUMBER | Enforce supplier capacity constraints | |||
| ENFORCE_PUR_LT_CONSTRAINTS | NUMBER | Enforce purchasing leadtime constraints | |||
| TGT_TL_UTIL_PCT | NUMBER | Target Truckload utilization percentage | |||
| MIN_TL_UTIL_PCT | NUMBER | Minimum Truckload utilization percentage | |||
| LOAD_SCHED_TIME_FENCE_DAYS | NUMBER | Load Scheduling timefence days | |||
| LOAD_SCHEDULING_DAYS | NUMBER | Load Scheduling days | |||
| DAILY_ALLOC_BUCKETS | NUMBER | Number of daily allocation buckets | |||
| WKS_PER_WKLY_ALLOC_BUCKET | NUMBER | Number of weekly allocation buckets | |||
| DMD_PRI_RULE_SET_ID | NUMBER | 18 | Demand Priority rule set | ||
| CIRC_SRCING_SURPLUS_DAYS | NUMBER | Circular Sourcing surplus days | |||
| SUPPLY_SCHED_ITF | NUMBER | supply schedule infinite time fence | |||
| INCLUDE_CRITICAL_COMPONENTS | NUMBER | This column represents if critical components are included in plan. | |||
| SCHEDULE_BY | NUMBER | 1 - SCHEDULE_SHIP, 2 - SCHEDULE_ARRIVAL , 3 - REQUEST_SHIP, 4 - REQUEST_ARRIVAL 5 - PROMISE_SHIP, 6 - PROMISE_ARRIVAL | |||
| PUBLISH_FCST_VERSION | NUMBER | Publish forecast version | |||
| RELEASE_RESCHEDULES | NUMBER | Flag indicates whether auto-release of reschedules are to be allowed if autorelease is enabled.1- Yes2- No | |||
| SAFETY_STK_CHANGE_INTERVAL | NUMBER | Safety stock duration interval | |||
| SAFETY_STK_THRESHOLD_PCT | NUMBER | Percent variation at threshold level | |||
| COPY_PLAN | NUMBER | Indicates whether plan is copid from some other plan | |||
| ENFORCE_USER_SAFETY_STOCKS | NUMBER | Flag to indicates whether to include safety stock constraints in plan | |||
| ENFORCE_BUDGET_CONSTRAINTS | NUMBER | Flag to indicates whether to include budget constraints in plan | |||
| BUDGET_ID | NUMBER | 18 | Budget id | ||
| BUDGET_VALUE | NUMBER | Budget Value | |||
| LATEST_REFRESH_NUMBER | NUMBER | Refresh number upto which the data has been summarized. | |||
| SUPPLIER_ALLOC_METHOD | NUMBER | Supplier allocation method | |||
| CUSTOMER_ALLOC_METHOD | NUMBER | Customer allocation method | |||
| DEFAULT_ALLOC_METHOD | NUMBER | Default allocation method | |||
| USE_FIXED_PERIOD_BKTS | VARCHAR2 | 1 | Use buckets based on absolute periods and not necessarily starting from the plan start date | ||
| SHIPMENT_CONSOLIDATION_DAYS | NUMBER | Shipment Consolidation Days | |||
| ITF_HORIZ_DAYS | NUMBER | Infinite timefence horizon days | |||
| USE_ORG_PRIORITY_OVERRIDE | VARCHAR2 | 1 | Use Organization Priority Overrides | ||
| USE_FIXED_PERIOD_ALLOC_BKTS | VARCHAR2 | 1 | Period Allocation Bucket - yes or no | ||
| SCHEDULE_BY_DATE_TYPE | NUMBER | Schedule by | |||
| DS_SUBSET_HORIZON_DAYS | NUMBER | Number of days for subset planning | |||
| SCHEDULE_DAYS_BEFORE | NUMBER | Days before sysdate | |||
| SCHEDULE_START_TIME | NUMBER | Schedule start time | |||
| SCHEDULE_SUBSET_TYPE | NUMBER | 1 Subset Designator 2 User Marked Order null: none | |||
| INCLUDE_WO | NUMBER | 1, Include production work orders, 2 include maintenance wo | |||
| ENFORCE_PURCH_LEAD_TIME | NUMBER | Honor purchasing lead time | |||
| USER_UPDATE_FIRM | NUMBER | Consider User updates firm | |||
| DEMAND_PRIORITY_SENSITIVITY | NUMBER | Demand prioirity | |||
| EARLY_BUILD_PENALTY | NUMBER | Penalty for early build | |||
| AUTO_RELEASE_TIME_FENCE | NUMBER | Specified the time fence within which the schedule gets automatically released to shop floor | |||
| SUBSET_DESIGNATOR_ID | NUMBER | 18 | fk to msc_subset_designators | ||
| INCLUDE_PLANNED_ORDER | NUMBER | Include Planned Order from ascp plan If this is specfied then only only ascp plan can be specified | |||
| CURR_INCLUDE_PLANNED_ORDER | NUMBER | Include Planned Order from ascp plan If this is specfied then only only ascp plan can be specified | |||
| CURR_INCLUDE_WO | NUMBER | 1, Include production work orders, 2 include maintenance wo | |||
| CURR_DS_HORIZON_DAYS | NUMBER | Current value of ds_horizon_days | |||
| CURR_SCHEDULE_SUBSET_TYPE | NUMBER | Current value of schedule_subset_type | |||
| CURR_SUBSET_DESIGNATOR_ID | NUMBER | 18 | Curent value of subset_designator_id | ||
| CALCULATE_SDS_DAYS_TIME | NUMBER | Calculate Sds Days Time | |||
| CALCULATE_SDS_WEEKS_TIME | NUMBER | Calculate Sds Weeks Time | |||
| CALCULATE_SDS_PERIODS_TIME | NUMBER | Calculate Sds Periods Time | |||
| FIRM_OUTSIDE_SUBSET | NUMBER | valid value :sys_yes,sys_no | |||
| ENABLE_SO_SPLIT | NUMBER | Enable So Split | |||
| DS_HORIZON_DAYS | NUMBER | Ds Horizon Days | |||
| PLANNING_MODE | NUMBER | 1 indicates plan is run for exception only mode | |||
| SDS_DMD_PENALTY | NUMBER | DS engine uses this to control the bias of the schedule output towards more favorable sequences / increase in demand lateness OR Less favorable sequences / decrease in demand lateness. Engine Multiplies demand lateness by this number (also influenced by priority exponent) to compare with setup times. | |||
| CURR_OLS_HORIZON_DAYS | NUMBER | OLS Horizon Days | |||
| OLS_FROZEN_HORIZON_DAYS | NUMBER | OLS Frozen Horizon Days | |||
| CALCULATE_LIABILITY | NUMBER | Calculate Liability | |||
| CURR_ENF_FULFILLMENT_LT | NUMBER | Curr Enf Fulfillment Lt | |||
| ENFORCE_FULFILLMENT_LT | NUMBER | Enforce Fulfillment Lt | |||
| DEMAND_FULFILLMENT_LT | NUMBER | Demand Fulfillment Lt | |||
| MFG_LT_VAR_PERCENT | NUMBER | Leadtime Variability | |||
| SUP_LT_VAR_PERCENT | NUMBER | Supplier Leadtime Variability | |||
| TRANSIT_LT_VAR_PERCENT | NUMBER | Intransit Leadtime Variability | |||
| SERVICE_LEVEL_SET_ID | NUMBER | 18 | Service level set id to identify the particular service level set | ||
| CURR_SERVICE_LEVEL_SET_ID | NUMBER | 18 | Curr service level set id | ||
| PLAN_RUN_DATE | DATE | Last plan run date ( used for DP Scenarios only Snaphot mode of plan run) | |||
| ITEM_SIMULATION_SET_ID | NUMBER | Item Simulation Set Id. | |||
| PUBLISH_SUPPLY_COMMIT_VERSION | NUMBER | Stores the Last published version of the Publish Supply commit program | |||
| PLANNED_BUCKET | NUMBER | Planned Bucket | |||
| PLANNED_BUCKET_TYPE | NUMBER | Planned Bucket Type | |||
| ASSIGNMENT_SET_OUT_ID | NUMBER | Assignment Set Out Id | |||
| CATEGORY_SET_ID | NUMBER | 18 | Category Set Id | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| MSC_PLANS | msc_assignment_sets | ASSIGNMENT_SET_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| MSC_PLANS_N1 | Non Unique | Default | COMPILE_DESIGNATOR |
| MSC_PLANS_U1 | Unique | Default | PLAN_ID |
| MSC_PLANS_U2 | Unique | Default | ORGANIZATION_ID, COMPILE_DESIGNATOR, SR_INSTANCE_ID |