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, 
                ut.ACCEPTANCE_DATE, 
                ausr.FULL_NAME AS REVIEWEE,
                ausr.user_email AS REVIEWEE_EMAIL,
                ut.NUMOF_TEST, 
                ut.TEST_ACCEPTED, 
                ut.REVIEW_COMMENTS
  FROM UNIT_TESTS ut,
           (
            SELECT tt.*
                  FROM TEST_TYPES tt
                 WHERE NOT tt.DISPLAY_ORDER IS NULL        
           ) ttypes,
           USERS tusr,
           USERS ausr
 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 (+)
   AND ut.ACCEPTED_BY  = ausr.user_id (+)
ORDER BY ttypes.DISPLAY_ORDER