转自ITPUB的脚本:
SELECT fu.user_name,
fu.start_date "User_Start_Date",
fu.end_date "User_End_Date" ,
frv.responsibility_name,
fa.application_short_name,
furgd.start_date "Resp_Start_Date",
furgd.end_date "Resp_End_Date"
FROM apps.fnd_user_resp_groups_direct furgd,
apps.fnd_user fu,
apps.fnd_responsibility_vl frv,
apps.fnd_application fa
WHERE fu.user_id = furgd.user_id
AND frv.responsibility_id = furgd.responsibility_id
AND frv.application_id=fa.application_id
AND fu.end_date IS NULL
AND furgd.end_date IS NULL
AND upper(fu.user_name) like upper('&user_name')