Subversion Repositories DevTools

Rev

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

Rev 5947 Rev 7570
Line 19... Line 19...
19 
   AND ev.RTAG_ID = rt.RTAG_ID
 19 
   AND ev.RTAG_ID = rt.RTAG_ID
20 
   AND rt.PROJ_ID = proj.PROJ_ID
 20 
   AND rt.PROJ_ID = proj.PROJ_ID
21 
   AND (ev.PV_ID  = :PV_ID OR :MATCH != 2)
 21 
   AND (ev.PV_ID  = :PV_ID OR :MATCH != 2)
22 
   AND (NVL(pv.v_ext,'LINK') in (  aa.ext ) OR :MATCH = 2 OR :MATCH = 0)
 22 
   AND (NVL(pv.v_ext,'LINK') in (  aa.ext ) OR :MATCH = 2 OR :MATCH = 0)
23 
   AND (pv.PKG_ID in ( bb.pkg_id ) OR :MATCH = 2)
 23 
   AND (pv.PKG_ID in ( bb.pkg_id ) OR :MATCH = 2)
- 
 
 24 
   AND rt.official != 'S'
24 
GROUP BY proj.PROJ_ID, proj.PROJ_NAME
 25 
GROUP BY proj.PROJ_NAME, proj.PROJ_ID
25 
ORDER BY UPPER(proj.PROJ_NAME)
 26 
ORDER BY UPPER(proj.PROJ_NAME) ASC
26 
 
 27