View: MSC_PDR_ITEM_DETAILS_V

Product:	MSC - Advanced Supply Chain Planning
Description:
Implementation/DBA Data:	APPS.MSC_PDR_ITEM_DETAILS_V

View Text

SELECT MSC_GET_NAME.ORG_CODE(MSI.ORGANIZATION_ID
, MSI.SR_INSTANCE_ID)
, MIC.CATEGORY_NAME
, MSI.ITEM_NAME
, MSI.DESCRIPTION
, MSI.ABC_CLASS_NAME
, MSI.UOM_CODE
, MSI.PREPROCESSING_LEAD_TIME
, MSI.FULL_LEAD_TIME
, MSI.POSTPROCESSING_LEAD_TIME
, MSI.VARIABLE_LEAD_TIME
, MSI.FIXED_LEAD_TIME
, MSI.NETTABLE_INVENTORY_QUANTITY
, MSI.NONNETTABLE_INVENTORY_QUANTITY
, MSI.STANDARD_COST
, MSI.CARRYING_COST
, MSI.SAFETY_STOCK_PERCENT
, MSI.SAFETY_STOCK_BUCKET_DAYS
, MSI.SAFETY_STOCK_CODE
, MSI.MINIMUM_ORDER_QUANTITY
, MSI.MAXIMUM_ORDER_QUANTITY
, MSI.FIXED_ORDER_QUANTITY
, MSC_GET_NAME.LOOKUP_MEANING('MTL_PLANNING_MAKE_BUY'
, MSI.PLANNING_MAKE_BUY_CODE)
, MSI.FIXED_DAYS_SUPPLY
, MSI.FIXED_LOT_MULTIPLIER
, MSC_GET_NAME.LOOKUP_MEANING('MRP_ATO_FORECAST_CONTROL'
, MSI.ATO_FORECAST_CONTROL)
, MSC_GET_NAME.LOOKUP_MEANING('MRP_PLANNING_CODE'
, MSI.MRP_PLANNING_CODE)
, MSC_GET_NAME.LOOKUP_MEANING('BOM_ITEM_TYPE'
, MSI.BOM_ITEM_TYPE)
, MSC_GET_NAME.LOOKUP_MEANING('WIP_SUPPLY'
, MSI.WIP_SUPPLY_TYPE)
, MSI.SHRINKAGE_RATE
, MSI.PLANNING_TIME_FENCE_DATE
, MSI.DEMAND_TIME_FENCE_DATE
, MSI.PLANNING_EXCEPTION_SET
, 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.REPETITIVE_TYPE
, MSI.PLANNER_CODE
, MSI.BUYER_NAME
, TO_CHAR(NULL)
, TRUNC(SYSDATE)
, MSI.PLAN_ID
, MSI.ORGANIZATION_ID
, MSI.SR_INSTANCE_ID
, MIC.CATEGORY_SET_ID
, MIC.SR_CATEGORY_ID
, MSI.ABC_CLASS
, MSI.INVENTORY_ITEM_ID
, MSI.PLANNER_CODE
, MSI.BUYER_NAME
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, MSI.ACCEPTABLE_EARLY_DELIVERY
FROM MSC_SYSTEM_ITEMS MSI
, MSC_ITEM_CATEGORIES MIC
, MSC_ITEMS MI
WHERE 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
AND MSI.PLAN_ID IN (SELECT PLAN_ID
FROM MSC_PDR_PARAMETERS
WHERE USER_ID = FND_GLOBAL.USER_ID)
AND ( (NVL(MSI.ORGANIZATION_ID
, -1)
, NVL(MSI.SR_INSTANCE_ID
, -1)) IN (SELECT NVL(ORGANIZATION_ID
, NVL(MSI.ORGANIZATION_ID
, -1))
, NVL(SR_INSTANCE_ID
, NVL(MSI.SR_INSTANCE_ID
, -1))
FROM MSC_PDR_PARAMETERS
WHERE USER_ID = FND_GLOBAL.USER_ID
AND NVL( ORGANIZATION_ID
, -2) <> -1 ) )
AND (NVL(MIC.CATEGORY_SET_ID
, -1) IN (SELECT NVL(CATEGORY_SET_ID
, NVL(MIC.CATEGORY_SET_ID
, -1))
FROM MSC_PDR_PARAMETERS
WHERE USER_ID = FND_GLOBAL.USER_ID
AND NVL(CATEGORY_SET_ID
, -2) <> -1))
AND (NVL(MIC.SR_CATEGORY_ID
, -1) IN (SELECT NVL(PRODUCT_CATEGORY_ID
, NVL(MIC.SR_CATEGORY_ID
, -1))
FROM MSC_PDR_PARAMETERS
WHERE USER_ID = FND_GLOBAL.USER_ID
AND NVL(PRODUCT_CATEGORY_ID
, -2) <> -1))
AND (NVL(MSI.ABC_CLASS
, -1) IN (SELECT NVL(ABC_CLASS_ID
, NVL(MSI.ABC_CLASS
, -1))
FROM MSC_PDR_PARAMETERS
WHERE USER_ID = FND_GLOBAL.USER_ID
AND NVL(ABC_CLASS_ID
, -2) <> -1))
AND (NVL(MSI.INVENTORY_ITEM_ID
, -1) IN (SELECT NVL(INVENTORY_ITEM_ID
, NVL(MSI.INVENTORY_ITEM_ID
, -1))
FROM MSC_PDR_PARAMETERS
WHERE USER_ID = FND_GLOBAL.USER_ID
AND NVL( INVENTORY_ITEM_ID
, -2) <> -1))
AND (NVL(MSI.PLANNER_CODE
, '-1') IN (SELECT NVL(PLANNER_CODE_ID
, NVL(MSI.PLANNER_CODE
, -1))
FROM MSC_PDR_PARAMETERS
WHERE USER_ID = FND_GLOBAL.USER_ID
AND NVL(PLANNER_CODE_ID
, '-2') <> '-1'))
AND (NVL(MSI.BUYER_NAME
, '-1') IN (SELECT NVL(BUYER_NAME_ID
, NVL(MSI.BUYER_NAME
, -1))
FROM MSC_PDR_PARAMETERS
WHERE USER_ID = FND_GLOBAL.USER_ID
AND NVL(BUYER_NAME_ID
, '-2') <> '-1'))

Columns