Script to check Responsibilities assigned to particular user or users assigned for particular resposibility or all users and their responsibilities


Script to check Responsibilities assigned to particular user or users assigned for particular resposibility or all users and their responsibilities in oracle

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 like ‘SAIRAM_GOUD’ — for all user or for perticular user
— AND fur.responsibility_application_id = 275 — to check users for perticular responsibility
order by user_name

Advertisements