Subversion Repositories DevTools

Rev

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

Rev 5512 Rev 6265
Line 12... Line 12...
12 
               app.app_id,
 12 
               app.app_id,
13 
               app.application_name,
 13 
               app.application_name,
14 
               TO_NUMBER(NULL) AS role_id,
 14 
               TO_NUMBER(NULL) AS role_id,
15 
               '-' AS role_name,
 15 
               '-' AS role_name,
16 
               '-' AS is_role_variation,
 16 
               '-' AS is_role_variation,
17 
               NULL AS drill_down_image
 17 
               NULL AS drill_down_image,
- 
 
 18 
               NULL as can_delegate,
- 
 
 19 
               NULL as comments
18 
          FROM applications app,
 20 
          FROM applications app,
19 
               roles ro,
 21 
               roles ro,
20 
               user_roles ur
 22 
               user_roles ur
21 
         WHERE ur.role_id = ro.role_id
 23 
         WHERE ur.role_id = ro.role_id
22 
           AND ro.app_id = app.app_id
 24 
           AND ro.app_id = app.app_id
Line 30... Line 32...
30 
               app.app_id,
 32 
               app.app_id,
31 
               app.application_name,
 33 
               app.application_name,
32 
               TO_NUMBER(NULL) AS role_id,
 34 
               TO_NUMBER(NULL) AS role_id,
33 
               '-' AS role_name,
 35 
               '-' AS role_name,
34 
               '-' AS is_role_variation,
 36 
               '-' AS is_role_variation,
35 
               NULL AS drill_down_image
 37 
               NULL AS drill_down_image,
- 
 
 38 
               NULL as can_delegate,
- 
 
 39 
               NULL as comments
36 
          FROM applications app,
 40 
          FROM applications app,
37 
               user_applications ua
 41 
               user_applications ua
38 
         WHERE ua.user_id = :USER_ID
 42 
         WHERE ua.user_id = :USER_ID
39 
           AND app.app_id = ua.app_id
 43 
           AND app.app_id = ua.app_id
40 
           AND app.app_id NOT IN
 44 
           AND app.app_id NOT IN
Line 61... Line 65...
61 
               ro.role_id,
 65 
               ro.role_id,
62 
               ro.role_name,
 66 
               ro.role_name,
63 
               ro.is_role_variation,
 67 
               ro.is_role_variation,
64 
               DECODE ( ro.is_role_variation, NULL, 'LIMG_DRILL_DOWN',
 68 
               DECODE ( ro.is_role_variation, NULL, 'LIMG_DRILL_DOWN',
65 
                        NULL
 69 
                        NULL
66 
                      ) AS drill_down_image
 70 
                      ) AS drill_down_image,
- 
 
 71 
              (SELECT COUNT(*)
- 
 
 72 
                  FROM ROLES ra,
- 
 
 73 
                    USER_ROLES ur
- 
 
 74 
                  WHERE ra.APP_ID = :APP_ID
- 
 
 75 
                  AND ur.USER_ID  = :USER_ID_USER
- 
 
 76 
                  AND ur.ROLE_ID  = ra.ROLE_ID
- 
 
 77 
                  AND ra.role_id  = ro.role_id
- 
 
 78 
                  ) AS can_Delegate,
- 
 
 79 
                  ro.comments
- 
 
 80
- 
 
 81 
 
67 
          FROM applications app,
 82 
          FROM applications app,
68 
               roles ro,
 83 
               roles ro,
69 
               user_roles ur
 84 
               user_roles ur
70 
         WHERE ur.role_id = ro.role_id
 85 
         WHERE ur.role_id = ro.role_id
71 
           AND ro.app_id = app.app_id
 86 
           AND ro.app_id = app.app_id
72 
           AND ur.user_ID = :USER_ID
 87 
           AND ur.user_ID = :USER_ID
73 
           AND ( app.app_id = :APP_ID
 88 
           AND ( app.app_id = :APP_ID
74 
                 AND :APP_ID != 0
 89 
                 AND :APP_ID != 0
75 
               )
 90 
               )
- 
 
 91 
           AND ro.IS_ROLE_VARIATION is NULL
76 
         ) qry
 92 
         ) qry
77 
ORDER BY qry.order_id DESC, UPPER(qry.application_name), qry.is_role_variation, UPPER(qry.role_name)
 - 
 
78 

            93
            
ORDER BY UPPER(qry.application_name), qry.is_role_variation, UPPER(qry.role_name)

          

          

            -
            
 

            94
            
 

          

          

            -
            
 

            95