Subversion Repositories DevTools

Rev

Go to most recent revision | Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
119 ghuddy 1 
SELECT  ttypes.test_type_id, ttypes.test_type_name,
2 
		ut.TEST_ID,
3 
		ut.PV_ID,
4 
		ut.TEST_SUMMARY,
5 
		ut.COMPLETION_DATE,
6 
		tusr.full_name AS TESTER,
7 
		tusr.user_email AS TESTER_EMAIL,
8 
		ut.RESULTS_URL,
9 
		ut.RESULTS_ATTACHMENT_NAME,
10 
		ut.ACCEPTANCE_DATE,
11 
		ausr.FULL_NAME AS REVIEWEE,
12 
		ausr.user_email AS REVIEWEE_EMAIL,
13 
		ut.NUMOF_TEST,
14 
		ut.TEST_ACCEPTED,
15 
		ut.REVIEW_COMMENTS
16 
  FROM UNIT_TESTS ut,
17 
  	   (
18 
	    SELECT tt.*
19 
		  FROM TEST_TYPES tt
20 
		 WHERE NOT tt.DISPLAY_ORDER IS NULL
21 
	   ) ttypes,
22 
	   USERS tusr,
23 
	   USERS ausr
24 
 WHERE /* ut.TEST_TYPES_FK (+)= ttypes.test_type_id -- REPLACED WITH NEXT LINE TEMPORARY  */
25 
   ut.TEST_TYPES_FK = ttypes.test_type_id
26 
   AND ut.pv_id (+) = :PV_ID
27 
   AND ut.COMPLETED_BY = tusr.user_id (+)
28 
   AND ut.ACCEPTED_BY  = ausr.user_id (+)
29 
ORDER BY ttypes.DISPLAY_ORDER
30