Subversion Repositories DevTools

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