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.

APPS.CS_SERVICEREQUEST_UTIL dependencies on MTL_ITEM_CATEGORIES

Line 3090: --FROM mtl_item_categories ic

3086: BEGIN
3087: IF (p_category_id IS NOT NULL AND
3088: l_profile IS NOT NULL ) THEN
3089: SELECT 'x' INTO l_dummy
3090: --FROM mtl_item_categories ic
3091: FROM mtl_category_set_valid_cats ic
3092: WHERE ic.category_id = p_category_id
3093: AND ic.category_set_id = l_profile;
3094: --AND ic.organization_id = CS_STD.Get_Item_Valdn_Orgzn_Id;

Line 3158: FROM mtl_item_categories

3154: AND category_set_id = p_category_set_id;
3155: ELSIF (p_inventory_item_id IS NOT NULL) THEN
3156: l_validation := 'I';
3157: SELECT 'x' INTO l_dummy
3158: FROM mtl_item_categories
3159: WHERE inventory_item_id = p_inventory_item_id
3160: AND category_id = p_category_id
3161: AND category_set_id = p_category_set_id
3162: --AND organization_id = CS_STD.Get_Item_Valdn_Orgzn_Id;

Line 4157: mtl_item_categories ic

4153:
4154: SELECT NVL(revision_qty_control_code,0)
4155: INTO l_control_code
4156: FROM mtl_system_items_vl item,
4157: mtl_item_categories ic
4158: WHERE item.organization_id = p_organization_id
4159: AND item.inventory_item_id = p_platform_id
4160: AND item.organization_id = ic.organization_id
4161: AND item.inventory_item_id = ic.inventory_item_id