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_PDR_ITEM_DETAILS_V

Source

View Text - Preformatted


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'))

View Text - HTML Formatted

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'))