Subversion Repositories DevTools

Rev

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

Rev 13 Rev 41
Line 1... Line 1...
1 
/* RM Releases Combo */
 1 
/* RM Releases Combo */
2 
SELECT rt.RTAG_ID,
 - 
 
3 
	   rt.RTAG_NAME,
 - 
 
4 
	   DECODE ( :RTAG_ID,
 - 
 
5 
	   			rt.RTAG_ID, 'selected',
 - 
 
6 
				NULL ) AS SELECTED
 - 
 
7 
  FROM RELEASE_TAGS rt
 - 
 
8 
 WHERE rt.PROJ_ID = :PROJ_ID
 - 
 
9 
   AND rt.OFFICIAL != 'Y'
- 
 
10 
 ORDER BY UPPER(rt.RTAG_NAME)
- 
 
11 

            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

          

          

            -
            
 

            8
            
AND   rt.official != 'Y' 

          

          

            -
            
 

            9
            
ORDER BY UPPER(rt.rtag_name)

          

          

            -
            
 

            10
            

          

          

            12
            

            11