Subversion Repositories DevTools

Rev

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

Rev 41 Rev 5385
Line 3... Line 3...
3 
       rt.rtag_name,
 3 
       rt.rtag_name,
4 
       DECODE ( :RTAG_ID, rt.rtag_id, 'selected',NULL ) AS selected
 4 
       DECODE ( :RTAG_ID, rt.rtag_id, 'selected',NULL ) AS selected
5 
FROM deployment_manager.dm_projects dp,release_manager.release_tags rt
 5 
FROM deployment_manager.dm_projects dp,release_manager.release_tags rt
6 
WHERE dp.rm_projects_fk = rt.proj_id
 6 
WHERE dp.rm_projects_fk = rt.proj_id
7 
AND   dp.proj_id = :PROJ_ID
 7 
AND   dp.proj_id = :PROJ_ID
8 
AND   rt.official != 'Y'
8 
AND   rt.official IN ('N','R','C')
9 
ORDER BY UPPER(rt.rtag_name)
 9 
ORDER BY UPPER(rt.rtag_name)
10 

            10