Subversion Repositories DevTools

Rev

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

Rev 5947 Rev 7570
Line 32... Line 32...
32 
   AND pv.MODIFIER_ID = usr.USER_ID
 32 
   AND pv.MODIFIER_ID = usr.USER_ID
33 
   AND rt.PROJ_ID = :PROJ_ID
 33 
   AND rt.PROJ_ID = :PROJ_ID
34 
   AND (ev.PV_ID  = :PV_ID OR :MATCH != 2)
 34 
   AND (ev.PV_ID  = :PV_ID OR :MATCH != 2)
35 
   AND (NVL(pv.v_ext,'LINK') in (  aa.ext ) OR :MATCH = 2 OR :MATCH = 0)
 35 
   AND (NVL(pv.v_ext,'LINK') in (  aa.ext ) OR :MATCH = 2 OR :MATCH = 0)
36 
   AND (pv.PKG_ID in ( bb.pkg_id ) OR :MATCH = 2)
 36 
   AND (pv.PKG_ID in ( bb.pkg_id ) OR :MATCH = 2)
- 
 
 37 
   AND rt.official != 'S'
37 
  ORDER BY rt.RTAG_ID DESC
38 
  ORDER BY rt.RTAG_NAME
38 
 
 39