- select distinct fu.USER_ID
- ,fu.USER_NAME
- ,frt.RESPONSIBILITY_ID
- ,frt.RESPONSIBILITY_NAME
- ,fu.CREATION_DATE
- from fnd_user fu
- ,fnd_responsibility_tl frt
- ,fnd_user_resp_groups_direct furgd
- where 1=1
- and frt.RESPONSIBILITY_ID=20420
- and fu.USER_ID=furgd.USER_ID
- and frt.RESPONSIBILITY_ID=furgd.RESPONSIBILITY_ID
- order by fu.CREATION_DATE desc
(OR)
- select distinct fu.USER_ID
- ,fu.USER_NAME
- ,frt.RESPONSIBILITY_ID
- ,frt.RESPONSIBILITY_NAME
- ,fu.CREATION_DATE
- from fnd_user fu
- ,fnd_responsibility_tl frt
- ,fnd_user_resp_groups_direct furgd
- where 1=1
- and frt.RESPONSIBILITY_ID=:lvResp_id
- and fu.USER_ID=furgd.USER_ID
- and frt.RESPONSIBILITY_ID=furgd.RESPONSIBILITY_ID
- order by fu.CREATION_DATE desc
No comments:
Post a Comment