Subversion Repositories DevTools

(root)/ManagerSuite/Release_Manager/branches/dpurdie/queries/ReleaseReferencedBy.sql @ 1336 – Rev 1281

Rev 119 | Blame | Compare with Previous | Last modification | View Log | RSS feed

/* Release Referenced By */
SELECT proj.PROJ_NAME,
           rt.RTAG_NAME,
           rt.OFFICIAL,
           rt.RTAG_ID
  FROM RELEASE_LINKS rl,
           PROJECTS proj,
           RELEASE_TAGS rt         
 WHERE rl.REF_RTAG_ID = :RTAG_ID  
   AND rl.RTAG_ID = rt.RTAG_ID
   AND rt.PROJ_ID = proj.PROJ_ID
ORDER BY UPPER( proj.PROJ_NAME ), UPPER(rt.RTAG_NAME)