Friday, 11 March 2016

How to find the users attached to the particular responsibility?




  1. select distinct fu.USER_ID
  2.                ,fu.USER_NAME
  3.                ,frt.RESPONSIBILITY_ID
  4.                ,frt.RESPONSIBILITY_NAME
  5.                ,fu.CREATION_DATE
  6. from fnd_user fu
  7.     ,fnd_responsibility_tl frt
  8.     ,fnd_user_resp_groups_direct furgd
  9. where 1=1
  10.    and frt.RESPONSIBILITY_ID=20420
  11.    and fu.USER_ID=furgd.USER_ID
  12.    and frt.RESPONSIBILITY_ID=furgd.RESPONSIBILITY_ID
  13. order by fu.CREATION_DATE desc
      (OR)

  1. select distinct fu.USER_ID
  2.                ,fu.USER_NAME
  3.                ,frt.RESPONSIBILITY_ID
  4.                ,frt.RESPONSIBILITY_NAME
  5.                ,fu.CREATION_DATE
  6. from fnd_user fu
  7.     ,fnd_responsibility_tl frt
  8.     ,fnd_user_resp_groups_direct furgd
  9. where 1=1
  10.    and frt.RESPONSIBILITY_ID=:lvResp_id   
  11.    and fu.USER_ID=furgd.USER_ID
  12.    and frt.RESPONSIBILITY_ID=furgd.RESPONSIBILITY_ID
  13. order by fu.CREATION_DATE desc

No comments:

Post a Comment

Query to find request set and its responsibility

  SELECT FA.application_name,        fr.responsibility_name program_attached_to,        frg.request_group_name,        fcp.request_set_name,...