DBA Data[Home] [Help] [Dependency Information]

TABLE: MSC.MSC_PLANS_OTHER

Object Details
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.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
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
FIRST_CYCLE_START_DATE DATE

First Cycle Start Date
ENFORCE_CRO_CYCLE NUMBER

Enforce CRO Cycle Boundaries
REM_CRO_RESI_PRODN NUMBER

Remove CRO Residual Production
INCLUDE_CMRO_WORKORDERS NUMBER

Flag to indicate, Inclusion of CMRO workorders
INCLUDE_EAM_WORKORDERS NUMBER

Include EAM WorkOrders
CONSIDER_EAM_SCHEDULE NUMBER

Consider EAM Schedule
INCLUDE_DEMANDS NUMBER

Include Demands
INCLUDE_SUPPLIES NUMBER

Include Supplies
ACTIVE_ITEM_FILTER NUMBER

Active Item Filter
SUPPLY_TOL_OFFSET NUMBER

INC_SCENARIO_FILE NUMBER

ENFORCE_HORIZON_START NUMBER

IMP_CLOSED_VISIT_WO NUMBER

Query Text

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
,      FIRST_CYCLE_START_DATE
,      ENFORCE_CRO_CYCLE
,      REM_CRO_RESI_PRODN
,      INCLUDE_CMRO_WORKORDERS
,      INCLUDE_EAM_WORKORDERS
,      CONSIDER_EAM_SCHEDULE
,      INCLUDE_DEMANDS
,      INCLUDE_SUPPLIES
,      ACTIVE_ITEM_FILTER
,      SUPPLY_TOL_OFFSET
,      INC_SCENARIO_FILE
,      ENFORCE_HORIZON_START
,      IMP_CLOSED_VISIT_WO
FROM MSC.MSC_PLANS_OTHER;

Dependencies

[top of page]

MSC.MSC_PLANS_OTHER does not reference any database object

MSC.MSC_PLANS_OTHER is referenced by following:

SchemaMSC
ViewMSC_PLANS_OTHER#