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

VIEW: MSC.MSC_PLANS_OTHER#

Object Details
Object Name: MSC_PLANS_OTHER#
Object Type: VIEW
Owner: MSC
Subobject Name:
Status: VALID

[View Source]

Columns
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

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# references the following:

SchemaMSC
TableMSC_PLANS_OTHER
MSC.MSC_PLANS_OTHER# is referenced by following:

SchemaAPPS
SynonymMSC_PLANS_OTHER