ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDE8479D2E0530100007F1FF2 FND User Name Y Y select fu.user_name value, trim(coalesce( trim(papf.first_name||' '||papf.last_name), fu.description, fu.email_address, papf.email_address )||fu.inactive) description from (select case when sysdate between fu.start_date and nvl(fu.end_date,sysdate) then null else ' (inactive)' end inactive, fu.* from fnd_user fu) fu, (select papf.* from per_all_people_f papf where sysdate between papf.effective_start_date and papf.effective_end_date) papf, ( select distinct furg.user_id, count(*) over (partition by furg.user_id) resp_count, max(fr.responsibility_key) over (partition by furg.user_id) max_responsibility_key from fnd_responsibility fr, fnd_user_resp_groups_direct furg where fr.responsibility_id=furg.responsibility_id and fr.application_id=furg.responsibility_application_id ) furg where fu.employee_id=papf.person_id(+) and fu.user_id=furg.user_id(+) and not (furg.resp_count=1 and furg.max_responsibility_key='IRC_EXT_CANDIDATE') order by fu.inactive desc, fu.user_name US FND user names, excluding iRecruitment candidates. 73B0E9FB77183416E053B86B6358EC5C select xxen_util.user_name(icme.user_id) user_name, frv.responsibility_name responsibility, icme.display_sequence, icme.prompt, icme.url, nvl(xxen_util.meaning(fffv.type,'FORM_FUNCTION_TYPE',0),icme.function_type) type, fffv.user_function_name, fffv.function_name from icx_custom_menu_entries icme, fnd_responsibility_vl frv, fnd_form_functions_vl fffv where 1=1 and icme.responsibility_id=frv.responsibility_id(+) and icme.responsibility_application_id=frv.application_id(+) and icme.function_id=fffv.function_id(+) order by user_name, icme.display_sequence Y AR FND User Login Page Favorites مفضلات HTML للمستخدم من الجدول icx_custom_menu_entries D FND User Login Page Favorites HTML-Favoriten des Benutzers aus Tabelle icx_custom_menu_entries E FND User Login Page Favorites Favoritos HTML del usuario de la tabla icx_custom_menu_entries F FND User Login Page Favorites Favoris HTML de l'utilisateur de la table icx_custom_menu_entries I FND User Login Page Favorites Preferiti HTML dell'utente dalla tabella icx_custom_menu_entries JA FND User Login Page Favorites icx_custom_menu_entries テーブルからのユーザの HTML お気に入り KO FND User Login Page Favorites icx_custom_menu_entries 테이블에서 사용자의 HTML 즐겨 찾기 PTB FND User Login Page Favorites Favoritos do usuário HTML da tabela icx_custom_menu_entries RU FND User Login Page Favorites Избранное пользователем HTML из таблицы icx_custom_menu_entries S FND User Login Page Favorites Användarens HTML-favoriter från tabellen icx_custom_menu_entries TR FND User Login Page Favorites Kullanıcının icx_custom_menu_entries tablosundaki HTML favorileri US FND User Login Page Favorites User's HTML favourites from table icx_custom_menu_entries ZHS FND User Login Page Favorites 用户从表icx_custom_menu_entries中的HTML收藏夹。 Enginatics 1=1 1 10 1=1 icme.user_id=xxen_util.user_id(:user_name) LOV FND User Name 8E2FF36EDE8479D2E0530100007F1FF2 Y Y select fu.user_name value, trim(coalesce( trim(papf.first_name||' '||papf.last_name), fu.description, fu.email_address, papf.email_address )||fu.inactive) description from (select case when sysdate between fu.start_date and nvl(fu.end_date,sysdate) then null else ' (inactive)' end inactive, fu.* from fnd_user fu) fu, (select papf.* from per_all_people_f papf where sysdate between papf.effective_start_date and papf.effective_end_date) papf, ( select distinct furg.user_id, count(*) over (partition by furg.user_id) resp_count, max(fr.responsibility_key) over (partition by furg.user_id) max_responsibility_key from fnd_responsibility fr, fnd_user_resp_groups_direct furg where fr.responsibility_id=furg.responsibility_id and fr.application_id=furg.responsibility_application_id ) furg where fu.employee_id=papf.person_id(+) and fu.user_id=furg.user_id(+) and not (furg.resp_count=1 and furg.max_responsibility_key='IRC_EXT_CANDIDATE') order by fu.inactive desc, fu.user_name F Nom de l'utilisateur US User Name