Subversion Repositories DevTools

/* Application Roles */
SELECT 'Role_General.asp' AS file_name,
           'IMG_ROLE' AS item_image,
           ro.ROLE_ID AS item_id,
           ro.ROLE_NAME AS item_name,
           'role_id='|| ro.role_id AS param
  FROM ROLES ro
 WHERE ro.APP_ID = :APP_ID
   AND ro.IS_ROLE_VARIATION IS NULL
ORDER BY UPPER(ro.ROLE_NAME)