[Home] [Help] [Dependency Information]
Object Name: | MSC_PLAN_PARAMETERS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | MSC.MSC_PLAN_PARAMETERS_V |
Subobject Name: | |
Status: | VALID |
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.
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 |
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;
|
|
|