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, msc_get_name.lookup_meaning('SYS_YES_NO',MSI.CRITICAL_COMPONENT_FLAG), MSI.BUYER_NAME, 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, msc_get_name.lookup_meaning('MRP_ATO_FORECAST_CONTROL',MSI.ATO_FORECAST_CONTROL), MSI.PLANNING_TIME_FENCE_DAYS, MSI.STANDARD_COST, NVL(MSI.LIST_PRICE, 0)*(1-NVL(MSI.AVERAGE_DISCOUNT, 0)/100), msc_get_name.lookup_meaning('SYS_YES_NO',MSI.PIP_FLAG), MSI.LIST_PRICE, MSI.SUBSTITUTION_WINDOW, MSI.SAFETY_STOCK_BUCKET_DAYS, MSI.UNIT_WEIGHT, MSI.UNIT_VOLUME, msc_get_name.lookup_meaning('MSC_SAFETY_STOCK_TYPE',MSI.SAFETY_STOCK_CODE), MSI.SAFETY_STOCK_PERCENT, MSI.ABC_CLASS_NAME, msc_get_name.lookup_meaning('MRP_PLANNING_CODE',MSI.MRP_PLANNING_CODE), msc_get_name.lookup_meaning('SYS_YES_NO',MSI.DRP_PLANNED), MSI.DAYS_MAX_INV_SUPPLY, MSI.DAYS_MAX_INV_WINDOW, MSI.DAYS_TGT_INV_SUPPLY, MSI.DAYS_TGT_INV_WINDOW, msc_get_name.lookup_meaning('MSC_CONTINOUS_TRANSFER',MSI.CONTINOUS_TRANSFER), msc_get_name.lookup_meaning('MSC_CONVERGENCE',MSI.CONVERGENCE), msc_get_name.lookup_meaning('SYS_YES_NO',MSI.CREATE_SUPPLY_FLAG), msc_get_name.lookup_meaning('MSC_DIVERGENCE',MSI.DIVERGENCE), MSI.PLANNING_EXCEPTION_SET, MSI.INVENTORY_USE_UP_DATE, msc_get_name.lookup_meaning('MTL_PLANNING_MAKE_BUY',MSI.PLANNING_MAKE_BUY_CODE), NVL(MSI.list_price, 0) - NVL(MSI.standard_cost, 0), MSI.WEIGHT_UOM, MSI.VOLUME_UOM, msc_get_name.lookup_meaning('SYS_YES_NO',MSI.ROUNDING_CONTROL_TYPE), msc_get_name.lookup_meaning ('MSC_ATP_COMPONENTS_FLAG', to_number(DECODE(MSI.ATP_FLAG,'N',1,'Y',2,'R',3,'C',4))), msc_get_name.lookup_meaning ('MSC_ATP_COMPONENTS_FLAG', to_number(DECODE(MSI.ATP_COMPONENTS_FLAG,'N',1,'Y',2,'R',3,'C',4))), 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, msc_get_name.lookup_meaning('MSC_CONSIGNED_FLAG',MSI.CONSIGNED_FLAG), 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, msc_get_name.category_name(MSIS_COLL.CRITICALITY_CATEGORY,fnd_profile.value('MSC_CRIT_CATEGORY_SET'),MSIS_COLL.ORGANIZATION_ID,MSIS_COLL.SR_INSTANCE_ID), MSIS_coll.RELIABILITY, MSIS_coll.FAILURE_IMPACT, MSIS_coll.STANDARD_DEVIATION, MSIS_coll.COEFFICIENT_OF_VARIATION, MSIS_coll.BASIS_AVG_DAILY_DEMAND, msc_get_name.lookup_meaning('SYS_YES_NO',MSIS_COLL.COMPUTE_SS), msc_get_name.lookup_meaning('SYS_YES_NO',MSIS_COLL.COMPUTE_EOQ), MSI.ORDER_COST, to_number(null), to_number(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, 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), null, null, to_number(null), to_number(null), to_number(null), null new_planned_order, null ori_new_planned_order, to_number(null) rop_safety_stock, to_number(null) ori_rop_safety_stock, to_number(null) ori_min_rem_shelf_life_days, to_number(null) intermittency_threshold, to_number(null) ori_intermittency_threshold, to_number(null) repair_module, to_number(null) ori_repair_module, to_number(null) scrap_rate, to_number(null) ori_scrap_rate, null rebuild_activity, null ori_rebuild_activity, to_number(null) ori_order_period, to_number(null) order_period, to_number(null) ori_inv_days_increment, to_number(null) inv_days_increment, null pre_position_point FROM msc_system_items msi, msc_trading_partners mtp, MSC_ITEM_ATTRIBUTES MSIS_coll, 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 mtp.partner_type = 3 and mtp.sr_tp_id = msi.organization_id and mtp.sr_instance_id = msi.sr_instance_id 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, msc_get_name.lookup_meaning('SYS_YES_NO',MSI.CRITICAL_COMPONENT_FLAG), msi.buyer_name, 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, msc_get_name.lookup_meaning('MRP_ATO_FORECAST_CONTROL',MSI.ATO_FORECAST_CONTROL), MSI.PLANNING_TIME_FENCE_DAYS, MSI.STANDARD_COST, NVL(MSI.LIST_PRICE, 0)*(1-NVL(MSI.AVERAGE_DISCOUNT, 0)/100), msc_get_name.lookup_meaning('SYS_YES_NO',MSI.PIP_FLAG), MSI.LIST_PRICE, MSI.SUBSTITUTION_WINDOW, MSI.SAFETY_STOCK_BUCKET_DAYS, MSI.UNIT_WEIGHT, MSI.UNIT_VOLUME, msc_get_name.lookup_meaning('MSC_SAFETY_STOCK_TYPE',MSI.SAFETY_STOCK_CODE), MSI.SAFETY_STOCK_PERCENT, MSI.ABC_CLASS_NAME, msc_get_name.lookup_meaning('MRP_PLANNING_CODE',MSI.MRP_PLANNING_CODE), msc_get_name.lookup_meaning('SYS_YES_NO',MSI.DRP_PLANNED), MSI.DAYS_MAX_INV_SUPPLY, MSI.DAYS_MAX_INV_WINDOW, MSI.DAYS_TGT_INV_SUPPLY, MSI.DAYS_TGT_INV_WINDOW, msc_get_name.lookup_meaning('MSC_CONTINOUS_TRANSFER',MSI.CONTINOUS_TRANSFER), msc_get_name.lookup_meaning('MSC_CONVERGENCE',MSI.CONVERGENCE), msc_get_name.lookup_meaning('SYS_YES_NO',MSI.CREATE_SUPPLY_FLAG), msc_get_name.lookup_meaning('MSC_DIVERGENCE',MSI.DIVERGENCE), MSI.PLANNING_EXCEPTION_SET, MSI.INVENTORY_USE_UP_DATE, msc_get_name.lookup_meaning('MTL_PLANNING_MAKE_BUY',MSI.PLANNING_MAKE_BUY_CODE), NVL(MSI.list_price, 0) - NVL(MSI.standard_cost, 0), MSI.WEIGHT_UOM, MSI.VOLUME_UOM, msc_get_name.lookup_meaning('SYS_YES_NO',MSI.ROUNDING_CONTROL_TYPE), msc_get_name.lookup_meaning('MSC_ATP_COMPONENTS_FLAG', to_number(DECODE(MSI.ATP_FLAG,'N',1,'Y',2,'R',3,'C',4))), msc_get_name.lookup_meaning('MSC_ATP_COMPONENTS_FLAG', to_number(DECODE(MSI.ATP_COMPONENTS_FLAG,'N',1,'Y',2,'R',3,'C',4))), 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, msc_get_name.lookup_meaning('MSC_CONSIGNED_FLAG',MSI.CONSIGNED_FLAG), 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, msc_get_name.category_name(MSIS_COLL.CRITICALITY_CATEGORY,fnd_profile.value('MSC_CRIT_CATEGORY_SET'), MSIS_COLL.ORGANIZATION_ID,MSIS_COLL.SR_INSTANCE_ID), MSIS_coll.RELIABILITY, MSIS_coll.FAILURE_IMPACT, MSIS_coll.STANDARD_DEVIATION, MSIS_coll.COEFFICIENT_OF_VARIATION, MSIS_coll.BASIS_AVG_DAILY_DEMAND, msc_get_name.lookup_meaning('SYS_YES_NO',MSIS_COLL.COMPUTE_SS), msc_get_name.lookup_meaning('SYS_YES_NO',MSIS_COLL.COMPUTE_EOQ), MSI.ORDER_COST, to_number(null), to_number(null), MSIS.ROWID, MSIS.SIMULATION_SET_ID, msc_get_name.lookup_meaning('SYS_YES_NO',MSIS.CRITICAL_COMPONENT_FLAG), 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, msc_get_name.lookup_meaning('MRP_ATO_FORECAST_CONTROL',MSIS.ATO_FORECAST_CONTROL), MSIS.PLANNING_TIME_FENCE_DAYS, MSIS.STANDARD_COST, null, msc_get_name.lookup_meaning('SYS_YES_NO',MSIS.PIP_FLAG), MSIS.LIST_PRICE, MSIS.SUBSTITUTION_WINDOW, MSIS.SAFETY_STOCK_BUCKET_DAYS, MSIS.UNIT_WEIGHT, MSIS.UNIT_VOLUME, msc_get_name.lookup_meaning('MSC_SAFETY_STOCK_TYPE',MSIS.SAFETY_STOCK_CODE), MSIS.SAFETY_STOCK_PERCENT, MSIS.ABC_CLASS_NAME, msc_get_name.lookup_meaning('MRP_PLANNING_CODE',MSIS.MRP_PLANNING_CODE), msc_get_name.lookup_meaning('SYS_YES_NO',MSIS.DRP_PLANNED), MSIS.DAYS_MAX_INV_SUPPLY, MSIS.DAYS_MAX_INV_WINDOW, MSIS.DAYS_TGT_INV_SUPPLY, MSIS.DAYS_TGT_INV_WINDOW, msc_get_name.lookup_meaning('MSC_CONTINOUS_TRANSFER',MSIS.CONTINOUS_TRANSFER), msc_get_name.lookup_meaning('MSC_CONVERGENCE',MSIS.CONVERGENCE), msc_get_name.lookup_meaning('SYS_YES_NO',MSIS.CREATE_SUPPLY_FLAG), msc_get_name.lookup_meaning('MSC_DIVERGENCE',MSIS.DIVERGENCE), MSIS.PLANNING_EXCEPTION_SET, MSIS.INVENTORY_USE_UP_DATE, msc_get_name.lookup_meaning('MTL_PLANNING_MAKE_BUY',MSIS.PLANNING_MAKE_BUY_CODE), null, MSIS.WEIGHT_UOM, MSIS.VOLUME_UOM, msc_get_name.lookup_meaning('SYS_YES_NO',MSIS.ROUNDING_CONTROL_TYPE), msc_get_name.lookup_meaning('MSC_ATP_COMPONENTS_FLAG', to_number(DECODE(MSIS.ATP_FLAG,'N',1,'Y',2,'R',3,'C',4))), msc_get_name.lookup_meaning('MSC_ATP_COMPONENTS_FLAG', to_number(DECODE(MSIS.ATP_COMPONENTS_FLAG,'N',1,'Y',2,'R',3,'C',4))), 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, msc_get_name.lookup_meaning('MSC_CONSIGNED_FLAG',MSIS.CONSIGNED_FLAG), decode(MSIS.SIMULATION_SET_ID,-1,null,MSIS.LEADTIME_VARIABILITY), MSIS.PLANNER_CODE, decode(MSIS.SIMULATION_SET_ID,-1,null, msc_get_name.lookup_meaning('SYS_YES_NO',MSIS.EO_FLAG)), to_number(decode(MSIS.SIMULATION_SET_ID,-1,null,MSIS.EXCESS_HORIZON)), decode(MSIS.SIMULATION_SET_ID,-1,fnd_date.CHARDT_TO_DATE(null),MSIS.OBSOLESCENCE_DATE) 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, msc_get_name.lookup_meaning('MSC_INTERMITTENT_DEMAND',MSIS.INTERMITTENT_DEMAND), to_number(null), null, to_number(null), to_number(null), null, msis.max_usage_factor, msis.min_rem_shelf_life_days, msis.Unsatisfied_demand_factor, msis.dmd_satisfied_percent, msis.min_sup_dem_percent, msc_get_name.lookup_meaning('SYS_YES_NO',MSIS.COMPUTE_SS), msc_get_name.lookup_meaning('SYS_YES_NO',MSIS.COMPUTE_EOQ), msis.order_cost, msis.annual_usage, msis.annual_carrying_cost, msc_get_name.lookup_meaning('MSC_IMM_NEW_PLANNED_ORDER',MSIS.NEW_PLANNED_ORDER), null, msis.rop_safety_stock, to_number(null), to_number(null) ori_min_rem_shelf_life_days, msis.intermittency_threshold, to_number(null) ori_intermittency_threshold, msc_get_name.lookup_meaning('MSC_REPAIR_MODULE',MSIS.REPAIR_MODULE), to_number(null), msis.scrap_rate, to_number(null) ori_scrap_rate, msc_get_name.getActivity(msis.rebuild_activity,msis.sr_instance_id,msis.organization_id,msis.inventory_item_id), null, to_number(null) ori_order_period, msis.order_period, to_number(null) ori_inv_days_increment, msis.inv_days_increment, msc_get_name.lookup_meaning('SYS_YES_NO',MSIS.Pre_position_point) FROM MSC_SYSTEM_ITEMS MSI, MSC_TRADING_PARTNERS MTP, MSC_ITEM_CATEGORIES MIC, MSC_ITEM_ATTRIBUTES MSIS, MSC_ITEM_ATTRIBUTES MSIS_coll, msc_forecast_rules mfr1, msc_forecast_rules mfr2 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.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

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
, MSC_GET_NAME.LOOKUP_MEANING('SYS_YES_NO'
, MSI.CRITICAL_COMPONENT_FLAG)
, MSI.BUYER_NAME
, 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
, MSC_GET_NAME.LOOKUP_MEANING('MRP_ATO_FORECAST_CONTROL'
, MSI.ATO_FORECAST_CONTROL)
, MSI.PLANNING_TIME_FENCE_DAYS
, MSI.STANDARD_COST
, NVL(MSI.LIST_PRICE
, 0)*(1-NVL(MSI.AVERAGE_DISCOUNT
, 0)/100)
, MSC_GET_NAME.LOOKUP_MEANING('SYS_YES_NO'
, MSI.PIP_FLAG)
, MSI.LIST_PRICE
, MSI.SUBSTITUTION_WINDOW
, MSI.SAFETY_STOCK_BUCKET_DAYS
, MSI.UNIT_WEIGHT
, MSI.UNIT_VOLUME
, MSC_GET_NAME.LOOKUP_MEANING('MSC_SAFETY_STOCK_TYPE'
, MSI.SAFETY_STOCK_CODE)
, MSI.SAFETY_STOCK_PERCENT
, MSI.ABC_CLASS_NAME
, MSC_GET_NAME.LOOKUP_MEANING('MRP_PLANNING_CODE'
, MSI.MRP_PLANNING_CODE)
, MSC_GET_NAME.LOOKUP_MEANING('SYS_YES_NO'
, MSI.DRP_PLANNED)
, MSI.DAYS_MAX_INV_SUPPLY
, MSI.DAYS_MAX_INV_WINDOW
, MSI.DAYS_TGT_INV_SUPPLY
, MSI.DAYS_TGT_INV_WINDOW
, MSC_GET_NAME.LOOKUP_MEANING('MSC_CONTINOUS_TRANSFER'
, MSI.CONTINOUS_TRANSFER)
, MSC_GET_NAME.LOOKUP_MEANING('MSC_CONVERGENCE'
, MSI.CONVERGENCE)
, MSC_GET_NAME.LOOKUP_MEANING('SYS_YES_NO'
, MSI.CREATE_SUPPLY_FLAG)
, MSC_GET_NAME.LOOKUP_MEANING('MSC_DIVERGENCE'
, MSI.DIVERGENCE)
, MSI.PLANNING_EXCEPTION_SET
, MSI.INVENTORY_USE_UP_DATE
, MSC_GET_NAME.LOOKUP_MEANING('MTL_PLANNING_MAKE_BUY'
, MSI.PLANNING_MAKE_BUY_CODE)
, NVL(MSI.LIST_PRICE
, 0) - NVL(MSI.STANDARD_COST
, 0)
, MSI.WEIGHT_UOM
, MSI.VOLUME_UOM
, MSC_GET_NAME.LOOKUP_MEANING('SYS_YES_NO'
, MSI.ROUNDING_CONTROL_TYPE)
, MSC_GET_NAME.LOOKUP_MEANING ('MSC_ATP_COMPONENTS_FLAG'
, TO_NUMBER(DECODE(MSI.ATP_FLAG
, 'N'
, 1
, 'Y'
, 2
, 'R'
, 3
, 'C'
, 4)))
, MSC_GET_NAME.LOOKUP_MEANING ('MSC_ATP_COMPONENTS_FLAG'
, TO_NUMBER(DECODE(MSI.ATP_COMPONENTS_FLAG
, 'N'
, 1
, 'Y'
, 2
, 'R'
, 3
, 'C'
, 4)))
, 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
, MSC_GET_NAME.LOOKUP_MEANING('MSC_CONSIGNED_FLAG'
, MSI.CONSIGNED_FLAG)
, 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
, MSC_GET_NAME.CATEGORY_NAME(MSIS_COLL.CRITICALITY_CATEGORY
, FND_PROFILE.VALUE('MSC_CRIT_CATEGORY_SET')
, MSIS_COLL.ORGANIZATION_ID
, MSIS_COLL.SR_INSTANCE_ID)
, MSIS_COLL.RELIABILITY
, MSIS_COLL.FAILURE_IMPACT
, MSIS_COLL.STANDARD_DEVIATION
, MSIS_COLL.COEFFICIENT_OF_VARIATION
, MSIS_COLL.BASIS_AVG_DAILY_DEMAND
, MSC_GET_NAME.LOOKUP_MEANING('SYS_YES_NO'
, MSIS_COLL.COMPUTE_SS)
, MSC_GET_NAME.LOOKUP_MEANING('SYS_YES_NO'
, MSIS_COLL.COMPUTE_EOQ)
, MSI.ORDER_COST
, TO_NUMBER(NULL)
, TO_NUMBER(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
, 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)
, NULL
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL NEW_PLANNED_ORDER
, NULL ORI_NEW_PLANNED_ORDER
, TO_NUMBER(NULL) ROP_SAFETY_STOCK
, TO_NUMBER(NULL) ORI_ROP_SAFETY_STOCK
, TO_NUMBER(NULL) ORI_MIN_REM_SHELF_LIFE_DAYS
, TO_NUMBER(NULL) INTERMITTENCY_THRESHOLD
, TO_NUMBER(NULL) ORI_INTERMITTENCY_THRESHOLD
, TO_NUMBER(NULL) REPAIR_MODULE
, TO_NUMBER(NULL) ORI_REPAIR_MODULE
, TO_NUMBER(NULL) SCRAP_RATE
, TO_NUMBER(NULL) ORI_SCRAP_RATE
, NULL REBUILD_ACTIVITY
, NULL ORI_REBUILD_ACTIVITY
, TO_NUMBER(NULL) ORI_ORDER_PERIOD
, TO_NUMBER(NULL) ORDER_PERIOD
, TO_NUMBER(NULL) ORI_INV_DAYS_INCREMENT
, TO_NUMBER(NULL) INV_DAYS_INCREMENT
, NULL PRE_POSITION_POINT
FROM MSC_SYSTEM_ITEMS MSI
, MSC_TRADING_PARTNERS MTP
, MSC_ITEM_ATTRIBUTES MSIS_COLL
, 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 MTP.PARTNER_TYPE = 3
AND MTP.SR_TP_ID = MSI.ORGANIZATION_ID
AND MTP.SR_INSTANCE_ID = MSI.SR_INSTANCE_ID 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
, MSC_GET_NAME.LOOKUP_MEANING('SYS_YES_NO'
, MSI.CRITICAL_COMPONENT_FLAG)
, MSI.BUYER_NAME
, 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
, MSC_GET_NAME.LOOKUP_MEANING('MRP_ATO_FORECAST_CONTROL'
, MSI.ATO_FORECAST_CONTROL)
, MSI.PLANNING_TIME_FENCE_DAYS
, MSI.STANDARD_COST
, NVL(MSI.LIST_PRICE
, 0)*(1-NVL(MSI.AVERAGE_DISCOUNT
, 0)/100)
, MSC_GET_NAME.LOOKUP_MEANING('SYS_YES_NO'
, MSI.PIP_FLAG)
, MSI.LIST_PRICE
, MSI.SUBSTITUTION_WINDOW
, MSI.SAFETY_STOCK_BUCKET_DAYS
, MSI.UNIT_WEIGHT
, MSI.UNIT_VOLUME
, MSC_GET_NAME.LOOKUP_MEANING('MSC_SAFETY_STOCK_TYPE'
, MSI.SAFETY_STOCK_CODE)
, MSI.SAFETY_STOCK_PERCENT
, MSI.ABC_CLASS_NAME
, MSC_GET_NAME.LOOKUP_MEANING('MRP_PLANNING_CODE'
, MSI.MRP_PLANNING_CODE)
, MSC_GET_NAME.LOOKUP_MEANING('SYS_YES_NO'
, MSI.DRP_PLANNED)
, MSI.DAYS_MAX_INV_SUPPLY
, MSI.DAYS_MAX_INV_WINDOW
, MSI.DAYS_TGT_INV_SUPPLY
, MSI.DAYS_TGT_INV_WINDOW
, MSC_GET_NAME.LOOKUP_MEANING('MSC_CONTINOUS_TRANSFER'
, MSI.CONTINOUS_TRANSFER)
, MSC_GET_NAME.LOOKUP_MEANING('MSC_CONVERGENCE'
, MSI.CONVERGENCE)
, MSC_GET_NAME.LOOKUP_MEANING('SYS_YES_NO'
, MSI.CREATE_SUPPLY_FLAG)
, MSC_GET_NAME.LOOKUP_MEANING('MSC_DIVERGENCE'
, MSI.DIVERGENCE)
, MSI.PLANNING_EXCEPTION_SET
, MSI.INVENTORY_USE_UP_DATE
, MSC_GET_NAME.LOOKUP_MEANING('MTL_PLANNING_MAKE_BUY'
, MSI.PLANNING_MAKE_BUY_CODE)
, NVL(MSI.LIST_PRICE
, 0) - NVL(MSI.STANDARD_COST
, 0)
, MSI.WEIGHT_UOM
, MSI.VOLUME_UOM
, MSC_GET_NAME.LOOKUP_MEANING('SYS_YES_NO'
, MSI.ROUNDING_CONTROL_TYPE)
, MSC_GET_NAME.LOOKUP_MEANING('MSC_ATP_COMPONENTS_FLAG'
, TO_NUMBER(DECODE(MSI.ATP_FLAG
, 'N'
, 1
, 'Y'
, 2
, 'R'
, 3
, 'C'
, 4)))
, MSC_GET_NAME.LOOKUP_MEANING('MSC_ATP_COMPONENTS_FLAG'
, TO_NUMBER(DECODE(MSI.ATP_COMPONENTS_FLAG
, 'N'
, 1
, 'Y'
, 2
, 'R'
, 3
, 'C'
, 4)))
, 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
, MSC_GET_NAME.LOOKUP_MEANING('MSC_CONSIGNED_FLAG'
, MSI.CONSIGNED_FLAG)
, 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
, MSC_GET_NAME.CATEGORY_NAME(MSIS_COLL.CRITICALITY_CATEGORY
, FND_PROFILE.VALUE('MSC_CRIT_CATEGORY_SET')
, MSIS_COLL.ORGANIZATION_ID
, MSIS_COLL.SR_INSTANCE_ID)
, MSIS_COLL.RELIABILITY
, MSIS_COLL.FAILURE_IMPACT
, MSIS_COLL.STANDARD_DEVIATION
, MSIS_COLL.COEFFICIENT_OF_VARIATION
, MSIS_COLL.BASIS_AVG_DAILY_DEMAND
, MSC_GET_NAME.LOOKUP_MEANING('SYS_YES_NO'
, MSIS_COLL.COMPUTE_SS)
, MSC_GET_NAME.LOOKUP_MEANING('SYS_YES_NO'
, MSIS_COLL.COMPUTE_EOQ)
, MSI.ORDER_COST
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, MSIS.ROWID
, MSIS.SIMULATION_SET_ID
, MSC_GET_NAME.LOOKUP_MEANING('SYS_YES_NO'
, MSIS.CRITICAL_COMPONENT_FLAG)
, 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
, MSC_GET_NAME.LOOKUP_MEANING('MRP_ATO_FORECAST_CONTROL'
, MSIS.ATO_FORECAST_CONTROL)
, MSIS.PLANNING_TIME_FENCE_DAYS
, MSIS.STANDARD_COST
, NULL
, MSC_GET_NAME.LOOKUP_MEANING('SYS_YES_NO'
, MSIS.PIP_FLAG)
, MSIS.LIST_PRICE
, MSIS.SUBSTITUTION_WINDOW
, MSIS.SAFETY_STOCK_BUCKET_DAYS
, MSIS.UNIT_WEIGHT
, MSIS.UNIT_VOLUME
, MSC_GET_NAME.LOOKUP_MEANING('MSC_SAFETY_STOCK_TYPE'
, MSIS.SAFETY_STOCK_CODE)
, MSIS.SAFETY_STOCK_PERCENT
, MSIS.ABC_CLASS_NAME
, MSC_GET_NAME.LOOKUP_MEANING('MRP_PLANNING_CODE'
, MSIS.MRP_PLANNING_CODE)
, MSC_GET_NAME.LOOKUP_MEANING('SYS_YES_NO'
, MSIS.DRP_PLANNED)
, MSIS.DAYS_MAX_INV_SUPPLY
, MSIS.DAYS_MAX_INV_WINDOW
, MSIS.DAYS_TGT_INV_SUPPLY
, MSIS.DAYS_TGT_INV_WINDOW
, MSC_GET_NAME.LOOKUP_MEANING('MSC_CONTINOUS_TRANSFER'
, MSIS.CONTINOUS_TRANSFER)
, MSC_GET_NAME.LOOKUP_MEANING('MSC_CONVERGENCE'
, MSIS.CONVERGENCE)
, MSC_GET_NAME.LOOKUP_MEANING('SYS_YES_NO'
, MSIS.CREATE_SUPPLY_FLAG)
, MSC_GET_NAME.LOOKUP_MEANING('MSC_DIVERGENCE'
, MSIS.DIVERGENCE)
, MSIS.PLANNING_EXCEPTION_SET
, MSIS.INVENTORY_USE_UP_DATE
, MSC_GET_NAME.LOOKUP_MEANING('MTL_PLANNING_MAKE_BUY'
, MSIS.PLANNING_MAKE_BUY_CODE)
, NULL
, MSIS.WEIGHT_UOM
, MSIS.VOLUME_UOM
, MSC_GET_NAME.LOOKUP_MEANING('SYS_YES_NO'
, MSIS.ROUNDING_CONTROL_TYPE)
, MSC_GET_NAME.LOOKUP_MEANING('MSC_ATP_COMPONENTS_FLAG'
, TO_NUMBER(DECODE(MSIS.ATP_FLAG
, 'N'
, 1
, 'Y'
, 2
, 'R'
, 3
, 'C'
, 4)))
, MSC_GET_NAME.LOOKUP_MEANING('MSC_ATP_COMPONENTS_FLAG'
, TO_NUMBER(DECODE(MSIS.ATP_COMPONENTS_FLAG
, 'N'
, 1
, 'Y'
, 2
, 'R'
, 3
, 'C'
, 4)))
, 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
, MSC_GET_NAME.LOOKUP_MEANING('MSC_CONSIGNED_FLAG'
, MSIS.CONSIGNED_FLAG)
, DECODE(MSIS.SIMULATION_SET_ID
, -1
, NULL
, MSIS.LEADTIME_VARIABILITY)
, MSIS.PLANNER_CODE
, DECODE(MSIS.SIMULATION_SET_ID
, -1
, NULL
, MSC_GET_NAME.LOOKUP_MEANING('SYS_YES_NO'
, MSIS.EO_FLAG))
, TO_NUMBER(DECODE(MSIS.SIMULATION_SET_ID
, -1
, NULL
, MSIS.EXCESS_HORIZON))
, DECODE(MSIS.SIMULATION_SET_ID
, -1
, FND_DATE.CHARDT_TO_DATE(NULL)
, MSIS.OBSOLESCENCE_DATE) 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
, MSC_GET_NAME.LOOKUP_MEANING('MSC_INTERMITTENT_DEMAND'
, MSIS.INTERMITTENT_DEMAND)
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, MSIS.MAX_USAGE_FACTOR
, MSIS.MIN_REM_SHELF_LIFE_DAYS
, MSIS.UNSATISFIED_DEMAND_FACTOR
, MSIS.DMD_SATISFIED_PERCENT
, MSIS.MIN_SUP_DEM_PERCENT
, MSC_GET_NAME.LOOKUP_MEANING('SYS_YES_NO'
, MSIS.COMPUTE_SS)
, MSC_GET_NAME.LOOKUP_MEANING('SYS_YES_NO'
, MSIS.COMPUTE_EOQ)
, MSIS.ORDER_COST
, MSIS.ANNUAL_USAGE
, MSIS.ANNUAL_CARRYING_COST
, MSC_GET_NAME.LOOKUP_MEANING('MSC_IMM_NEW_PLANNED_ORDER'
, MSIS.NEW_PLANNED_ORDER)
, NULL
, MSIS.ROP_SAFETY_STOCK
, TO_NUMBER(NULL)
, TO_NUMBER(NULL) ORI_MIN_REM_SHELF_LIFE_DAYS
, MSIS.INTERMITTENCY_THRESHOLD
, TO_NUMBER(NULL) ORI_INTERMITTENCY_THRESHOLD
, MSC_GET_NAME.LOOKUP_MEANING('MSC_REPAIR_MODULE'
, MSIS.REPAIR_MODULE)
, TO_NUMBER(NULL)
, MSIS.SCRAP_RATE
, TO_NUMBER(NULL) ORI_SCRAP_RATE
, MSC_GET_NAME.GETACTIVITY(MSIS.REBUILD_ACTIVITY
, MSIS.SR_INSTANCE_ID
, MSIS.ORGANIZATION_ID
, MSIS.INVENTORY_ITEM_ID)
, NULL
, TO_NUMBER(NULL) ORI_ORDER_PERIOD
, MSIS.ORDER_PERIOD
, TO_NUMBER(NULL) ORI_INV_DAYS_INCREMENT
, MSIS.INV_DAYS_INCREMENT
, MSC_GET_NAME.LOOKUP_MEANING('SYS_YES_NO'
, MSIS.PRE_POSITION_POINT)
FROM MSC_SYSTEM_ITEMS MSI
, MSC_TRADING_PARTNERS MTP
, MSC_ITEM_CATEGORIES MIC
, MSC_ITEM_ATTRIBUTES MSIS
, MSC_ITEM_ATTRIBUTES MSIS_COLL
, MSC_FORECAST_RULES MFR1
, MSC_FORECAST_RULES MFR2
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.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