Subversion Repositories DevTools

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
119 ghuddy 1 
SELECT qry.*
2 
  FROM (
3 
 
4 
		SELECT ut.COMPLETION_DATE ||' by '|| usr.FULL_NAME AS MSG,
5 
			   -1 AS MSG_ID,
6 
			   ut.test_id,
7 
			   ut.TEST_SUMMARY
8 
		  FROM UNIT_TESTS ut,
9 
		  	   USERS usr
10 
		 WHERE ut.PV_ID = :PV_ID
11 
		   AND ut.TEST_TYPES_FK = :enumTEST_TYPE_NOT_DONE
12 
		   AND ut.COMPLETED_BY = usr.user_id
13 
 
14 
		UNION
15 
 
16 
		SELECT DECODE( COUNT( ut.test_id ),
17 
			   		   0, '<span class="err_alert">Required!</span>',
18 
					   NULL
19 
			   		 ) AS MSG,
20 
 
21 
			   TO_NUMBER( NULL ) AS test_id,
22 
			   NULL AS TEST_SUMMARY
23 
		  FROM UNIT_TESTS ut
24 
		 WHERE ut.PV_ID = :PV_ID
25 
		   AND ut.TEST_TYPES_FK <> :enumTEST_TYPE_NOT_DONE
26 
 
27 
 
28 
	   ) qry
29 
 ORDER BY qry.msg_id
30