Search 800 + Posts

Jan 24, 2013

Query to get the Responsibilities attached to user


Below is simple Query to get the Responsibilities attached to user in Oracle Application .It has 1 parameter

  1. User Name
 select  usr.user_id, usr.user_name, res.RESPONSIBILITY_ID,
      res.RESPONSIBILITY_NAME
      INTO p_resp_name
      from
      apps.FND_USER usr,
      apps.FND_RESPONSIBILITY_TL res,
      apps.FND_USER_RESP_GROUPS grp
      where  1=1
      and grp.responsibility_id = res.responsibility_id
      and grp.user_id = usr.user_id
      and usr.user_name =p_user_name;

No comments:

Post a Comment