/* Branch List */
SELECT br.BRANCH_ID,
	   br.BRANCH_NAME,
	   br.RM_VTREE_FK,
	   rt.RTAG_NAME,
	   br.IS_HIDDEN,
	   br.BRANCH_COMMENTS
  FROM BRANCHES br,
  	   RELEASE_TAGS rt
 WHERE br.PROJ_ID = :PROJ_ID
   AND br.RM_VTREE_FK = rt.VTREE_ID (+)
 ORDER BY UPPER(br.BRANCH_NAME)