Listing User’s Assigned Responsibility in Application level

The following scripts used for User’s responsibility  , User Assigned Responsibility Listing in Application level.




1.Script for View User’s responsibility.

SELECT (SELECT application_short_name 
FROM apps.fnd_application fa
WHERE fa.application_id = frt.application_id) application,
frt.responsibility_id, frt.responsibility_name
FROM apps.fnd_responsibility_tl frt;




2.User Assigned Responsibility Listing in Application level.

SELECT UNIQUE u.user_id, SUBSTR (u.user_name, 1, 30) user_name,
SUBSTR (r.responsibility_name, 1, 60) responsiblity,
SUBSTR (a.application_name, 1, 50) application
FROM apps.fnd_user u,
apps.fnd_user_resp_groups g,
apps.fnd_application_tl a,
apps.fnd_responsibility_tl r
WHERE g.user_id(+) = u.user_id
AND g.responsibility_application_id = a.application_id
AND a.application_id = r.application_id
AND g.responsibility_id = r.responsibility_id
ORDER BY SUBSTR (user_name, 1, 30),
SUBSTR (a.application_name, 1, 50),
SUBSTR (r.responsibility_name, 1, 60);

  • October 3, 2018 | 22 views
  • Comments