Subversion Repositories DevTools

Rev

Rev 13 | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
13 rsolanki 1 
/* Branches 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 BRANCHES br
8 
 WHERE br.PROJ_ID = :PROJ_ID
9 
 ORDER BY UPPER(br.BRANCH_NAME)