Shulou(Shulou.com)06/01 Report--

SELECT DISTINCT papf.person_id

Papf.employee_number

Papf.full_name

Su.user_id

Res.responsibility_id

Res.application_id

Su.user_name

Res.responsibility_name

FROM hr.per_all_people_f papf

Applsys.fnd_user su

Fnd_responsibility_vl res

Fnd_user_resp_groups_all furg

Fnd_application_vl app

WHERE

Su.employee_id = Papf.person_Id (+)

AND su.user_id = furg.user_id

AND res.responsibility_id = furg.responsibility_id

AND res.application_id = furg.responsibility_application_id

AND furg.responsibility_application_id = app.application_Id

And res.responsibility_name Like'% responsibility_name%'

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.