VIEW: APPS.MSC_SYSTEM_ITEMS_V

Source

View Text - Preformatted

SELECT MSI.PLAN_ID , MP.PLAN_ID PDS_PLAN_ID , MP.ITEM_SIMULATION_SET_ID , MSI.ORGANIZATION_ID , MSI.INVENTORY_ITEM_ID , MSI.SR_INSTANCE_ID , MSI.SR_INVENTORY_ITEM_ID , MSI.ITEM_NAME , MSI.LOTS_EXPIRATION , MSI.LOT_CONTROL_CODE , MSI.SHRINKAGE_RATE , MSI.FIXED_DAYS_SUPPLY , MSI.FIXED_ORDER_QUANTITY , MSI.FIXED_LOT_MULTIPLIER , MSI.MINIMUM_ORDER_QUANTITY , MSI.MAXIMUM_ORDER_QUANTITY , MSI.ROUNDING_CONTROL_TYPE , MSI.PLANNING_TIME_FENCE_DAYS , MSI.PLANNING_TIME_FENCE_DATE , MSI.DEMAND_TIME_FENCE_DAYS , MSI.DEMAND_TIME_FENCE_DATE , MSI.DESCRIPTION , MSI.RELEASE_TIME_FENCE_CODE , MSI.RELEASE_TIME_FENCE_DAYS , MSI.IN_SOURCE_PLAN , MSI.REVISION , MSI.SR_CATEGORY_ID , MSI.ABC_CLASS , MSI.CATEGORY_NAME , MSI.MRP_PLANNING_CODE , MSI.FIXED_LEAD_TIME , MSI.VARIABLE_LEAD_TIME , MSI.PREPROCESSING_LEAD_TIME , MSI.POSTPROCESSING_LEAD_TIME , MSI.FULL_LEAD_TIME , MSI.CUMULATIVE_TOTAL_LEAD_TIME , MSI.CUM_MANUFACTURING_LEAD_TIME , MSI.UOM_CODE , MSI.UNIT_WEIGHT , MSI.UNIT_VOLUME , MSI.WEIGHT_UOM , MSI.VOLUME_UOM , MSI.PRODUCT_FAMILY_ID , MSI.ATP_RULE_ID , MSI.ATP_COMPONENTS_FLAG , MSI.BUILD_IN_WIP_FLAG , MSI.PURCHASING_ENABLED_FLAG , MSI.PLANNING_MAKE_BUY_CODE , MSI.REPETITIVE_TYPE , MSI.REPETITIVE_VARIANCE , MSI.STANDARD_COST , MSI.CARRYING_COST , MSI.ORDER_COST , MSI.MATERIAL_COST , MSI.DMD_LATENESS_COST , MSI.RESOURCE_COST , MSI.SS_PENALTY_COST , MSI.SUPPLIER_CAP_OVERUTIL_COST , MSI.LIST_PRICE , MSI.AVERAGE_DISCOUNT , MSI.ENGINEERING_ITEM_FLAG , MSI.WIP_SUPPLY_TYPE , MSI.SAFETY_STOCK_CODE , MSI.SAFETY_STOCK_PERCENT , MSI.SAFETY_STOCK_BUCKET_DAYS , MSI.INVENTORY_USE_UP_DATE , MSI.BUYER_NAME , MSI.PLANNER_CODE , MSI.PLANNING_EXCEPTION_SET , MSI.EXCESS_QUANTITY , MSI.EXCEPTION_SHORTAGE_DAYS , MSI.EXCEPTION_EXCESS_DAYS , MSI.EXCEPTION_OVERPROMISED_DAYS , MSI.EXCEPTION_CODE , MSI.BOM_ITEM_TYPE , MSI.ATO_FORECAST_CONTROL , MSI.EFFECTIVITY_CONTROL , MSI.ORGANIZATION_CODE , MSI.ACCEPTABLE_RATE_INCREASE , MSI.ACCEPTABLE_RATE_DECREASE , MSI.EXCEPTION_REP_VARIANCE_DAYS , MSI.OVERRUN_PERCENTAGE , MSI.INVENTORY_PLANNING_CODE , MSI.ACCEPTABLE_EARLY_DELIVERY , MSI.CALCULATE_ATP , MSI.END_ASSEMBLY_PEGGING_FLAG , MSI.END_ASSEMBLY_PEGGING , MSI.FULL_PEGGING , MSI.INVENTORY_ITEM_FLAG , MSI.SOURCE_ORG_ID , MSI.BASE_ITEM_ID , MSI.ABC_CLASS_NAME , MSI.FIXED_SAFETY_STOCK_QTY , MSI.PRIMARY_SUPPLIER_ID , MSI.ATP_FLAG , MSI.LOW_LEVEL_CODE , MSI.PLANNER_STATUS_CODE , MSI.NETTABLE_INVENTORY_QUANTITY , MSI.NONNETTABLE_INVENTORY_QUANTITY , MSI.REFRESH_NUMBER , MSI.LAST_UPDATE_DATE , MSI.LAST_UPDATED_BY , MSI.CREATION_DATE , MSI.CREATED_BY , MSI.LAST_UPDATE_LOGIN , MSI.REQUEST_ID , MSI.PROGRAM_APPLICATION_ID , MSI.PROGRAM_ID , MSI.PROGRAM_UPDATE_DATE , MSI.ATTRIBUTE_CATEGORY , MSI.ATTRIBUTE1 , MSI.ATTRIBUTE2 , MSI.ATTRIBUTE3 , MSI.ATTRIBUTE4 , MSI.ATTRIBUTE5 , MSI.ATTRIBUTE6 , MSI.ATTRIBUTE7 , MSI.ATTRIBUTE8 , MSI.ATTRIBUTE9 , MSI.ATTRIBUTE10 , MSI.ATTRIBUTE11 , MSI.ATTRIBUTE12 , MSI.ATTRIBUTE13 , MSI.ATTRIBUTE14 , MSI.ATTRIBUTE15 , MSI.REVISION_QTY_CONTROL_CODE , MSI.EXPENSE_ACCOUNT , MSI.INVENTORY_ASSET_FLAG , MSI.BUYER_ID , MSI.REPETITIVE_PLANNING_FLAG , MSI.PICK_COMPONENTS_FLAG , MSI.SERVICE_LEVEL , MSI.REPLENISH_TO_ORDER_FLAG , MSI.PIP_FLAG , MSI.YIELD_CONV_FACTOR , MSI.MIN_MINMAX_QUANTITY , MSI.MAX_MINMAX_QUANTITY , MSI.NEW_ATP_FLAG , MSI.SOURCE_TYPE , MSI.SUBSTITUTION_WINDOW , MSI.CREATE_SUPPLY_FLAG , MSI.REORDER_POINT , MSI.AVERAGE_ANNUAL_DEMAND , MSI.ECONOMIC_ORDER_QUANTITY , MSI.SERIAL_NUMBER_CONTROL_CODE , MSI.CONVERGENCE , MSI.DIVERGENCE , MSI.CONTINOUS_TRANSFER , MSI.CRITICAL_COMPONENT_FLAG , MSI.REDUCE_MPS , MSI.CONSIGNED_FLAG , MSI.VMI_MINIMUM_UNITS , MSI.VMI_MINIMUM_DAYS , MSI.VMI_MAXIMUM_UNITS , MSI.VMI_MAXIMUM_DAYS , MSI.AVERAGE_DAILY_DEMAND , MSI.VMI_FIXED_ORDER_QUANTITY , MSI.SO_AUTHORIZATION_FLAG , MSI.VMI_FORECAST_TYPE , MSI.FORECAST_HORIZON , MSI.ASN_AUTOEXPIRE_FLAG , MSI.VMI_REFRESH_FLAG , MSI.BUDGET_CONSTRAINED , MSI.MAX_QUANTITY , MSI.MAX_QUANTITY_DOS , MSI.DAYS_TGT_INV_WINDOW , MSI.DAYS_MAX_INV_WINDOW , MSI.DAYS_TGT_INV_SUPPLY , MSI.DAYS_MAX_INV_SUPPLY , MSI.DRP_PLANNED , MSI.AGGREGATE_TIME_FENCE_DATE , MSI.INFERRED_CRITICAL_FLAG , MSI.SS_WINDOW_SIZE , MSI.LOWEST_LEVEL_SRC , MSI.EAM_ITEM_TYPE , MSI.LOTS_EXIST , MSI.LEADTIME_VARIABILITY , MSI.MIN_SHELF_LIFE_DAYS , MSI.GROUP_ID , MSI.REPAIR_YIELD , MSI.REPAIR_PROGRAM , MSI.REPAIR_LEAD_TIME , MSI.PRE_POSITION_INVENTORY , MSI.PREPOSITION_POINT , MSI.DEMAND_FULFILLMENT_LT, MSI.FORECAST_RULE_FOR_DEMANDS, MSI.FORECAST_RULE_FOR_RETURNS, MSI.DEMAND_DISTRIBUTION, MSI.INTERARRIVAL_TIME, MSI.REPAIR_COST, MSI.LIFE_TIME_BUY_DATE, MSI.END_OF_LIFE_DATE, MSI.STD_DMD_OVER_HORIZON, msi.coefficient_of_variation, msi.avg_demand_beyond_ph, msi.avg_returns_beyond_ph, msi.return_forecast_time_fence, msi.defective_item_cost, msi.basis_avg_daily_demand, msi.std_deviation_for_demand, msi.mean_inter_arrival, msi.std_deviation_inter_arrival, msi.standard_deviation, msi.interarrival_dist_method, msi.safety_lead_time, msi.unsatisfied_demand_factor, msi.planning_time_fence_code, msi.max_usage_factor, msi.min_sup_dem_percent, msi.dmd_satisfied_percent, NULL MIN_REM_SHELF_LIFE_DAYS, 1 NEW_PLANNED_ORDER, msi.PEGGING_DEMAND_WINDOW_DAYS, msi.PEGGING_SUPPLY_WINDOW_DAYS, null scrap_rate, null repair_module, null rebuild_activity, NULL order_period, NULL inv_days_increment FROM MSC_SYSTEM_ITEMS MSI, MSC_PLANS MP WHERE MSI.PLAN_ID = -1 AND (MP.ITEM_SIMULATION_SET_ID IS NULL /* OR NOT EXISTS (SELECT 1 FROM MSC_ITEM_ATTRIBUTES MIA WHERE MIA.PLAN_ID = -1 AND MP.ITEM_SIMULATION_SET_ID IS NOT NULL AND MP.ITEM_SIMULATION_SET_ID = MIA.SIMULATION_SET_ID AND MSI.INVENTORY_ITEM_ID = MIA.INVENTORY_ITEM_ID AND MSI.ORGANIZATION_ID = MIA.ORGANIZATION_ID AND MSI.SR_INSTANCE_ID = MIA.SR_INSTANCE_ID ) */ OR (MSI.INVENTORY_ITEM_ID,MSI.ORGANIZATION_ID,MSI.SR_INSTANCE_ID) NOT IN (SELECT MIA.INVENTORY_ITEM_ID,MIA.ORGANIZATION_ID,MIA.SR_INSTANCE_ID FROM MSC_ITEM_ATTRIBUTES MIA WHERE MIA.PLAN_ID = -1 AND MP.ITEM_SIMULATION_SET_ID IS NOT NULL AND MP.ITEM_SIMULATION_SET_ID = MIA.SIMULATION_SET_ID AND MIA.region_id IS NULL AND MIA.customer_id IS NULL) ) UNION ALL SELECT /*+ ORDERED INDEX(MIA MSC_ITEM_ATTRIBUTES_U2) */ MSI.PLAN_ID , MP.PLAN_ID PDS_PLAN_ID , MP.ITEM_SIMULATION_SET_ID , MSI.ORGANIZATION_ID , MSI.INVENTORY_ITEM_ID , MSI.SR_INSTANCE_ID , MSI.SR_INVENTORY_ITEM_ID , MSI.ITEM_NAME , MSI.LOTS_EXPIRATION , MSI.LOT_CONTROL_CODE , decode(MIA.SHRINKAGE_RATE, -23453 , TO_NUMBER(NULL) , NULL, MSI.SHRINKAGE_RATE,MIA.SHRINKAGE_RATE)SHRINKAGE_RATE, decode(MIA.FIXED_DAYS_SUPPLY, -23453 , TO_NUMBER(NULL) , NULL, MSI.FIXED_DAYS_SUPPLY,MIA.FIXED_DAYS_SUPPLY)FIXED_DAYS_SUPPLY, decode(MIA.FIXED_ORDER_QUANTITY, -23453 , TO_NUMBER(NULL) , NULL, MSI.FIXED_ORDER_QUANTITY,MIA.FIXED_ORDER_QUANTITY)FIXED_ORDER_QUANTITY, decode(MIA.FIXED_LOT_MULTIPLIER, -23453 , TO_NUMBER(NULL) , NULL, MSI.FIXED_LOT_MULTIPLIER,MIA.FIXED_LOT_MULTIPLIER)FIXED_LOT_MULTIPLIER, decode(MIA.MINIMUM_ORDER_QUANTITY, -23453 , TO_NUMBER(NULL) , NULL, MSI.MINIMUM_ORDER_QUANTITY,MIA.MINIMUM_ORDER_QUANTITY)MINIMUM_ORDER_QUANTITY, decode(MIA.MAXIMUM_ORDER_QUANTITY, -23453 , TO_NUMBER(NULL) , NULL, MSI.MAXIMUM_ORDER_QUANTITY,MIA.MAXIMUM_ORDER_QUANTITY)MAXIMUM_ORDER_QUANTITY, NVL(MIA.ROUNDING_CONTROL_TYPE,MSI.ROUNDING_CONTROL_TYPE) , decode(MIA.PLANNING_TIME_FENCE_DAYS, -23453 , TO_NUMBER(NULL) , NULL, MSI.PLANNING_TIME_FENCE_DAYS,MIA.PLANNING_TIME_FENCE_DAYS)PLANNING_TIME_FENCE_DAYS, MSI.PLANNING_TIME_FENCE_DATE , decode(MIA.DEMAND_TIME_FENCE_DAYS, -23453 , TO_NUMBER(NULL) , NULL, MSI.DEMAND_TIME_FENCE_DAYS,MIA.DEMAND_TIME_FENCE_DAYS)DEMAND_TIME_FENCE_DAYS, MSI.DEMAND_TIME_FENCE_DATE , MSI.DESCRIPTION , MSI.RELEASE_TIME_FENCE_CODE , MSI.RELEASE_TIME_FENCE_DAYS , MSI.IN_SOURCE_PLAN , MSI.REVISION , MSI.SR_CATEGORY_ID , NVL(MIA.ABC_CLASS,MSI.ABC_CLASS) , MSI.CATEGORY_NAME , NVL(MIA.MRP_PLANNING_CODE,MSI.MRP_PLANNING_CODE) , decode(MIA.FIXED_LEAD_TIME, -23453 , TO_NUMBER(NULL) , NULL, MSI.FIXED_LEAD_TIME,MIA.FIXED_LEAD_TIME)FIXED_LEAD_TIME, decode(MIA.VARIABLE_LEAD_TIME, -23453 , TO_NUMBER(NULL) , NULL, MSI.VARIABLE_LEAD_TIME,MIA.VARIABLE_LEAD_TIME)VARIABLE_LEAD_TIME, decode(MIA.preProcessIng_Lead_Time, -23453 , TO_NUMBER(NULL) , NULL, MSI.preProcessIng_Lead_Time, MIA.preProcessIng_Lead_Time)preProcessIng_Lead_Time, decode(MIA.PostProcessIng_Lead_Time, -23453 , TO_NUMBER(NULL) , NULL, MSI.PostProcessIng_Lead_Time, MIA.PostProcessIng_Lead_Time)PostProcessIng_Lead_Time, decode(MIA.Full_Lead_Time, -23453 , TO_NUMBER(NULL) , NULL, MSI.Full_Lead_Time, MIA.Full_Lead_Time)Full_Lead_Time, MSI.CUMULATIVE_TOTAL_LEAD_TIME , MSI.CUM_MANUFACTURING_LEAD_TIME , MSI.UOM_CODE , decode(MIA.UNIT_WEIGHT, -23453 , TO_NUMBER(NULL) , NULL, MSI.UNIT_WEIGHT, MIA.UNIT_WEIGHT)UNIT_WEIGHT, decode(MIA.UNIT_VOLUME, -23453 , TO_NUMBER(NULL) , NULL, MSI.UNIT_VOLUME, MIA.UNIT_VOLUME)UNIT_VOLUME, NVL(MIA.WEIGHT_UOM,MSI.WEIGHT_UOM) , NVL(MIA.VOLUME_UOM,MSI.VOLUME_UOM) , MSI.PRODUCT_FAMILY_ID , MSI.ATP_RULE_ID , NVL(MIA.ATP_COMPONENTS_FLAG,MSI.ATP_COMPONENTS_FLAG) , MSI.BUILD_IN_WIP_FLAG , MSI.PURCHASING_ENABLED_FLAG , NVL(MIA.PLANNING_MAKE_BUY_CODE,MSI.PLANNING_MAKE_BUY_CODE) , MSI.REPETITIVE_TYPE , MSI.REPETITIVE_VARIANCE , decode(MIA.STANDARD_COST, -23453 , TO_NUMBER(NULL) , NULL, MSI.STANDARD_COST, MIA.STANDARD_COST)STANDARD_COST, decode(MIA.CARRYING_COST, -23453 , TO_NUMBER(NULL) , NULL, MSI.CARRYING_COST, MIA.CARRYING_COST)CARRYING_COST, MSI.ORDER_COST , MSI.MATERIAL_COST , MSI.DMD_LATENESS_COST , MSI.RESOURCE_COST , MSI.SS_PENALTY_COST , MSI.SUPPLIER_CAP_OVERUTIL_COST , decode(MIA.LIST_PRICE, -23453 , TO_NUMBER(NULL) , NULL, MSI.LIST_PRICE, MIA.LIST_PRICE)LIST_PRICE, MSI.AVERAGE_DISCOUNT , MSI.ENGINEERING_ITEM_FLAG , MSI.WIP_SUPPLY_TYPE , NVL(MIA.SAFETY_STOCK_CODE,MSI.SAFETY_STOCK_CODE) , decode(MIA.SAFETY_STOCK_PERCENT, -23453 , TO_NUMBER(NULL) , NULL, MSI.SAFETY_STOCK_PERCENT, MIA.SAFETY_STOCK_PERCENT)SAFETY_STOCK_PERCENT, decode(MIA.SAFETY_STOCK_BUCKET_DAYS, -23453 , TO_NUMBER(NULL) , NULL, MSI.SAFETY_STOCK_BUCKET_DAYS, MIA.SAFETY_STOCK_BUCKET_DAYS)SAFETY_STOCK_BUCKET_DAYS, MSI.INVENTORY_USE_UP_DATE , MSI.BUYER_NAME , NVL( MIA.PLANNER_CODE, MSI.PLANNER_CODE ) , NVL(MIA.PLANNING_EXCEPTION_SET,MSI.PLANNING_EXCEPTION_SET) , MSI.EXCESS_QUANTITY , MSI.EXCEPTION_SHORTAGE_DAYS , MSI.EXCEPTION_EXCESS_DAYS , MSI.EXCEPTION_OVERPROMISED_DAYS , MSI.EXCEPTION_CODE , MSI.BOM_ITEM_TYPE , NVL(MIA.ATO_FORECAST_CONTROL,MSI.ATO_FORECAST_CONTROL) , MSI.EFFECTIVITY_CONTROL , MSI.ORGANIZATION_CODE , MSI.ACCEPTABLE_RATE_INCREASE , MSI.ACCEPTABLE_RATE_DECREASE , MSI.EXCEPTION_REP_VARIANCE_DAYS , MSI.OVERRUN_PERCENTAGE , MSI.INVENTORY_PLANNING_CODE , MSI.ACCEPTABLE_EARLY_DELIVERY , MSI.CALCULATE_ATP , MSI.END_ASSEMBLY_PEGGING_FLAG , MSI.END_ASSEMBLY_PEGGING , MSI.FULL_PEGGING , MSI.INVENTORY_ITEM_FLAG , MSI.SOURCE_ORG_ID , MSI.BASE_ITEM_ID , NVL(MIA.ABC_CLASS_NAME,MSI.ABC_CLASS_NAME) , MSI.FIXED_SAFETY_STOCK_QTY , MSI.PRIMARY_SUPPLIER_ID , NVL(MIA.ATP_FLAG,MSI.ATP_FLAG) , MSI.LOW_LEVEL_CODE , MSI.PLANNER_STATUS_CODE , MSI.NETTABLE_INVENTORY_QUANTITY , MSI.NONNETTABLE_INVENTORY_QUANTITY , MSI.REFRESH_NUMBER , MSI.LAST_UPDATE_DATE , MSI.LAST_UPDATED_BY , MSI.CREATION_DATE , MSI.CREATED_BY , MSI.LAST_UPDATE_LOGIN , MSI.REQUEST_ID , MSI.PROGRAM_APPLICATION_ID , MSI.PROGRAM_ID , MSI.PROGRAM_UPDATE_DATE , MSI.ATTRIBUTE_CATEGORY , MSI.ATTRIBUTE1 , MSI.ATTRIBUTE2 , MSI.ATTRIBUTE3 , MSI.ATTRIBUTE4 , MSI.ATTRIBUTE5 , MSI.ATTRIBUTE6 , MSI.ATTRIBUTE7 , MSI.ATTRIBUTE8 , MSI.ATTRIBUTE9 , MSI.ATTRIBUTE10 , MSI.ATTRIBUTE11 , MSI.ATTRIBUTE12 , MSI.ATTRIBUTE13 , MSI.ATTRIBUTE14 , MSI.ATTRIBUTE15 , MSI.REVISION_QTY_CONTROL_CODE , MSI.EXPENSE_ACCOUNT , MSI.INVENTORY_ASSET_FLAG , MSI.BUYER_ID , MSI.REPETITIVE_PLANNING_FLAG , MSI.PICK_COMPONENTS_FLAG , decode(MIA.SERVICE_LEVEL, -23453 , TO_NUMBER(NULL) , NULL, MSI.SERVICE_LEVEL, MIA.SERVICE_LEVEL)SERVICE_LEVEL, MSI.REPLENISH_TO_ORDER_FLAG , NVL(MIA.PIP_FLAG,MSI.PIP_FLAG) , MSI.YIELD_CONV_FACTOR , MSI.MIN_MINMAX_QUANTITY , MSI.MAX_MINMAX_QUANTITY , MSI.NEW_ATP_FLAG , MSI.SOURCE_TYPE , decode(MIA.SUBSTITUTION_WINDOW, -23453 , TO_NUMBER(NULL) , NULL, MSI.SUBSTITUTION_WINDOW, MIA.SUBSTITUTION_WINDOW)SUBSTITUTION_WINDOW, NVL(MIA.CREATE_SUPPLY_FLAG,MSI.CREATE_SUPPLY_FLAG) , MSI.REORDER_POINT , MSI.AVERAGE_ANNUAL_DEMAND , MSI.ECONOMIC_ORDER_QUANTITY , MSI.SERIAL_NUMBER_CONTROL_CODE , NVL(MIA.CONVERGENCE,MSI.CONVERGENCE) , NVL(MIA.DIVERGENCE,MSI.DIVERGENCE) , NVL(MIA.CONTINOUS_TRANSFER,MSI.CONTINOUS_TRANSFER) , NVL(MIA.CRITICAL_COMPONENT_FLAG,MSI.CRITICAL_COMPONENT_FLAG) , MSI.REDUCE_MPS , NVL(MIA.CONSIGNED_FLAG,MSI.CONSIGNED_FLAG) , decode(MIA.VMI_MINIMUM_UNITS, -23453 , TO_NUMBER(NULL) , NULL, MSI.VMI_MINIMUM_UNITS, MIA.VMI_MINIMUM_UNITS)VMI_MINIMUM_UNITS, decode(MIA.VMI_MINIMUM_DAYS, -23453 , TO_NUMBER(NULL) , NULL, MSI.VMI_MINIMUM_DAYS, MIA.VMI_MINIMUM_DAYS)VMI_MINIMUM_DAYS, decode(MIA.VMI_MAXIMUM_UNITS, -23453 , TO_NUMBER(NULL) , NULL, MSI.VMI_MAXIMUM_UNITS, MIA.VMI_MAXIMUM_UNITS)VMI_MAXIMUM_UNITS, decode(MIA.VMI_MAXIMUM_DAYS, -23453 , TO_NUMBER(NULL) , NULL, MSI.VMI_MAXIMUM_DAYS, MIA.VMI_MAXIMUM_UNITS)VMI_MAXIMUM_UNITS, MSI.AVERAGE_DAILY_DEMAND , decode(MIA.VMI_FIXED_ORDER_QUANTITY, -23453 , TO_NUMBER(NULL) , NULL, MSI.VMI_FIXED_ORDER_QUANTITY, MIA.VMI_FIXED_ORDER_QUANTITY)VMI_FIXED_ORDER_QUANTITY, MSI.SO_AUTHORIZATION_FLAG , MSI.VMI_FORECAST_TYPE , MSI.FORECAST_HORIZON , MSI.ASN_AUTOEXPIRE_FLAG , MSI.VMI_REFRESH_FLAG , MSI.BUDGET_CONSTRAINED , MSI.MAX_QUANTITY , MSI.MAX_QUANTITY_DOS , decode(MIA.DAYS_TGT_INV_WINDOW, -23453 , TO_NUMBER(NULL) , NULL, MSI.DAYS_TGT_INV_WINDOW, MIA.DAYS_TGT_INV_WINDOW)DAYS_TGT_INV_WINDOW, decode(MIA.DAYS_MAX_INV_SUPPLY, -23453 , TO_NUMBER(NULL) , NULL, MSI.DAYS_MAX_INV_SUPPLY, MIA.DAYS_MAX_INV_SUPPLY)DAYS_MAX_INV_SUPPLY, decode(MIA.DAYS_MAX_INV_WINDOW, -23453 , TO_NUMBER(NULL) , NULL, MSI.DAYS_MAX_INV_WINDOW, MIA.DAYS_MAX_INV_WINDOW)DAYS_MAX_INV_WINDOW, decode(MIA.DAYS_TGT_INV_SUPPLY, -23453 , TO_NUMBER(NULL) , NULL, MSI.DAYS_TGT_INV_SUPPLY, MIA.DAYS_TGT_INV_SUPPLY)DAYS_TGT_INV_SUPPLY, NVL(MIA.DRP_PLANNED,MSI.DRP_PLANNED) , MSI.AGGREGATE_TIME_FENCE_DATE , MSI.INFERRED_CRITICAL_FLAG , MSI.SS_WINDOW_SIZE , MSI.LOWEST_LEVEL_SRC , MSI.EAM_ITEM_TYPE , MSI.LOTS_EXIST , NVL(MIA.LEADTIME_VARIABILITY, MSI.LEADTIME_VARIABILITY ) , decode(MIA.MIN_SHELF_LIFE_DAYS, -23453 , TO_NUMBER(NULL) , NULL, MSI.MIN_SHELF_LIFE_DAYS, MIA.MIN_SHELF_LIFE_DAYS)MIN_SHELF_LIFE_DAYS, MSI.GROUP_ID , NVL(MIA.REPAIR_YIELD, MSI.REPAIR_YIELD) , MSI.REPAIR_PROGRAM , NVL(MIA.REPAIR_LEAD_TIME, MSI.REPAIR_LEAD_TIME) , MSI.PRE_POSITION_INVENTORY , MSI.PREPOSITION_POINT , decode(MIA.DEMAND_FULFILLMENT_LT, -23453 , TO_NUMBER(NULL) , NULL, MSI.DEMAND_FULFILLMENT_LT, MIA.DEMAND_FULFILLMENT_LT)DEMAND_FULFILLMENT_LT, MSI.FORECAST_RULE_FOR_DEMANDS, MSI.FORECAST_RULE_FOR_RETURNS, MSI.DEMAND_DISTRIBUTION, MSI.INTERARRIVAL_TIME, NVL(MIA.REPAIR_COST, MSI.REPAIR_COST), MSI.LIFE_TIME_BUY_DATE, MSI.END_OF_LIFE_DATE, MSI.STD_DMD_OVER_HORIZON, NVL(mia.coefficient_of_variation, msi.coefficient_of_variation ), NVL(mia.avg_demand_beyond_ph, msi.avg_demand_beyond_ph ), NVL(mia.avg_returns_beyond_ph, msi.avg_returns_beyond_ph ), NVL(mia.return_forecast_time_fence, msi.return_forecast_time_fence ), NVL(mia.defective_item_cost, msi.defective_item_cost ), NVL(mia.basis_avg_daily_demand, msi.basis_avg_daily_demand ), NVL(mia.std_deviation_for_demand, msi.std_deviation_for_demand ), NVL(mia.mean_inter_arrival, msi.mean_inter_arrival ), NVL(mia.std_deviation_inter_arrival, msi.std_deviation_inter_arrival ), NVL(mia.standard_deviation, msi.standard_deviation ), NVL(mia.interarrival_dist_method, msi.interarrival_dist_method ), NVL(mia.safety_lead_time,msi.safety_lead_time), NVL(mia.unsatisfied_demand_factor,msi.unsatisfied_demand_factor), MSI.planning_time_fence_code, NVL(mia.max_usage_factor,msi.max_usage_factor), mia.min_sup_dem_percent, mia.dmd_satisfied_percent, mia.min_rem_shelf_life_days, NVL(mia.new_planned_order, 1), msi.PEGGING_DEMAND_WINDOW_DAYS, msi.PEGGING_SUPPLY_WINDOW_DAYS, MIA.scrap_rate, MIA.repair_module, MIA.rebuild_activity, MIA.order_period, MIA.inv_days_increment FROM MSC_PLANS MP, MSC_ITEM_ATTRIBUTES MIA, MSC_SYSTEM_ITEMS MSI WHERE MIA.PLAN_ID = -1 AND MP.ITEM_SIMULATION_SET_ID IS NOT NULL AND MP.ITEM_SIMULATION_SET_ID = MIA.SIMULATION_SET_ID AND MSI.PLAN_ID = MIA.PLAN_ID AND MSI.INVENTORY_ITEM_ID = MIA.INVENTORY_ITEM_ID AND MSI.ORGANIZATION_ID = MIA.ORGANIZATION_ID AND MSI.SR_INSTANCE_ID = MIA.SR_INSTANCE_ID AND MIA.region_id IS NULL AND MIA.customer_id IS NULL UNION ALL SELECT MSI.PLAN_ID , MP.PLAN_ID PDS_PLAN_ID , MP.ITEM_SIMULATION_SET_ID , MSI.ORGANIZATION_ID , MSI.INVENTORY_ITEM_ID , MSI.SR_INSTANCE_ID , MSI.SR_INVENTORY_ITEM_ID , MSI.ITEM_NAME , MSI.LOTS_EXPIRATION , MSI.LOT_CONTROL_CODE , MSI.SHRINKAGE_RATE , MSI.FIXED_DAYS_SUPPLY , MSI.FIXED_ORDER_QUANTITY , MSI.FIXED_LOT_MULTIPLIER , MSI.MINIMUM_ORDER_QUANTITY , MSI.MAXIMUM_ORDER_QUANTITY , MSI.ROUNDING_CONTROL_TYPE , MSI.PLANNING_TIME_FENCE_DAYS , MSI.PLANNING_TIME_FENCE_DATE , MSI.DEMAND_TIME_FENCE_DAYS , MSI.DEMAND_TIME_FENCE_DATE , MSI.DESCRIPTION , MSI.RELEASE_TIME_FENCE_CODE , MSI.RELEASE_TIME_FENCE_DAYS , MSI.IN_SOURCE_PLAN , MSI.REVISION , MSI.SR_CATEGORY_ID , MSI.ABC_CLASS , MSI.CATEGORY_NAME , MSI.MRP_PLANNING_CODE , MSI.FIXED_LEAD_TIME , MSI.VARIABLE_LEAD_TIME , MSI.PREPROCESSING_LEAD_TIME , MSI.POSTPROCESSING_LEAD_TIME , MSI.FULL_LEAD_TIME , MSI.CUMULATIVE_TOTAL_LEAD_TIME , MSI.CUM_MANUFACTURING_LEAD_TIME , MSI.UOM_CODE , MSI.UNIT_WEIGHT , MSI.UNIT_VOLUME , MSI.WEIGHT_UOM , MSI.VOLUME_UOM , MSI.PRODUCT_FAMILY_ID , MSI.ATP_RULE_ID , MSI.ATP_COMPONENTS_FLAG , MSI.BUILD_IN_WIP_FLAG , MSI.PURCHASING_ENABLED_FLAG , MSI.PLANNING_MAKE_BUY_CODE , MSI.REPETITIVE_TYPE , MSI.REPETITIVE_VARIANCE , MSI.STANDARD_COST , MSI.CARRYING_COST , MSI.ORDER_COST , MSI.MATERIAL_COST , MSI.DMD_LATENESS_COST , MSI.RESOURCE_COST , MSI.SS_PENALTY_COST , MSI.SUPPLIER_CAP_OVERUTIL_COST , MSI.LIST_PRICE , MSI.AVERAGE_DISCOUNT , MSI.ENGINEERING_ITEM_FLAG , MSI.WIP_SUPPLY_TYPE , MSI.SAFETY_STOCK_CODE , MSI.SAFETY_STOCK_PERCENT , MSI.SAFETY_STOCK_BUCKET_DAYS , MSI.INVENTORY_USE_UP_DATE , MSI.BUYER_NAME , MSI.PLANNER_CODE , MSI.PLANNING_EXCEPTION_SET , MSI.EXCESS_QUANTITY , MSI.EXCEPTION_SHORTAGE_DAYS , MSI.EXCEPTION_EXCESS_DAYS , MSI.EXCEPTION_OVERPROMISED_DAYS , MSI.EXCEPTION_CODE , MSI.BOM_ITEM_TYPE , MSI.ATO_FORECAST_CONTROL , MSI.EFFECTIVITY_CONTROL , MSI.ORGANIZATION_CODE , MSI.ACCEPTABLE_RATE_INCREASE , MSI.ACCEPTABLE_RATE_DECREASE , MSI.EXCEPTION_REP_VARIANCE_DAYS , MSI.OVERRUN_PERCENTAGE , MSI.INVENTORY_PLANNING_CODE , MSI.ACCEPTABLE_EARLY_DELIVERY , MSI.CALCULATE_ATP , MSI.END_ASSEMBLY_PEGGING_FLAG , MSI.END_ASSEMBLY_PEGGING , MSI.FULL_PEGGING , MSI.INVENTORY_ITEM_FLAG , MSI.SOURCE_ORG_ID , MSI.BASE_ITEM_ID , MSI.ABC_CLASS_NAME , MSI.FIXED_SAFETY_STOCK_QTY , MSI.PRIMARY_SUPPLIER_ID , MSI.ATP_FLAG , MSI.LOW_LEVEL_CODE , MSI.PLANNER_STATUS_CODE , MSI.NETTABLE_INVENTORY_QUANTITY , MSI.NONNETTABLE_INVENTORY_QUANTITY , MSI.REFRESH_NUMBER , MSI.LAST_UPDATE_DATE , MSI.LAST_UPDATED_BY , MSI.CREATION_DATE , MSI.CREATED_BY , MSI.LAST_UPDATE_LOGIN , MSI.REQUEST_ID , MSI.PROGRAM_APPLICATION_ID , MSI.PROGRAM_ID , MSI.PROGRAM_UPDATE_DATE , MSI.ATTRIBUTE_CATEGORY , MSI.ATTRIBUTE1 , MSI.ATTRIBUTE2 , MSI.ATTRIBUTE3 , MSI.ATTRIBUTE4 , MSI.ATTRIBUTE5 , MSI.ATTRIBUTE6 , MSI.ATTRIBUTE7 , MSI.ATTRIBUTE8 , MSI.ATTRIBUTE9 , MSI.ATTRIBUTE10 , MSI.ATTRIBUTE11 , MSI.ATTRIBUTE12 , MSI.ATTRIBUTE13 , MSI.ATTRIBUTE14 , MSI.ATTRIBUTE15 , MSI.REVISION_QTY_CONTROL_CODE , MSI.EXPENSE_ACCOUNT , MSI.INVENTORY_ASSET_FLAG , MSI.BUYER_ID , MSI.REPETITIVE_PLANNING_FLAG , MSI.PICK_COMPONENTS_FLAG , MSI.SERVICE_LEVEL , MSI.REPLENISH_TO_ORDER_FLAG , MSI.PIP_FLAG , MSI.YIELD_CONV_FACTOR , MSI.MIN_MINMAX_QUANTITY , MSI.MAX_MINMAX_QUANTITY , MSI.NEW_ATP_FLAG , MSI.SOURCE_TYPE , MSI.SUBSTITUTION_WINDOW , MSI.CREATE_SUPPLY_FLAG , MSI.REORDER_POINT , MSI.AVERAGE_ANNUAL_DEMAND , MSI.ECONOMIC_ORDER_QUANTITY , MSI.SERIAL_NUMBER_CONTROL_CODE , MSI.CONVERGENCE , MSI.DIVERGENCE , MSI.CONTINOUS_TRANSFER , MSI.CRITICAL_COMPONENT_FLAG , MSI.REDUCE_MPS , MSI.CONSIGNED_FLAG , MSI.VMI_MINIMUM_UNITS , MSI.VMI_MINIMUM_DAYS , MSI.VMI_MAXIMUM_UNITS , MSI.VMI_MAXIMUM_DAYS , MSI.AVERAGE_DAILY_DEMAND , MSI.VMI_FIXED_ORDER_QUANTITY , MSI.SO_AUTHORIZATION_FLAG , MSI.VMI_FORECAST_TYPE , MSI.FORECAST_HORIZON , MSI.ASN_AUTOEXPIRE_FLAG , MSI.VMI_REFRESH_FLAG , MSI.BUDGET_CONSTRAINED , MSI.MAX_QUANTITY , MSI.MAX_QUANTITY_DOS , MSI.DAYS_TGT_INV_WINDOW , MSI.DAYS_MAX_INV_WINDOW , MSI.DAYS_TGT_INV_SUPPLY , MSI.DAYS_MAX_INV_SUPPLY , MSI.DRP_PLANNED , MSI.AGGREGATE_TIME_FENCE_DATE , MSI.INFERRED_CRITICAL_FLAG , MSI.SS_WINDOW_SIZE , MSI.LOWEST_LEVEL_SRC , MSI.EAM_ITEM_TYPE , MSI.LOTS_EXIST , MSI.LEADTIME_VARIABILITY , MSI.MIN_SHELF_LIFE_DAYS , MSI.GROUP_ID , MSI.REPAIR_YIELD , MSI.REPAIR_PROGRAM , MSI.REPAIR_LEAD_TIME , MSI.PRE_POSITION_INVENTORY , MSI.PREPOSITION_POINT , MSI.DEMAND_FULFILLMENT_LT, MSI.FORECAST_RULE_FOR_DEMANDS, MSI.FORECAST_RULE_FOR_RETURNS, MSI.DEMAND_DISTRIBUTION, MSI.INTERARRIVAL_TIME, MSI.REPAIR_COST, MSI.LIFE_TIME_BUY_DATE, MSI.END_OF_LIFE_DATE, MSI.STD_DMD_OVER_HORIZON, msi.coefficient_of_variation, msi.avg_demand_beyond_ph, msi.avg_returns_beyond_ph, msi.return_forecast_time_fence, msi.defective_item_cost, msi.basis_avg_daily_demand, msi.std_deviation_for_demand, msi.mean_inter_arrival, msi.std_deviation_inter_arrival, msi.standard_deviation, msi.interarrival_dist_method, msi.safety_lead_time, msi.unsatisfied_demand_factor, msi.planning_time_fence_code, msi.max_usage_factor, msi.min_sup_dem_percent, msi.dmd_satisfied_percent, NULL MIN_REM_SHELF_LIFE_DAYS, 1 NEW_PLANNED_ORDER, msi.PEGGING_DEMAND_WINDOW_DAYS, msi.PEGGING_SUPPLY_WINDOW_DAYS, NULL scrap_rate, NULL repair_module, NULL rebuild_activity, NULL order_period, NULL inv_days_increment FROM MSC_SYSTEM_ITEMS MSI, MSC_PLANS MP WHERE MP.PLAN_ID <> -1 AND MP.PLAN_ID = MSI.PLAN_ID

View Text - HTML Formatted

SELECT MSI.PLAN_ID
, MP.PLAN_ID PDS_PLAN_ID
, MP.ITEM_SIMULATION_SET_ID
, MSI.ORGANIZATION_ID
, MSI.INVENTORY_ITEM_ID
, MSI.SR_INSTANCE_ID
, MSI.SR_INVENTORY_ITEM_ID
, MSI.ITEM_NAME
, MSI.LOTS_EXPIRATION
, MSI.LOT_CONTROL_CODE
, MSI.SHRINKAGE_RATE
, MSI.FIXED_DAYS_SUPPLY
, MSI.FIXED_ORDER_QUANTITY
, MSI.FIXED_LOT_MULTIPLIER
, MSI.MINIMUM_ORDER_QUANTITY
, MSI.MAXIMUM_ORDER_QUANTITY
, MSI.ROUNDING_CONTROL_TYPE
, MSI.PLANNING_TIME_FENCE_DAYS
, MSI.PLANNING_TIME_FENCE_DATE
, MSI.DEMAND_TIME_FENCE_DAYS
, MSI.DEMAND_TIME_FENCE_DATE
, MSI.DESCRIPTION
, MSI.RELEASE_TIME_FENCE_CODE
, MSI.RELEASE_TIME_FENCE_DAYS
, MSI.IN_SOURCE_PLAN
, MSI.REVISION
, MSI.SR_CATEGORY_ID
, MSI.ABC_CLASS
, MSI.CATEGORY_NAME
, MSI.MRP_PLANNING_CODE
, MSI.FIXED_LEAD_TIME
, MSI.VARIABLE_LEAD_TIME
, MSI.PREPROCESSING_LEAD_TIME
, MSI.POSTPROCESSING_LEAD_TIME
, MSI.FULL_LEAD_TIME
, MSI.CUMULATIVE_TOTAL_LEAD_TIME
, MSI.CUM_MANUFACTURING_LEAD_TIME
, MSI.UOM_CODE
, MSI.UNIT_WEIGHT
, MSI.UNIT_VOLUME
, MSI.WEIGHT_UOM
, MSI.VOLUME_UOM
, MSI.PRODUCT_FAMILY_ID
, MSI.ATP_RULE_ID
, MSI.ATP_COMPONENTS_FLAG
, MSI.BUILD_IN_WIP_FLAG
, MSI.PURCHASING_ENABLED_FLAG
, MSI.PLANNING_MAKE_BUY_CODE
, MSI.REPETITIVE_TYPE
, MSI.REPETITIVE_VARIANCE
, MSI.STANDARD_COST
, MSI.CARRYING_COST
, MSI.ORDER_COST
, MSI.MATERIAL_COST
, MSI.DMD_LATENESS_COST
, MSI.RESOURCE_COST
, MSI.SS_PENALTY_COST
, MSI.SUPPLIER_CAP_OVERUTIL_COST
, MSI.LIST_PRICE
, MSI.AVERAGE_DISCOUNT
, MSI.ENGINEERING_ITEM_FLAG
, MSI.WIP_SUPPLY_TYPE
, MSI.SAFETY_STOCK_CODE
, MSI.SAFETY_STOCK_PERCENT
, MSI.SAFETY_STOCK_BUCKET_DAYS
, MSI.INVENTORY_USE_UP_DATE
, MSI.BUYER_NAME
, MSI.PLANNER_CODE
, MSI.PLANNING_EXCEPTION_SET
, MSI.EXCESS_QUANTITY
, MSI.EXCEPTION_SHORTAGE_DAYS
, MSI.EXCEPTION_EXCESS_DAYS
, MSI.EXCEPTION_OVERPROMISED_DAYS
, MSI.EXCEPTION_CODE
, MSI.BOM_ITEM_TYPE
, MSI.ATO_FORECAST_CONTROL
, MSI.EFFECTIVITY_CONTROL
, MSI.ORGANIZATION_CODE
, MSI.ACCEPTABLE_RATE_INCREASE
, MSI.ACCEPTABLE_RATE_DECREASE
, MSI.EXCEPTION_REP_VARIANCE_DAYS
, MSI.OVERRUN_PERCENTAGE
, MSI.INVENTORY_PLANNING_CODE
, MSI.ACCEPTABLE_EARLY_DELIVERY
, MSI.CALCULATE_ATP
, MSI.END_ASSEMBLY_PEGGING_FLAG
, MSI.END_ASSEMBLY_PEGGING
, MSI.FULL_PEGGING
, MSI.INVENTORY_ITEM_FLAG
, MSI.SOURCE_ORG_ID
, MSI.BASE_ITEM_ID
, MSI.ABC_CLASS_NAME
, MSI.FIXED_SAFETY_STOCK_QTY
, MSI.PRIMARY_SUPPLIER_ID
, MSI.ATP_FLAG
, MSI.LOW_LEVEL_CODE
, MSI.PLANNER_STATUS_CODE
, MSI.NETTABLE_INVENTORY_QUANTITY
, MSI.NONNETTABLE_INVENTORY_QUANTITY
, MSI.REFRESH_NUMBER
, MSI.LAST_UPDATE_DATE
, MSI.LAST_UPDATED_BY
, MSI.CREATION_DATE
, MSI.CREATED_BY
, MSI.LAST_UPDATE_LOGIN
, MSI.REQUEST_ID
, MSI.PROGRAM_APPLICATION_ID
, MSI.PROGRAM_ID
, MSI.PROGRAM_UPDATE_DATE
, MSI.ATTRIBUTE_CATEGORY
, MSI.ATTRIBUTE1
, MSI.ATTRIBUTE2
, MSI.ATTRIBUTE3
, MSI.ATTRIBUTE4
, MSI.ATTRIBUTE5
, MSI.ATTRIBUTE6
, MSI.ATTRIBUTE7
, MSI.ATTRIBUTE8
, MSI.ATTRIBUTE9
, MSI.ATTRIBUTE10
, MSI.ATTRIBUTE11
, MSI.ATTRIBUTE12
, MSI.ATTRIBUTE13
, MSI.ATTRIBUTE14
, MSI.ATTRIBUTE15
, MSI.REVISION_QTY_CONTROL_CODE
, MSI.EXPENSE_ACCOUNT
, MSI.INVENTORY_ASSET_FLAG
, MSI.BUYER_ID
, MSI.REPETITIVE_PLANNING_FLAG
, MSI.PICK_COMPONENTS_FLAG
, MSI.SERVICE_LEVEL
, MSI.REPLENISH_TO_ORDER_FLAG
, MSI.PIP_FLAG
, MSI.YIELD_CONV_FACTOR
, MSI.MIN_MINMAX_QUANTITY
, MSI.MAX_MINMAX_QUANTITY
, MSI.NEW_ATP_FLAG
, MSI.SOURCE_TYPE
, MSI.SUBSTITUTION_WINDOW
, MSI.CREATE_SUPPLY_FLAG
, MSI.REORDER_POINT
, MSI.AVERAGE_ANNUAL_DEMAND
, MSI.ECONOMIC_ORDER_QUANTITY
, MSI.SERIAL_NUMBER_CONTROL_CODE
, MSI.CONVERGENCE
, MSI.DIVERGENCE
, MSI.CONTINOUS_TRANSFER
, MSI.CRITICAL_COMPONENT_FLAG
, MSI.REDUCE_MPS
, MSI.CONSIGNED_FLAG
, MSI.VMI_MINIMUM_UNITS
, MSI.VMI_MINIMUM_DAYS
, MSI.VMI_MAXIMUM_UNITS
, MSI.VMI_MAXIMUM_DAYS
, MSI.AVERAGE_DAILY_DEMAND
, MSI.VMI_FIXED_ORDER_QUANTITY
, MSI.SO_AUTHORIZATION_FLAG
, MSI.VMI_FORECAST_TYPE
, MSI.FORECAST_HORIZON
, MSI.ASN_AUTOEXPIRE_FLAG
, MSI.VMI_REFRESH_FLAG
, MSI.BUDGET_CONSTRAINED
, MSI.MAX_QUANTITY
, MSI.MAX_QUANTITY_DOS
, MSI.DAYS_TGT_INV_WINDOW
, MSI.DAYS_MAX_INV_WINDOW
, MSI.DAYS_TGT_INV_SUPPLY
, MSI.DAYS_MAX_INV_SUPPLY
, MSI.DRP_PLANNED
, MSI.AGGREGATE_TIME_FENCE_DATE
, MSI.INFERRED_CRITICAL_FLAG
, MSI.SS_WINDOW_SIZE
, MSI.LOWEST_LEVEL_SRC
, MSI.EAM_ITEM_TYPE
, MSI.LOTS_EXIST
, MSI.LEADTIME_VARIABILITY
, MSI.MIN_SHELF_LIFE_DAYS
, MSI.GROUP_ID
, MSI.REPAIR_YIELD
, MSI.REPAIR_PROGRAM
, MSI.REPAIR_LEAD_TIME
, MSI.PRE_POSITION_INVENTORY
, MSI.PREPOSITION_POINT
, MSI.DEMAND_FULFILLMENT_LT
, MSI.FORECAST_RULE_FOR_DEMANDS
, MSI.FORECAST_RULE_FOR_RETURNS
, MSI.DEMAND_DISTRIBUTION
, MSI.INTERARRIVAL_TIME
, MSI.REPAIR_COST
, MSI.LIFE_TIME_BUY_DATE
, MSI.END_OF_LIFE_DATE
, MSI.STD_DMD_OVER_HORIZON
, MSI.COEFFICIENT_OF_VARIATION
, MSI.AVG_DEMAND_BEYOND_PH
, MSI.AVG_RETURNS_BEYOND_PH
, MSI.RETURN_FORECAST_TIME_FENCE
, MSI.DEFECTIVE_ITEM_COST
, MSI.BASIS_AVG_DAILY_DEMAND
, MSI.STD_DEVIATION_FOR_DEMAND
, MSI.MEAN_INTER_ARRIVAL
, MSI.STD_DEVIATION_INTER_ARRIVAL
, MSI.STANDARD_DEVIATION
, MSI.INTERARRIVAL_DIST_METHOD
, MSI.SAFETY_LEAD_TIME
, MSI.UNSATISFIED_DEMAND_FACTOR
, MSI.PLANNING_TIME_FENCE_CODE
, MSI.MAX_USAGE_FACTOR
, MSI.MIN_SUP_DEM_PERCENT
, MSI.DMD_SATISFIED_PERCENT
, NULL MIN_REM_SHELF_LIFE_DAYS
, 1 NEW_PLANNED_ORDER
, MSI.PEGGING_DEMAND_WINDOW_DAYS
, MSI.PEGGING_SUPPLY_WINDOW_DAYS
, NULL SCRAP_RATE
, NULL REPAIR_MODULE
, NULL REBUILD_ACTIVITY
, NULL ORDER_PERIOD
, NULL INV_DAYS_INCREMENT
FROM MSC_SYSTEM_ITEMS MSI
, MSC_PLANS MP
WHERE MSI.PLAN_ID = -1
AND (MP.ITEM_SIMULATION_SET_ID IS NULL /* OR NOT EXISTS (SELECT 1
FROM MSC_ITEM_ATTRIBUTES MIA
WHERE MIA.PLAN_ID = -1
AND MP.ITEM_SIMULATION_SET_ID IS NOT NULL
AND MP.ITEM_SIMULATION_SET_ID = MIA.SIMULATION_SET_ID
AND MSI.INVENTORY_ITEM_ID = MIA.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID = MIA.ORGANIZATION_ID
AND MSI.SR_INSTANCE_ID = MIA.SR_INSTANCE_ID ) */ OR (MSI.INVENTORY_ITEM_ID
, MSI.ORGANIZATION_ID
, MSI.SR_INSTANCE_ID) NOT IN (SELECT MIA.INVENTORY_ITEM_ID
, MIA.ORGANIZATION_ID
, MIA.SR_INSTANCE_ID
FROM MSC_ITEM_ATTRIBUTES MIA
WHERE MIA.PLAN_ID = -1
AND MP.ITEM_SIMULATION_SET_ID IS NOT NULL
AND MP.ITEM_SIMULATION_SET_ID = MIA.SIMULATION_SET_ID
AND MIA.REGION_ID IS NULL
AND MIA.CUSTOMER_ID IS NULL) ) UNION ALL SELECT /*+ ORDERED INDEX(MIA MSC_ITEM_ATTRIBUTES_U2) */ MSI.PLAN_ID
, MP.PLAN_ID PDS_PLAN_ID
, MP.ITEM_SIMULATION_SET_ID
, MSI.ORGANIZATION_ID
, MSI.INVENTORY_ITEM_ID
, MSI.SR_INSTANCE_ID
, MSI.SR_INVENTORY_ITEM_ID
, MSI.ITEM_NAME
, MSI.LOTS_EXPIRATION
, MSI.LOT_CONTROL_CODE
, DECODE(MIA.SHRINKAGE_RATE
, -23453
, TO_NUMBER(NULL)
, NULL
, MSI.SHRINKAGE_RATE
, MIA.SHRINKAGE_RATE)SHRINKAGE_RATE
, DECODE(MIA.FIXED_DAYS_SUPPLY
, -23453
, TO_NUMBER(NULL)
, NULL
, MSI.FIXED_DAYS_SUPPLY
, MIA.FIXED_DAYS_SUPPLY)FIXED_DAYS_SUPPLY
, DECODE(MIA.FIXED_ORDER_QUANTITY
, -23453
, TO_NUMBER(NULL)
, NULL
, MSI.FIXED_ORDER_QUANTITY
, MIA.FIXED_ORDER_QUANTITY)FIXED_ORDER_QUANTITY
, DECODE(MIA.FIXED_LOT_MULTIPLIER
, -23453
, TO_NUMBER(NULL)
, NULL
, MSI.FIXED_LOT_MULTIPLIER
, MIA.FIXED_LOT_MULTIPLIER)FIXED_LOT_MULTIPLIER
, DECODE(MIA.MINIMUM_ORDER_QUANTITY
, -23453
, TO_NUMBER(NULL)
, NULL
, MSI.MINIMUM_ORDER_QUANTITY
, MIA.MINIMUM_ORDER_QUANTITY)MINIMUM_ORDER_QUANTITY
, DECODE(MIA.MAXIMUM_ORDER_QUANTITY
, -23453
, TO_NUMBER(NULL)
, NULL
, MSI.MAXIMUM_ORDER_QUANTITY
, MIA.MAXIMUM_ORDER_QUANTITY)MAXIMUM_ORDER_QUANTITY
, NVL(MIA.ROUNDING_CONTROL_TYPE
, MSI.ROUNDING_CONTROL_TYPE)
, DECODE(MIA.PLANNING_TIME_FENCE_DAYS
, -23453
, TO_NUMBER(NULL)
, NULL
, MSI.PLANNING_TIME_FENCE_DAYS
, MIA.PLANNING_TIME_FENCE_DAYS)PLANNING_TIME_FENCE_DAYS
, MSI.PLANNING_TIME_FENCE_DATE
, DECODE(MIA.DEMAND_TIME_FENCE_DAYS
, -23453
, TO_NUMBER(NULL)
, NULL
, MSI.DEMAND_TIME_FENCE_DAYS
, MIA.DEMAND_TIME_FENCE_DAYS)DEMAND_TIME_FENCE_DAYS
, MSI.DEMAND_TIME_FENCE_DATE
, MSI.DESCRIPTION
, MSI.RELEASE_TIME_FENCE_CODE
, MSI.RELEASE_TIME_FENCE_DAYS
, MSI.IN_SOURCE_PLAN
, MSI.REVISION
, MSI.SR_CATEGORY_ID
, NVL(MIA.ABC_CLASS
, MSI.ABC_CLASS)
, MSI.CATEGORY_NAME
, NVL(MIA.MRP_PLANNING_CODE
, MSI.MRP_PLANNING_CODE)
, DECODE(MIA.FIXED_LEAD_TIME
, -23453
, TO_NUMBER(NULL)
, NULL
, MSI.FIXED_LEAD_TIME
, MIA.FIXED_LEAD_TIME)FIXED_LEAD_TIME
, DECODE(MIA.VARIABLE_LEAD_TIME
, -23453
, TO_NUMBER(NULL)
, NULL
, MSI.VARIABLE_LEAD_TIME
, MIA.VARIABLE_LEAD_TIME)VARIABLE_LEAD_TIME
, DECODE(MIA.PREPROCESSING_LEAD_TIME
, -23453
, TO_NUMBER(NULL)
, NULL
, MSI.PREPROCESSING_LEAD_TIME
, MIA.PREPROCESSING_LEAD_TIME)PREPROCESSING_LEAD_TIME
, DECODE(MIA.POSTPROCESSING_LEAD_TIME
, -23453
, TO_NUMBER(NULL)
, NULL
, MSI.POSTPROCESSING_LEAD_TIME
, MIA.POSTPROCESSING_LEAD_TIME)POSTPROCESSING_LEAD_TIME
, DECODE(MIA.FULL_LEAD_TIME
, -23453
, TO_NUMBER(NULL)
, NULL
, MSI.FULL_LEAD_TIME
, MIA.FULL_LEAD_TIME)FULL_LEAD_TIME
, MSI.CUMULATIVE_TOTAL_LEAD_TIME
, MSI.CUM_MANUFACTURING_LEAD_TIME
, MSI.UOM_CODE
, DECODE(MIA.UNIT_WEIGHT
, -23453
, TO_NUMBER(NULL)
, NULL
, MSI.UNIT_WEIGHT
, MIA.UNIT_WEIGHT)UNIT_WEIGHT
, DECODE(MIA.UNIT_VOLUME
, -23453
, TO_NUMBER(NULL)
, NULL
, MSI.UNIT_VOLUME
, MIA.UNIT_VOLUME)UNIT_VOLUME
, NVL(MIA.WEIGHT_UOM
, MSI.WEIGHT_UOM)
, NVL(MIA.VOLUME_UOM
, MSI.VOLUME_UOM)
, MSI.PRODUCT_FAMILY_ID
, MSI.ATP_RULE_ID
, NVL(MIA.ATP_COMPONENTS_FLAG
, MSI.ATP_COMPONENTS_FLAG)
, MSI.BUILD_IN_WIP_FLAG
, MSI.PURCHASING_ENABLED_FLAG
, NVL(MIA.PLANNING_MAKE_BUY_CODE
, MSI.PLANNING_MAKE_BUY_CODE)
, MSI.REPETITIVE_TYPE
, MSI.REPETITIVE_VARIANCE
, DECODE(MIA.STANDARD_COST
, -23453
, TO_NUMBER(NULL)
, NULL
, MSI.STANDARD_COST
, MIA.STANDARD_COST)STANDARD_COST
, DECODE(MIA.CARRYING_COST
, -23453
, TO_NUMBER(NULL)
, NULL
, MSI.CARRYING_COST
, MIA.CARRYING_COST)CARRYING_COST
, MSI.ORDER_COST
, MSI.MATERIAL_COST
, MSI.DMD_LATENESS_COST
, MSI.RESOURCE_COST
, MSI.SS_PENALTY_COST
, MSI.SUPPLIER_CAP_OVERUTIL_COST
, DECODE(MIA.LIST_PRICE
, -23453
, TO_NUMBER(NULL)
, NULL
, MSI.LIST_PRICE
, MIA.LIST_PRICE)LIST_PRICE
, MSI.AVERAGE_DISCOUNT
, MSI.ENGINEERING_ITEM_FLAG
, MSI.WIP_SUPPLY_TYPE
, NVL(MIA.SAFETY_STOCK_CODE
, MSI.SAFETY_STOCK_CODE)
, DECODE(MIA.SAFETY_STOCK_PERCENT
, -23453
, TO_NUMBER(NULL)
, NULL
, MSI.SAFETY_STOCK_PERCENT
, MIA.SAFETY_STOCK_PERCENT)SAFETY_STOCK_PERCENT
, DECODE(MIA.SAFETY_STOCK_BUCKET_DAYS
, -23453
, TO_NUMBER(NULL)
, NULL
, MSI.SAFETY_STOCK_BUCKET_DAYS
, MIA.SAFETY_STOCK_BUCKET_DAYS)SAFETY_STOCK_BUCKET_DAYS
, MSI.INVENTORY_USE_UP_DATE
, MSI.BUYER_NAME
, NVL( MIA.PLANNER_CODE
, MSI.PLANNER_CODE )
, NVL(MIA.PLANNING_EXCEPTION_SET
, MSI.PLANNING_EXCEPTION_SET)
, MSI.EXCESS_QUANTITY
, MSI.EXCEPTION_SHORTAGE_DAYS
, MSI.EXCEPTION_EXCESS_DAYS
, MSI.EXCEPTION_OVERPROMISED_DAYS
, MSI.EXCEPTION_CODE
, MSI.BOM_ITEM_TYPE
, NVL(MIA.ATO_FORECAST_CONTROL
, MSI.ATO_FORECAST_CONTROL)
, MSI.EFFECTIVITY_CONTROL
, MSI.ORGANIZATION_CODE
, MSI.ACCEPTABLE_RATE_INCREASE
, MSI.ACCEPTABLE_RATE_DECREASE
, MSI.EXCEPTION_REP_VARIANCE_DAYS
, MSI.OVERRUN_PERCENTAGE
, MSI.INVENTORY_PLANNING_CODE
, MSI.ACCEPTABLE_EARLY_DELIVERY
, MSI.CALCULATE_ATP
, MSI.END_ASSEMBLY_PEGGING_FLAG
, MSI.END_ASSEMBLY_PEGGING
, MSI.FULL_PEGGING
, MSI.INVENTORY_ITEM_FLAG
, MSI.SOURCE_ORG_ID
, MSI.BASE_ITEM_ID
, NVL(MIA.ABC_CLASS_NAME
, MSI.ABC_CLASS_NAME)
, MSI.FIXED_SAFETY_STOCK_QTY
, MSI.PRIMARY_SUPPLIER_ID
, NVL(MIA.ATP_FLAG
, MSI.ATP_FLAG)
, MSI.LOW_LEVEL_CODE
, MSI.PLANNER_STATUS_CODE
, MSI.NETTABLE_INVENTORY_QUANTITY
, MSI.NONNETTABLE_INVENTORY_QUANTITY
, MSI.REFRESH_NUMBER
, MSI.LAST_UPDATE_DATE
, MSI.LAST_UPDATED_BY
, MSI.CREATION_DATE
, MSI.CREATED_BY
, MSI.LAST_UPDATE_LOGIN
, MSI.REQUEST_ID
, MSI.PROGRAM_APPLICATION_ID
, MSI.PROGRAM_ID
, MSI.PROGRAM_UPDATE_DATE
, MSI.ATTRIBUTE_CATEGORY
, MSI.ATTRIBUTE1
, MSI.ATTRIBUTE2
, MSI.ATTRIBUTE3
, MSI.ATTRIBUTE4
, MSI.ATTRIBUTE5
, MSI.ATTRIBUTE6
, MSI.ATTRIBUTE7
, MSI.ATTRIBUTE8
, MSI.ATTRIBUTE9
, MSI.ATTRIBUTE10
, MSI.ATTRIBUTE11
, MSI.ATTRIBUTE12
, MSI.ATTRIBUTE13
, MSI.ATTRIBUTE14
, MSI.ATTRIBUTE15
, MSI.REVISION_QTY_CONTROL_CODE
, MSI.EXPENSE_ACCOUNT
, MSI.INVENTORY_ASSET_FLAG
, MSI.BUYER_ID
, MSI.REPETITIVE_PLANNING_FLAG
, MSI.PICK_COMPONENTS_FLAG
, DECODE(MIA.SERVICE_LEVEL
, -23453
, TO_NUMBER(NULL)
, NULL
, MSI.SERVICE_LEVEL
, MIA.SERVICE_LEVEL)SERVICE_LEVEL
, MSI.REPLENISH_TO_ORDER_FLAG
, NVL(MIA.PIP_FLAG
, MSI.PIP_FLAG)
, MSI.YIELD_CONV_FACTOR
, MSI.MIN_MINMAX_QUANTITY
, MSI.MAX_MINMAX_QUANTITY
, MSI.NEW_ATP_FLAG
, MSI.SOURCE_TYPE
, DECODE(MIA.SUBSTITUTION_WINDOW
, -23453
, TO_NUMBER(NULL)
, NULL
, MSI.SUBSTITUTION_WINDOW
, MIA.SUBSTITUTION_WINDOW)SUBSTITUTION_WINDOW
, NVL(MIA.CREATE_SUPPLY_FLAG
, MSI.CREATE_SUPPLY_FLAG)
, MSI.REORDER_POINT
, MSI.AVERAGE_ANNUAL_DEMAND
, MSI.ECONOMIC_ORDER_QUANTITY
, MSI.SERIAL_NUMBER_CONTROL_CODE
, NVL(MIA.CONVERGENCE
, MSI.CONVERGENCE)
, NVL(MIA.DIVERGENCE
, MSI.DIVERGENCE)
, NVL(MIA.CONTINOUS_TRANSFER
, MSI.CONTINOUS_TRANSFER)
, NVL(MIA.CRITICAL_COMPONENT_FLAG
, MSI.CRITICAL_COMPONENT_FLAG)
, MSI.REDUCE_MPS
, NVL(MIA.CONSIGNED_FLAG
, MSI.CONSIGNED_FLAG)
, DECODE(MIA.VMI_MINIMUM_UNITS
, -23453
, TO_NUMBER(NULL)
, NULL
, MSI.VMI_MINIMUM_UNITS
, MIA.VMI_MINIMUM_UNITS)VMI_MINIMUM_UNITS
, DECODE(MIA.VMI_MINIMUM_DAYS
, -23453
, TO_NUMBER(NULL)
, NULL
, MSI.VMI_MINIMUM_DAYS
, MIA.VMI_MINIMUM_DAYS)VMI_MINIMUM_DAYS
, DECODE(MIA.VMI_MAXIMUM_UNITS
, -23453
, TO_NUMBER(NULL)
, NULL
, MSI.VMI_MAXIMUM_UNITS
, MIA.VMI_MAXIMUM_UNITS)VMI_MAXIMUM_UNITS
, DECODE(MIA.VMI_MAXIMUM_DAYS
, -23453
, TO_NUMBER(NULL)
, NULL
, MSI.VMI_MAXIMUM_DAYS
, MIA.VMI_MAXIMUM_UNITS)VMI_MAXIMUM_UNITS
, MSI.AVERAGE_DAILY_DEMAND
, DECODE(MIA.VMI_FIXED_ORDER_QUANTITY
, -23453
, TO_NUMBER(NULL)
, NULL
, MSI.VMI_FIXED_ORDER_QUANTITY
, MIA.VMI_FIXED_ORDER_QUANTITY)VMI_FIXED_ORDER_QUANTITY
, MSI.SO_AUTHORIZATION_FLAG
, MSI.VMI_FORECAST_TYPE
, MSI.FORECAST_HORIZON
, MSI.ASN_AUTOEXPIRE_FLAG
, MSI.VMI_REFRESH_FLAG
, MSI.BUDGET_CONSTRAINED
, MSI.MAX_QUANTITY
, MSI.MAX_QUANTITY_DOS
, DECODE(MIA.DAYS_TGT_INV_WINDOW
, -23453
, TO_NUMBER(NULL)
, NULL
, MSI.DAYS_TGT_INV_WINDOW
, MIA.DAYS_TGT_INV_WINDOW)DAYS_TGT_INV_WINDOW
, DECODE(MIA.DAYS_MAX_INV_SUPPLY
, -23453
, TO_NUMBER(NULL)
, NULL
, MSI.DAYS_MAX_INV_SUPPLY
, MIA.DAYS_MAX_INV_SUPPLY)DAYS_MAX_INV_SUPPLY
, DECODE(MIA.DAYS_MAX_INV_WINDOW
, -23453
, TO_NUMBER(NULL)
, NULL
, MSI.DAYS_MAX_INV_WINDOW
, MIA.DAYS_MAX_INV_WINDOW)DAYS_MAX_INV_WINDOW
, DECODE(MIA.DAYS_TGT_INV_SUPPLY
, -23453
, TO_NUMBER(NULL)
, NULL
, MSI.DAYS_TGT_INV_SUPPLY
, MIA.DAYS_TGT_INV_SUPPLY)DAYS_TGT_INV_SUPPLY
, NVL(MIA.DRP_PLANNED
, MSI.DRP_PLANNED)
, MSI.AGGREGATE_TIME_FENCE_DATE
, MSI.INFERRED_CRITICAL_FLAG
, MSI.SS_WINDOW_SIZE
, MSI.LOWEST_LEVEL_SRC
, MSI.EAM_ITEM_TYPE
, MSI.LOTS_EXIST
, NVL(MIA.LEADTIME_VARIABILITY
, MSI.LEADTIME_VARIABILITY )
, DECODE(MIA.MIN_SHELF_LIFE_DAYS
, -23453
, TO_NUMBER(NULL)
, NULL
, MSI.MIN_SHELF_LIFE_DAYS
, MIA.MIN_SHELF_LIFE_DAYS)MIN_SHELF_LIFE_DAYS
, MSI.GROUP_ID
, NVL(MIA.REPAIR_YIELD
, MSI.REPAIR_YIELD)
, MSI.REPAIR_PROGRAM
, NVL(MIA.REPAIR_LEAD_TIME
, MSI.REPAIR_LEAD_TIME)
, MSI.PRE_POSITION_INVENTORY
, MSI.PREPOSITION_POINT
, DECODE(MIA.DEMAND_FULFILLMENT_LT
, -23453
, TO_NUMBER(NULL)
, NULL
, MSI.DEMAND_FULFILLMENT_LT
, MIA.DEMAND_FULFILLMENT_LT)DEMAND_FULFILLMENT_LT
, MSI.FORECAST_RULE_FOR_DEMANDS
, MSI.FORECAST_RULE_FOR_RETURNS
, MSI.DEMAND_DISTRIBUTION
, MSI.INTERARRIVAL_TIME
, NVL(MIA.REPAIR_COST
, MSI.REPAIR_COST)
, MSI.LIFE_TIME_BUY_DATE
, MSI.END_OF_LIFE_DATE
, MSI.STD_DMD_OVER_HORIZON
, NVL(MIA.COEFFICIENT_OF_VARIATION
, MSI.COEFFICIENT_OF_VARIATION )
, NVL(MIA.AVG_DEMAND_BEYOND_PH
, MSI.AVG_DEMAND_BEYOND_PH )
, NVL(MIA.AVG_RETURNS_BEYOND_PH
, MSI.AVG_RETURNS_BEYOND_PH )
, NVL(MIA.RETURN_FORECAST_TIME_FENCE
, MSI.RETURN_FORECAST_TIME_FENCE )
, NVL(MIA.DEFECTIVE_ITEM_COST
, MSI.DEFECTIVE_ITEM_COST )
, NVL(MIA.BASIS_AVG_DAILY_DEMAND
, MSI.BASIS_AVG_DAILY_DEMAND )
, NVL(MIA.STD_DEVIATION_FOR_DEMAND
, MSI.STD_DEVIATION_FOR_DEMAND )
, NVL(MIA.MEAN_INTER_ARRIVAL
, MSI.MEAN_INTER_ARRIVAL )
, NVL(MIA.STD_DEVIATION_INTER_ARRIVAL
, MSI.STD_DEVIATION_INTER_ARRIVAL )
, NVL(MIA.STANDARD_DEVIATION
, MSI.STANDARD_DEVIATION )
, NVL(MIA.INTERARRIVAL_DIST_METHOD
, MSI.INTERARRIVAL_DIST_METHOD )
, NVL(MIA.SAFETY_LEAD_TIME
, MSI.SAFETY_LEAD_TIME)
, NVL(MIA.UNSATISFIED_DEMAND_FACTOR
, MSI.UNSATISFIED_DEMAND_FACTOR)
, MSI.PLANNING_TIME_FENCE_CODE
, NVL(MIA.MAX_USAGE_FACTOR
, MSI.MAX_USAGE_FACTOR)
, MIA.MIN_SUP_DEM_PERCENT
, MIA.DMD_SATISFIED_PERCENT
, MIA.MIN_REM_SHELF_LIFE_DAYS
, NVL(MIA.NEW_PLANNED_ORDER
, 1)
, MSI.PEGGING_DEMAND_WINDOW_DAYS
, MSI.PEGGING_SUPPLY_WINDOW_DAYS
, MIA.SCRAP_RATE
, MIA.REPAIR_MODULE
, MIA.REBUILD_ACTIVITY
, MIA.ORDER_PERIOD
, MIA.INV_DAYS_INCREMENT
FROM MSC_PLANS MP
, MSC_ITEM_ATTRIBUTES MIA
, MSC_SYSTEM_ITEMS MSI
WHERE MIA.PLAN_ID = -1
AND MP.ITEM_SIMULATION_SET_ID IS NOT NULL
AND MP.ITEM_SIMULATION_SET_ID = MIA.SIMULATION_SET_ID
AND MSI.PLAN_ID = MIA.PLAN_ID
AND MSI.INVENTORY_ITEM_ID = MIA.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID = MIA.ORGANIZATION_ID
AND MSI.SR_INSTANCE_ID = MIA.SR_INSTANCE_ID
AND MIA.REGION_ID IS NULL
AND MIA.CUSTOMER_ID IS NULL UNION ALL SELECT MSI.PLAN_ID
, MP.PLAN_ID PDS_PLAN_ID
, MP.ITEM_SIMULATION_SET_ID
, MSI.ORGANIZATION_ID
, MSI.INVENTORY_ITEM_ID
, MSI.SR_INSTANCE_ID
, MSI.SR_INVENTORY_ITEM_ID
, MSI.ITEM_NAME
, MSI.LOTS_EXPIRATION
, MSI.LOT_CONTROL_CODE
, MSI.SHRINKAGE_RATE
, MSI.FIXED_DAYS_SUPPLY
, MSI.FIXED_ORDER_QUANTITY
, MSI.FIXED_LOT_MULTIPLIER
, MSI.MINIMUM_ORDER_QUANTITY
, MSI.MAXIMUM_ORDER_QUANTITY
, MSI.ROUNDING_CONTROL_TYPE
, MSI.PLANNING_TIME_FENCE_DAYS
, MSI.PLANNING_TIME_FENCE_DATE
, MSI.DEMAND_TIME_FENCE_DAYS
, MSI.DEMAND_TIME_FENCE_DATE
, MSI.DESCRIPTION
, MSI.RELEASE_TIME_FENCE_CODE
, MSI.RELEASE_TIME_FENCE_DAYS
, MSI.IN_SOURCE_PLAN
, MSI.REVISION
, MSI.SR_CATEGORY_ID
, MSI.ABC_CLASS
, MSI.CATEGORY_NAME
, MSI.MRP_PLANNING_CODE
, MSI.FIXED_LEAD_TIME
, MSI.VARIABLE_LEAD_TIME
, MSI.PREPROCESSING_LEAD_TIME
, MSI.POSTPROCESSING_LEAD_TIME
, MSI.FULL_LEAD_TIME
, MSI.CUMULATIVE_TOTAL_LEAD_TIME
, MSI.CUM_MANUFACTURING_LEAD_TIME
, MSI.UOM_CODE
, MSI.UNIT_WEIGHT
, MSI.UNIT_VOLUME
, MSI.WEIGHT_UOM
, MSI.VOLUME_UOM
, MSI.PRODUCT_FAMILY_ID
, MSI.ATP_RULE_ID
, MSI.ATP_COMPONENTS_FLAG
, MSI.BUILD_IN_WIP_FLAG
, MSI.PURCHASING_ENABLED_FLAG
, MSI.PLANNING_MAKE_BUY_CODE
, MSI.REPETITIVE_TYPE
, MSI.REPETITIVE_VARIANCE
, MSI.STANDARD_COST
, MSI.CARRYING_COST
, MSI.ORDER_COST
, MSI.MATERIAL_COST
, MSI.DMD_LATENESS_COST
, MSI.RESOURCE_COST
, MSI.SS_PENALTY_COST
, MSI.SUPPLIER_CAP_OVERUTIL_COST
, MSI.LIST_PRICE
, MSI.AVERAGE_DISCOUNT
, MSI.ENGINEERING_ITEM_FLAG
, MSI.WIP_SUPPLY_TYPE
, MSI.SAFETY_STOCK_CODE
, MSI.SAFETY_STOCK_PERCENT
, MSI.SAFETY_STOCK_BUCKET_DAYS
, MSI.INVENTORY_USE_UP_DATE
, MSI.BUYER_NAME
, MSI.PLANNER_CODE
, MSI.PLANNING_EXCEPTION_SET
, MSI.EXCESS_QUANTITY
, MSI.EXCEPTION_SHORTAGE_DAYS
, MSI.EXCEPTION_EXCESS_DAYS
, MSI.EXCEPTION_OVERPROMISED_DAYS
, MSI.EXCEPTION_CODE
, MSI.BOM_ITEM_TYPE
, MSI.ATO_FORECAST_CONTROL
, MSI.EFFECTIVITY_CONTROL
, MSI.ORGANIZATION_CODE
, MSI.ACCEPTABLE_RATE_INCREASE
, MSI.ACCEPTABLE_RATE_DECREASE
, MSI.EXCEPTION_REP_VARIANCE_DAYS
, MSI.OVERRUN_PERCENTAGE
, MSI.INVENTORY_PLANNING_CODE
, MSI.ACCEPTABLE_EARLY_DELIVERY
, MSI.CALCULATE_ATP
, MSI.END_ASSEMBLY_PEGGING_FLAG
, MSI.END_ASSEMBLY_PEGGING
, MSI.FULL_PEGGING
, MSI.INVENTORY_ITEM_FLAG
, MSI.SOURCE_ORG_ID
, MSI.BASE_ITEM_ID
, MSI.ABC_CLASS_NAME
, MSI.FIXED_SAFETY_STOCK_QTY
, MSI.PRIMARY_SUPPLIER_ID
, MSI.ATP_FLAG
, MSI.LOW_LEVEL_CODE
, MSI.PLANNER_STATUS_CODE
, MSI.NETTABLE_INVENTORY_QUANTITY
, MSI.NONNETTABLE_INVENTORY_QUANTITY
, MSI.REFRESH_NUMBER
, MSI.LAST_UPDATE_DATE
, MSI.LAST_UPDATED_BY
, MSI.CREATION_DATE
, MSI.CREATED_BY
, MSI.LAST_UPDATE_LOGIN
, MSI.REQUEST_ID
, MSI.PROGRAM_APPLICATION_ID
, MSI.PROGRAM_ID
, MSI.PROGRAM_UPDATE_DATE
, MSI.ATTRIBUTE_CATEGORY
, MSI.ATTRIBUTE1
, MSI.ATTRIBUTE2
, MSI.ATTRIBUTE3
, MSI.ATTRIBUTE4
, MSI.ATTRIBUTE5
, MSI.ATTRIBUTE6
, MSI.ATTRIBUTE7
, MSI.ATTRIBUTE8
, MSI.ATTRIBUTE9
, MSI.ATTRIBUTE10
, MSI.ATTRIBUTE11
, MSI.ATTRIBUTE12
, MSI.ATTRIBUTE13
, MSI.ATTRIBUTE14
, MSI.ATTRIBUTE15
, MSI.REVISION_QTY_CONTROL_CODE
, MSI.EXPENSE_ACCOUNT
, MSI.INVENTORY_ASSET_FLAG
, MSI.BUYER_ID
, MSI.REPETITIVE_PLANNING_FLAG
, MSI.PICK_COMPONENTS_FLAG
, MSI.SERVICE_LEVEL
, MSI.REPLENISH_TO_ORDER_FLAG
, MSI.PIP_FLAG
, MSI.YIELD_CONV_FACTOR
, MSI.MIN_MINMAX_QUANTITY
, MSI.MAX_MINMAX_QUANTITY
, MSI.NEW_ATP_FLAG
, MSI.SOURCE_TYPE
, MSI.SUBSTITUTION_WINDOW
, MSI.CREATE_SUPPLY_FLAG
, MSI.REORDER_POINT
, MSI.AVERAGE_ANNUAL_DEMAND
, MSI.ECONOMIC_ORDER_QUANTITY
, MSI.SERIAL_NUMBER_CONTROL_CODE
, MSI.CONVERGENCE
, MSI.DIVERGENCE
, MSI.CONTINOUS_TRANSFER
, MSI.CRITICAL_COMPONENT_FLAG
, MSI.REDUCE_MPS
, MSI.CONSIGNED_FLAG
, MSI.VMI_MINIMUM_UNITS
, MSI.VMI_MINIMUM_DAYS
, MSI.VMI_MAXIMUM_UNITS
, MSI.VMI_MAXIMUM_DAYS
, MSI.AVERAGE_DAILY_DEMAND
, MSI.VMI_FIXED_ORDER_QUANTITY
, MSI.SO_AUTHORIZATION_FLAG
, MSI.VMI_FORECAST_TYPE
, MSI.FORECAST_HORIZON
, MSI.ASN_AUTOEXPIRE_FLAG
, MSI.VMI_REFRESH_FLAG
, MSI.BUDGET_CONSTRAINED
, MSI.MAX_QUANTITY
, MSI.MAX_QUANTITY_DOS
, MSI.DAYS_TGT_INV_WINDOW
, MSI.DAYS_MAX_INV_WINDOW
, MSI.DAYS_TGT_INV_SUPPLY
, MSI.DAYS_MAX_INV_SUPPLY
, MSI.DRP_PLANNED
, MSI.AGGREGATE_TIME_FENCE_DATE
, MSI.INFERRED_CRITICAL_FLAG
, MSI.SS_WINDOW_SIZE
, MSI.LOWEST_LEVEL_SRC
, MSI.EAM_ITEM_TYPE
, MSI.LOTS_EXIST
, MSI.LEADTIME_VARIABILITY
, MSI.MIN_SHELF_LIFE_DAYS
, MSI.GROUP_ID
, MSI.REPAIR_YIELD
, MSI.REPAIR_PROGRAM
, MSI.REPAIR_LEAD_TIME
, MSI.PRE_POSITION_INVENTORY
, MSI.PREPOSITION_POINT
, MSI.DEMAND_FULFILLMENT_LT
, MSI.FORECAST_RULE_FOR_DEMANDS
, MSI.FORECAST_RULE_FOR_RETURNS
, MSI.DEMAND_DISTRIBUTION
, MSI.INTERARRIVAL_TIME
, MSI.REPAIR_COST
, MSI.LIFE_TIME_BUY_DATE
, MSI.END_OF_LIFE_DATE
, MSI.STD_DMD_OVER_HORIZON
, MSI.COEFFICIENT_OF_VARIATION
, MSI.AVG_DEMAND_BEYOND_PH
, MSI.AVG_RETURNS_BEYOND_PH
, MSI.RETURN_FORECAST_TIME_FENCE
, MSI.DEFECTIVE_ITEM_COST
, MSI.BASIS_AVG_DAILY_DEMAND
, MSI.STD_DEVIATION_FOR_DEMAND
, MSI.MEAN_INTER_ARRIVAL
, MSI.STD_DEVIATION_INTER_ARRIVAL
, MSI.STANDARD_DEVIATION
, MSI.INTERARRIVAL_DIST_METHOD
, MSI.SAFETY_LEAD_TIME
, MSI.UNSATISFIED_DEMAND_FACTOR
, MSI.PLANNING_TIME_FENCE_CODE
, MSI.MAX_USAGE_FACTOR
, MSI.MIN_SUP_DEM_PERCENT
, MSI.DMD_SATISFIED_PERCENT
, NULL MIN_REM_SHELF_LIFE_DAYS
, 1 NEW_PLANNED_ORDER
, MSI.PEGGING_DEMAND_WINDOW_DAYS
, MSI.PEGGING_SUPPLY_WINDOW_DAYS
, NULL SCRAP_RATE
, NULL REPAIR_MODULE
, NULL REBUILD_ACTIVITY
, NULL ORDER_PERIOD
, NULL INV_DAYS_INCREMENT
FROM MSC_SYSTEM_ITEMS MSI
, MSC_PLANS MP
WHERE MP.PLAN_ID <> -1
AND MP.PLAN_ID = MSI.PLAN_ID