Subversion Repositories DevTools

Rev

Rev 119 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 119 Rev 5097
Line 31... Line 31...
31
               AND vi.view_id = vd.view_id(+) 
31
               AND vi.view_id = vd.view_id(+) 
32
               AND vis.user_id = $USER_ID$
32
               AND vis.user_id = $USER_ID$
33
               AND vi.public_read = 'Y'
33
               AND vi.public_read = 'Y'
34
         GROUP BY vi.view_id, vi.view_name, usr.user_name, usr.user_email, vi.base_view, vi.owner_id
34
         GROUP BY vi.view_id, vi.view_name, usr.user_name, usr.user_email, vi.base_view, vi.owner_id
35
       ) pview
35
       ) pview
36
 ORDER BY pview.view_name ASC
-
 
37
36
 ORDER BY UPPER(pview.view_name) ASC
-
 
37
38
38