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.INV_MATERIAL_STATUS_GRP dependencies on MTL_MATERIAL_STATUSES

Line 2963: FROM mtl_material_statuses

2959: If (l_return_status_id IS NOT NULL AND l_return_status_id <> -1) THEN
2960: BEGIN
2961: SELECT status_code
2962: INTO l_return_status_code
2963: FROM mtl_material_statuses
2964: WHERE status_id =l_return_status_id ;
2965: EXCEPTION
2966: WHEN NO_DATA_FOUND THEN
2967: l_return_status_id := NULL; --as status_id is not found in mtl_material_statuses therefore returning NULL

Line 2967: l_return_status_id := NULL; --as status_id is not found in mtl_material_statuses therefore returning NULL

2963: FROM mtl_material_statuses
2964: WHERE status_id =l_return_status_id ;
2965: EXCEPTION
2966: WHEN NO_DATA_FOUND THEN
2967: l_return_status_id := NULL; --as status_id is not found in mtl_material_statuses therefore returning NULL
2968: l_return_status_code := NULL;
2969: END;
2970: ELSIF (NVL(l_return_status_id,-99) = -1)THEN
2971: l_return_status_code := FND_MESSAGE.get_string('WMS','WMS_LPN_STATUS_MIXED');