eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.MSC_PLAN_PARAMETERS_V

Object Details

Object Name:	MSC_PLAN_PARAMETERS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	MSC.MSC_PLAN_PARAMETERS_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)
PLAN_ID	NUMBER
ORGANIZATION_ID	NUMBER		Yes
SR_INSTANCE_ID	NUMBER		Yes
COMPILE_DESIGNATOR	VARCHAR2	(10)	Yes
LAST_UPDATE_DATE	DATE
LAST_UPDATED_BY	NUMBER
CREATION_DATE	DATE
CREATED_BY	NUMBER
LAST_UPDATE_LOGIN	NUMBER
CURR_OPERATION_SCHEDULE_TYPE	NUMBER
CURR_PLAN_TYPE	NUMBER
CURR_PLAN_TYPE_TEXT	VARCHAR2	(80)
CURR_OVERWRITE_OPTION	NUMBER
CURR_APPEND_PLANNED_ORDERS	NUMBER
CURR_CUTOFF_DATE	DATE
CURR_PART_INCLUDE_TYPE	NUMBER
CURR_PLANNING_TIME_FENCE_FLAG	NUMBER
CURR_DEMAND_TIME_FENCE_FLAG	NUMBER
CURR_CONSIDER_RESERVATIONS	NUMBER
CURR_PLAN_SAFETY_STOCK	NUMBER
CURR_CONSIDER_WIP	NUMBER
CURR_CONSIDER_PO	NUMBER
CURR_SNAPSHOT_LOCK	NUMBER
DESCRIPTION	VARCHAR2	(50)
DISABLE_DATE	DATE
CURR_ASSIGNMENT_SET_ID	NUMBER
CURR_SR_ASSIGNMENT_SET	VARCHAR2	(34)
CURR_SR_ASSIGN_SET_DESC	VARCHAR2	(80)
ORGANIZATION_SELECTION	NUMBER
ORGANIZATION_SELECTION_TEXT	VARCHAR2	(80)	Yes
OPERATION_SCHEDULE_TYPE	NUMBER
PLAN_TYPE	NUMBER
PLAN_TYPE_TEXT	VARCHAR2	(4000)
OVERWRITE_OPTION	NUMBER
APPEND_PLANNED_ORDERS	NUMBER
CUTOFF_DATE	DATE
PART_INCLUDE_TYPE	NUMBER
PLANNING_TIME_FENCE_FLAG	NUMBER
DEMAND_TIME_FENCE_FLAG	NUMBER
CONSIDER_RESERVATIONS	NUMBER
PLAN_SAFETY_STOCK	NUMBER
CONSIDER_WIP	NUMBER
CONSIDER_PO	NUMBER
SNAPSHOT_LOCK	NUMBER
ASSIGNMENT_SET_ID	NUMBER
SR_ASSIGNMENT_SET	VARCHAR2	(34)
SR_ASSIGN_SET_DESC	VARCHAR2	(80)
DATA_START_DATE	DATE
DATA_COMPLETION_DATE	DATE
PLAN_START_DATE	DATE
PLAN_COMPLETION_DATE	DATE
CURR_RESERVATION_LEVEL	NUMBER
CURR_HARD_PEGGING_LEVEL	NUMBER
RESERVATION_LEVEL	NUMBER
HARD_PEGGING_LEVEL	NUMBER
CURR_PLAN_CAPACITY_FLAG	NUMBER
CURR_SIMULATION_SET	VARCHAR2	(255)
CURR_BILL_OF_RESOURCES	VARCHAR2	(10)
PLAN_CAPACITY_FLAG	NUMBER
SIMULATION_SET	VARCHAR2	(10)
BILL_OF_RESOURCES	VARCHAR2	(10)
CURR_ENFORCE_DEM_DUE_DATES	NUMBER
ENFORCE_DEM_DUE_DATES	NUMBER
CURR_PLANNED_RESOURCES	NUMBER
PLANNED_RESOURCES	NUMBER
CURR_DEM_PRIORITY_RULE_ID	NUMBER
DEM_PRIORITY_RULE_ID	NUMBER
ENFORCE_CAP_CONSTRAINTS	NUMBER
CURR_ENFORCE_CAP_CONSTRAINTS	NUMBER
BOTTLENECK_RES_GROUP	VARCHAR2	(30)
CURR_BOTTLENECK_RES_GROUP	VARCHAR2	(255)
OBJECTIVE_WEIGHT_1	NUMBER
OBJECTIVE_WEIGHT_2	NUMBER
OBJECTIVE_WEIGHT_3	NUMBER
OBJECTIVE_WEIGHT_4	NUMBER
OBJECTIVE_WEIGHT_5	NUMBER
OPTIMIZE_FLAG	NUMBER
DMD_LATENESS_PENALTY_COST	NUMBER
SUPPLIER_CAP_OVER_UTIL_COST	NUMBER
TRANSPORT_CAP_OVER_UTIL_COST	NUMBER
RESOURCE_OVER_UTIL_COST	NUMBER
CURR_START_DATE	DATE
START_DATE	DATE
DAILY_ITEM_AGGREGATION_LEVEL	NUMBER
DAILY_MATERIAL_CONSTRAINTS	NUMBER
DAILY_RESOURCE_CONSTRAINTS	NUMBER
DAILY_RES_AGGREGATION_LEVEL	NUMBER
DAILY_TRANS_CONSTRAINTS	NUMBER
WEEKLY_ITEM_AGGREGATION_LEVEL	NUMBER
WEEKLY_MATERIAL_CONSTRAINTS	NUMBER
WEEKLY_RESOURCE_CONSTRAINTS	NUMBER
WEEKLY_RES_AGGREGATION_LEVEL	NUMBER
WEEKLY_TRANS_CONSTRAINTS	NUMBER
PERIOD_ITEM_AGGREGATION_LEVEL	NUMBER
PERIOD_MATERIAL_CONSTRAINTS	NUMBER
PERIOD_RESOURCE_CONSTRAINTS	NUMBER
PERIOD_RES_AGGREGATION_LEVEL	NUMBER
PERIOD_TRANS_CONSTRAINTS	NUMBER
DAILY_CUTOFF_BUCKET	NUMBER
HOUR_CUTOFF_BUCKET	NUMBER
MIN_CUTOFF_BUCKET	NUMBER
PERIOD_CUTOFF_BUCKET	NUMBER
QTRLY_CUTOFF_BUCKET	NUMBER
WEEKLY_CUTOFF_BUCKET	NUMBER
DAILY_RTG_AGGREGATION_LEVEL	NUMBER
WEEKLY_RTG_AGGREGATION_LEVEL	NUMBER
PERIOD_RTG_AGGREGATION_LEVEL	NUMBER
SCHEDULE_FLAG	NUMBER
LOT_FOR_LOT	NUMBER
FULL_PEGGING	NUMBER
CURR_FULL_PEGGING	NUMBER
CURR_DEM_PRIORITY_RULE	VARCHAR2	(4000)
SERVICE_LEVEL	NUMBER
CURR_ENFORCE_SL_CONSTRAINTS	NUMBER
ENFORCE_SL_CONSTRAINTS	NUMBER
DESIGNATOR_TYPE	NUMBER	(22)	Yes
DEMAND_CLASS	VARCHAR2	(34)
MOVE_JOBS_TO_PIP	NUMBER
ENABLE_CLOSEST_QTY_PEGGING	NUMBER
CURR_ENABLE_CLOSEST_QTY_PEG	NUMBER
ENABLE_PRIORITY_PEGGING	NUMBER
CURR_ENABLE_PRIORITY_PEGGING	NUMBER
BACKWARD_DAYS	NUMBER
CURR_BACKWARD_DAYS	NUMBER
FORWARD_DAYS	NUMBER
CURR_FORWARD_DAYS	NUMBER
CURR_ENFORCE_SRC_CONSTRAINTS	NUMBER
ENFORCE_SRC_CONSTRAINTS	NUMBER
USE_END_ITEM_SUBSTITUTIONS	NUMBER
USE_ALTERNATE_RESOURCES	NUMBER
USE_ALTERNATE_BOM_ROUTING	NUMBER
USE_SUBSTITUTE_COMPONENTS	NUMBER
USE_ALTERNATE_SOURCES	NUMBER
SUBSTITUTION_SET	VARCHAR2	(50)
DISPLAY_KPI	NUMBER
FORECAST_ALLOCATION_METHOD	NUMBER
FORECAST_CONSUMPTION_METHOD	NUMBER
EXPLODE_FORECAST	NUMBER
FD_ASSIGNMENT_SET_ID	NUMBER
FD_ASSIGNMENT_SET	VARCHAR2	(34)
FD_ASSIGNMENT_SET_DESC	VARCHAR2	(80)
ENFORCE_SUP_CAP_CONST	NUMBER
ENFORCE_PURCH_LT_CONST	NUMBER
TARGET_LOAD_UTIL	NUMBER
MIN_LOAD_UTIL	NUMBER
LOAD_SCHED_TF_DAYS	NUMBER
LOAD_SCHED_DAYS	NUMBER
DAILY_SUPPLY_ALLOC_BUCKET	VARCHAR2	(40)
WEEKS_PER_AGGR_BUCKET	VARCHAR2	(40)
CIRC_SOURCING_SURPLUS_DAYS	NUMBER
SUPPLY_SCHED_HORIZON_DAYS	NUMBER
INCLUDE_CRITICAL_COMPONENTS	NUMBER
SCHEDULE_BY	NUMBER
SAFETY_STK_CHANGE_INTERVAL	NUMBER
SAFETY_STK_THRESHOLD_PCT	NUMBER
ENFORCE_USER_SAFETY_STOCKS	NUMBER
ENFORCE_BUDGET_CONSTRAINTS	NUMBER
FORECAST_ASSIGNMENT_SET_ID	NUMBER
COPY_PLAN	NUMBER
BUDGET_ID	NUMBER
BUDGET_VALUE	NUMBER
SUPPLIER_ALLOC_METHOD	NUMBER
CUSTOMER_ALLOC_METHOD	NUMBER
DEFAULT_ALLOC_METHOD	NUMBER
USE_ORG_PRIORITY_OVERRIDE	VARCHAR2	(1)
SHIPMENT_CONSOLIDATION_DAYS	NUMBER
USE_FIXED_PERIOD_BKTS	VARCHAR2	(1)
ITF_HORIZ_DAYS	NUMBER
DEMAND_PRIORITY_RULE_SET	NUMBER
DEMAND_PRIORITY_RULE_SET_NAME	VARCHAR2	(4000)
ENABLE_SO_SPLIT	NUMBER
CALCULATE_SDS_DAYS_TIME	NUMBER			Sequence dependent setup day time - 1 Yes, 2 No
CALCULATE_SDS_WEEKS_TIME	NUMBER			Sequence dependent setup week time - 1 Yes, 2 No
CALCULATE_SDS_PERIODS_TIME	NUMBER			Sequence dependent setup periods time - 1 Yes, 2 No
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 (in Minutes)
CURR_INCLUDE_WO	NUMBER			Flag to include WO - 1 Production Order, 2 Maintenance Order
INCLUDE_WO	NUMBER			Days before sysdate
CURR_DS_HORIZON_DAYS	NUMBER
ENFORCE_PURCH_LEAD_TIME	NUMBER
USER_UPDATE_FIRM	NUMBER
DEMAND_PRIORITY_SENSITIVITY	NUMBER
EARLY_BUILD_PENALTY	NUMBER
AUTO_RELEASE_TIME_FENCE	NUMBER
CURR_SUBSET_DESIGNATOR_ID	NUMBER
SUBSET_DESIGNATOR_ID	NUMBER
CURR_INCLUDE_PLANNED_ORDER	NUMBER
INCLUDE_PLANNED_ORDER	NUMBER
CURR_SCHEDULE_SUBSET_TYPE	NUMBER
SCHEDULE_SUBSET_TYPE	NUMBER
ENFORCE_SUP_CAP_CONSTRAINTS	NUMBER
FROZEN_HORIZON_DAYS	NUMBER
CURR_RESPECT_MAX_ACCEPT_DAYS	NUMBER
CURR_MIN_SUPPLY_LEAD_TIME	NUMBER
PLAN_ORG_SIMULATION_SET	VARCHAR2	(10)
FIRM_OUTSIDE_SUBSET	NUMBER
DS_HORIZON_DAYS	NUMBER
SDS_DMD_PENALTY	NUMBER
CALCULATE_LIABILITY	NUMBER
CURR_ENF_FULFILLMENT_LT	NUMBER
DEMAND_FULFILLMENT_LT	NUMBER
ENFORCE_FULFILLMENT_LT	NUMBER
MFG_LT_VAR_PERCENT	NUMBER
SUP_LT_VAR_PERCENT	NUMBER
TRANSIT_LT_VAR_PERCENT	NUMBER
CURR_SERVICE_LEVEL_SET_ID	NUMBER
CURR_SERVICE_LEVEL_SET	VARCHAR2	(240)
CURR_SERVICE_LEVEL_SET_DESC	VARCHAR2	(240)
SR_SERVICE_LEVEL_SET_ID	NUMBER
SR_SERVICE_LEVEL_SET	VARCHAR2	(240)
SR_SERVICE_LEVEL_SET_DESC	VARCHAR2	(240)
ITEM_SIMULATION_SET_ID	NUMBER
ITEM_SIMULATION_SET	VARCHAR2	(240)
MODEL_HORIZON	NUMBER
DATA_HORIZON	NUMBER
HORIZON_UNITS	NUMBER
REF_PLAN_ID	NUMBER
DECIMAL_PRECISION	NUMBER
OFFLOAD_THRESHOLD	NUMBER
OFFLOAD_THRESHOLD_WINDOW	NUMBER
WORKDAY_TIME	NUMBER
WORKDAY_DAY	NUMBER
COST_TIME_UNIT	NUMBER
FIXED_PRODUCTION_FENCE	NUMBER
FIXED_PRODUCTION_UNITS	NUMBER
CRITICAL_COMPONENTS_FLAG	NUMBER
ALLOW_WO_OFFLOAD_FLAG	NUMBER
INCLUDE_PAST_DUE_SALESORDERS	NUMBER
DEMAND_FORECAST_FENCE	NUMBER
DEMAND_BUILD_STRATEGY	NUMBER
GLOBAL_BUILD_STRATEGY	NUMBER
SHIP_COMPLETE_FLAG	NUMBER
CREATE_ITEM_FOLDERS	NUMBER
CREATE_DEMAND_FOLDERS	NUMBER
CREATE_SUPPLY_FOLDERS	NUMBER
CREATE_WORKORDER_FOLDERS	NUMBER
USE_RMO_FLAG	NUMBER
MINIMUM_CYCLE_TIME	NUMBER
MINIMIZE_CHANGEOVER_FLAG	NUMBER
IDEAL_SEQUENCE_BASE	NUMBER
INVENTORY_COST_FACTOR	NUMBER
STOCKOUT_COST_FACTOR	NUMBER
CHANGEOVER_COST_FACTOR	NUMBER
SAFETY_COST_FACTOR	NUMBER
START_TIME	NUMBER
OFFSET_DAYS	NUMBER
PLANNED_BUCKET	NUMBER
PLANNED_BUCKET_TYPE	NUMBER
ASSIGNMENT_SET_OUT_ID	NUMBER
ASSIGNMENT_SET_OUT	VARCHAR2	(34)
CATEGORY_SET_ID	NUMBER
CATEGORY_SET_NAME	VARCHAR2	(30)
CATEGORY_SET_DESCRIPTION	VARCHAR2	(240)
PS_CATEGORY_SET_NAME	VARCHAR2	(30)
PS_CATEGORY_SET_DESCRIPTION	VARCHAR2	(240)
MANUAL_FCST_OVERWRITE_OPTION	NUMBER
ENFORCE_CONSTRAINTS	NUMBER
SAFETY_STOCK_VALUE_TYPE	NUMBER
REALLOC_SURPLUS_DAYS	NUMBER
PERFORM_FAIR_SHARE_ALLOC	NUMBER
INCLUDE_ALL_ITEMS	NUMBER
INCLUDE_ALL_CATEGORIES	NUMBER
AUTO_RELEASE_METHOD	NUMBER
INCLUDE_RESCHEDULES	NUMBER
CALENDAR_TYPE	NUMBER
HISTORY_RANGE	NUMBER
HISTORY_RANGE_UOM	NUMBER
FORECAST	NUMBER
FORECAST_UOM	NUMBER
FORECAST_BUCKET	NUMBER
FORECAST_BUCKET_UOM	NUMBER
HISTORY_RANGE_TYPE_TEXT	VARCHAR2	(4000)
FORECAST_TYPE_TEXT	VARCHAR2	(4000)
FORECAST_BUCKET_TYPE_TEXT	VARCHAR2	(4000)
USE_UNITS_OF_EFFORT	NUMBER
USE_ADJACENT_OPERATIONS	NUMBER
SOP_ENABLED	NUMBER
CIRCULAR_SRC	NUMBER
PURCHASE_LEAD_TIME_OFFSET	NUMBER
ENABLE_SAFETY_COVER	NUMBER
CONSTRAINED_MODE	NUMBER
RELEASE_FLAG	NUMBER
FIRST_CYCLE_START_DATE	DATE
ENFORCE_CRO_CYCLE	NUMBER
REM_CRO_RESI_PRODN	NUMBER
INCLUDE_CMRO_WORKORDERS	NUMBER			Flag to indicate inclusion of CMRO workorders in a PS plan
DERIVE_RETURN_FCST_FROM_WO	NUMBER
INCLUDE_EAM_WORKORDERS	NUMBER
INCLUDE_DEMANDS	NUMBER
INCLUDE_SUPPLIES	NUMBER
CONSIDER_EAM_SCHEDULE	NUMBER
INC_SCENARIO_FILE	NUMBER
SUPPLY_TOL_OFFSET	NUMBER
ACTIVE_ITEM_FILTER	NUMBER
EXCEP_GROUP_NAME	VARCHAR2	(80)
EXCEP_GROUP_ID	NUMBER
ENFORCE_HORIZON_START	NUMBER
IMP_CLOSED_VISIT_WO	NUMBER
DAILY_MWO_AGGR_LVL	NUMBER
WEEKLY_MWO_AGGR_LVL	NUMBER
PERIOD_MWO_AGGR_LVL	NUMBER
ENFORCE_WRH_CPTY	NUMBER			Enforce Warehouse Capacity
PUB_CAP_TO_CMRO	NUMBER
ENABLE_SAFETY_STOCK_RES	NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ROW_ID
,      PLAN_ID
,      ORGANIZATION_ID
,      SR_INSTANCE_ID
,      COMPILE_DESIGNATOR
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      CURR_OPERATION_SCHEDULE_TYPE
,      CURR_PLAN_TYPE
,      CURR_PLAN_TYPE_TEXT
,      CURR_OVERWRITE_OPTION
,      CURR_APPEND_PLANNED_ORDERS
,      CURR_CUTOFF_DATE
,      CURR_PART_INCLUDE_TYPE
,      CURR_PLANNING_TIME_FENCE_FLAG
,      CURR_DEMAND_TIME_FENCE_FLAG
,      CURR_CONSIDER_RESERVATIONS
,      CURR_PLAN_SAFETY_STOCK
,      CURR_CONSIDER_WIP
,      CURR_CONSIDER_PO
,      CURR_SNAPSHOT_LOCK
,      DESCRIPTION
,      DISABLE_DATE
,      CURR_ASSIGNMENT_SET_ID
,      CURR_SR_ASSIGNMENT_SET
,      CURR_SR_ASSIGN_SET_DESC
,      ORGANIZATION_SELECTION
,      ORGANIZATION_SELECTION_TEXT
,      OPERATION_SCHEDULE_TYPE
,      PLAN_TYPE
,      PLAN_TYPE_TEXT
,      OVERWRITE_OPTION
,      APPEND_PLANNED_ORDERS
,      CUTOFF_DATE
,      PART_INCLUDE_TYPE
,      PLANNING_TIME_FENCE_FLAG
,      DEMAND_TIME_FENCE_FLAG
,      CONSIDER_RESERVATIONS
,      PLAN_SAFETY_STOCK
,      CONSIDER_WIP
,      CONSIDER_PO
,      SNAPSHOT_LOCK
,      ASSIGNMENT_SET_ID
,      SR_ASSIGNMENT_SET
,      SR_ASSIGN_SET_DESC
,      DATA_START_DATE
,      DATA_COMPLETION_DATE
,      PLAN_START_DATE
,      PLAN_COMPLETION_DATE
,      CURR_RESERVATION_LEVEL
,      CURR_HARD_PEGGING_LEVEL
,      RESERVATION_LEVEL
,      HARD_PEGGING_LEVEL
,      CURR_PLAN_CAPACITY_FLAG
,      CURR_SIMULATION_SET
,      CURR_BILL_OF_RESOURCES
,      PLAN_CAPACITY_FLAG
,      SIMULATION_SET
,      BILL_OF_RESOURCES
,      CURR_ENFORCE_DEM_DUE_DATES
,      ENFORCE_DEM_DUE_DATES
,      CURR_PLANNED_RESOURCES
,      PLANNED_RESOURCES
,      CURR_DEM_PRIORITY_RULE_ID
,      DEM_PRIORITY_RULE_ID
,      ENFORCE_CAP_CONSTRAINTS
,      CURR_ENFORCE_CAP_CONSTRAINTS
,      BOTTLENECK_RES_GROUP
,      CURR_BOTTLENECK_RES_GROUP
,      OBJECTIVE_WEIGHT_1
,      OBJECTIVE_WEIGHT_2
,      OBJECTIVE_WEIGHT_3
,      OBJECTIVE_WEIGHT_4
,      OBJECTIVE_WEIGHT_5
,      OPTIMIZE_FLAG
,      DMD_LATENESS_PENALTY_COST
,      SUPPLIER_CAP_OVER_UTIL_COST
,      TRANSPORT_CAP_OVER_UTIL_COST
,      RESOURCE_OVER_UTIL_COST
,      CURR_START_DATE
,      START_DATE
,      DAILY_ITEM_AGGREGATION_LEVEL
,      DAILY_MATERIAL_CONSTRAINTS
,      DAILY_RESOURCE_CONSTRAINTS
,      DAILY_RES_AGGREGATION_LEVEL
,      DAILY_TRANS_CONSTRAINTS
,      WEEKLY_ITEM_AGGREGATION_LEVEL
,      WEEKLY_MATERIAL_CONSTRAINTS
,      WEEKLY_RESOURCE_CONSTRAINTS
,      WEEKLY_RES_AGGREGATION_LEVEL
,      WEEKLY_TRANS_CONSTRAINTS
,      PERIOD_ITEM_AGGREGATION_LEVEL
,      PERIOD_MATERIAL_CONSTRAINTS
,      PERIOD_RESOURCE_CONSTRAINTS
,      PERIOD_RES_AGGREGATION_LEVEL
,      PERIOD_TRANS_CONSTRAINTS
,      DAILY_CUTOFF_BUCKET
,      HOUR_CUTOFF_BUCKET
,      MIN_CUTOFF_BUCKET
,      PERIOD_CUTOFF_BUCKET
,      QTRLY_CUTOFF_BUCKET
,      WEEKLY_CUTOFF_BUCKET
,      DAILY_RTG_AGGREGATION_LEVEL
,      WEEKLY_RTG_AGGREGATION_LEVEL
,      PERIOD_RTG_AGGREGATION_LEVEL
,      SCHEDULE_FLAG
,      LOT_FOR_LOT
,      FULL_PEGGING
,      CURR_FULL_PEGGING
,      CURR_DEM_PRIORITY_RULE
,      SERVICE_LEVEL
,      CURR_ENFORCE_SL_CONSTRAINTS
,      ENFORCE_SL_CONSTRAINTS
,      DESIGNATOR_TYPE
,      DEMAND_CLASS
,      MOVE_JOBS_TO_PIP
,      ENABLE_CLOSEST_QTY_PEGGING
,      CURR_ENABLE_CLOSEST_QTY_PEG
,      ENABLE_PRIORITY_PEGGING
,      CURR_ENABLE_PRIORITY_PEGGING
,      BACKWARD_DAYS
,      CURR_BACKWARD_DAYS
,      FORWARD_DAYS
,      CURR_FORWARD_DAYS
,      CURR_ENFORCE_SRC_CONSTRAINTS
,      ENFORCE_SRC_CONSTRAINTS
,      USE_END_ITEM_SUBSTITUTIONS
,      USE_ALTERNATE_RESOURCES
,      USE_ALTERNATE_BOM_ROUTING
,      USE_SUBSTITUTE_COMPONENTS
,      USE_ALTERNATE_SOURCES
,      SUBSTITUTION_SET
,      DISPLAY_KPI
,      FORECAST_ALLOCATION_METHOD
,      FORECAST_CONSUMPTION_METHOD
,      EXPLODE_FORECAST
,      FD_ASSIGNMENT_SET_ID
,      FD_ASSIGNMENT_SET
,      FD_ASSIGNMENT_SET_DESC
,      ENFORCE_SUP_CAP_CONST
,      ENFORCE_PURCH_LT_CONST
,      TARGET_LOAD_UTIL
,      MIN_LOAD_UTIL
,      LOAD_SCHED_TF_DAYS
,      LOAD_SCHED_DAYS
,      DAILY_SUPPLY_ALLOC_BUCKET
,      WEEKS_PER_AGGR_BUCKET
,      CIRC_SOURCING_SURPLUS_DAYS
,      SUPPLY_SCHED_HORIZON_DAYS
,      INCLUDE_CRITICAL_COMPONENTS
,      SCHEDULE_BY
,      SAFETY_STK_CHANGE_INTERVAL
,      SAFETY_STK_THRESHOLD_PCT
,      ENFORCE_USER_SAFETY_STOCKS
,      ENFORCE_BUDGET_CONSTRAINTS
,      FORECAST_ASSIGNMENT_SET_ID
,      COPY_PLAN
,      BUDGET_ID
,      BUDGET_VALUE
,      SUPPLIER_ALLOC_METHOD
,      CUSTOMER_ALLOC_METHOD
,      DEFAULT_ALLOC_METHOD
,      USE_ORG_PRIORITY_OVERRIDE
,      SHIPMENT_CONSOLIDATION_DAYS
,      USE_FIXED_PERIOD_BKTS
,      ITF_HORIZ_DAYS
,      DEMAND_PRIORITY_RULE_SET
,      DEMAND_PRIORITY_RULE_SET_NAME
,      ENABLE_SO_SPLIT
,      CALCULATE_SDS_DAYS_TIME
,      CALCULATE_SDS_WEEKS_TIME
,      CALCULATE_SDS_PERIODS_TIME
,      DS_SUBSET_HORIZON_DAYS
,      SCHEDULE_DAYS_BEFORE
,      SCHEDULE_START_TIME
,      CURR_INCLUDE_WO
,      INCLUDE_WO
,      CURR_DS_HORIZON_DAYS
,      ENFORCE_PURCH_LEAD_TIME
,      USER_UPDATE_FIRM
,      DEMAND_PRIORITY_SENSITIVITY
,      EARLY_BUILD_PENALTY
,      AUTO_RELEASE_TIME_FENCE
,      CURR_SUBSET_DESIGNATOR_ID
,      SUBSET_DESIGNATOR_ID
,      CURR_INCLUDE_PLANNED_ORDER
,      INCLUDE_PLANNED_ORDER
,      CURR_SCHEDULE_SUBSET_TYPE
,      SCHEDULE_SUBSET_TYPE
,      ENFORCE_SUP_CAP_CONSTRAINTS
,      FROZEN_HORIZON_DAYS
,      CURR_RESPECT_MAX_ACCEPT_DAYS
,      CURR_MIN_SUPPLY_LEAD_TIME
,      PLAN_ORG_SIMULATION_SET
,      FIRM_OUTSIDE_SUBSET
,      DS_HORIZON_DAYS
,      SDS_DMD_PENALTY
,      CALCULATE_LIABILITY
,      CURR_ENF_FULFILLMENT_LT
,      DEMAND_FULFILLMENT_LT
,      ENFORCE_FULFILLMENT_LT
,      MFG_LT_VAR_PERCENT
,      SUP_LT_VAR_PERCENT
,      TRANSIT_LT_VAR_PERCENT
,      CURR_SERVICE_LEVEL_SET_ID
,      CURR_SERVICE_LEVEL_SET
,      CURR_SERVICE_LEVEL_SET_DESC
,      SR_SERVICE_LEVEL_SET_ID
,      SR_SERVICE_LEVEL_SET
,      SR_SERVICE_LEVEL_SET_DESC
,      ITEM_SIMULATION_SET_ID
,      ITEM_SIMULATION_SET
,      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_FORECAST_FENCE
,      DEMAND_BUILD_STRATEGY
,      GLOBAL_BUILD_STRATEGY
,      SHIP_COMPLETE_FLAG
,      CREATE_ITEM_FOLDERS
,      CREATE_DEMAND_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
,      PLANNED_BUCKET
,      PLANNED_BUCKET_TYPE
,      ASSIGNMENT_SET_OUT_ID
,      ASSIGNMENT_SET_OUT
,      CATEGORY_SET_ID
,      CATEGORY_SET_NAME
,      CATEGORY_SET_DESCRIPTION
,      PS_CATEGORY_SET_NAME
,      PS_CATEGORY_SET_DESCRIPTION
,      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
,      HISTORY_RANGE_TYPE_TEXT
,      FORECAST_TYPE_TEXT
,      FORECAST_BUCKET_TYPE_TEXT
,      USE_UNITS_OF_EFFORT
,      USE_ADJACENT_OPERATIONS
,      SOP_ENABLED
,      CIRCULAR_SRC
,      PURCHASE_LEAD_TIME_OFFSET
,      ENABLE_SAFETY_COVER
,      CONSTRAINED_MODE
,      RELEASE_FLAG
,      FIRST_CYCLE_START_DATE
,      ENFORCE_CRO_CYCLE
,      REM_CRO_RESI_PRODN
,      INCLUDE_CMRO_WORKORDERS
,      DERIVE_RETURN_FCST_FROM_WO
,      INCLUDE_EAM_WORKORDERS
,      INCLUDE_DEMANDS
,      INCLUDE_SUPPLIES
,      CONSIDER_EAM_SCHEDULE
,      INC_SCENARIO_FILE
,      SUPPLY_TOL_OFFSET
,      ACTIVE_ITEM_FILTER
,      EXCEP_GROUP_NAME
,      EXCEP_GROUP_ID
,      ENFORCE_HORIZON_START
,      IMP_CLOSED_VISIT_WO
,      DAILY_MWO_AGGR_LVL
,      WEEKLY_MWO_AGGR_LVL
,      PERIOD_MWO_AGGR_LVL
,      ENFORCE_WRH_CPTY
,      PUB_CAP_TO_CMRO
,      ENABLE_SAFETY_STOCK_RES
FROM APPS.MSC_PLAN_PARAMETERS_V;

Dependencies

[top of page]

APPS.MSC_PLAN_PARAMETERS_V references the following:

APPS: MFG_LOOKUPS; MSC_ASSIGNMENT_SETS; MSC_CATEGORY_SETS; MSC_DESIGNATORS; MSC_EXCEPTION_GROUPS; MSC_GET_NAME - show dependent code; MSC_ITEM_SIMULATION_SETS; MSC_PARAMETERS; MSC_PLANS; MSC_PLANS_OTHER; MSC_PLAN_ORGANIZATIONS; MSC_SCHEDULING_RULES; MSC_SERVICE_LEVEL_SETS

APPS.MSC_PLAN_PARAMETERS_V is referenced by following:

APPS: MSC_PDR_PLAN_DETAILS_V1