选择papf截然不同。person_id,
papf。employee_number,
papf。,
su.user_id full_name
res.responsibility_id,
res.application_id,
,
su.user_name res.responsibility_name
人力资源。per_all_people_f papf,
applsys。fnd_user苏,
fnd_responsibility_vl res,
fnd_user_resp_groups_all furg,
fnd_application_vl应用
,
su.employee_id=Papf.person_Id (+)
和su.user_id=furg。user_id
和res.responsibility_id=furg。responsibility_id
和res.application_id=furg。responsibility_application_id
和furg。responsibility_application_id=app.application_Id
和res.responsibility_name % responsibility_name %的;
