View: MSC_SYSTEM_ITEMS_SC_V

Product:	MSC - Advanced Supply Chain Planning
Description:	This view shows all the items
Implementation/DBA Data:	APPS.MSC_SYSTEM_ITEMS_SC_V

View Text

SELECT 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('SYS_YES_NO'
, DECODE(MSI.ATP_FLAG
, 'Y'
, 1
, 'N'
, 2
, 2))
, 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
, MSI.DEMAND_TIME_FENCE_DATE
, MSC_GET_NAME.SS_METHOD_TEXT(-1
, 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)
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

Columns