Subversion Repositories DevTools

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
13 rsolanki 1 
/* Releases Combo */
2 
SELECT br.BRANCH_ID,
3 
	   br.BRANCH_NAME,
4 
	   DECODE ( :BRANCH_ID,
5 
	   			br.BRANCH_ID, 'selected',
6 
				NULL ) AS SELECTED
7 
  FROM DM_PROJECTS pr,
8 
  	   BRANCHES br
9 
 WHERE br.PROJ_ID = pr.PROJ_ID
10 
   AND pr.PROJ_ID = :PROJ_ID
11 
 ORDER BY UPPER(br.BRANCH_NAME)