R12_User_Responsibility

/* Formatted on 27-08-2011 12:19:51 (QP5 v5.115.810.9015) */
  SELECT   DISTINCT u.user_id,u.user_name, rtl.RESPONSIBILITY_NAME, emp.EMAIL_ADDRESS
    FROM   fnd_responsibility r,
           fnd_responsibility_TL rtl,
           fnd_user_resp_groups urg,
           fnd_user u,
           hr_employees emp
   WHERE       urg.responsibility_id = r.responsibility_id
           AND rtl.responsibility_id = r.responsibility_id
           AND r.APPLICATION_ID = urg.RESPONSIBILITY_APPLICATION_ID
           AND u.user_id = urg.user_id
           AND emp.EMPLOYEE_ID = u.EMPLOYEE_ID
           and u.employee_id not in (1130)
           AND u.employee_id IN
                    (81,
                     82,
                     83,
                     86,
                     87,
                     88,
                     89,
                     90,
                     91,
                     92,
                     121,
                     141,
                     161,
                     201,
                     221,
                     222,
                     225,
                     241,
                     261,
                     262,
                     263,
                     264,
                     265,
                     266,
                     267,
                     268,
                     269,
                     270,
                     271,
                     281,
                     302,
                     341,
                     361,
                     381,
                     382,
                     383,
                     384,
                     386,
                     388,
                     401,
                     421,
                     441,
                     461,
                     462,
                     481,
                     501,
                     521,
                     522,
                     523,
                     524,
                     525,
                     526,
                     527,
                     528,
                     529,
                     530,
                     531,
                     532,
                     533,
                     541,
                     542,
                     561,
                     562,
                     563,
                     564,
                     565,
                     566,
                     567,
                     570,
                     571,
                     572)
ORDER BY   u.user_name