Subversion Repositories DevTools

Rev

Rev 119 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 119 Rev 5384
Line 7... Line 7...
7 
  FROM PROJECTS pr,
 7 
  FROM PROJECTS pr,
8 
  	   RELEASE_TAGS rt
 8 
  	   RELEASE_TAGS rt
9 
 WHERE rt.PROJ_ID = pr.PROJ_ID
 9 
 WHERE rt.PROJ_ID = pr.PROJ_ID
10 
   AND pr.PROJ_ID = :PROJ_ID
10 
   AND pr.PROJ_ID = :PROJ_ID
11 
   AND rt.RTAG_ID NOT IN (:RTAG_ID)
11 
   AND rt.RTAG_ID NOT IN (:RTAG_ID)
12 
   AND rt.OFFICIAL <> 'Y'
12 
   AND rt.OFFICIAL IN ('N', 'R', 'C')
13 
 ORDER BY UPPER(rt.RTAG_NAME)
 13 
 ORDER BY UPPER(rt.RTAG_NAME)
14 

            14