Tuesday, 22 July 2014

Oracle Apps - To know the responsibility of user

Hi Folks,



 Below is the query to know the responsibility of user


   SELECT fu.user_name, fu.start_date user_startdate, fu.end_date user_enddate,
       fr.responsibility_name, furgd.start_date, furgd.end_date,
       fu.email_address,trunc(sysdate)
  FROM fnd_user fu,
       fnd_user_resp_groups_direct furgd,
       fnd_responsibility_tl fr
 WHERE fr.responsibility_id = furgd.responsibility_id
   AND fu.user_id = furgd.user_id
 and fu.user_name = :User_name

   AND fr.LANGUAGE = 'US'

No comments:

Post a Comment