Details | Last modification | View Log | RSS feed
/* 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)