[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | MSC_PLANS_OTHER |
|---|---|
| Object Type: | TABLE |
| Owner: | MSC |
| Subobject Name: | |
| Status: | VALID |
This table stores additional details of 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: |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PLAN_ID | NUMBER | Yes | Plan Id | |
| MODEL_HORIZON | NUMBER | Yes | Model Horizon | |
| DATA_HORIZON | NUMBER | Yes | Data Horizon | |
| HORIZON_UNITS | NUMBER | Yes | Horizon Units | |
| REF_PLAN_ID | NUMBER | Reference Plan Id | ||
| DECIMAL_PRECISION | NUMBER | Yes | Decimal Precision | |
| OFFLOAD_THRESHOLD | NUMBER | Yes | Offload Threshold | |
| OFFLOAD_THRESHOLD_WINDOW | NUMBER | Yes | Offload Threshold Window | |
| WORKDAY_TIME | NUMBER | Yes | Work Day Time | |
| WORKDAY_DAY | NUMBER | Yes | Work Day Day | |
| COST_TIME_UNIT | NUMBER | Yes | Cost Time Unit | |
| FIXED_PRODUCTION_FENCE | NUMBER | Yes | Fixed Production Fence | |
| FIXED_PRODUCTION_UNITS | NUMBER | Yes | Fixed Production Units | |
| CRITICAL_COMPONENTS_FLAG | NUMBER | Yes | Critical Components Flag | |
| ALLOW_WO_OFFLOAD_FLAG | NUMBER | Yes | Allow Work Order Offload Flag | |
| INCLUDE_PAST_DUE_SALESORDERS | NUMBER | Yes | Include Past Due Sales Orders | |
| DEMAND_BUILD_STRATEGY | NUMBER | Yes | Demand Build Strategy | |
| GLOBAL_BUILD_STRATEGY | NUMBER | Yes | Global Build Strategy | |
| SHIP_COMPLETE_FLAG | NUMBER | Yes | Ship Complete Flag | |
| CREATE_ITEM_FOLDERS | NUMBER | Create Item Folders | ||
| CREATE_SUPPLY_FOLDERS | NUMBER | Create Supply Folders | ||
| CREATE_WORKORDER_FOLDERS | NUMBER | Create WorkOrder Folders | ||
| USE_RMO_FLAG | NUMBER | Yes | Flag to Run Optimization | |
| MINIMUM_CYCLE_TIME | NUMBER | Yes | Minimum Cycle Time | |
| MINIMIZE_CHANGEOVER_FLAG | NUMBER | Yes | MInimize Changeover Flag | |
| IDEAL_SEQUENCE_BASE | NUMBER | Yes | Ideal Sequence Base | |
| INVENTORY_COST_FACTOR | NUMBER | Yes | INventory Cost Factor | |
| STOCKOUT_COST_FACTOR | NUMBER | Yes | Stockout Cost Factor | |
| CHANGEOVER_COST_FACTOR | NUMBER | Yes | Changeover Cost Factor | |
| SAFETY_COST_FACTOR | NUMBER | Yes | Safety Cost Factor | |
| START_TIME | NUMBER | Yes | Start Time | |
| OFFSET_DAYS | NUMBER | Yes | Offset Days | |
| DEMAND_FORECAST_FENCE | NUMBER | Demand Forecast Fence | ||
| BOTTLENECK_RESOURCE_GROUP | VARCHAR2 | (255) | Bottleneck Resource Group | |
| SIMULATION_SET | VARCHAR2 | (255) | Simulation Set | |
| CREATED_BY | NUMBER | Yes | Standard Who column | |
| CREATION_DATE | DATE | Standard Who column | ||
| LAST_UPDATED_BY | NUMBER | Standard Who column | ||
| LAST_UPDATE_DATE | DATE | Standard Who column | ||
| LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
| REQUEST_ID | NUMBER | Concurrent Who column | ||
| PROGRAM_ID | NUMBER | Concurrent Who column | ||
| PRGRAM_APPLICATION_ID | NUMBER | Concurrent Who column | ||
| PROGRAM_UPDATE_DATE | DATE | Concurrent Who column | ||
| CREATE_DEMAND_FOLDERS | NUMBER | Create Demand Folders | ||
| USE_UNITS_OF_EFFORT | NUMBER | Use Units of Effort | ||
| USE_ADJACENT_OPERATIONS | NUMBER | Use Adjacent Operations | ||
| PURCHASE_LEAD_TIME_OFFSET | NUMBER | Purchase Lead Time | ||
| ENABLE_SAFETY_COVER | NUMBER | Enable Safety Cover | ||
| RELEASE_FLAG | NUMBER | Release Flag |
Cut, paste (and edit) the following text to query this object:
SELECT PLAN_ID
, MODEL_HORIZON
, DATA_HORIZON
, HORIZON_UNITS
, REF_PLAN_ID
, DECIMAL_PRECISION
, OFFLOAD_THRESHOLD
, OFFLOAD_THRESHOLD_WINDOW
, WORKDAY_TIME
, WORKDAY_DAY
, COST_TIME_UNIT
, FIXED_PRODUCTION_FENCE
, FIXED_PRODUCTION_UNITS
, CRITICAL_COMPONENTS_FLAG
, ALLOW_WO_OFFLOAD_FLAG
, INCLUDE_PAST_DUE_SALESORDERS
, DEMAND_BUILD_STRATEGY
, GLOBAL_BUILD_STRATEGY
, SHIP_COMPLETE_FLAG
, CREATE_ITEM_FOLDERS
, CREATE_SUPPLY_FOLDERS
, CREATE_WORKORDER_FOLDERS
, USE_RMO_FLAG
, MINIMUM_CYCLE_TIME
, MINIMIZE_CHANGEOVER_FLAG
, IDEAL_SEQUENCE_BASE
, INVENTORY_COST_FACTOR
, STOCKOUT_COST_FACTOR
, CHANGEOVER_COST_FACTOR
, SAFETY_COST_FACTOR
, START_TIME
, OFFSET_DAYS
, DEMAND_FORECAST_FENCE
, BOTTLENECK_RESOURCE_GROUP
, SIMULATION_SET
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_ID
, PRGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE
, CREATE_DEMAND_FOLDERS
, USE_UNITS_OF_EFFORT
, USE_ADJACENT_OPERATIONS
, PURCHASE_LEAD_TIME_OFFSET
, ENABLE_SAFETY_COVER
, RELEASE_FLAG
FROM MSC.MSC_PLANS_OTHER;
MSC.MSC_PLANS_OTHER does not reference any database object
MSC.MSC_PLANS_OTHER is referenced by following:
APPS
MSC_PLANS_OTHER
|
|
|
|