1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 |
SELECT fu.user_name "User Name", frt.responsibility_name "Responsibility Name", furg.start_date "Start Date", furg.end_date "End Date", fr.responsibility_key "Responsibility Key", fa.application_short_name "Application Short Name" FROM apps.fnd_user_resp_groups_direct furg, applsys.fnd_user fu, applsys.fnd_responsibility_tl frt, applsys.fnd_responsibility fr, applsys.fnd_application_tl fat, applsys.fnd_application fa WHERE furg.user_id = fu.user_id AND furg.responsibility_id = frt.responsibility_id AND fr.responsibility_id = frt.responsibility_id AND fa.application_id = fat.application_id AND fr.application_id = fat.application_id AND frt.language = USERENV('LANG') AND UPPER(fu.user_name) = UPPER('USUARIO_DO_EBS') AND (furg.end_date IS NULL OR furg.end_date >= TRUNC(SYSDATE)) ORDER BY frt.responsibility_name; |
Orabr
Base e troca de conhecimentos, divulgação de oportunidades e projetos
Você precisa fazer log in para comentar.