Monday, 13 July 2015

How to know the responsibilities attached to the user from back end ?

select fr.responsibility_id,
          fr.responsibility_name,
          fu.user_name,
          furgd. start_date,
          furgd. end_date
from fnd_responsibility_tl fr,
         fnd_user fu,
         fnd_user_resp_groups_direct furgd
where     fr.responsibility_id=furgd.responsibility_id
        and fu. user_id = furgd. user_id
and fu. user_name= 'xxxxx';


or


select fr.responsibility_id,
          fr.responsibility_name,
          fu.user_name,
          furgd. start_date,
          furgd. end_date
from fnd_responsibility_tl fr,
         fnd_user fu,
         fnd_user_resp_groups_direct furgd
where     fr.responsibility_id=furgd.responsibility_id
        and fu. user_id = furgd. user_id
and fu. user_id=1032;

No comments:

Post a Comment

How to schedule PO workflow schedule process

create or replace PACKAGE APPS.XXXX_PO_WF_SCHEDULING_PKG IS    --|==========================================================================...