SELECT  ttypes.test_type_id, ttypes.test_type_name,
		ut.TEST_ID, 
		ut.PV_ID, 
		ut.TEST_SUMMARY, 
		ut.COMPLETION_DATE, 
		tusr.full_name AS TESTER,
		tusr.user_email AS TESTER_EMAIL, 
		ut.RESULTS_URL, 
		ut.RESULTS_ATTACHMENT_NAME
  FROM UNIT_TESTS ut,
  	   (
	    SELECT tt.*
		  FROM TEST_TYPES tt
		 WHERE NOT tt.DISPLAY_ORDER IS NULL	   
	   ) ttypes,
	   USERS tusr
 WHERE /* ut.TEST_TYPES_FK (+)= ttypes.test_type_id -- REPLACED WITH NEXT LINE TEMPORARY  */
   ut.TEST_TYPES_FK = ttypes.test_type_id  
   AND ut.pv_id (+) = :PV_ID
   AND ut.COMPLETED_BY = tusr.user_id (+)
ORDER BY ut.COMPLETION_DATE DESC 

