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: ViewMSC.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

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
FROM APPS.MSC_PLAN_PARAMETERS_V;

Dependencies

[top of page]

APPS.MSC_PLAN_PARAMETERS_V references the following:

SchemaAPPS
ViewMFG_LOOKUPS
SynonymMSC_ASSIGNMENT_SETS
SynonymMSC_CATEGORY_SETS
SynonymMSC_DESIGNATORS
PL/SQL PackageMSC_GET_NAME - show dependent code
SynonymMSC_ITEM_SIMULATION_SETS
SynonymMSC_PARAMETERS
SynonymMSC_PLANS
SynonymMSC_PLANS_OTHER
SynonymMSC_PLAN_ORGANIZATIONS
SynonymMSC_SCHEDULING_RULES
SynonymMSC_SERVICE_LEVEL_SETS
APPS.MSC_PLAN_PARAMETERS_V is referenced by following:

SchemaAPPS
ViewMSC_PDR_PLAN_DETAILS_V1