SELECT fr.responsibility_name
|| ' ' || DECODE (fur.end_date,
NULL, '', '(inactive)')
resp_name,
' BEGIN FND_GLOBAL.APPS_INITIALIZE('
|| fu.user_id
|| ','
|| fr.responsibility_id
|| ','
|| fur.responsibility_application_id
|| '); END;'
exe
FROM
apps.fnd_responsibility_vl fr,
apps.fnd_user_resp_groups_direct
fur,
apps.fnd_user
fu
WHERE
1 = 1
AND
fu.user_name LIKE UPPER ('&username')
AND
fur.user_id = fu.user_id
AND
fr.responsibility_id =
fur.responsibility_id
ORDER BY fr.responsibility_name;
No comments:
Post a Comment