MSC_ANALYTIC_ITEM_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name

INVENTORY_ITEM_ID ITEM_NAME DESCRIPTION UOM_CODE ABC_CLASS_NAME FIXED_LEAD_TIME VARIABLE_LEAD_TIME PREPROCESSING_LEAD_TIME POSTPROCESSING_LEAD_TIME CUM_MANUFACTURING_LEAD_TIME FIXED_DAYS_SUPPLY FIXED_ORDER_QUANTITY FIXED_LOT_MULTIPLIER MINIMUM_ORDER_QUANTITY MAXIMUM_ORDER_QUANTITY PLANNER_CODE BUYER_NAME PLANNING_MAKE_BUY_CODE CRITICAL_COMPONENT_FLAG ATO_FORECAST_CONTROL SAFETY_STOCK_CODE SAFETY_STOCK_PERCENT DEMAND_TIME_FENCE_DATE PLANNING_TIME_FENCE_DATE DEMAND_TIME_FENCE_DAYS PLANNING_TIME_FENCE_DAYS RELEASE_TIME_FENCE_DAYS RELEASE_TIME_FENCE_CODE DEMAND_TIME_FENCE_CODE PLANNING_TIME_FENCE_CODE CARRYING_COST SAFETY_STOCK_QUANTITY SAFETY_STOCK_QUANTITY_OVERRIDE LIFE_CYCLE_PHASE

Query

SQL_Statement

select si.inventory_item_id,si.item_name, si.description, si.UOM_CODE, si.ABC_CLASS_NAME, si.FIXED_LEAD_TIME , si.VARIABLE_LEAD_TIME , si.PREPROCESSING_LEAD_TIME, si.POSTPROCESSING_LEAD_TIME, si.CUM_MANUFACTURING_LEAD_TIME, si.FIXED_DAYS_SUPPLY , si.FIXED_ORDER_QUANTITY , si.FIXED_LOT_MULTIPLIER , si.MINIMUM_ORDER_QUANTITY , si.MAXIMUM_ORDER_QUANTITY , si.PLANNER_CODE, si.BUYER_NAME, si.PLANNING_MAKE_BUY_CODE, si.CRITICAL_COMPONENT_FLAG, si.ATO_FORECAST_CONTROL, si.SAFETY_STOCK_CODE, si.SAFETY_STOCK_PERCENT, si.DEMAND_TIME_FENCE_DATE, si.PLANNING_TIME_FENCE_DATE, si.DEMAND_TIME_FENCE_DAYS, si.PLANNING_TIME_FENCE_DAYS, si.RELEASE_TIME_FENCE_DAYS, si.RELEASE_TIME_FENCE_CODE, si.DEMAND_TIME_FENCE_CODE, si.PLANNING_TIME_FENCE_CODE, si.CARRYING_COST, si.SAFETY_STOCK_QUANTITY, si.SAFETY_STOCK_QUANTITY_OVERRIDE, si.LIFE_CYCLE_PHASE from fusion.msc_system_items si