[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | MSC_PLANS |
|---|---|
| Object Type: | TABLE |
| Owner: | MSC |
| FND Design Data: |  MSC.MSC_PLANS
|
| Subobject Name: | |
| Status: | VALID |
This table stores different plans, with their names, and settings in the Oracle Advanced Planning and Scheduling(APS) and Oracle Supply Chain Hub products.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| MSC_PLANS_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 PLAN_ID
|
| MSC_PLANS_U2 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
ORGANIZATION_ID
COMPILE_DESIGNATOR
SR_INSTANCE_ID
|
| MSC_PLANS_N1 | NORMAL | NONUNIQUE |
APPS_TS_SEED
|
COMPILE_DESIGNATOR
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PLAN_ID | NUMBER | Yes | Plan identifier | |
| COMPILE_DESIGNATOR | VARCHAR2 | (10) | Yes | Name of the plan |
| SR_INSTANCE_ID | NUMBER | 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 | 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_FULL_PEGGING | NUMBER | Current value of full pegging flag | ||
| 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_BUCKET | NUMBER | Yes | Daily 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 | ||
| FULL_PEGGING | NUMBER | Full pegging flag | ||
| HOUR_CUTOFF_BUCKET | NUMBER | End date of the planning horizon in hours | ||
| 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_BUCKET | NUMBER | End date of the planning horizon in minutes | ||
| MONTHLY_CUTOFF_BUCKET | NUMBER | Monthly end date of the planning horizon | ||
| 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_BUCKET | NUMBER | Quaterly end date of the planning horizon | ||
| 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 | ||
| START_DATE | DATE | Start date of the planning horizon | ||
| SUPPLIER_CAP_OVER_UTIL_COST | NUMBER | Supplier capacity overutilization cost | ||
| WEEKLY_CUTOFF_BUCKET | NUMBER | Yes | Weekly 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 | Transfortation constraints at the weekly level | ||
| 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 | ||
| 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) | |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
| CREATION_DATE | DATE | Yes | Standard Who column | |
| LOT_FOR_LOT | NUMBER | (1) | Lot for lot flag | |
| CREATED_BY | NUMBER | Yes | Standard Who column | |
| LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield structure defining column | |
| REQUEST_ID | NUMBER | Concurrent Who column | ||
| PROGRAM_APPLICATION_ID | NUMBER | Concurrent Who column | ||
| PROGRAM_ID | NUMBER | Concurrent Who column | ||
| PROGRAM_UPDATE_DATE | DATE | Concurrent Who column | ||
| MIN_WF_EXCEPT_ID | NUMBER | Minimum workflow exception identifier | ||
| MAX_WF_EXCEPT_ID | NUMBER | Maximum workflow exception identifier | ||
| ONLINE_REPLAN | NUMBER | Online replan | ||
| REFRESH_NUMBER | NUMBER | Refresh number | ||
| REVISION | VARCHAR2 | (30) | Revision | |
| PARENT_PLAN_ID | NUMBER | 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 | ||
| ENFORCE_SL_CONSTRAINTS | NUMBER | Enforce SL constraints | ||
| CURR_ENFORCE_SL_CONSTRAINTS | NUMBER | Current enforce SL constraints | ||
| 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 | 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 | 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 | 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 | 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 | 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 | Service level set id to identify the particular service level set | ||
| CURR_SERVICE_LEVEL_SET_ID | NUMBER | 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 | Category Set Id | ||
| SOP_ENABLED | NUMBER | Enable for SOP Flag | ||
| CONSTRAINED_MODE | NUMBER | Constrained Mode | ||
| MANUAL_FCST_OVERWRITE_OPTION | NUMBER | Manual Forecast Overwrite Option | ||
| ENFORCE_CONSTRAINTS | NUMBER | Enforce Constraints Flag | ||
| SAFETY_STOCK_VALUE_TYPE | NUMBER | Safety Stock Value Type | ||
| REALLOC_SURPLUS_DAYS | NUMBER | Reallocation Surplus Days | ||
| PERFORM_FAIR_SHARE_ALLOC | NUMBER | Perform Fair Share Allocation Flag | ||
| INCLUDE_ALL_ITEMS | NUMBER | Include All Items Flag | ||
| INCLUDE_ALL_CATEGORIES | NUMBER | Include All Categories Flag | ||
| AUTO_RELEASE_METHOD | NUMBER | Auto Release Method | ||
| INCLUDE_RESCHEDULES | NUMBER | Include Reschedules | ||
| CALENDAR_TYPE | NUMBER | Calendar Type | ||
| HISTORY_RANGE | NUMBER | History Range | ||
| HISTORY_RANGE_UOM | NUMBER | History Range UOM | ||
| FORECAST | NUMBER | Forecast | ||
| FORECAST_UOM | NUMBER | Forecast UOM | ||
| FORECAST_BUCKET | NUMBER | Forecast Bucket | ||
| FORECAST_BUCKET_UOM | NUMBER | Forecast Bucket UOM | ||
| GENERATE_INLINE_FORECAST | NUMBER | Genrate Inline Forecast Flag | ||
| CIRCULAR_SRC | NUMBER | Circular Sourcing Flag | ||
| ARCHIVE_FLAG | NUMBER | Archive Flag |
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
FROM MSC.MSC_PLANS;
MSC.MSC_PLANS does not reference any database object
MSC.MSC_PLANS is referenced by following:
APPS
MSC_DEMANDS_F_MV
MSC_PLANS
MSC
MSC_ATP_PLAN_SN
|
|
|
|