[Home] [Help] [Dependency Information]
Object Name: | MSC_PLANS_OTHER# |
---|---|
Object Type: | VIEW |
Owner: | MSC |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PLAN_ID | NUMBER | Yes | ||
MODEL_HORIZON | NUMBER | Yes | ||
DATA_HORIZON | NUMBER | Yes | ||
HORIZON_UNITS | NUMBER | Yes | ||
REF_PLAN_ID | NUMBER | |||
DECIMAL_PRECISION | NUMBER | Yes | ||
OFFLOAD_THRESHOLD | NUMBER | Yes | ||
OFFLOAD_THRESHOLD_WINDOW | NUMBER | Yes | ||
WORKDAY_TIME | NUMBER | Yes | ||
WORKDAY_DAY | NUMBER | Yes | ||
COST_TIME_UNIT | NUMBER | Yes | ||
FIXED_PRODUCTION_FENCE | NUMBER | Yes | ||
FIXED_PRODUCTION_UNITS | NUMBER | Yes | ||
CRITICAL_COMPONENTS_FLAG | NUMBER | Yes | ||
ALLOW_WO_OFFLOAD_FLAG | NUMBER | Yes | ||
INCLUDE_PAST_DUE_SALESORDERS | NUMBER | Yes | ||
DEMAND_BUILD_STRATEGY | NUMBER | Yes | ||
GLOBAL_BUILD_STRATEGY | NUMBER | Yes | ||
SHIP_COMPLETE_FLAG | NUMBER | Yes | ||
CREATE_ITEM_FOLDERS | NUMBER | |||
CREATE_SUPPLY_FOLDERS | NUMBER | |||
CREATE_WORKORDER_FOLDERS | NUMBER | |||
USE_RMO_FLAG | NUMBER | Yes | ||
MINIMUM_CYCLE_TIME | NUMBER | Yes | ||
MINIMIZE_CHANGEOVER_FLAG | NUMBER | Yes | ||
IDEAL_SEQUENCE_BASE | NUMBER | Yes | ||
INVENTORY_COST_FACTOR | NUMBER | Yes | ||
STOCKOUT_COST_FACTOR | NUMBER | Yes | ||
CHANGEOVER_COST_FACTOR | NUMBER | Yes | ||
SAFETY_COST_FACTOR | NUMBER | Yes | ||
START_TIME | NUMBER | Yes | ||
OFFSET_DAYS | NUMBER | Yes | ||
DEMAND_FORECAST_FENCE | NUMBER | |||
BOTTLENECK_RESOURCE_GROUP | VARCHAR2 | (255) | ||
SIMULATION_SET | VARCHAR2 | (255) | ||
CREATED_BY | NUMBER | Yes | ||
CREATION_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | |||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATE_LOGIN | NUMBER | |||
REQUEST_ID | NUMBER | |||
PROGRAM_ID | NUMBER | |||
PRGRAM_APPLICATION_ID | NUMBER | |||
PROGRAM_UPDATE_DATE | DATE | |||
CREATE_DEMAND_FOLDERS | NUMBER | |||
USE_UNITS_OF_EFFORT | NUMBER | |||
USE_ADJACENT_OPERATIONS | NUMBER | |||
PURCHASE_LEAD_TIME_OFFSET | NUMBER | |||
ENABLE_SAFETY_COVER | NUMBER | |||
RELEASE_FLAG | NUMBER | |||
FIRST_CYCLE_START_DATE | DATE | |||
ENFORCE_CRO_CYCLE | NUMBER | |||
REM_CRO_RESI_PRODN | NUMBER | |||
INCLUDE_CMRO_WORKORDERS | NUMBER | |||
INCLUDE_EAM_WORKORDERS | NUMBER | |||
CONSIDER_EAM_SCHEDULE | NUMBER | |||
INCLUDE_DEMANDS | NUMBER | |||
INCLUDE_SUPPLIES | NUMBER | |||
ACTIVE_ITEM_FILTER | NUMBER | |||
SUPPLY_TOL_OFFSET | NUMBER | |||
INC_SCENARIO_FILE | NUMBER | |||
ENFORCE_HORIZON_START | NUMBER | |||
IMP_CLOSED_VISIT_WO | NUMBER |
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#;
|
|
|