Stay at Home!! Be Safe!! Take Care!!

For Any queries, please mail us at support@funoracleapps.com

Query to find all Responsibilities of a User

No comments

Query to find all Responsibilities of a User



Script:

SELECT
    fu.user_name "User Name",
    frt.responsibility_name "Responsibility Name",
    furg.start_date "Start Date",
    furg.end_date "End Date",
    fr.responsibility_key "Responsibility Key",
    fa.application_short_name "Application Short Name"
FROM
    fnd_user_resp_groups_direct furg,
    applsys.fnd_user fu,
    applsys.fnd_responsibility_tl frt,
    applsys.fnd_responsibility fr,
    applsys.fnd_application_tl fat,
    applsys.fnd_application fa
WHERE
        furg.user_id = fu.user_id
    AND
        furg.responsibility_id = frt.responsibility_id
    AND
        fr.responsibility_id = frt.responsibility_id
    AND
        fa.application_id = fat.application_id
    AND
        fr.application_id = fat.application_id
    AND
        frt.language = userenv('LANG')
    AND
        upper(fu.user_name) = upper('HSINGH')  --

ORDER BY frt.responsibility_name;

No comments :

Post a Comment