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_SYSTEM_ITEMS_SC_V

Source

View Text - Preformatted


SELECT msi.rowid ,MSI.INVENTORY_ITEM_ID , msi.item_name , msi.organization_id , msc_get_name.org_code(msi.ORGANIZATION_id, msi.sr_instance_id) , PLANS.ORGANIZATION_ID , PLANS.COMPILE_DESIGNATOR , msc_get_name.lookup_meaning('MRP_PLANNING_CODE',MSI.MRP_PLANNING_CODE) , MSI.PREPROCESSING_LEAD_TIME , MSI.POSTPROCESSING_LEAD_TIME , MSI.FULL_LEAD_TIME , MSI.FIXED_LEAD_TIME , MSI.VARIABLE_LEAD_TIME , msc_get_name.lookup_meaning('MTL_PLANNING_MAKE_BUY', MSI.PLANNING_MAKE_BUY_CODE) , MSI.REPETITIVE_TYPE , MSI.STANDARD_COST , msi.carrying_cost , msi.list_price , NVL(msi.list_price,0) - NVL(msi.standard_cost,0) , MSI.ROUNDING_CONTROL_TYPE , msc_get_name.lookup_meaning('WIP_SUPPLY',MSI.WIP_SUPPLY_TYPE) , MSI.DESCRIPTION , mic.sr_CATEGORY_ID , MSI.BUYER_NAME , MSI.PLANNER_CODE , MSI.ABC_CLASS , Msi.ABC_CLASS_NAME , MSI.FIXED_DAYS_SUPPLY , MSI.FIXED_ORDER_QUANTITY , MSI.FIXED_LOT_MULTIPLIER , MSI.MINIMUM_ORDER_QUANTITY , MSI.MAXIMUM_ORDER_QUANTITY , MSI.SHRINKAGE_RATE , MSI.PLANNING_EXCEPTION_SET , MSI.BASE_ITEM_ID , msc_get_name.lookup_meaning('BOM_ITEM_TYPE',MSI.BOM_ITEM_TYPE) , msi.ato_forecast_control , msc_get_name.lookup_meaning('MRP_ATO_FORECAST_CONTROL', MSI.ATO_FORECAST_CONTROL) , MSI.PRIMARY_supplier_ID , DECODE(MSI.IN_SOURCE_PLAN, 1, 1, 2) ,MSI.planning_make_buy_code ,msi.effectivity_control ,msc_get_name.lookup_meaning('MTL_EFFECTIVITY_CONTROL',MSI.EFFECTIVITY_CONTROL) ,MSI.PLANNING_TIME_FENCE_DATE ,MSI.PLANNING_TIME_FENCE_days ,MSI.UOM_CODE ,mic.category_set_id ,mic.category_name ,mic.description ,msi.inventory_use_up_date ,msi.end_assembly_pegging_flag ,msc_get_name.lookup_meaning('MSC_END_ASSEMBLY_PEGGING', DECODE(msi.end_assembly_pegging_flag,'N',1,'A',2,'Y',3,'B',4,'I',5,'X',6,1)) ,msi.full_pegging ,msc_get_name.lookup_meaning('MRP_HARD_PEGGING_LEVEL',msi.full_pegging) ,msi.safety_stock_bucket_days ,msi.safety_stock_percent ,msi.fixed_safety_stock_qty ,msi.product_family_id ,mi.item_name ,msc_get_name.item_desc(msi.product_family_id, msi.organization_id, msi.plan_id,msi.sr_instance_id) ,msi.plan_id ,msi.sr_instance_id ,msi.nettable_inventory_quantity ,msi.nonnettable_inventory_quantity ,msi.service_level ,msc_get_name.lookup_meaning('MSC_ATP_COMPONENTS_FLAG', DECODE(msi.atp_flag,'N',1,'Y',2,'R',3,'C',4,4)) ,msc_get_name.lookup_meaning('MSC_ATP_COMPONENTS_FLAG', DECODE(msi.atp_components_flag,'N',1,'Y',2,'R',3,'C',4,4)) ,msi.demand_time_fence_days ,decode(plans.curr_demand_time_fence_flag, 1, msi.demand_time_fence_date, to_date(null)) ,msc_get_name.ss_method_text(msi.plan_id, msi.organization_id, msi.sr_instance_id, msi.inventory_item_id) ,msi.weight_uom ,msi.unit_weight ,msi.volume_uom ,msi.unit_volume ,msc_get_name.lookup_meaning('SYS_YES_NO',msi.pip_flag) ,msi.create_supply_flag ,msi.substitution_window ,msi.average_discount ,nvl(msi.list_price,0)*(1-nvl(msi.average_discount,0)/100) ,decode(msi.convergence, 1,'Series', 2, 'Parallel', 'Global Default Value'), decode(msi.divergence, 1,'Series', 2, 'Series with MTQ', 'Global Default Value'), decode(msi.continous_transfer, 1,'Yes', 2, 'No', 'Global Default Value') ,decode(msi.critical_component_flag , 1, msc_get_name.lookup_meaning('MSC_CRITICAL_COMPONENT', 1 ), decode( msi.inferred_critical_flag , 1, msc_get_name.lookup_meaning('MSC_CRITICAL_COMPONENT', 2 ), NULL) ) ,msc_get_name.item_name(msi.base_item_id,null,null,null) ,msc_get_name.lookup_meaning('SYS_YES_NO',decode(msi.drp_planned, NULL, 2, msi.drp_planned)), msc_get_name.lookup_meaning('SYS_YES_NO', decode(msi.budget_constrained,2,1,2)), msi.days_tgt_inv_window, msi.days_max_inv_window, msi.days_tgt_inv_supply, msi.days_max_inv_supply, msi.acceptable_early_delivery, msi.leadtime_variability, msi.last_update_date, msi.last_updated_by, msi.creation_date, msi.created_by, msi.last_update_login, msi.lots_expiration, decode(msi.release_time_fence_code, 1, NVL(msi.CUMULATIVE_TOTAL_LEAD_TIME,0), 2, NVL(msi.CUM_MANUFACTURING_LEAD_TIME,0), 3, NVL(msi.FULL_LEAD_TIME,0), 4, NVL(msi.RELEASE_TIME_FENCE_DAYS,0), NULL) release_time_fence_days , msi.min_shelf_life_days, msi.demand_fulfillment_lt, msi.end_of_life_date, msc_get_name.forecast_rule_name(msi.forecast_rule_for_demands), msc_get_name.forecast_rule_name(msi.forecast_rule_for_returns), msi.interarrival_time, msi.life_time_buy_date, msi.preposition_point, msi.pre_position_inventory, msi.repair_cost, msi.repair_lead_time, msc_get_name.lookup_meaning('MSC_REPAIR_PROGRAM', msi.repair_program), msi.repair_yield, msi.std_dmd_over_horizon, msi.mean_inter_arrival, msc_get_name.lookup_meaning('SYS_YES_NO', nvl(msi.REPETITIVE_PLANNING_FLAG,2)), msi.forecast_rule_for_demands, msi.forecast_rule_for_returns, msi.criticality_category, msi.max_usage_factor, msi.MIN_SUP_DEM_PERCENT, msi.DMD_SATISFIED_PERCENT, msi.CUM_MANUFACTURING_LEAD_TIME, msi.rop_safety_stock rop_safety_stock, msc_get_name.lookup_meaning('SYS_YES_NO',msi.compute_ss) compute_ss, msc_get_name.lookup_meaning('SYS_YES_NO',msi.compute_eoq) compute_eoq, msi.order_cost order_cost, msi.INTERMITTENT_DEMAND FROM Msc_SYSTEM_ITEMS MSI, msc_item_categories mic, msc_items mi, Msc_PLANS PLANS WHERE MSI.plan_id =PLANS.plan_id 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 mi.inventory_item_id(+) = msi.product_family_id

View Text - HTML Formatted

SELECT MSI.ROWID
, MSI.INVENTORY_ITEM_ID
, MSI.ITEM_NAME
, MSI.ORGANIZATION_ID
, MSC_GET_NAME.ORG_CODE(MSI.ORGANIZATION_ID
, MSI.SR_INSTANCE_ID)
, PLANS.ORGANIZATION_ID
, PLANS.COMPILE_DESIGNATOR
, MSC_GET_NAME.LOOKUP_MEANING('MRP_PLANNING_CODE'
, MSI.MRP_PLANNING_CODE)
, MSI.PREPROCESSING_LEAD_TIME
, MSI.POSTPROCESSING_LEAD_TIME
, MSI.FULL_LEAD_TIME
, MSI.FIXED_LEAD_TIME
, MSI.VARIABLE_LEAD_TIME
, MSC_GET_NAME.LOOKUP_MEANING('MTL_PLANNING_MAKE_BUY'
, MSI.PLANNING_MAKE_BUY_CODE)
, MSI.REPETITIVE_TYPE
, MSI.STANDARD_COST
, MSI.CARRYING_COST
, MSI.LIST_PRICE
, NVL(MSI.LIST_PRICE
, 0) - NVL(MSI.STANDARD_COST
, 0)
, MSI.ROUNDING_CONTROL_TYPE
, MSC_GET_NAME.LOOKUP_MEANING('WIP_SUPPLY'
, MSI.WIP_SUPPLY_TYPE)
, MSI.DESCRIPTION
, MIC.SR_CATEGORY_ID
, MSI.BUYER_NAME
, MSI.PLANNER_CODE
, MSI.ABC_CLASS
, MSI.ABC_CLASS_NAME
, MSI.FIXED_DAYS_SUPPLY
, MSI.FIXED_ORDER_QUANTITY
, MSI.FIXED_LOT_MULTIPLIER
, MSI.MINIMUM_ORDER_QUANTITY
, MSI.MAXIMUM_ORDER_QUANTITY
, MSI.SHRINKAGE_RATE
, MSI.PLANNING_EXCEPTION_SET
, MSI.BASE_ITEM_ID
, MSC_GET_NAME.LOOKUP_MEANING('BOM_ITEM_TYPE'
, MSI.BOM_ITEM_TYPE)
, MSI.ATO_FORECAST_CONTROL
, MSC_GET_NAME.LOOKUP_MEANING('MRP_ATO_FORECAST_CONTROL'
, MSI.ATO_FORECAST_CONTROL)
, MSI.PRIMARY_SUPPLIER_ID
, DECODE(MSI.IN_SOURCE_PLAN
, 1
, 1
, 2)
, MSI.PLANNING_MAKE_BUY_CODE
, MSI.EFFECTIVITY_CONTROL
, MSC_GET_NAME.LOOKUP_MEANING('MTL_EFFECTIVITY_CONTROL'
, MSI.EFFECTIVITY_CONTROL)
, MSI.PLANNING_TIME_FENCE_DATE
, MSI.PLANNING_TIME_FENCE_DAYS
, MSI.UOM_CODE
, MIC.CATEGORY_SET_ID
, MIC.CATEGORY_NAME
, MIC.DESCRIPTION
, MSI.INVENTORY_USE_UP_DATE
, MSI.END_ASSEMBLY_PEGGING_FLAG
, MSC_GET_NAME.LOOKUP_MEANING('MSC_END_ASSEMBLY_PEGGING'
, DECODE(MSI.END_ASSEMBLY_PEGGING_FLAG
, 'N'
, 1
, 'A'
, 2
, 'Y'
, 3
, 'B'
, 4
, 'I'
, 5
, 'X'
, 6
, 1))
, MSI.FULL_PEGGING
, MSC_GET_NAME.LOOKUP_MEANING('MRP_HARD_PEGGING_LEVEL'
, MSI.FULL_PEGGING)
, MSI.SAFETY_STOCK_BUCKET_DAYS
, MSI.SAFETY_STOCK_PERCENT
, MSI.FIXED_SAFETY_STOCK_QTY
, MSI.PRODUCT_FAMILY_ID
, MI.ITEM_NAME
, MSC_GET_NAME.ITEM_DESC(MSI.PRODUCT_FAMILY_ID
, MSI.ORGANIZATION_ID
, MSI.PLAN_ID
, MSI.SR_INSTANCE_ID)
, MSI.PLAN_ID
, MSI.SR_INSTANCE_ID
, MSI.NETTABLE_INVENTORY_QUANTITY
, MSI.NONNETTABLE_INVENTORY_QUANTITY
, MSI.SERVICE_LEVEL
, MSC_GET_NAME.LOOKUP_MEANING('MSC_ATP_COMPONENTS_FLAG'
, DECODE(MSI.ATP_FLAG
, 'N'
, 1
, 'Y'
, 2
, 'R'
, 3
, 'C'
, 4
, 4))
, MSC_GET_NAME.LOOKUP_MEANING('MSC_ATP_COMPONENTS_FLAG'
, DECODE(MSI.ATP_COMPONENTS_FLAG
, 'N'
, 1
, 'Y'
, 2
, 'R'
, 3
, 'C'
, 4
, 4))
, MSI.DEMAND_TIME_FENCE_DAYS
, DECODE(PLANS.CURR_DEMAND_TIME_FENCE_FLAG
, 1
, MSI.DEMAND_TIME_FENCE_DATE
, TO_DATE(NULL))
, MSC_GET_NAME.SS_METHOD_TEXT(MSI.PLAN_ID
, MSI.ORGANIZATION_ID
, MSI.SR_INSTANCE_ID
, MSI.INVENTORY_ITEM_ID)
, MSI.WEIGHT_UOM
, MSI.UNIT_WEIGHT
, MSI.VOLUME_UOM
, MSI.UNIT_VOLUME
, MSC_GET_NAME.LOOKUP_MEANING('SYS_YES_NO'
, MSI.PIP_FLAG)
, MSI.CREATE_SUPPLY_FLAG
, MSI.SUBSTITUTION_WINDOW
, MSI.AVERAGE_DISCOUNT
, NVL(MSI.LIST_PRICE
, 0)*(1-NVL(MSI.AVERAGE_DISCOUNT
, 0)/100)
, DECODE(MSI.CONVERGENCE
, 1
, 'SERIES'
, 2
, 'PARALLEL'
, 'GLOBAL DEFAULT VALUE')
, DECODE(MSI.DIVERGENCE
, 1
, 'SERIES'
, 2
, 'SERIES WITH MTQ'
, 'GLOBAL DEFAULT VALUE')
, DECODE(MSI.CONTINOUS_TRANSFER
, 1
, 'YES'
, 2
, 'NO'
, 'GLOBAL DEFAULT VALUE')
, DECODE(MSI.CRITICAL_COMPONENT_FLAG
, 1
, MSC_GET_NAME.LOOKUP_MEANING('MSC_CRITICAL_COMPONENT'
, 1 )
, DECODE( MSI.INFERRED_CRITICAL_FLAG
, 1
, MSC_GET_NAME.LOOKUP_MEANING('MSC_CRITICAL_COMPONENT'
, 2 )
, NULL) )
, MSC_GET_NAME.ITEM_NAME(MSI.BASE_ITEM_ID
, NULL
, NULL
, NULL)
, MSC_GET_NAME.LOOKUP_MEANING('SYS_YES_NO'
, DECODE(MSI.DRP_PLANNED
, NULL
, 2
, MSI.DRP_PLANNED))
, MSC_GET_NAME.LOOKUP_MEANING('SYS_YES_NO'
, DECODE(MSI.BUDGET_CONSTRAINED
, 2
, 1
, 2))
, MSI.DAYS_TGT_INV_WINDOW
, MSI.DAYS_MAX_INV_WINDOW
, MSI.DAYS_TGT_INV_SUPPLY
, MSI.DAYS_MAX_INV_SUPPLY
, MSI.ACCEPTABLE_EARLY_DELIVERY
, MSI.LEADTIME_VARIABILITY
, MSI.LAST_UPDATE_DATE
, MSI.LAST_UPDATED_BY
, MSI.CREATION_DATE
, MSI.CREATED_BY
, MSI.LAST_UPDATE_LOGIN
, MSI.LOTS_EXPIRATION
, DECODE(MSI.RELEASE_TIME_FENCE_CODE
, 1
, NVL(MSI.CUMULATIVE_TOTAL_LEAD_TIME
, 0)
, 2
, NVL(MSI.CUM_MANUFACTURING_LEAD_TIME
, 0)
, 3
, NVL(MSI.FULL_LEAD_TIME
, 0)
, 4
, NVL(MSI.RELEASE_TIME_FENCE_DAYS
, 0)
, NULL) RELEASE_TIME_FENCE_DAYS
, MSI.MIN_SHELF_LIFE_DAYS
, MSI.DEMAND_FULFILLMENT_LT
, MSI.END_OF_LIFE_DATE
, MSC_GET_NAME.FORECAST_RULE_NAME(MSI.FORECAST_RULE_FOR_DEMANDS)
, MSC_GET_NAME.FORECAST_RULE_NAME(MSI.FORECAST_RULE_FOR_RETURNS)
, MSI.INTERARRIVAL_TIME
, MSI.LIFE_TIME_BUY_DATE
, MSI.PREPOSITION_POINT
, MSI.PRE_POSITION_INVENTORY
, MSI.REPAIR_COST
, MSI.REPAIR_LEAD_TIME
, MSC_GET_NAME.LOOKUP_MEANING('MSC_REPAIR_PROGRAM'
, MSI.REPAIR_PROGRAM)
, MSI.REPAIR_YIELD
, MSI.STD_DMD_OVER_HORIZON
, MSI.MEAN_INTER_ARRIVAL
, MSC_GET_NAME.LOOKUP_MEANING('SYS_YES_NO'
, NVL(MSI.REPETITIVE_PLANNING_FLAG
, 2))
, MSI.FORECAST_RULE_FOR_DEMANDS
, MSI.FORECAST_RULE_FOR_RETURNS
, MSI.CRITICALITY_CATEGORY
, MSI.MAX_USAGE_FACTOR
, MSI.MIN_SUP_DEM_PERCENT
, MSI.DMD_SATISFIED_PERCENT
, MSI.CUM_MANUFACTURING_LEAD_TIME
, MSI.ROP_SAFETY_STOCK ROP_SAFETY_STOCK
, MSC_GET_NAME.LOOKUP_MEANING('SYS_YES_NO'
, MSI.COMPUTE_SS) COMPUTE_SS
, MSC_GET_NAME.LOOKUP_MEANING('SYS_YES_NO'
, MSI.COMPUTE_EOQ) COMPUTE_EOQ
, MSI.ORDER_COST ORDER_COST
, MSI.INTERMITTENT_DEMAND
FROM MSC_SYSTEM_ITEMS MSI
, MSC_ITEM_CATEGORIES MIC
, MSC_ITEMS MI
, MSC_PLANS PLANS
WHERE MSI.PLAN_ID =PLANS.PLAN_ID
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 MI.INVENTORY_ITEM_ID(+) = MSI.PRODUCT_FAMILY_ID