VIEW: APPS.MSC_PLAN_PARAMETERS_V

Source

View Text - Preformatted

SELECT DISTINCT M.ROWID , M.PLAN_ID , D.ORGANIZATION_ID , D.SR_INSTANCE_ID , D.DESIGNATOR , NVL(M.LAST_UPDATE_DATE, SYSDATE) , NVL(M.LAST_UPDATED_BY, D.LAST_UPDATED_BY) , NVL(M.CREATION_DATE, SYSDATE) , NVL(M.CREATED_BY, D.CREATED_BY) , M.LAST_UPDATE_LOGIN , decode(d.DESIGNATOR_TYPE, 5, NVL(M.CURR_OPERATION_SCHEDULE_TYPE, 2), nvl(NVL(M.CURR_OPERATION_SCHEDULE_TYPE, P.OPERATION_SCHEDULE_TYPE),1)) , DECODE(D.DESIGNATOR_TYPE, 2, 2, 3, 1,5,4,4,3,8,5,9,6,10,7,11,8, 1) , DECODE(D.DESIGNATOR_TYPE, -99, ' ', L1.MEANING) , NVL(M.CURR_OVERWRITE_OPTION, 1) , NVL(M.CURR_APPEND_PLANNED_ORDERS, DECODE(M.CURR_OVERWRITE_OPTION, 3, 2, 1)) , NVL(M.CURR_CUTOFF_DATE, SYSDATE+NVL(M.DAILY_CUTOFF_BUCKET,30) +NVL(M.WEEKLY_CUTOFF_BUCKET,4)*7 +NVL(M.PERIOD_CUTOFF_BUCKET,5)*30) , decode(D.designator_type, 5,nvl(M.CURR_PART_INCLUDE_TYPE, msc_get_name.abc_class_id(d.organization_id,d.sr_instance_id)), nvl(NVL(M.CURR_PART_INCLUDE_TYPE,P.PART_INCLUDE_TYPE),2)) , NVL(M.CURR_PLANNING_TIME_FENCE_FLAG, P.PLANNING_TIME_FENCE_FLAG) , NVL(M.CURR_DEMAND_TIME_FENCE_FLAG, P.DEMAND_TIME_FENCE_FLAG) , NVL(M.CURR_CONSIDER_RESERVATIONS, P.CONSIDER_RESERVATIONS) , NVL(M.CURR_PLAN_SAFETY_STOCK, P.PLAN_SAFETY_STOCK) , NVL(M.CURR_CONSIDER_WIP, P.CONSIDER_WIP) , NVL(M.CURR_CONSIDER_PO, P.CONSIDER_PO) , NVL(M.CURR_SNAPSHOT_LOCK, P.SNAPSHOT_LOCK) , D.DESCRIPTION , D.DISABLE_DATE , M.CURR_ASSIGNMENT_SET_ID , MAS.ASSIGNMENT_SET_NAME , MAS.DESCRIPTION , NVL(D.ORGANIZATION_SELECTION, 3) , L3.MEANING , M.OPERATION_SCHEDULE_TYPE , M.PLAN_TYPE , MSC_GET_NAME.LOOKUP_MEANING('MRP_PLAN_TYPE',M.PLAN_TYPE) , M.OVERWRITE_OPTION , M.APPEND_PLANNED_ORDERS , M.CUTOFF_DATE , M.PART_INCLUDE_TYPE , M.PLANNING_TIME_FENCE_FLAG , M.DEMAND_TIME_FENCE_FLAG , M.CONSIDER_RESERVATIONS , M.PLAN_SAFETY_STOCK , M.CONSIDER_WIP , M.CONSIDER_PO , M.SNAPSHOT_LOCK , M.ASSIGNMENT_SET_ID , MAS1.ASSIGNMENT_SET_NAME , MAS1.DESCRIPTION , M.DATA_START_DATE , M.DATA_COMPLETION_DATE , M.PLAN_START_DATE , M.PLAN_COMPLETION_DATE , NVL(M.CURR_RESERVATION_LEVEL, 4) , NVL(M.CURR_HARD_PEGGING_LEVEL, 3) , NVL(M.RESERVATION_LEVEL, 3) , NVL(M.HARD_PEGGING_LEVEL, 3) , NVL(M.CURR_PLAN_CAPACITY_FLAG, 1) , DECODE(M.CURR_PLAN_TYPE, 7, MPLO.SIMULATION_SET, M.CURR_SIMULATION_SET) , M.CURR_BILL_OF_RESOURCES , M.PLAN_CAPACITY_FLAG , M.SIMULATION_SET , M.BILL_OF_RESOURCES , nvl(M.CURR_ENFORCE_DEM_DUE_DATES,decode(d.designator_type,5,2,1)) , M.ENFORCE_DEM_DUE_DATES , nvl(M.CURR_PLANNED_RESOURCES,1) , M.PLANNED_RESOURCES , DECODE(M.CURR_DEM_PRIORITY_RULE_ID, null ,msc_get_name.get_default_dem_pri_rule_id, M.CURR_DEM_PRIORITY_RULE_ID) , DECODE(M.DEM_PRIORITY_RULE_ID, null ,msc_get_name.get_default_dem_pri_rule_id, M.DEM_PRIORITY_RULE_ID) , M.ENFORCE_CAP_CONSTRAINTS , nvl(M.CURR_ENFORCE_CAP_CONSTRAINTS,2) , M.BOTTLENECK_RES_GROUP , decode(M.curr_plan_type , 7 , MPLO.BOTTLENECK_RESOURCE_GROUP , M.CURR_BOTTLENECK_RES_GROUP) , M.OBJECTIVE_WEIGHT_1 , M.OBJECTIVE_WEIGHT_2 , M.OBJECTIVE_WEIGHT_3 , M.OBJECTIVE_WEIGHT_4 , M.OBJECTIVE_WEIGHT_5 , nvl(M.OPTIMIZE_FLAG, decode(d.designator_type,5,1,2)) , DECODE(M.DMD_LATENESS_PENALTY_COST , NULL, DECODE(D.DESIGNATOR_TYPE , 9, 0, 10, 0, NULL), M.DMD_LATENESS_PENALTY_COST) , M.SUPPLIER_CAP_OVER_UTIL_COST , M.TRANSPORT_CAP_OVER_UTIL_COST , M.RESOURCE_OVER_UTIL_COST , nvl(M.CURR_START_DATE, sysdate) , M.START_DATE , nvl(M.DAILY_ITEM_AGGREGATION_LEVEL,1) , nvl(M.DAILY_MATERIAL_CONSTRAINTS,2) , nvl(M.DAILY_RESOURCE_CONSTRAINTS,2) , nvl(M.DAILY_RES_AGGREGATION_LEVEL,1) , M.DAILY_TRANS_CONSTRAINTS , nvl(M.WEEKLY_ITEM_AGGREGATION_LEVEL,1) , nvl(M.WEEKLY_MATERIAL_CONSTRAINTS,2) , nvl(M.WEEKLY_RESOURCE_CONSTRAINTS,2) , nvl(M.WEEKLY_RES_AGGREGATION_LEVEL,1) , M.WEEKLY_TRANS_CONSTRAINTS , nvl(M.PERIOD_ITEM_AGGREGATION_LEVEL,1) , nvl(M.PERIOD_MATERIAL_CONSTRAINTS,2) , nvl(M.PERIOD_RESOURCE_CONSTRAINTS,2) , nvl(M.PERIOD_RES_AGGREGATION_LEVEL,1) , M.PERIOD_TRANS_CONSTRAINTS , nvl(M.DAILY_CUTOFF_BUCKET,30) , nvl(M.HOUR_CUTOFF_BUCKET,0) , nvl(M.MIN_CUTOFF_BUCKET,0) , nvl(M.PERIOD_CUTOFF_BUCKET,5) , M.QTRLY_CUTOFF_BUCKET , nvl(M.WEEKLY_CUTOFF_BUCKET,4) , nvl(M.DAILY_RTG_AGGREGATION_LEVEL, decode(d.designator_type,2,2,1)) , nvl(M.WEEKLY_RTG_AGGREGATION_LEVEL, decode(d.designator_type,2,2,1)) , nvl(M.PERIOD_RTG_AGGREGATION_LEVEL, decode(d.designator_type,2,2,1)) , M.SCHEDULE_FLAg , M.LOT_FOR_LOT_FLAG ,M.FULL_PEGGING ,M.CURR_FULL_PEGGING ,DECODE(MSR.MEANING, null, msc_get_name.get_default_dem_pri_rule, MSR.MEANING) ,M.SERVICE_LEVEL ,nvl(M.CURR_ENFORCE_SL_CONSTRAINTS,decode(d.designator_type,5,1,2)) ,M.ENFORCE_SL_CONSTRAINTS ,D.DESIGNATOR_TYPE ,D.DEMAND_CLASS ,M.plan_inventory_point ,M.enable_closest_qty_pegging ,M.curr_closest_qty_peg ,M.enable_priority_pegging ,DECODE(M.curr_priority_pegging , NULL, DECODE(D.DESIGNATOR_TYPE , 9, 1, 10, 1, NULL), M.curr_priority_pegging) ,M.backward_days ,M.curr_backward_days ,M.forward_days ,M.curr_forward_days ,nvl(M.curr_enforce_src_constraints, decode(d.designator_type,5,2,1)) ,M.enforce_src_constraints ,nvl(M.use_end_item_substitutions,2) ,nvl(M.use_alternate_resources,1) ,nvl(M.use_alternate_bom_routing,1) ,nvl(M.use_substitute_components,1) ,nvl(M.use_alternate_sources,1) ,M.substitution_designator ,M.display_kpi ,decode(d.designator_type, 5, nvl(M.FORECAST_ALLOCATION_METHOD,2), M.FORECAST_ALLOCATION_METHOD) ,M.FORECAST_CONSUMPTION_METHOD, nvl(m.explode_forecast,2), M.forecast_assignment_set_id, MAS2.ASSIGNMENT_SET_NAME, MAS2.DESCRIPTION, nvl(M.ENFORCE_SUP_CAP_CONSTRAINTS, 2) , nvl(M.ENFORCE_PUR_LT_CONSTRAINTS,2), M.TGT_TL_UTIL_PCT, M.MIN_TL_UTIL_PCT, nvl(M.LOAD_SCHED_TIME_FENCE_DAYS,0), nvl(M.LOAD_SCHEDULING_DAYS,0) , decode(M.USE_FIXED_PERIOD_BKTS, 1, null, nvl(M.DAILY_ALLOC_BUCKETS,0)), decode(M.USE_FIXED_PERIOD_BKTS, 1, null, decode(M.plan_id , null ,1 ,M.WKS_PER_WKLY_ALLOC_BUCKET)), nvl(M.CIRC_SRCING_SURPLUS_DAYS,0), nvl(M.SUPPLY_SCHED_ITF,0), DECODE(M.INCLUDE_CRITICAL_COMPONENTS , NULL , DECODE(D.DESIGNATOR_TYPE , 9, 1, 10, 1, 2), M.INCLUDE_CRITICAL_COMPONENTS), NVL(M.schedule_by,1), M.SAFETY_STK_CHANGE_INTERVAL, M.SAFETY_STK_THRESHOLD_PCT, NVL(M.ENFORCE_USER_SAFETY_STOCKS,2), NVL(M.ENFORCE_BUDGET_CONSTRAINTS,2), M.FORECAST_ASSIGNMENT_SET_ID, NVL(M.COPY_PLAN,2), M.BUDGET_ID, M.BUDGET_VALUE, nvl(M.SUPPLIER_ALLOC_METHOD,0), NVL(M.CUSTOMER_ALLOC_METHOD, 0), NVL(m.DEFAULT_ALLOC_METHOD,0), NVL(M.USE_ORG_PRIORITY_OVERRIDE,2), NVL(m.SHIPMENT_CONSOLIDATION_DAYS,0), NVL(M.USE_FIXED_PERIOD_BKTS,2), NVL(m.ITF_HORIZ_DAYS,0), M.dmd_pri_rule_set_id, MSC_GET_NAME.DRP_PRI_RULE_NAME(M.DMD_PRI_RULE_SET_ID), NVL(M.ENABLE_SO_SPLIT,2) ,NVL(CALCULATE_SDS_DAYS_TIME ,2) ,NVL(CALCULATE_SDS_WEEKS_TIME , 2) ,NVL(CALCULATE_SDS_PERIODS_TIME , 2) ,M.DS_SUBSET_HORIZON_DAYS ,M.SCHEDULE_DAYS_BEFORE ,M.SCHEDULE_START_TIME ,DECODE(M.CURR_INCLUDE_WO , NULL , DECODE(D.DESIGNATOR_TYPE , 9, 2, 10, 1, 2) , M.CURR_INCLUDE_WO) ,M.INCLUDE_WO ,nvl(M.CURR_DS_HORIZON_DAYS,1) ,DECODE(M.ENFORCE_PURCH_LEAD_TIME , NULL , DECODE(D.DESIGNATOR_TYPE , 9, 1, 10, 1, 2), M.ENFORCE_PURCH_LEAD_TIME) ,M.USER_UPDATE_FIRM ,NVL(M.DEMAND_PRIORITY_SENSITIVITY ,1) ,NVL(M.EARLY_BUILD_PENALTY ,0) ,M.AUTO_RELEASE_TIME_FENCE ,M.CURR_SUBSET_DESIGNATOR_ID ,M.SUBSET_DESIGNATOR_ID ,NVL(M.CURR_INCLUDE_PLANNED_ORDER,2) ,M.INCLUDE_PLANNED_ORDER ,NVL(M.CURR_SCHEDULE_SUBSET_TYPE,1) ,NVL(M.SCHEDULE_SUBSET_TYPE,1) ,M.ENFORCE_SUP_CAP_CONSTRAINTS ,MPO.FROZEN_HORIZON_DAYS ,NVL(MPO.CURR_RESPECT_MAX_ACCEPT_DAYS ,2) ,NVL(MPO.CURR_MIN_SUPPLY_LEAD_TIME ,1) ,MPO.SIMULATION_SET ,NVL(M.FIRM_OUTSIDE_SUBSET,2) ,M.DS_HORIZON_DAYS ,nvl(M.SDS_DMD_PENALTY ,0) ,nvl(M.CALCULATE_LIABILITY ,2) ,nvl(M.CURR_ENF_FULFILLMENT_LT,2) ,M.DEMAND_FULFILLMENT_LT ,nvl(M.ENFORCE_FULFILLMENT_LT,2) ,M.MFG_LT_VAR_PERCENT ,M.SUP_LT_VAR_PERCENT ,M.TRANSIT_LT_VAR_PERCENT ,m.curr_service_level_set_id ,MSLS.SERVICE_LEVEL_SET_NAME ,MSLS.DESCRIPTION ,m.service_level_set_id ,MSLS1.SERVICE_LEVEL_SET_NAME ,MSLS1.DESCRIPTION ,M.ITEM_SIMULATION_SET_ID ,MISS.SIMULATION_SET_NAME ITEM_SIMULATION_SET ,nvl(MPLO.MODEL_HORIZON,30) , nvl(MPLO.DATA_HORIZON,30) , nvl(MPLO.HORIZON_UNITS,1) , MPLO.REF_PLAN_ID , nvl(MPLO.DECIMAL_PRECISION,2) , nvl(MPLO.OFFLOAD_THRESHOLD, 75) , nvl(MPLO.OFFLOAD_THRESHOLD_WINDOW,7) , nvl(MPLO.WORKDAY_TIME ,480) , nvl(MPLO.WORKDAY_DAY,1) , nvl(MPLO.COST_TIME_UNIT,4) , nvl(MPLO.FIXED_PRODUCTION_FENCE,0) , nvl(MPLO.FIXED_PRODUCTION_UNITS,2) , nvl(MPLO.CRITICAL_COMPONENTS_FLAG,1) , nvl(MPLO.ALLOW_WO_OFFLOAD_FLAG,2) , nvl(MPLO.INCLUDE_PAST_DUE_SALESORDERS,0) , nvl(MPLO.DEMAND_FORECAST_FENCE, 0), nvl(MPLO.DEMAND_BUILD_STRATEGY,1) , nvl(MPLO.GLOBAL_BUILD_STRATEGY,1) , nvl(MPLO.SHIP_COMPLETE_FLAG,2) , nvl(MPLO.CREATE_ITEM_FOLDERS,1) , decode(MPLO.PLAN_ID, NULL, nvl(MPLO.CREATE_DEMAND_FOLDERS,1) , MPLO.CREATE_DEMAND_FOLDERS) , DECODE(MPLO. PLAN_ID, NULL, nvl(MPLO.CREATE_SUPPLY_FOLDERS,2), MPLO.CREATE_SUPPLY_FOLDERS) , DECODE(MPLO.PLAN_ID ,NULL,nvl(MPLO.CREATE_WORKORDER_FOLDERS,1) ,MPLO.CREATE_WORKORDER_FOLDERS) , nvl(MPLO.USE_RMO_FLAG,1) , nvl(MPLO.MINIMUM_CYCLE_TIME,2) , nvl(MPLO.MINIMIZE_CHANGEOVER_FLAG,1) , nvl(MPLO.IDEAL_SEQUENCE_BASE,1) , nvl(MPLO.INVENTORY_COST_FACTOR,1) , nvl(MPLO.STOCKOUT_COST_FACTOR,1) , nvl(MPLO.CHANGEOVER_COST_FACTOR,1) , nvl(MPLO.SAFETY_COST_FACTOR,1) , nvl(MPLO.START_TIME,0) , nvl(MPLO.OFFSET_DAYS ,0) , nvl(M.PLANNED_BUCKET, 52) , nvl(M.PLANNED_BUCKET_TYPE, 2) , M.ASSIGNMENT_SET_OUT_ID , MAS3.ASSIGNMENT_SET_NAME , M.CATEGORY_SET_ID , MCS.CATEGORY_SET_NAME , MCS.DESCRIPTION , MCS1.CATEGORY_SET_NAME , MCS1.DESCRIPTION, m.manual_fcst_overwrite_option, m.enforce_constraints, m.safety_stock_value_type, m.realloc_surplus_days, m.perform_fair_share_alloc, m.include_all_items, m.include_all_categories, m.auto_release_method, m.include_reschedules, m.calendar_type, m.history_range, m.history_range_uom, m.forecast, m.forecast_uom, m.forecast_bucket, m.forecast_bucket_uom, decode(m.calendar_type, 1, msc_get_name.lookup_meaning('MRP_BUCKET_TYPE', m.history_range_uom), 2, msc_get_name.lookup_meaning('MRP_GREGORIAN_BUCKET_TYPE', m.history_range_uom), null) history_range_type_text, decode(m.calendar_type, 1, msc_get_name.lookup_meaning('MRP_BUCKET_TYPE', m.forecast_uom), 2, msc_get_name.lookup_meaning('MRP_GREGORIAN_BUCKET_TYPE', m.forecast_uom), null) forecast_type_text, decode(m.calendar_type, 1, msc_get_name.lookup_meaning('MRP_BUCKET_TYPE', m.forecast_bucket_uom), 2, msc_get_name.lookup_meaning('MRP_GREGORIAN_BUCKET_TYPE', m.forecast_bucket_uom), null) forecast_bucket_type_text, nvl(MPLO.USE_UNITS_OF_EFFORT,3) , nvl(MPLO.USE_ADJACENT_OPERATIONS,2), nvl(M.SOP_ENABLED,2), nvl(M.CIRCULAR_SRC,1), nvl(MPLO.PURCHASE_LEAD_TIME_OFFSET,0), nvl(MPLO.ENABLE_SAFETY_COVER,2), nvl(m.constrained_mode,0), nvl(mplo.release_flag,1) FROM MFG_LOOKUPS L3, MFG_LOOKUPS L1, MSC_SCHEDULING_RULES MSR, MSC_ASSIGNMENT_SETS MAS, MSC_ASSIGNMENT_SETS MAS1, MSC_ASSIGNMENT_SETS MAS2, MSC_ASSIGNMENT_SETS MAS3, MSC_CATEGORY_SETS MCS , MSC_CATEGORY_SETS MCS1 , MSC_PARAMETERS P, MSC_PLANS M, MSC_PLANS_OTHER MPLO, MSC_DESIGNATORS D, MSC_PLAN_ORGANIZATIONS MPO, MSC_SERVICE_LEVEL_SETS MSLS, MSC_SERVICE_LEVEL_SETS MSLS1, MSC_ITEM_SIMULATION_SETS MISS WHERE L1.LOOKUP_TYPE = 'MSC_PLAN_TYPE_LONG' AND L1.LOOKUP_CODE = DECODE(D.DESIGNATOR_TYPE,-99,1, 2, 2, 3, 1, 5, 4, 8, 5, 9,6, 10,7,11,8,12,9, 3) AND L3.LOOKUP_TYPE = 'MRP_ORGANIZATION_SELECTION' AND L3.LOOKUP_CODE = NVL(D.ORGANIZATION_SELECTION, 1) AND MAS1.ASSIGNMENT_SET_ID (+) = M.ASSIGNMENT_SET_ID AND MAS1.SR_INSTANCE_ID (+) = M.SR_INSTANCE_ID AND MAS.ASSIGNMENT_SET_ID (+) = M.CURR_ASSIGNMENT_SET_ID AND MAS.SR_INSTANCE_ID (+) = M.SR_INSTANCE_ID AND MAS2.ASSIGNMENT_SET_ID(+) = M.FORECAST_ASSIGNMENT_SET_ID AND MAS2.SR_INSTANCE_ID (+) = M.SR_INSTANCE_ID AND MAS3.ASSIGNMENT_SET_ID(+) = M.ASSIGNMENT_SET_OUT_ID AND MAS3.SR_INSTANCE_ID (+) = M.SR_INSTANCE_ID AND MCS.CATEGORY_SET_ID (+) = M.CATEGORY_SET_ID AND MCS1.CATEGORY_SET_ID (+) = M.CATEGORY_SET_ID AND D.ORGANIZATION_ID = P.ORGANIZATION_ID (+) AND D.SR_INSTANCE_ID = P.SR_INSTANCE_ID (+) AND NVL(D.DESIGNATOR_TYPE,3) IN (2, 3, 4,5,8,9,10,11,12,-99) AND M.SR_INSTANCE_ID(+) = D.SR_INSTANCE_ID AND M.ORGANIZATION_ID (+)= D.ORGANIZATION_ID AND M.COMPILE_DESIGNATOR(+) = D.DESIGNATOR AND MSR.RULE_ID(+)=M.CURR_DEM_PRIORITY_RULE_ID AND MPO.PLAN_ID(+) = M.PLAN_ID AND MPLO.PLAN_ID(+) = M.PLAN_ID AND MPO.ORGANIZATION_ID(+) = M.ORGANIZATION_ID AND MPO.SR_INSTANCE_ID(+) = M.SR_INSTANCE_ID AND nvl(M.COPY_PLAN_ID,-1) = -1 AND nvl(D.COPY_DESIGNATOR_ID,-1) = -1 and nvl(d.collected_flag,2) <> 1 AND MSLS.SERVICE_LEVEL_SET_ID (+) = M.CURR_SERVICE_LEVEL_SET_ID AND MSLS1.SERVICE_LEVEL_SET_ID (+) = M.SERVICE_LEVEL_SET_ID AND MISS.SIMULATION_SET_ID (+) = M.ITEM_SIMULATION_SET_ID

View Text - HTML Formatted

SELECT DISTINCT M.ROWID
, M.PLAN_ID
, D.ORGANIZATION_ID
, D.SR_INSTANCE_ID
, D.DESIGNATOR
, NVL(M.LAST_UPDATE_DATE
, SYSDATE)
, NVL(M.LAST_UPDATED_BY
, D.LAST_UPDATED_BY)
, NVL(M.CREATION_DATE
, SYSDATE)
, NVL(M.CREATED_BY
, D.CREATED_BY)
, M.LAST_UPDATE_LOGIN
, DECODE(D.DESIGNATOR_TYPE
, 5
, NVL(M.CURR_OPERATION_SCHEDULE_TYPE
, 2)
, NVL(NVL(M.CURR_OPERATION_SCHEDULE_TYPE
, P.OPERATION_SCHEDULE_TYPE)
, 1))
, DECODE(D.DESIGNATOR_TYPE
, 2
, 2
, 3
, 1
, 5
, 4
, 4
, 3
, 8
, 5
, 9
, 6
, 10
, 7
, 11
, 8
, 1)
, DECODE(D.DESIGNATOR_TYPE
, -99
, ' '
, L1.MEANING)
, NVL(M.CURR_OVERWRITE_OPTION
, 1)
, NVL(M.CURR_APPEND_PLANNED_ORDERS
, DECODE(M.CURR_OVERWRITE_OPTION
, 3
, 2
, 1))
, NVL(M.CURR_CUTOFF_DATE
, SYSDATE+NVL(M.DAILY_CUTOFF_BUCKET
, 30) +NVL(M.WEEKLY_CUTOFF_BUCKET
, 4)*7 +NVL(M.PERIOD_CUTOFF_BUCKET
, 5)*30)
, DECODE(D.DESIGNATOR_TYPE
, 5
, NVL(M.CURR_PART_INCLUDE_TYPE
, MSC_GET_NAME.ABC_CLASS_ID(D.ORGANIZATION_ID
, D.SR_INSTANCE_ID))
, NVL(NVL(M.CURR_PART_INCLUDE_TYPE
, P.PART_INCLUDE_TYPE)
, 2))
, NVL(M.CURR_PLANNING_TIME_FENCE_FLAG
, P.PLANNING_TIME_FENCE_FLAG)
, NVL(M.CURR_DEMAND_TIME_FENCE_FLAG
, P.DEMAND_TIME_FENCE_FLAG)
, NVL(M.CURR_CONSIDER_RESERVATIONS
, P.CONSIDER_RESERVATIONS)
, NVL(M.CURR_PLAN_SAFETY_STOCK
, P.PLAN_SAFETY_STOCK)
, NVL(M.CURR_CONSIDER_WIP
, P.CONSIDER_WIP)
, NVL(M.CURR_CONSIDER_PO
, P.CONSIDER_PO)
, NVL(M.CURR_SNAPSHOT_LOCK
, P.SNAPSHOT_LOCK)
, D.DESCRIPTION
, D.DISABLE_DATE
, M.CURR_ASSIGNMENT_SET_ID
, MAS.ASSIGNMENT_SET_NAME
, MAS.DESCRIPTION
, NVL(D.ORGANIZATION_SELECTION
, 3)
, L3.MEANING
, M.OPERATION_SCHEDULE_TYPE
, M.PLAN_TYPE
, MSC_GET_NAME.LOOKUP_MEANING('MRP_PLAN_TYPE'
, M.PLAN_TYPE)
, M.OVERWRITE_OPTION
, M.APPEND_PLANNED_ORDERS
, M.CUTOFF_DATE
, M.PART_INCLUDE_TYPE
, M.PLANNING_TIME_FENCE_FLAG
, M.DEMAND_TIME_FENCE_FLAG
, M.CONSIDER_RESERVATIONS
, M.PLAN_SAFETY_STOCK
, M.CONSIDER_WIP
, M.CONSIDER_PO
, M.SNAPSHOT_LOCK
, M.ASSIGNMENT_SET_ID
, MAS1.ASSIGNMENT_SET_NAME
, MAS1.DESCRIPTION
, M.DATA_START_DATE
, M.DATA_COMPLETION_DATE
, M.PLAN_START_DATE
, M.PLAN_COMPLETION_DATE
, NVL(M.CURR_RESERVATION_LEVEL
, 4)
, NVL(M.CURR_HARD_PEGGING_LEVEL
, 3)
, NVL(M.RESERVATION_LEVEL
, 3)
, NVL(M.HARD_PEGGING_LEVEL
, 3)
, NVL(M.CURR_PLAN_CAPACITY_FLAG
, 1)
, DECODE(M.CURR_PLAN_TYPE
, 7
, MPLO.SIMULATION_SET
, M.CURR_SIMULATION_SET)
, M.CURR_BILL_OF_RESOURCES
, M.PLAN_CAPACITY_FLAG
, M.SIMULATION_SET
, M.BILL_OF_RESOURCES
, NVL(M.CURR_ENFORCE_DEM_DUE_DATES
, DECODE(D.DESIGNATOR_TYPE
, 5
, 2
, 1))
, M.ENFORCE_DEM_DUE_DATES
, NVL(M.CURR_PLANNED_RESOURCES
, 1)
, M.PLANNED_RESOURCES
, DECODE(M.CURR_DEM_PRIORITY_RULE_ID
, NULL
, MSC_GET_NAME.GET_DEFAULT_DEM_PRI_RULE_ID
, M.CURR_DEM_PRIORITY_RULE_ID)
, DECODE(M.DEM_PRIORITY_RULE_ID
, NULL
, MSC_GET_NAME.GET_DEFAULT_DEM_PRI_RULE_ID
, M.DEM_PRIORITY_RULE_ID)
, M.ENFORCE_CAP_CONSTRAINTS
, NVL(M.CURR_ENFORCE_CAP_CONSTRAINTS
, 2)
, M.BOTTLENECK_RES_GROUP
, DECODE(M.CURR_PLAN_TYPE
, 7
, MPLO.BOTTLENECK_RESOURCE_GROUP
, M.CURR_BOTTLENECK_RES_GROUP)
, M.OBJECTIVE_WEIGHT_1
, M.OBJECTIVE_WEIGHT_2
, M.OBJECTIVE_WEIGHT_3
, M.OBJECTIVE_WEIGHT_4
, M.OBJECTIVE_WEIGHT_5
, NVL(M.OPTIMIZE_FLAG
, DECODE(D.DESIGNATOR_TYPE
, 5
, 1
, 2))
, DECODE(M.DMD_LATENESS_PENALTY_COST
, NULL
, DECODE(D.DESIGNATOR_TYPE
, 9
, 0
, 10
, 0
, NULL)
, M.DMD_LATENESS_PENALTY_COST)
, M.SUPPLIER_CAP_OVER_UTIL_COST
, M.TRANSPORT_CAP_OVER_UTIL_COST
, M.RESOURCE_OVER_UTIL_COST
, NVL(M.CURR_START_DATE
, SYSDATE)
, M.START_DATE
, NVL(M.DAILY_ITEM_AGGREGATION_LEVEL
, 1)
, NVL(M.DAILY_MATERIAL_CONSTRAINTS
, 2)
, NVL(M.DAILY_RESOURCE_CONSTRAINTS
, 2)
, NVL(M.DAILY_RES_AGGREGATION_LEVEL
, 1)
, M.DAILY_TRANS_CONSTRAINTS
, NVL(M.WEEKLY_ITEM_AGGREGATION_LEVEL
, 1)
, NVL(M.WEEKLY_MATERIAL_CONSTRAINTS
, 2)
, NVL(M.WEEKLY_RESOURCE_CONSTRAINTS
, 2)
, NVL(M.WEEKLY_RES_AGGREGATION_LEVEL
, 1)
, M.WEEKLY_TRANS_CONSTRAINTS
, NVL(M.PERIOD_ITEM_AGGREGATION_LEVEL
, 1)
, NVL(M.PERIOD_MATERIAL_CONSTRAINTS
, 2)
, NVL(M.PERIOD_RESOURCE_CONSTRAINTS
, 2)
, NVL(M.PERIOD_RES_AGGREGATION_LEVEL
, 1)
, M.PERIOD_TRANS_CONSTRAINTS
, NVL(M.DAILY_CUTOFF_BUCKET
, 30)
, NVL(M.HOUR_CUTOFF_BUCKET
, 0)
, NVL(M.MIN_CUTOFF_BUCKET
, 0)
, NVL(M.PERIOD_CUTOFF_BUCKET
, 5)
, M.QTRLY_CUTOFF_BUCKET
, NVL(M.WEEKLY_CUTOFF_BUCKET
, 4)
, NVL(M.DAILY_RTG_AGGREGATION_LEVEL
, DECODE(D.DESIGNATOR_TYPE
, 2
, 2
, 1))
, NVL(M.WEEKLY_RTG_AGGREGATION_LEVEL
, DECODE(D.DESIGNATOR_TYPE
, 2
, 2
, 1))
, NVL(M.PERIOD_RTG_AGGREGATION_LEVEL
, DECODE(D.DESIGNATOR_TYPE
, 2
, 2
, 1))
, M.SCHEDULE_FLAG
, M.LOT_FOR_LOT_FLAG
, M.FULL_PEGGING
, M.CURR_FULL_PEGGING
, DECODE(MSR.MEANING
, NULL
, MSC_GET_NAME.GET_DEFAULT_DEM_PRI_RULE
, MSR.MEANING)
, M.SERVICE_LEVEL
, NVL(M.CURR_ENFORCE_SL_CONSTRAINTS
, DECODE(D.DESIGNATOR_TYPE
, 5
, 1
, 2))
, M.ENFORCE_SL_CONSTRAINTS
, D.DESIGNATOR_TYPE
, D.DEMAND_CLASS
, M.PLAN_INVENTORY_POINT
, M.ENABLE_CLOSEST_QTY_PEGGING
, M.CURR_CLOSEST_QTY_PEG
, M.ENABLE_PRIORITY_PEGGING
, DECODE(M.CURR_PRIORITY_PEGGING
, NULL
, DECODE(D.DESIGNATOR_TYPE
, 9
, 1
, 10
, 1
, NULL)
, M.CURR_PRIORITY_PEGGING)
, M.BACKWARD_DAYS
, M.CURR_BACKWARD_DAYS
, M.FORWARD_DAYS
, M.CURR_FORWARD_DAYS
, NVL(M.CURR_ENFORCE_SRC_CONSTRAINTS
, DECODE(D.DESIGNATOR_TYPE
, 5
, 2
, 1))
, M.ENFORCE_SRC_CONSTRAINTS
, NVL(M.USE_END_ITEM_SUBSTITUTIONS
, 2)
, NVL(M.USE_ALTERNATE_RESOURCES
, 1)
, NVL(M.USE_ALTERNATE_BOM_ROUTING
, 1)
, NVL(M.USE_SUBSTITUTE_COMPONENTS
, 1)
, NVL(M.USE_ALTERNATE_SOURCES
, 1)
, M.SUBSTITUTION_DESIGNATOR
, M.DISPLAY_KPI
, DECODE(D.DESIGNATOR_TYPE
, 5
, NVL(M.FORECAST_ALLOCATION_METHOD
, 2)
, M.FORECAST_ALLOCATION_METHOD)
, M.FORECAST_CONSUMPTION_METHOD
, NVL(M.EXPLODE_FORECAST
, 2)
, M.FORECAST_ASSIGNMENT_SET_ID
, MAS2.ASSIGNMENT_SET_NAME
, MAS2.DESCRIPTION
, NVL(M.ENFORCE_SUP_CAP_CONSTRAINTS
, 2)
, NVL(M.ENFORCE_PUR_LT_CONSTRAINTS
, 2)
, M.TGT_TL_UTIL_PCT
, M.MIN_TL_UTIL_PCT
, NVL(M.LOAD_SCHED_TIME_FENCE_DAYS
, 0)
, NVL(M.LOAD_SCHEDULING_DAYS
, 0)
, DECODE(M.USE_FIXED_PERIOD_BKTS
, 1
, NULL
, NVL(M.DAILY_ALLOC_BUCKETS
, 0))
, DECODE(M.USE_FIXED_PERIOD_BKTS
, 1
, NULL
, DECODE(M.PLAN_ID
, NULL
, 1
, M.WKS_PER_WKLY_ALLOC_BUCKET))
, NVL(M.CIRC_SRCING_SURPLUS_DAYS
, 0)
, NVL(M.SUPPLY_SCHED_ITF
, 0)
, DECODE(M.INCLUDE_CRITICAL_COMPONENTS
, NULL
, DECODE(D.DESIGNATOR_TYPE
, 9
, 1
, 10
, 1
, 2)
, M.INCLUDE_CRITICAL_COMPONENTS)
, NVL(M.SCHEDULE_BY
, 1)
, M.SAFETY_STK_CHANGE_INTERVAL
, M.SAFETY_STK_THRESHOLD_PCT
, NVL(M.ENFORCE_USER_SAFETY_STOCKS
, 2)
, NVL(M.ENFORCE_BUDGET_CONSTRAINTS
, 2)
, M.FORECAST_ASSIGNMENT_SET_ID
, NVL(M.COPY_PLAN
, 2)
, M.BUDGET_ID
, M.BUDGET_VALUE
, NVL(M.SUPPLIER_ALLOC_METHOD
, 0)
, NVL(M.CUSTOMER_ALLOC_METHOD
, 0)
, NVL(M.DEFAULT_ALLOC_METHOD
, 0)
, NVL(M.USE_ORG_PRIORITY_OVERRIDE
, 2)
, NVL(M.SHIPMENT_CONSOLIDATION_DAYS
, 0)
, NVL(M.USE_FIXED_PERIOD_BKTS
, 2)
, NVL(M.ITF_HORIZ_DAYS
, 0)
, M.DMD_PRI_RULE_SET_ID
, MSC_GET_NAME.DRP_PRI_RULE_NAME(M.DMD_PRI_RULE_SET_ID)
, NVL(M.ENABLE_SO_SPLIT
, 2)
, NVL(CALCULATE_SDS_DAYS_TIME
, 2)
, NVL(CALCULATE_SDS_WEEKS_TIME
, 2)
, NVL(CALCULATE_SDS_PERIODS_TIME
, 2)
, M.DS_SUBSET_HORIZON_DAYS
, M.SCHEDULE_DAYS_BEFORE
, M.SCHEDULE_START_TIME
, DECODE(M.CURR_INCLUDE_WO
, NULL
, DECODE(D.DESIGNATOR_TYPE
, 9
, 2
, 10
, 1
, 2)
, M.CURR_INCLUDE_WO)
, M.INCLUDE_WO
, NVL(M.CURR_DS_HORIZON_DAYS
, 1)
, DECODE(M.ENFORCE_PURCH_LEAD_TIME
, NULL
, DECODE(D.DESIGNATOR_TYPE
, 9
, 1
, 10
, 1
, 2)
, M.ENFORCE_PURCH_LEAD_TIME)
, M.USER_UPDATE_FIRM
, NVL(M.DEMAND_PRIORITY_SENSITIVITY
, 1)
, NVL(M.EARLY_BUILD_PENALTY
, 0)
, M.AUTO_RELEASE_TIME_FENCE
, M.CURR_SUBSET_DESIGNATOR_ID
, M.SUBSET_DESIGNATOR_ID
, NVL(M.CURR_INCLUDE_PLANNED_ORDER
, 2)
, M.INCLUDE_PLANNED_ORDER
, NVL(M.CURR_SCHEDULE_SUBSET_TYPE
, 1)
, NVL(M.SCHEDULE_SUBSET_TYPE
, 1)
, M.ENFORCE_SUP_CAP_CONSTRAINTS
, MPO.FROZEN_HORIZON_DAYS
, NVL(MPO.CURR_RESPECT_MAX_ACCEPT_DAYS
, 2)
, NVL(MPO.CURR_MIN_SUPPLY_LEAD_TIME
, 1)
, MPO.SIMULATION_SET
, NVL(M.FIRM_OUTSIDE_SUBSET
, 2)
, M.DS_HORIZON_DAYS
, NVL(M.SDS_DMD_PENALTY
, 0)
, NVL(M.CALCULATE_LIABILITY
, 2)
, NVL(M.CURR_ENF_FULFILLMENT_LT
, 2)
, M.DEMAND_FULFILLMENT_LT
, NVL(M.ENFORCE_FULFILLMENT_LT
, 2)
, M.MFG_LT_VAR_PERCENT
, M.SUP_LT_VAR_PERCENT
, M.TRANSIT_LT_VAR_PERCENT
, M.CURR_SERVICE_LEVEL_SET_ID
, MSLS.SERVICE_LEVEL_SET_NAME
, MSLS.DESCRIPTION
, M.SERVICE_LEVEL_SET_ID
, MSLS1.SERVICE_LEVEL_SET_NAME
, MSLS1.DESCRIPTION
, M.ITEM_SIMULATION_SET_ID
, MISS.SIMULATION_SET_NAME ITEM_SIMULATION_SET
, NVL(MPLO.MODEL_HORIZON
, 30)
, NVL(MPLO.DATA_HORIZON
, 30)
, NVL(MPLO.HORIZON_UNITS
, 1)
, MPLO.REF_PLAN_ID
, NVL(MPLO.DECIMAL_PRECISION
, 2)
, NVL(MPLO.OFFLOAD_THRESHOLD
, 75)
, NVL(MPLO.OFFLOAD_THRESHOLD_WINDOW
, 7)
, NVL(MPLO.WORKDAY_TIME
, 480)
, NVL(MPLO.WORKDAY_DAY
, 1)
, NVL(MPLO.COST_TIME_UNIT
, 4)
, NVL(MPLO.FIXED_PRODUCTION_FENCE
, 0)
, NVL(MPLO.FIXED_PRODUCTION_UNITS
, 2)
, NVL(MPLO.CRITICAL_COMPONENTS_FLAG
, 1)
, NVL(MPLO.ALLOW_WO_OFFLOAD_FLAG
, 2)
, NVL(MPLO.INCLUDE_PAST_DUE_SALESORDERS
, 0)
, NVL(MPLO.DEMAND_FORECAST_FENCE
, 0)
, NVL(MPLO.DEMAND_BUILD_STRATEGY
, 1)
, NVL(MPLO.GLOBAL_BUILD_STRATEGY
, 1)
, NVL(MPLO.SHIP_COMPLETE_FLAG
, 2)
, NVL(MPLO.CREATE_ITEM_FOLDERS
, 1)
, DECODE(MPLO.PLAN_ID
, NULL
, NVL(MPLO.CREATE_DEMAND_FOLDERS
, 1)
, MPLO.CREATE_DEMAND_FOLDERS)
, DECODE(MPLO. PLAN_ID
, NULL
, NVL(MPLO.CREATE_SUPPLY_FOLDERS
, 2)
, MPLO.CREATE_SUPPLY_FOLDERS)
, DECODE(MPLO.PLAN_ID
, NULL
, NVL(MPLO.CREATE_WORKORDER_FOLDERS
, 1)
, MPLO.CREATE_WORKORDER_FOLDERS)
, NVL(MPLO.USE_RMO_FLAG
, 1)
, NVL(MPLO.MINIMUM_CYCLE_TIME
, 2)
, NVL(MPLO.MINIMIZE_CHANGEOVER_FLAG
, 1)
, NVL(MPLO.IDEAL_SEQUENCE_BASE
, 1)
, NVL(MPLO.INVENTORY_COST_FACTOR
, 1)
, NVL(MPLO.STOCKOUT_COST_FACTOR
, 1)
, NVL(MPLO.CHANGEOVER_COST_FACTOR
, 1)
, NVL(MPLO.SAFETY_COST_FACTOR
, 1)
, NVL(MPLO.START_TIME
, 0)
, NVL(MPLO.OFFSET_DAYS
, 0)
, NVL(M.PLANNED_BUCKET
, 52)
, NVL(M.PLANNED_BUCKET_TYPE
, 2)
, M.ASSIGNMENT_SET_OUT_ID
, MAS3.ASSIGNMENT_SET_NAME
, M.CATEGORY_SET_ID
, MCS.CATEGORY_SET_NAME
, MCS.DESCRIPTION
, MCS1.CATEGORY_SET_NAME
, MCS1.DESCRIPTION
, M.MANUAL_FCST_OVERWRITE_OPTION
, M.ENFORCE_CONSTRAINTS
, M.SAFETY_STOCK_VALUE_TYPE
, M.REALLOC_SURPLUS_DAYS
, M.PERFORM_FAIR_SHARE_ALLOC
, M.INCLUDE_ALL_ITEMS
, M.INCLUDE_ALL_CATEGORIES
, M.AUTO_RELEASE_METHOD
, M.INCLUDE_RESCHEDULES
, M.CALENDAR_TYPE
, M.HISTORY_RANGE
, M.HISTORY_RANGE_UOM
, M.FORECAST
, M.FORECAST_UOM
, M.FORECAST_BUCKET
, M.FORECAST_BUCKET_UOM
, DECODE(M.CALENDAR_TYPE
, 1
, MSC_GET_NAME.LOOKUP_MEANING('MRP_BUCKET_TYPE'
, M.HISTORY_RANGE_UOM)
, 2
, MSC_GET_NAME.LOOKUP_MEANING('MRP_GREGORIAN_BUCKET_TYPE'
, M.HISTORY_RANGE_UOM)
, NULL) HISTORY_RANGE_TYPE_TEXT
, DECODE(M.CALENDAR_TYPE
, 1
, MSC_GET_NAME.LOOKUP_MEANING('MRP_BUCKET_TYPE'
, M.FORECAST_UOM)
, 2
, MSC_GET_NAME.LOOKUP_MEANING('MRP_GREGORIAN_BUCKET_TYPE'
, M.FORECAST_UOM)
, NULL) FORECAST_TYPE_TEXT
, DECODE(M.CALENDAR_TYPE
, 1
, MSC_GET_NAME.LOOKUP_MEANING('MRP_BUCKET_TYPE'
, M.FORECAST_BUCKET_UOM)
, 2
, MSC_GET_NAME.LOOKUP_MEANING('MRP_GREGORIAN_BUCKET_TYPE'
, M.FORECAST_BUCKET_UOM)
, NULL) FORECAST_BUCKET_TYPE_TEXT
, NVL(MPLO.USE_UNITS_OF_EFFORT
, 3)
, NVL(MPLO.USE_ADJACENT_OPERATIONS
, 2)
, NVL(M.SOP_ENABLED
, 2)
, NVL(M.CIRCULAR_SRC
, 1)
, NVL(MPLO.PURCHASE_LEAD_TIME_OFFSET
, 0)
, NVL(MPLO.ENABLE_SAFETY_COVER
, 2)
, NVL(M.CONSTRAINED_MODE
, 0)
, NVL(MPLO.RELEASE_FLAG
, 1)
FROM MFG_LOOKUPS L3
, MFG_LOOKUPS L1
, MSC_SCHEDULING_RULES MSR
, MSC_ASSIGNMENT_SETS MAS
, MSC_ASSIGNMENT_SETS MAS1
, MSC_ASSIGNMENT_SETS MAS2
, MSC_ASSIGNMENT_SETS MAS3
, MSC_CATEGORY_SETS MCS
, MSC_CATEGORY_SETS MCS1
, MSC_PARAMETERS P
, MSC_PLANS M
, MSC_PLANS_OTHER MPLO
, MSC_DESIGNATORS D
, MSC_PLAN_ORGANIZATIONS MPO
, MSC_SERVICE_LEVEL_SETS MSLS
, MSC_SERVICE_LEVEL_SETS MSLS1
, MSC_ITEM_SIMULATION_SETS MISS
WHERE L1.LOOKUP_TYPE = 'MSC_PLAN_TYPE_LONG'
AND L1.LOOKUP_CODE = DECODE(D.DESIGNATOR_TYPE
, -99
, 1
, 2
, 2
, 3
, 1
, 5
, 4
, 8
, 5
, 9
, 6
, 10
, 7
, 11
, 8
, 12
, 9
, 3)
AND L3.LOOKUP_TYPE = 'MRP_ORGANIZATION_SELECTION'
AND L3.LOOKUP_CODE = NVL(D.ORGANIZATION_SELECTION
, 1)
AND MAS1.ASSIGNMENT_SET_ID (+) = M.ASSIGNMENT_SET_ID
AND MAS1.SR_INSTANCE_ID (+) = M.SR_INSTANCE_ID
AND MAS.ASSIGNMENT_SET_ID (+) = M.CURR_ASSIGNMENT_SET_ID
AND MAS.SR_INSTANCE_ID (+) = M.SR_INSTANCE_ID
AND MAS2.ASSIGNMENT_SET_ID(+) = M.FORECAST_ASSIGNMENT_SET_ID
AND MAS2.SR_INSTANCE_ID (+) = M.SR_INSTANCE_ID
AND MAS3.ASSIGNMENT_SET_ID(+) = M.ASSIGNMENT_SET_OUT_ID
AND MAS3.SR_INSTANCE_ID (+) = M.SR_INSTANCE_ID
AND MCS.CATEGORY_SET_ID (+) = M.CATEGORY_SET_ID
AND MCS1.CATEGORY_SET_ID (+) = M.CATEGORY_SET_ID
AND D.ORGANIZATION_ID = P.ORGANIZATION_ID (+)
AND D.SR_INSTANCE_ID = P.SR_INSTANCE_ID (+)
AND NVL(D.DESIGNATOR_TYPE
, 3) IN (2
, 3
, 4
, 5
, 8
, 9
, 10
, 11
, 12
, -99)
AND M.SR_INSTANCE_ID(+) = D.SR_INSTANCE_ID
AND M.ORGANIZATION_ID (+)= D.ORGANIZATION_ID
AND M.COMPILE_DESIGNATOR(+) = D.DESIGNATOR
AND MSR.RULE_ID(+)=M.CURR_DEM_PRIORITY_RULE_ID
AND MPO.PLAN_ID(+) = M.PLAN_ID
AND MPLO.PLAN_ID(+) = M.PLAN_ID
AND MPO.ORGANIZATION_ID(+) = M.ORGANIZATION_ID
AND MPO.SR_INSTANCE_ID(+) = M.SR_INSTANCE_ID
AND NVL(M.COPY_PLAN_ID
, -1) = -1
AND NVL(D.COPY_DESIGNATOR_ID
, -1) = -1
AND NVL(D.COLLECTED_FLAG
, 2) <> 1
AND MSLS.SERVICE_LEVEL_SET_ID (+) = M.CURR_SERVICE_LEVEL_SET_ID
AND MSLS1.SERVICE_LEVEL_SET_ID (+) = M.SERVICE_LEVEL_SET_ID
AND MISS.SIMULATION_SET_ID (+) = M.ITEM_SIMULATION_SET_ID