Go to most recent revision | Details | Last modification | View Log | RSS feed
/* RM Releases Combo */
SELECT rt.RTAG_ID,
rt.RTAG_NAME,
DECODE ( :RTAG_ID,
rt.RTAG_ID, 'selected',
NULL ) AS SELECTED
FROM RELEASE_TAGS rt
WHERE rt.PROJ_ID = :PROJ_ID
AND rt.OFFICIAL != 'Y'
ORDER BY UPPER(rt.RTAG_NAME)