Wednesday 1 October 2014

how to find out the list of responsibilities assign to users

SELECT   fu.user_id,
           fu.user_name,
           fur.responsibility_id,
           fr.responsibility_name
    FROM   fnd_user fu, fnd_user_resp_groups fur, fnd_responsibility_vl fr
   WHERE       fu.user_id = fur.user_id
           AND fr.application_id = fur.responsibility_application_id
           AND fr.responsibility_id = fur.responsibility_id
           AND TRUNC (SYSDATE) BETWEEN TRUNC (fr.start_date)
                                   AND  TRUNC (
                                           NVL ( (fr.end_date - 1), SYSDATE)
                                        )
           AND TRUNC (SYSDATE) BETWEEN TRUNC (fur.start_date)
                                   AND  TRUNC (
                                           NVL ( (fur.end_date - 1), SYSDATE)
                                        )
--and user_name ='502135771'--- for all user or for perticular user
--AND fr.RESPONSIBILITY_NAME ='System Administrator'
ORDER BY   user_name

No comments:

Post a Comment