Subversion Repositories DevTools

Rev

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

/* Application User List*/
SELECT 'User_General.asp' AS file_name,
           DECODE ( usr.IS_DISABLED,
                                NULL, 'IMG_USER',
                                'IMG_USER_DISABLED' ) AS item_image,
           usr.user_id AS item_id,
           usr.full_name ||' ['|| usr.user_name ||']' AS item_name,
           'user_id='|| usr.user_id AS param
  FROM USERS usr,
           USER_APPLICATIONS usra
 WHERE usra.USER_ID = usr.USER_ID 
   AND usra.APP_ID = :APP_ID
ORDER BY UPPER(usr.FULL_NAME)