Friday, November 1, 2019

Find all Oracle R12 responsibility access by Query

SELECT fuser.user_name User_Name,
       frt.responsibility_name  Responsibility_Name,
       furgd.start_date            Start_Date,
       furgd.end_date              End_Date,
       fresp.responsibility_key    Responsibility_Key,
       fapp.application_short_name Application_Short_Name
    FROM apps.fnd_user_resp_groups_direct furgd,
       apps.fnd_user                    fuser,
       apps.fnd_responsibility          fresp,
       apps.fnd_responsibility_tl       frt,
       apps.fnd_application             fapp,
       apps.fnd_application_tl          fat
 WHERE 1 = 1
   AND furgd.user_id = fuser.user_id
   AND furgd.responsibility_id = frt.responsibility_id
   AND fresp.responsibility_id = frt.responsibility_id
   AND fapp.application_id = fat.application_id
   AND fresp.application_id = fat.application_id
   AND frt.language = USERENV('LANG')
   AND UPPER(fuser.user_name) = UPPER('&Enter_User_Name')
--AND (furgd.end_date IS NULL OR furgd.end_date >= TRUNC(SYSDATE))
 ORDER BY frt.responsibility_name;

No comments:

Post a Comment