Sunday, August 28, 2016

Query to find out Responsibilities assigned to a user

* Formatted on 2016/08/26 16:14 (Formatter Plus v4.8.8) */
SELECT fu.user_name "User Name",
       frt.responsibility_name "Responsibility Name",
       furg.start_date "Start Date", furg.end_date "End Date",
       fr.responsibility_key "Responsibility Key",
       fa.application_short_name "Application Short Name"
  FROM fnd_user_resp_groups_direct furg,
       applsys.fnd_user fu,
       applsys.fnd_responsibility_tl frt,
       applsys.fnd_responsibility fr,
       applsys.fnd_application_tl fat,
       applsys.fnd_application fa
WHERE furg.user_id = fu.user_id
   AND furg.responsibility_id = frt.responsibility_id
   AND fr.responsibility_id = frt.responsibility_id
   AND fa.application_id = fat.application_id
   AND fr.application_id = fat.application_id
   AND frt.LANGUAGE = USERENV ('LANG')
   AND UPPER (fu.user_name) =
          UPPER
             ('MUNGI500')  ---- Provide user id


No comments:

Post a Comment

Types of animations

Animation is a diverse and creative field with a variety of styles that artists and filmmakers use to bring their visions to life. Here are ...