1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Query to find responsibilities for particular user

Discussion in 'Oracle Apps Technical' started by Bharat, May 16, 2012.

  1. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Query to find Responsibilities for particular user.

    Code (Text):
    select fu.user_name, fr.responsibility_name, furg.START_DATE, furg.END_DATE
    from fnd_user_resp_groups_direct furg, fnd_user fu, fnd_responsibility_tl fr
    where fu.user_name = upper('&user_name') and furg.user_id = fu.user_id
    and furg.responsibility_id = fr.responsibility_id and fr.language = userenv('LANG');
     
    Ramji likes this.