Subversion Repositories DevTools

Rev

Rev 64 | Blame | Compare with Previous | Last modification | View Log | RSS feed 

/* Releases Combo */
SELECT br.BRANCH_ID,
           br.BRANCH_NAME,
           DECODE ( :BRANCH_ID,
                                br.BRANCH_ID, 'selected',
                                NULL ) AS SELECTED
  FROM DM_PROJECTS pr,
           BRANCHES br
 WHERE br.PROJ_ID = pr.PROJ_ID
   AND pr.PROJ_ID = :PROJ_ID       
 ORDER BY UPPER(br.BRANCH_NAME)