Subversion Repositories DevTools

Rev

Go to most recent revision | Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
13 rsolanki 1 
/* RM Releases Combo */
41 brianf 2 
SELECT rt.rtag_id,
3 
       rt.rtag_name,
4 
       DECODE ( :RTAG_ID, rt.rtag_id, 'selected',NULL ) AS selected
5 
FROM deployment_manager.dm_projects dp,release_manager.release_tags rt
6 
WHERE dp.rm_projects_fk = rt.proj_id
7 
AND   dp.proj_id = :PROJ_ID
5385 dpurdie 8 
AND   rt.official IN ('N','R','C')
41 brianf 9 
ORDER BY UPPER(rt.rtag_name)