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

VIEW: APPS.MSC_ITEM_ATTRIBUTES_V

Source

View Text - Preformatted


SELECT distinct MSI.ROWID, MSI.PLAN_ID, MSI.SR_INSTANCE_ID, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, MSI.ITEM_NAME, MTP.ORGANIZATION_CODE, MIC.SR_CATEGORY_ID, MIC.CATEGORY_SET_ID, MIC.CATEGORY_NAME, MIC.DESCRIPTION, MLK1.MEANING, MSI.FULL_LEAD_TIME, MSI.PREPROCESSING_LEAD_TIME, MSI.POSTPROCESSING_LEAD_TIME, MSI.FIXED_LEAD_TIME, MSI.VARIABLE_LEAD_TIME, MSI.FIXED_ORDER_QUANTITY, MSI.FIXED_DAYS_SUPPLY, MSI.SHRINKAGE_RATE, MSI.FIXED_LOT_MULTIPLIER, MSI.MINIMUM_ORDER_QUANTITY, MSI.MAXIMUM_ORDER_QUANTITY, MSIS_coll.SERVICE_LEVEL, MSI.CARRYING_COST, MSI.DEMAND_TIME_FENCE_DAYS, MLK2.MEANING, MSI.PLANNING_TIME_FENCE_DAYS, MSI.STANDARD_COST, NVL(MSI.LIST_PRICE, 0)*(1-NVL(MSI.AVERAGE_DISCOUNT, 0)/100), MLK3.MEANING, MSI.LIST_PRICE, MSI.SUBSTITUTION_WINDOW, MSI.SAFETY_STOCK_BUCKET_DAYS, MSI.UNIT_WEIGHT, MSI.UNIT_VOLUME, MLK4.MEANING, MSI.SAFETY_STOCK_PERCENT, MSI.ABC_CLASS_NAME, MLK5.MEANING, MLK6.MEANING, MSI.DAYS_MAX_INV_SUPPLY, MSI.DAYS_MAX_INV_WINDOW, MSI.DAYS_TGT_INV_SUPPLY, MSI.DAYS_TGT_INV_WINDOW, MLK7.MEANING, MLK8.MEANING, MLK9.MEANING, MLK10.MEANING, MSI.PLANNING_EXCEPTION_SET, MSI.INVENTORY_USE_UP_DATE, MLK11.MEANING, NVL(MSI.list_price, 0) - NVL(MSI.standard_cost, 0), MSI.WEIGHT_UOM, MSI.VOLUME_UOM, MLK12.MEANING, MLK13.MEANING, MLK14.MEANING, MSIS_coll.DEMAND_FULFILLMENT_LT, MSI.LOTS_EXPIRATION, MSI.VMI_MINIMUM_UNITS, MSI.VMI_MINIMUM_DAYS, MSI.VMI_MAXIMUM_UNITS, MSI.VMI_MAXIMUM_DAYS, MSI.VMI_FIXED_ORDER_QUANTITY, MLK15.MEANING, MSIS_coll.LEADTIME_VARIABILITY, MSI.PLANNER_CODE, MSIS_coll.EO_FLAG, MSIS_coll.EXCESS_HORIZON, MSIS_coll.OBSOLESCENCE_DATE, MSI.MIN_SHELF_LIFE_DAYS, MSI.REPAIR_LEAD_TIME, MSI.REPAIR_YIELD, MSI.REPAIR_COST, MIC_COLL.CATEGORY_NAME, MSIS_coll.RELIABILITY, MSIS_coll.FAILURE_IMPACT, MSIS_coll.STANDARD_DEVIATION, MSIS_coll.COEFFICIENT_OF_VARIATION, MSIS_coll.BASIS_AVG_DAILY_DEMAND, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'No', to_number(null), to_number(null), null, to_number(null), to_number(null), to_date(null), to_date(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), null, null, to_number(null), null, to_number(null), to_number(null), null, to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), null, null FROM msc_system_items msi, msc_trading_partners mtp, MSC_ITEM_ATTRIBUTES MSIS_coll, MSC_ITEM_CATEGORIES MIC_COLL, mfg_lookups mlk1, mfg_lookups mlk2, mfg_lookups mlk3, mfg_lookups mlk4, mfg_lookups mlk5, mfg_lookups mlk6, mfg_lookups mlk7, mfg_lookups mlk8, mfg_lookups mlk9, mfg_lookups mlk10, mfg_lookups mlk11, mfg_lookups mlk12, mfg_lookups mlk13, mfg_lookups mlk14, mfg_lookups mlk15, msc_item_categories mic WHERE msi.plan_id = -1 and msi.sr_instance_id = mic.sr_instance_id and msi.inventory_item_id = mic.inventory_item_id and msi.organization_id = mic.organization_id and MSIS_coll.PLAN_ID (+) = MSI.PLAN_ID AND MSIS_coll.SR_INSTANCE_ID (+) = MSI.SR_INSTANCE_ID AND MSIS_coll.INVENTORY_ITEM_ID (+) = MSI.INVENTORY_ITEM_ID AND MSIS_coll.ORGANIZATION_ID (+) = MSI.ORGANIZATION_ID AND MSIS_coll.SIMULATION_SET_ID (+) = -1 AND MSIS_COLL.CRITICALITY_CATEGORY = MIC_COLL.SR_CATEGORY_ID(+) AND mtp.partner_type = 3 and mtp.sr_tp_id = msi.organization_id and mtp.sr_instance_id = msi.sr_instance_id and mlk1.lookup_type(+) = 'SYS_YES_NO' and mlk1.lookup_code(+) = MSI.CRITICAL_COMPONENT_FLAG and mlk2.lookup_type(+) = 'MRP_ATO_FORECAST_CONTROL' and mlk2.lookup_code(+) = MSI.ATO_FORECAST_CONTROL and mlk3.lookup_type(+) = 'SYS_YES_NO' and mlk3.lookup_code(+) = MSI.PIP_FLAG and mlk4.lookup_type(+) = 'MSC_SAFETY_STOCK_TYPE' and mlk4.lookup_code(+) = MSI.SAFETY_STOCK_CODE and mlk5.lookup_type(+) = 'MRP_PLANNING_CODE' and mlk5.lookup_code(+) = MSI.MRP_PLANNING_CODE and mlk6.lookup_type(+) = 'SYS_YES_NO' and mlk6.lookup_code(+) = MSI.DRP_PLANNED and mlk7.lookup_type(+) = 'MSC_CONTINOUS_TRANSFER' and mlk7.lookup_code(+) = MSI.CONTINOUS_TRANSFER and mlk8.lookup_type(+) = 'MSC_CONVERGENCE' and mlk8.lookup_code(+) = MSI.CONVERGENCE and mlk9.lookup_type(+) = 'SYS_YES_NO' and mlk9.lookup_code(+) = MSI.CREATE_SUPPLY_FLAG and mlk10.lookup_type(+) = 'MSC_DIVERGENCE' and mlk10.lookup_code(+) = MSI.DIVERGENCE and mlk11.lookup_type(+) = 'MTL_PLANNING_MAKE_BUY' and mlk11.lookup_code(+) = MSI.PLANNING_MAKE_BUY_CODE and mlk12.lookup_type(+) = 'SYS_YES_NO' and mlk12.lookup_code(+) = MSI.ROUNDING_CONTROL_TYPE and mlk13.lookup_type(+) = 'MSC_ATP_COMPONENTS_FLAG' and mlk13.lookup_code(+) = to_number(DECODE(MSI.ATP_FLAG,'N',1,'Y',2,'R',3,'C',4)) and mlk14.lookup_type(+) = 'MSC_ATP_COMPONENTS_FLAG' and mlk14.lookup_code(+) = to_number(DECODE(MSI.ATP_COMPONENTS_FLAG,'N',1,'Y',2,'R',3,'C',4)) and mlk15.lookup_type(+) = 'MSC_CONSIGNED_FLAG' and mlk15.lookup_code(+) = MSI.CONSIGNED_FLAG union all SELECT distinct MSI.ROWID, MSI.PLAN_ID, MSI.SR_INSTANCE_ID, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, MSI.ITEM_NAME, MTP.ORGANIZATION_CODE, MIC.SR_CATEGORY_ID, MIC.CATEGORY_SET_ID, MIC.CATEGORY_NAME, MIC.DESCRIPTION, MLK1.MEANING, MSI.FULL_LEAD_TIME, MSI.PREPROCESSING_LEAD_TIME, MSI.POSTPROCESSING_LEAD_TIME, MSI.FIXED_LEAD_TIME, MSI.VARIABLE_LEAD_TIME, MSI.FIXED_ORDER_QUANTITY, MSI.FIXED_DAYS_SUPPLY, MSI.SHRINKAGE_RATE, MSI.FIXED_LOT_MULTIPLIER, MSI.MINIMUM_ORDER_QUANTITY, MSI.MAXIMUM_ORDER_QUANTITY, MSIS_coll.SERVICE_LEVEL, MSI.CARRYING_COST, MSI.DEMAND_TIME_FENCE_DAYS, MLK2.MEANING, MSI.PLANNING_TIME_FENCE_DAYS, MSI.STANDARD_COST, NVL(MSI.LIST_PRICE, 0)*(1-NVL(MSI.AVERAGE_DISCOUNT, 0)/100), MLK3.MEANING, MSI.LIST_PRICE, MSI.SUBSTITUTION_WINDOW, MSI.SAFETY_STOCK_BUCKET_DAYS, MSI.UNIT_WEIGHT, MSI.UNIT_VOLUME, MLK4.MEANING, MSI.SAFETY_STOCK_PERCENT, MSI.ABC_CLASS_NAME, MLK5.MEANING, MLK6.MEANING, MSI.DAYS_MAX_INV_SUPPLY, MSI.DAYS_MAX_INV_WINDOW, MSI.DAYS_TGT_INV_SUPPLY, MSI.DAYS_TGT_INV_WINDOW, MLK7.MEANING, MLK8.MEANING, MLK9.MEANING, MLK10.MEANING, MSI.PLANNING_EXCEPTION_SET, MSI.INVENTORY_USE_UP_DATE, MLK11.MEANING, NVL(MSI.list_price, 0) - NVL(MSI.standard_cost, 0), MSI.WEIGHT_UOM, MSI.VOLUME_UOM, MLK12.MEANING, MLK13.MEANING, MLK14.MEANING, MSIS_coll.DEMAND_FULFILLMENT_LT, MSI.LOTS_EXPIRATION, MSI.VMI_MINIMUM_UNITS, MSI.VMI_MINIMUM_DAYS, MSI.VMI_MAXIMUM_UNITS, MSI.VMI_MAXIMUM_DAYS, MSI.VMI_FIXED_ORDER_QUANTITY, MLK15.MEANING, MSIS_coll.LEADTIME_VARIABILITY, MSI.PLANNER_CODE, MSIS_coll.EO_FLAG, MSIS_coll.EXCESS_HORIZON, MSIS_coll.OBSOLESCENCE_DATE, MSI.MIN_SHELF_LIFE_DAYS, MSI.REPAIR_LEAD_TIME, MSI.REPAIR_YIELD, MSI.REPAIR_COST, MIC_coll.CATEGORY_NAME, MSIS_coll.RELIABILITY, MSIS_coll.FAILURE_IMPACT, MSIS_coll.STANDARD_DEVIATION, MSIS_coll.COEFFICIENT_OF_VARIATION, MSIS_coll.BASIS_AVG_DAILY_DEMAND, MSIS.ROWID, MSIS.SIMULATION_SET_ID, MLK16.MEANING, MSIS.FULL_LEAD_TIME, MSIS.PREPROCESSING_LEAD_TIME, MSIS.POSTPROCESSING_LEAD_TIME, MSIS.FIXED_LEAD_TIME, MSIS.VARIABLE_LEAD_TIME, MSIS.FIXED_ORDER_QUANTITY, MSIS.FIXED_DAYS_SUPPLY, MSIS.SHRINKAGE_RATE, MSIS.FIXED_LOT_MULTIPLIER, MSIS.MINIMUM_ORDER_QUANTITY, MSIS.MAXIMUM_ORDER_QUANTITY, decode(MSIS.SIMULATION_SET_ID,-1,null,MSIS.SERVICE_LEVEL), MSIS.CARRYING_COST, MSIS.DEMAND_TIME_FENCE_DAYS, MLK17.MEANING, MSIS.PLANNING_TIME_FENCE_DAYS, MSIS.STANDARD_COST, null, MLK18.MEANING, MSIS.LIST_PRICE, MSIS.SUBSTITUTION_WINDOW, MSIS.SAFETY_STOCK_BUCKET_DAYS, MSIS.UNIT_WEIGHT, MSIS.UNIT_VOLUME, MLK19.MEANING, MSIS.SAFETY_STOCK_PERCENT, MSIS.ABC_CLASS_NAME, MLK20.MEANING, MLK21.MEANING, MSIS.DAYS_MAX_INV_SUPPLY, MSIS.DAYS_MAX_INV_WINDOW, MSIS.DAYS_TGT_INV_SUPPLY, MSIS.DAYS_TGT_INV_WINDOW, MLK22.MEANING, MLK23.MEANING, MLK24.MEANING, MLK25.MEANING, MSIS.PLANNING_EXCEPTION_SET, MSIS.INVENTORY_USE_UP_DATE, MLK26.MEANING, null, MSIS.WEIGHT_UOM, MSIS.VOLUME_UOM, MLK27.MEANING, MLK28.MEANING, MLK29.MEANING, decode(MSIS.SIMULATION_SET_ID,-1,null,MSIS.DEMAND_FULFILLMENT_LT), MSIS.LOTS_EXPIRATION, MSIS.VMI_MINIMUM_UNITS, MSIS.VMI_MINIMUM_DAYS, MSIS.VMI_MAXIMUM_UNITS, MSIS.VMI_MAXIMUM_DAYS, MSIS.VMI_FIXED_ORDER_QUANTITY, MLK30.MEANING, decode(MSIS.SIMULATION_SET_ID,-1,null,MSIS.LEADTIME_VARIABILITY), MSIS.PLANNER_CODE, decode(MSIS.SIMULATION_SET_ID,-1,null,MLK31.MEANING), decode(MSIS.SIMULATION_SET_ID,-1,null,MSIS.EXCESS_HORIZON), decode(MSIS.SIMULATION_SET_ID,-1,null,MSIS.OBSOLESCENCE_DATE), MSIS.MIN_SHELF_LIFE_DAYS, decode(MSIS.SIMULATION_SET_ID,-1,null,MSIS.REPAIR_LEAD_TIME), decode(MSIS.SIMULATION_SET_ID,-1,null,MSIS.REPAIR_YIELD), decode(MSIS.SIMULATION_SET_ID,-1,null,MSIS.REPAIR_COST), null, decode(MSIS.SIMULATION_SET_ID,-1,null,MSIS.RELIABILITY), decode(MSIS.SIMULATION_SET_ID,-1,null,MSIS.FAILURE_IMPACT), decode(MSIS.SIMULATION_SET_ID,-1,null,MSIS.STANDARD_DEVIATION), decode(MSIS.SIMULATION_SET_ID,-1,null,MSIS.COEFFICIENT_OF_VARIATION), decode(MSIS.SIMULATION_SET_ID,-1,null,MSIS.BASIS_AVG_DAILY_DEMAND), MSIS.UPDATED_COLUMNS_COUNT, 'Yes', to_number(null), to_number(null), null, mfr1.forecast_rule_name, mfr2.forecast_rule_name, msis.LIFE_TIME_BUY_DATE, msis.END_OF_LIFE_DATE, msis.AVG_DEMAND_BEYOND_PH, msis.AVG_RETURNS_BEYOND_PH, msis.RETURN_FORECAST_TIME_FENCE, msis.AVERAGE_DAILY_DEMAND, msis.DEFECTIVE_ITEM_COST, msis.STD_DEVIATION_FOR_DEMAND, msis.MEAN_INTER_ARRIVAL, msis.STD_DEVIATION_INTER_ARRIVAL, msis.INTERARRIVAL_DIST_METHOD, mlk32.meaning, to_number(null), null, to_number(null), to_number(null), null, msis.max_usage_factor, to_number(null), msis.Unsatisfied_demand_factor, msis.dmd_satisfied_percent, msis.min_sup_dem_percent, msis.pick_pack_lt, mlk33.meaning, mlk34.meaning FROM MSC_SYSTEM_ITEMS MSI, MSC_TRADING_PARTNERS MTP, MSC_ITEM_CATEGORIES MIC, msc_item_categories mic_coll, MSC_ITEM_ATTRIBUTES MSIS, MSC_ITEM_ATTRIBUTES MSIS_coll, msc_forecast_rules mfr1, msc_forecast_rules mfr2, mfg_lookups mlk1, mfg_lookups mlk2, mfg_lookups mlk3, mfg_lookups mlk4, mfg_lookups mlk5, mfg_lookups mlk6, mfg_lookups mlk7, mfg_lookups mlk8, mfg_lookups mlk9, mfg_lookups mlk10, mfg_lookups mlk11, mfg_lookups mlk12, mfg_lookups mlk13, mfg_lookups mlk14, mfg_lookups mlk15, mfg_lookups mlk16, mfg_lookups mlk17, mfg_lookups mlk18, mfg_lookups mlk19, mfg_lookups mlk20, mfg_lookups mlk21, mfg_lookups mlk22, mfg_lookups mlk23, mfg_lookups mlk24, mfg_lookups mlk25, mfg_lookups mlk26, mfg_lookups mlk27, mfg_lookups mlk28, mfg_lookups mlk29, mfg_lookups mlk30, mfg_lookups mlk31, mfg_lookups mlk32, mfg_lookups mlk33, mfg_lookups mlk34 WHERE MSI.PLAN_ID = -1 AND MSIS.PLAN_ID = MSI.PLAN_ID AND MSIS.SR_INSTANCE_ID = MSI.SR_INSTANCE_ID AND MSIS.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID AND MSIS.ORGANIZATION_ID = MSI.ORGANIZATION_ID AND msis.forecast_rule_for_demands = mfr1.forecast_rule_id (+) and msis.forecast_rule_for_returns = mfr2.forecast_rule_id (+) and msis.region_id is null and msis.customer_id is null and MSIS_coll.PLAN_ID (+) = MSI.PLAN_ID AND MSIS_coll.SR_INSTANCE_ID (+) = MSI.SR_INSTANCE_ID AND MSIS_coll.INVENTORY_ITEM_ID (+) = MSI.INVENTORY_ITEM_ID AND MSIS_coll.ORGANIZATION_ID (+) = MSI.ORGANIZATION_ID AND MSIS_coll.SIMULATION_SET_ID (+) = -1 AND MSIS_COLL.CRITICALITY_CATEGORY = MIC_COLL.SR_CATEGORY_ID(+) AND MSIS_COLL.region_id is null and MSI.SR_INSTANCE_ID = MIC.SR_INSTANCE_ID AND MSI.INVENTORY_ITEM_ID = MIC.INVENTORY_ITEM_ID AND MSI.ORGANIZATION_ID = MIC.ORGANIZATION_ID AND MTP.PARTNER_TYPE = 3 AND MTP.SR_TP_ID = MSI.ORGANIZATION_ID AND MTP.SR_INSTANCE_ID = MSI.SR_INSTANCE_ID and mlk1.lookup_type(+) = 'SYS_YES_NO' and mlk1.lookup_code(+) = MSI.CRITICAL_COMPONENT_FLAG and mlk2.lookup_type(+) = 'MRP_ATO_FORECAST_CONTROL' and mlk2.lookup_code(+) = MSI.ATO_FORECAST_CONTROL and mlk3.lookup_type(+) = 'SYS_YES_NO' and mlk3.lookup_code(+) = MSI.PIP_FLAG and mlk4.lookup_type(+) = 'MSC_SAFETY_STOCK_TYPE' and mlk4.lookup_code(+) = MSI.SAFETY_STOCK_CODE and mlk5.lookup_type(+) = 'MRP_PLANNING_CODE' and mlk5.lookup_code(+) = MSI.MRP_PLANNING_CODE and mlk6.lookup_type(+) = 'SYS_YES_NO' and mlk6.lookup_code(+) = MSI.DRP_PLANNED and mlk7.lookup_type(+) = 'MSC_CONTINOUS_TRANSFER' and mlk7.lookup_code(+) = MSI.CONTINOUS_TRANSFER and mlk8.lookup_type(+) = 'MSC_CONVERGENCE' and mlk8.lookup_code(+) = MSI.CONVERGENCE and mlk9.lookup_type(+) = 'SYS_YES_NO' and mlk9.lookup_code(+) = MSI.CREATE_SUPPLY_FLAG and mlk10.lookup_type(+) = 'MSC_DIVERGENCE' and mlk10.lookup_code(+) = MSI.DIVERGENCE and mlk11.lookup_type(+) = 'MTL_PLANNING_MAKE_BUY' and mlk11.lookup_code(+) = MSI.PLANNING_MAKE_BUY_CODE and mlk12.lookup_type(+) = 'SYS_YES_NO' and mlk12.lookup_code(+) = MSI.ROUNDING_CONTROL_TYPE and mlk13.lookup_type(+) = 'MSC_ATP_COMPONENTS_FLAG' and mlk13.lookup_code(+) = to_number(DECODE(MSI.ATP_FLAG,'N',1,'Y',2,'R',3,'C',4)) and mlk14.lookup_type(+) = 'MSC_ATP_COMPONENTS_FLAG' and mlk14.lookup_code(+) = to_number(DECODE(MSI.ATP_COMPONENTS_FLAG,'N',1,'Y',2,'R',3,'C',4)) and mlk15.lookup_type(+) = 'MSC_CONSIGNED_FLAG' and mlk15.lookup_code(+) = MSI.CONSIGNED_FLAG and mlk16.lookup_type(+) = 'SYS_YES_NO' and mlk16.lookup_code(+) = MSIS.CRITICAL_COMPONENT_FLAG and mlk17.lookup_type(+) = 'MRP_ATO_FORECAST_CONTROL' and mlk17.lookup_code(+) = MSIS.ATO_FORECAST_CONTROL and mlk18.lookup_type(+) = 'SYS_YES_NO' and mlk18.lookup_code(+) = MSIS.PIP_FLAG and mlk19.lookup_type(+) = 'MSC_SAFETY_STOCK_TYPE' and mlk19.lookup_code(+) = MSIS.SAFETY_STOCK_CODE and mlk20.lookup_type(+) = 'MRP_PLANNING_CODE' and mlk20.lookup_code(+) = MSIS.MRP_PLANNING_CODE and mlk21.lookup_type(+) = 'SYS_YES_NO' and mlk21.lookup_code(+) = MSIS.DRP_PLANNED and mlk22.lookup_type(+) = 'MSC_CONTINOUS_TRANSFER' and mlk22.lookup_code(+) = MSIS.CONTINOUS_TRANSFER and mlk23.lookup_type(+) = 'MSC_CONVERGENCE' and mlk23.lookup_code(+) = MSIS.CONVERGENCE and mlk24.lookup_type(+) = 'SYS_YES_NO' and mlk24.lookup_code(+) = MSIS.CREATE_SUPPLY_FLAG and mlk25.lookup_type(+) = 'MSC_DIVERGENCE' and mlk25.lookup_code(+) = MSIS.DIVERGENCE and mlk26.lookup_type(+) = 'MTL_PLANNING_MAKE_BUY' and mlk26.lookup_code(+) = MSIS.PLANNING_MAKE_BUY_CODE and mlk27.lookup_type(+) = 'SYS_YES_NO' and mlk27.lookup_code(+) = MSIS.ROUNDING_CONTROL_TYPE and mlk28.lookup_type(+) = 'MSC_ATP_COMPONENTS_FLAG' and mlk28.lookup_code(+) = to_number(DECODE(MSIS.ATP_FLAG,'N',1,'Y',2,'R',3,'C',4)) and mlk29.lookup_type(+) = 'MSC_ATP_COMPONENTS_FLAG' and mlk29.lookup_code(+) = to_number(DECODE(MSIS.ATP_COMPONENTS_FLAG,'N',1,'Y',2,'R',3,'C',4)) and mlk30.lookup_type(+) = 'MSC_CONSIGNED_FLAG' and mlk30.lookup_code(+) = MSIS.CONSIGNED_FLAG and mlk31.lookup_type(+) = 'SYS_YES_NO' and mlk31.lookup_code(+) = MSIS.EO_FLAG and mlk32.lookup_type(+) = 'SYS_YES_NO' and mlk32.lookup_code(+) = MSIS.INTERMITTENT_DEMAND and mlk33.lookup_type(+) = 'MSC_REPAIR_PROGRAM' and mlk33.lookup_code(+) = MSIS.repair_program and mlk34.lookup_type(+) = 'SYS_YES_NO' and mlk34.lookup_code(+) = MSIS.Pre_position_point

View Text - HTML Formatted

SELECT DISTINCT MSI.ROWID
, MSI.PLAN_ID
, MSI.SR_INSTANCE_ID
, MSI.ORGANIZATION_ID
, MSI.INVENTORY_ITEM_ID
, MSI.ITEM_NAME
, MTP.ORGANIZATION_CODE
, MIC.SR_CATEGORY_ID
, MIC.CATEGORY_SET_ID
, MIC.CATEGORY_NAME
, MIC.DESCRIPTION
, MLK1.MEANING
, MSI.FULL_LEAD_TIME
, MSI.PREPROCESSING_LEAD_TIME
, MSI.POSTPROCESSING_LEAD_TIME
, MSI.FIXED_LEAD_TIME
, MSI.VARIABLE_LEAD_TIME
, MSI.FIXED_ORDER_QUANTITY
, MSI.FIXED_DAYS_SUPPLY
, MSI.SHRINKAGE_RATE
, MSI.FIXED_LOT_MULTIPLIER
, MSI.MINIMUM_ORDER_QUANTITY
, MSI.MAXIMUM_ORDER_QUANTITY
, MSIS_COLL.SERVICE_LEVEL
, MSI.CARRYING_COST
, MSI.DEMAND_TIME_FENCE_DAYS
, MLK2.MEANING
, MSI.PLANNING_TIME_FENCE_DAYS
, MSI.STANDARD_COST
, NVL(MSI.LIST_PRICE
, 0)*(1-NVL(MSI.AVERAGE_DISCOUNT
, 0)/100)
, MLK3.MEANING
, MSI.LIST_PRICE
, MSI.SUBSTITUTION_WINDOW
, MSI.SAFETY_STOCK_BUCKET_DAYS
, MSI.UNIT_WEIGHT
, MSI.UNIT_VOLUME
, MLK4.MEANING
, MSI.SAFETY_STOCK_PERCENT
, MSI.ABC_CLASS_NAME
, MLK5.MEANING
, MLK6.MEANING
, MSI.DAYS_MAX_INV_SUPPLY
, MSI.DAYS_MAX_INV_WINDOW
, MSI.DAYS_TGT_INV_SUPPLY
, MSI.DAYS_TGT_INV_WINDOW
, MLK7.MEANING
, MLK8.MEANING
, MLK9.MEANING
, MLK10.MEANING
, MSI.PLANNING_EXCEPTION_SET
, MSI.INVENTORY_USE_UP_DATE
, MLK11.MEANING
, NVL(MSI.LIST_PRICE
, 0) - NVL(MSI.STANDARD_COST
, 0)
, MSI.WEIGHT_UOM
, MSI.VOLUME_UOM
, MLK12.MEANING
, MLK13.MEANING
, MLK14.MEANING
, MSIS_COLL.DEMAND_FULFILLMENT_LT
, MSI.LOTS_EXPIRATION
, MSI.VMI_MINIMUM_UNITS
, MSI.VMI_MINIMUM_DAYS
, MSI.VMI_MAXIMUM_UNITS
, MSI.VMI_MAXIMUM_DAYS
, MSI.VMI_FIXED_ORDER_QUANTITY
, MLK15.MEANING
, MSIS_COLL.LEADTIME_VARIABILITY
, MSI.PLANNER_CODE
, MSIS_COLL.EO_FLAG
, MSIS_COLL.EXCESS_HORIZON
, MSIS_COLL.OBSOLESCENCE_DATE
, MSI.MIN_SHELF_LIFE_DAYS
, MSI.REPAIR_LEAD_TIME
, MSI.REPAIR_YIELD
, MSI.REPAIR_COST
, MIC_COLL.CATEGORY_NAME
, MSIS_COLL.RELIABILITY
, MSIS_COLL.FAILURE_IMPACT
, MSIS_COLL.STANDARD_DEVIATION
, MSIS_COLL.COEFFICIENT_OF_VARIATION
, MSIS_COLL.BASIS_AVG_DAILY_DEMAND
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, 'NO'
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_DATE(NULL)
, TO_DATE(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, NULL
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, NULL
FROM MSC_SYSTEM_ITEMS MSI
, MSC_TRADING_PARTNERS MTP
, MSC_ITEM_ATTRIBUTES MSIS_COLL
, MSC_ITEM_CATEGORIES MIC_COLL
, MFG_LOOKUPS MLK1
, MFG_LOOKUPS MLK2
, MFG_LOOKUPS MLK3
, MFG_LOOKUPS MLK4
, MFG_LOOKUPS MLK5
, MFG_LOOKUPS MLK6
, MFG_LOOKUPS MLK7
, MFG_LOOKUPS MLK8
, MFG_LOOKUPS MLK9
, MFG_LOOKUPS MLK10
, MFG_LOOKUPS MLK11
, MFG_LOOKUPS MLK12
, MFG_LOOKUPS MLK13
, MFG_LOOKUPS MLK14
, MFG_LOOKUPS MLK15
, MSC_ITEM_CATEGORIES MIC
WHERE MSI.PLAN_ID = -1
AND MSI.SR_INSTANCE_ID = MIC.SR_INSTANCE_ID
AND MSI.INVENTORY_ITEM_ID = MIC.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID = MIC.ORGANIZATION_ID
AND MSIS_COLL.PLAN_ID (+) = MSI.PLAN_ID
AND MSIS_COLL.SR_INSTANCE_ID (+) = MSI.SR_INSTANCE_ID
AND MSIS_COLL.INVENTORY_ITEM_ID (+) = MSI.INVENTORY_ITEM_ID
AND MSIS_COLL.ORGANIZATION_ID (+) = MSI.ORGANIZATION_ID
AND MSIS_COLL.SIMULATION_SET_ID (+) = -1
AND MSIS_COLL.CRITICALITY_CATEGORY = MIC_COLL.SR_CATEGORY_ID(+)
AND MTP.PARTNER_TYPE = 3
AND MTP.SR_TP_ID = MSI.ORGANIZATION_ID
AND MTP.SR_INSTANCE_ID = MSI.SR_INSTANCE_ID
AND MLK1.LOOKUP_TYPE(+) = 'SYS_YES_NO'
AND MLK1.LOOKUP_CODE(+) = MSI.CRITICAL_COMPONENT_FLAG
AND MLK2.LOOKUP_TYPE(+) = 'MRP_ATO_FORECAST_CONTROL'
AND MLK2.LOOKUP_CODE(+) = MSI.ATO_FORECAST_CONTROL
AND MLK3.LOOKUP_TYPE(+) = 'SYS_YES_NO'
AND MLK3.LOOKUP_CODE(+) = MSI.PIP_FLAG
AND MLK4.LOOKUP_TYPE(+) = 'MSC_SAFETY_STOCK_TYPE'
AND MLK4.LOOKUP_CODE(+) = MSI.SAFETY_STOCK_CODE
AND MLK5.LOOKUP_TYPE(+) = 'MRP_PLANNING_CODE'
AND MLK5.LOOKUP_CODE(+) = MSI.MRP_PLANNING_CODE
AND MLK6.LOOKUP_TYPE(+) = 'SYS_YES_NO'
AND MLK6.LOOKUP_CODE(+) = MSI.DRP_PLANNED
AND MLK7.LOOKUP_TYPE(+) = 'MSC_CONTINOUS_TRANSFER'
AND MLK7.LOOKUP_CODE(+) = MSI.CONTINOUS_TRANSFER
AND MLK8.LOOKUP_TYPE(+) = 'MSC_CONVERGENCE'
AND MLK8.LOOKUP_CODE(+) = MSI.CONVERGENCE
AND MLK9.LOOKUP_TYPE(+) = 'SYS_YES_NO'
AND MLK9.LOOKUP_CODE(+) = MSI.CREATE_SUPPLY_FLAG
AND MLK10.LOOKUP_TYPE(+) = 'MSC_DIVERGENCE'
AND MLK10.LOOKUP_CODE(+) = MSI.DIVERGENCE
AND MLK11.LOOKUP_TYPE(+) = 'MTL_PLANNING_MAKE_BUY'
AND MLK11.LOOKUP_CODE(+) = MSI.PLANNING_MAKE_BUY_CODE
AND MLK12.LOOKUP_TYPE(+) = 'SYS_YES_NO'
AND MLK12.LOOKUP_CODE(+) = MSI.ROUNDING_CONTROL_TYPE
AND MLK13.LOOKUP_TYPE(+) = 'MSC_ATP_COMPONENTS_FLAG'
AND MLK13.LOOKUP_CODE(+) = TO_NUMBER(DECODE(MSI.ATP_FLAG
, 'N'
, 1
, 'Y'
, 2
, 'R'
, 3
, 'C'
, 4))
AND MLK14.LOOKUP_TYPE(+) = 'MSC_ATP_COMPONENTS_FLAG'
AND MLK14.LOOKUP_CODE(+) = TO_NUMBER(DECODE(MSI.ATP_COMPONENTS_FLAG
, 'N'
, 1
, 'Y'
, 2
, 'R'
, 3
, 'C'
, 4))
AND MLK15.LOOKUP_TYPE(+) = 'MSC_CONSIGNED_FLAG'
AND MLK15.LOOKUP_CODE(+) = MSI.CONSIGNED_FLAG UNION ALL SELECT DISTINCT MSI.ROWID
, MSI.PLAN_ID
, MSI.SR_INSTANCE_ID
, MSI.ORGANIZATION_ID
, MSI.INVENTORY_ITEM_ID
, MSI.ITEM_NAME
, MTP.ORGANIZATION_CODE
, MIC.SR_CATEGORY_ID
, MIC.CATEGORY_SET_ID
, MIC.CATEGORY_NAME
, MIC.DESCRIPTION
, MLK1.MEANING
, MSI.FULL_LEAD_TIME
, MSI.PREPROCESSING_LEAD_TIME
, MSI.POSTPROCESSING_LEAD_TIME
, MSI.FIXED_LEAD_TIME
, MSI.VARIABLE_LEAD_TIME
, MSI.FIXED_ORDER_QUANTITY
, MSI.FIXED_DAYS_SUPPLY
, MSI.SHRINKAGE_RATE
, MSI.FIXED_LOT_MULTIPLIER
, MSI.MINIMUM_ORDER_QUANTITY
, MSI.MAXIMUM_ORDER_QUANTITY
, MSIS_COLL.SERVICE_LEVEL
, MSI.CARRYING_COST
, MSI.DEMAND_TIME_FENCE_DAYS
, MLK2.MEANING
, MSI.PLANNING_TIME_FENCE_DAYS
, MSI.STANDARD_COST
, NVL(MSI.LIST_PRICE
, 0)*(1-NVL(MSI.AVERAGE_DISCOUNT
, 0)/100)
, MLK3.MEANING
, MSI.LIST_PRICE
, MSI.SUBSTITUTION_WINDOW
, MSI.SAFETY_STOCK_BUCKET_DAYS
, MSI.UNIT_WEIGHT
, MSI.UNIT_VOLUME
, MLK4.MEANING
, MSI.SAFETY_STOCK_PERCENT
, MSI.ABC_CLASS_NAME
, MLK5.MEANING
, MLK6.MEANING
, MSI.DAYS_MAX_INV_SUPPLY
, MSI.DAYS_MAX_INV_WINDOW
, MSI.DAYS_TGT_INV_SUPPLY
, MSI.DAYS_TGT_INV_WINDOW
, MLK7.MEANING
, MLK8.MEANING
, MLK9.MEANING
, MLK10.MEANING
, MSI.PLANNING_EXCEPTION_SET
, MSI.INVENTORY_USE_UP_DATE
, MLK11.MEANING
, NVL(MSI.LIST_PRICE
, 0) - NVL(MSI.STANDARD_COST
, 0)
, MSI.WEIGHT_UOM
, MSI.VOLUME_UOM
, MLK12.MEANING
, MLK13.MEANING
, MLK14.MEANING
, MSIS_COLL.DEMAND_FULFILLMENT_LT
, MSI.LOTS_EXPIRATION
, MSI.VMI_MINIMUM_UNITS
, MSI.VMI_MINIMUM_DAYS
, MSI.VMI_MAXIMUM_UNITS
, MSI.VMI_MAXIMUM_DAYS
, MSI.VMI_FIXED_ORDER_QUANTITY
, MLK15.MEANING
, MSIS_COLL.LEADTIME_VARIABILITY
, MSI.PLANNER_CODE
, MSIS_COLL.EO_FLAG
, MSIS_COLL.EXCESS_HORIZON
, MSIS_COLL.OBSOLESCENCE_DATE
, MSI.MIN_SHELF_LIFE_DAYS
, MSI.REPAIR_LEAD_TIME
, MSI.REPAIR_YIELD
, MSI.REPAIR_COST
, MIC_COLL.CATEGORY_NAME
, MSIS_COLL.RELIABILITY
, MSIS_COLL.FAILURE_IMPACT
, MSIS_COLL.STANDARD_DEVIATION
, MSIS_COLL.COEFFICIENT_OF_VARIATION
, MSIS_COLL.BASIS_AVG_DAILY_DEMAND
, MSIS.ROWID
, MSIS.SIMULATION_SET_ID
, MLK16.MEANING
, MSIS.FULL_LEAD_TIME
, MSIS.PREPROCESSING_LEAD_TIME
, MSIS.POSTPROCESSING_LEAD_TIME
, MSIS.FIXED_LEAD_TIME
, MSIS.VARIABLE_LEAD_TIME
, MSIS.FIXED_ORDER_QUANTITY
, MSIS.FIXED_DAYS_SUPPLY
, MSIS.SHRINKAGE_RATE
, MSIS.FIXED_LOT_MULTIPLIER
, MSIS.MINIMUM_ORDER_QUANTITY
, MSIS.MAXIMUM_ORDER_QUANTITY
, DECODE(MSIS.SIMULATION_SET_ID
, -1
, NULL
, MSIS.SERVICE_LEVEL)
, MSIS.CARRYING_COST
, MSIS.DEMAND_TIME_FENCE_DAYS
, MLK17.MEANING
, MSIS.PLANNING_TIME_FENCE_DAYS
, MSIS.STANDARD_COST
, NULL
, MLK18.MEANING
, MSIS.LIST_PRICE
, MSIS.SUBSTITUTION_WINDOW
, MSIS.SAFETY_STOCK_BUCKET_DAYS
, MSIS.UNIT_WEIGHT
, MSIS.UNIT_VOLUME
, MLK19.MEANING
, MSIS.SAFETY_STOCK_PERCENT
, MSIS.ABC_CLASS_NAME
, MLK20.MEANING
, MLK21.MEANING
, MSIS.DAYS_MAX_INV_SUPPLY
, MSIS.DAYS_MAX_INV_WINDOW
, MSIS.DAYS_TGT_INV_SUPPLY
, MSIS.DAYS_TGT_INV_WINDOW
, MLK22.MEANING
, MLK23.MEANING
, MLK24.MEANING
, MLK25.MEANING
, MSIS.PLANNING_EXCEPTION_SET
, MSIS.INVENTORY_USE_UP_DATE
, MLK26.MEANING
, NULL
, MSIS.WEIGHT_UOM
, MSIS.VOLUME_UOM
, MLK27.MEANING
, MLK28.MEANING
, MLK29.MEANING
, DECODE(MSIS.SIMULATION_SET_ID
, -1
, NULL
, MSIS.DEMAND_FULFILLMENT_LT)
, MSIS.LOTS_EXPIRATION
, MSIS.VMI_MINIMUM_UNITS
, MSIS.VMI_MINIMUM_DAYS
, MSIS.VMI_MAXIMUM_UNITS
, MSIS.VMI_MAXIMUM_DAYS
, MSIS.VMI_FIXED_ORDER_QUANTITY
, MLK30.MEANING
, DECODE(MSIS.SIMULATION_SET_ID
, -1
, NULL
, MSIS.LEADTIME_VARIABILITY)
, MSIS.PLANNER_CODE
, DECODE(MSIS.SIMULATION_SET_ID
, -1
, NULL
, MLK31.MEANING)
, DECODE(MSIS.SIMULATION_SET_ID
, -1
, NULL
, MSIS.EXCESS_HORIZON)
, DECODE(MSIS.SIMULATION_SET_ID
, -1
, NULL
, MSIS.OBSOLESCENCE_DATE)
, MSIS.MIN_SHELF_LIFE_DAYS
, DECODE(MSIS.SIMULATION_SET_ID
, -1
, NULL
, MSIS.REPAIR_LEAD_TIME)
, DECODE(MSIS.SIMULATION_SET_ID
, -1
, NULL
, MSIS.REPAIR_YIELD)
, DECODE(MSIS.SIMULATION_SET_ID
, -1
, NULL
, MSIS.REPAIR_COST)
, NULL
, DECODE(MSIS.SIMULATION_SET_ID
, -1
, NULL
, MSIS.RELIABILITY)
, DECODE(MSIS.SIMULATION_SET_ID
, -1
, NULL
, MSIS.FAILURE_IMPACT)
, DECODE(MSIS.SIMULATION_SET_ID
, -1
, NULL
, MSIS.STANDARD_DEVIATION)
, DECODE(MSIS.SIMULATION_SET_ID
, -1
, NULL
, MSIS.COEFFICIENT_OF_VARIATION)
, DECODE(MSIS.SIMULATION_SET_ID
, -1
, NULL
, MSIS.BASIS_AVG_DAILY_DEMAND)
, MSIS.UPDATED_COLUMNS_COUNT
, 'YES'
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, MFR1.FORECAST_RULE_NAME
, MFR2.FORECAST_RULE_NAME
, MSIS.LIFE_TIME_BUY_DATE
, MSIS.END_OF_LIFE_DATE
, MSIS.AVG_DEMAND_BEYOND_PH
, MSIS.AVG_RETURNS_BEYOND_PH
, MSIS.RETURN_FORECAST_TIME_FENCE
, MSIS.AVERAGE_DAILY_DEMAND
, MSIS.DEFECTIVE_ITEM_COST
, MSIS.STD_DEVIATION_FOR_DEMAND
, MSIS.MEAN_INTER_ARRIVAL
, MSIS.STD_DEVIATION_INTER_ARRIVAL
, MSIS.INTERARRIVAL_DIST_METHOD
, MLK32.MEANING
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, MSIS.MAX_USAGE_FACTOR
, TO_NUMBER(NULL)
, MSIS.UNSATISFIED_DEMAND_FACTOR
, MSIS.DMD_SATISFIED_PERCENT
, MSIS.MIN_SUP_DEM_PERCENT
, MSIS.PICK_PACK_LT
, MLK33.MEANING
, MLK34.MEANING
FROM MSC_SYSTEM_ITEMS MSI
, MSC_TRADING_PARTNERS MTP
, MSC_ITEM_CATEGORIES MIC
, MSC_ITEM_CATEGORIES MIC_COLL
, MSC_ITEM_ATTRIBUTES MSIS
, MSC_ITEM_ATTRIBUTES MSIS_COLL
, MSC_FORECAST_RULES MFR1
, MSC_FORECAST_RULES MFR2
, MFG_LOOKUPS MLK1
, MFG_LOOKUPS MLK2
, MFG_LOOKUPS MLK3
, MFG_LOOKUPS MLK4
, MFG_LOOKUPS MLK5
, MFG_LOOKUPS MLK6
, MFG_LOOKUPS MLK7
, MFG_LOOKUPS MLK8
, MFG_LOOKUPS MLK9
, MFG_LOOKUPS MLK10
, MFG_LOOKUPS MLK11
, MFG_LOOKUPS MLK12
, MFG_LOOKUPS MLK13
, MFG_LOOKUPS MLK14
, MFG_LOOKUPS MLK15
, MFG_LOOKUPS MLK16
, MFG_LOOKUPS MLK17
, MFG_LOOKUPS MLK18
, MFG_LOOKUPS MLK19
, MFG_LOOKUPS MLK20
, MFG_LOOKUPS MLK21
, MFG_LOOKUPS MLK22
, MFG_LOOKUPS MLK23
, MFG_LOOKUPS MLK24
, MFG_LOOKUPS MLK25
, MFG_LOOKUPS MLK26
, MFG_LOOKUPS MLK27
, MFG_LOOKUPS MLK28
, MFG_LOOKUPS MLK29
, MFG_LOOKUPS MLK30
, MFG_LOOKUPS MLK31
, MFG_LOOKUPS MLK32
, MFG_LOOKUPS MLK33
, MFG_LOOKUPS MLK34
WHERE MSI.PLAN_ID = -1
AND MSIS.PLAN_ID = MSI.PLAN_ID
AND MSIS.SR_INSTANCE_ID = MSI.SR_INSTANCE_ID
AND MSIS.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND MSIS.ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND MSIS.FORECAST_RULE_FOR_DEMANDS = MFR1.FORECAST_RULE_ID (+)
AND MSIS.FORECAST_RULE_FOR_RETURNS = MFR2.FORECAST_RULE_ID (+)
AND MSIS.REGION_ID IS NULL
AND MSIS.CUSTOMER_ID IS NULL
AND MSIS_COLL.PLAN_ID (+) = MSI.PLAN_ID
AND MSIS_COLL.SR_INSTANCE_ID (+) = MSI.SR_INSTANCE_ID
AND MSIS_COLL.INVENTORY_ITEM_ID (+) = MSI.INVENTORY_ITEM_ID
AND MSIS_COLL.ORGANIZATION_ID (+) = MSI.ORGANIZATION_ID
AND MSIS_COLL.SIMULATION_SET_ID (+) = -1
AND MSIS_COLL.CRITICALITY_CATEGORY = MIC_COLL.SR_CATEGORY_ID(+)
AND MSIS_COLL.REGION_ID IS NULL
AND MSI.SR_INSTANCE_ID = MIC.SR_INSTANCE_ID
AND MSI.INVENTORY_ITEM_ID = MIC.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID = MIC.ORGANIZATION_ID
AND MTP.PARTNER_TYPE = 3
AND MTP.SR_TP_ID = MSI.ORGANIZATION_ID
AND MTP.SR_INSTANCE_ID = MSI.SR_INSTANCE_ID
AND MLK1.LOOKUP_TYPE(+) = 'SYS_YES_NO'
AND MLK1.LOOKUP_CODE(+) = MSI.CRITICAL_COMPONENT_FLAG
AND MLK2.LOOKUP_TYPE(+) = 'MRP_ATO_FORECAST_CONTROL'
AND MLK2.LOOKUP_CODE(+) = MSI.ATO_FORECAST_CONTROL
AND MLK3.LOOKUP_TYPE(+) = 'SYS_YES_NO'
AND MLK3.LOOKUP_CODE(+) = MSI.PIP_FLAG
AND MLK4.LOOKUP_TYPE(+) = 'MSC_SAFETY_STOCK_TYPE'
AND MLK4.LOOKUP_CODE(+) = MSI.SAFETY_STOCK_CODE
AND MLK5.LOOKUP_TYPE(+) = 'MRP_PLANNING_CODE'
AND MLK5.LOOKUP_CODE(+) = MSI.MRP_PLANNING_CODE
AND MLK6.LOOKUP_TYPE(+) = 'SYS_YES_NO'
AND MLK6.LOOKUP_CODE(+) = MSI.DRP_PLANNED
AND MLK7.LOOKUP_TYPE(+) = 'MSC_CONTINOUS_TRANSFER'
AND MLK7.LOOKUP_CODE(+) = MSI.CONTINOUS_TRANSFER
AND MLK8.LOOKUP_TYPE(+) = 'MSC_CONVERGENCE'
AND MLK8.LOOKUP_CODE(+) = MSI.CONVERGENCE
AND MLK9.LOOKUP_TYPE(+) = 'SYS_YES_NO'
AND MLK9.LOOKUP_CODE(+) = MSI.CREATE_SUPPLY_FLAG
AND MLK10.LOOKUP_TYPE(+) = 'MSC_DIVERGENCE'
AND MLK10.LOOKUP_CODE(+) = MSI.DIVERGENCE
AND MLK11.LOOKUP_TYPE(+) = 'MTL_PLANNING_MAKE_BUY'
AND MLK11.LOOKUP_CODE(+) = MSI.PLANNING_MAKE_BUY_CODE
AND MLK12.LOOKUP_TYPE(+) = 'SYS_YES_NO'
AND MLK12.LOOKUP_CODE(+) = MSI.ROUNDING_CONTROL_TYPE
AND MLK13.LOOKUP_TYPE(+) = 'MSC_ATP_COMPONENTS_FLAG'
AND MLK13.LOOKUP_CODE(+) = TO_NUMBER(DECODE(MSI.ATP_FLAG
, 'N'
, 1
, 'Y'
, 2
, 'R'
, 3
, 'C'
, 4))
AND MLK14.LOOKUP_TYPE(+) = 'MSC_ATP_COMPONENTS_FLAG'
AND MLK14.LOOKUP_CODE(+) = TO_NUMBER(DECODE(MSI.ATP_COMPONENTS_FLAG
, 'N'
, 1
, 'Y'
, 2
, 'R'
, 3
, 'C'
, 4))
AND MLK15.LOOKUP_TYPE(+) = 'MSC_CONSIGNED_FLAG'
AND MLK15.LOOKUP_CODE(+) = MSI.CONSIGNED_FLAG
AND MLK16.LOOKUP_TYPE(+) = 'SYS_YES_NO'
AND MLK16.LOOKUP_CODE(+) = MSIS.CRITICAL_COMPONENT_FLAG
AND MLK17.LOOKUP_TYPE(+) = 'MRP_ATO_FORECAST_CONTROL'
AND MLK17.LOOKUP_CODE(+) = MSIS.ATO_FORECAST_CONTROL
AND MLK18.LOOKUP_TYPE(+) = 'SYS_YES_NO'
AND MLK18.LOOKUP_CODE(+) = MSIS.PIP_FLAG
AND MLK19.LOOKUP_TYPE(+) = 'MSC_SAFETY_STOCK_TYPE'
AND MLK19.LOOKUP_CODE(+) = MSIS.SAFETY_STOCK_CODE
AND MLK20.LOOKUP_TYPE(+) = 'MRP_PLANNING_CODE'
AND MLK20.LOOKUP_CODE(+) = MSIS.MRP_PLANNING_CODE
AND MLK21.LOOKUP_TYPE(+) = 'SYS_YES_NO'
AND MLK21.LOOKUP_CODE(+) = MSIS.DRP_PLANNED
AND MLK22.LOOKUP_TYPE(+) = 'MSC_CONTINOUS_TRANSFER'
AND MLK22.LOOKUP_CODE(+) = MSIS.CONTINOUS_TRANSFER
AND MLK23.LOOKUP_TYPE(+) = 'MSC_CONVERGENCE'
AND MLK23.LOOKUP_CODE(+) = MSIS.CONVERGENCE
AND MLK24.LOOKUP_TYPE(+) = 'SYS_YES_NO'
AND MLK24.LOOKUP_CODE(+) = MSIS.CREATE_SUPPLY_FLAG
AND MLK25.LOOKUP_TYPE(+) = 'MSC_DIVERGENCE'
AND MLK25.LOOKUP_CODE(+) = MSIS.DIVERGENCE
AND MLK26.LOOKUP_TYPE(+) = 'MTL_PLANNING_MAKE_BUY'
AND MLK26.LOOKUP_CODE(+) = MSIS.PLANNING_MAKE_BUY_CODE
AND MLK27.LOOKUP_TYPE(+) = 'SYS_YES_NO'
AND MLK27.LOOKUP_CODE(+) = MSIS.ROUNDING_CONTROL_TYPE
AND MLK28.LOOKUP_TYPE(+) = 'MSC_ATP_COMPONENTS_FLAG'
AND MLK28.LOOKUP_CODE(+) = TO_NUMBER(DECODE(MSIS.ATP_FLAG
, 'N'
, 1
, 'Y'
, 2
, 'R'
, 3
, 'C'
, 4))
AND MLK29.LOOKUP_TYPE(+) = 'MSC_ATP_COMPONENTS_FLAG'
AND MLK29.LOOKUP_CODE(+) = TO_NUMBER(DECODE(MSIS.ATP_COMPONENTS_FLAG
, 'N'
, 1
, 'Y'
, 2
, 'R'
, 3
, 'C'
, 4))
AND MLK30.LOOKUP_TYPE(+) = 'MSC_CONSIGNED_FLAG'
AND MLK30.LOOKUP_CODE(+) = MSIS.CONSIGNED_FLAG
AND MLK31.LOOKUP_TYPE(+) = 'SYS_YES_NO'
AND MLK31.LOOKUP_CODE(+) = MSIS.EO_FLAG
AND MLK32.LOOKUP_TYPE(+) = 'SYS_YES_NO'
AND MLK32.LOOKUP_CODE(+) = MSIS.INTERMITTENT_DEMAND
AND MLK33.LOOKUP_TYPE(+) = 'MSC_REPAIR_PROGRAM'
AND MLK33.LOOKUP_CODE(+) = MSIS.REPAIR_PROGRAM
AND MLK34.LOOKUP_TYPE(+) = 'SYS_YES_NO'
AND MLK34.LOOKUP_CODE(+) = MSIS.PRE_POSITION_POINT