ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDE9879D2E0530100007F1FF2 FND Application Name Y select fav.application_name value, fav.application_short_name description from fnd_application_vl fav order by fav.application_name US 8E2FF36EDE8279D2E0530100007F1FF2 FND Concurrent Program Name (SRS enabled only) select fcpv.user_concurrent_program_name value, fav.application_name||nvl2(fcpv.description,': ',null)||fcpv.description description from fnd_application_vl fav, fnd_concurrent_programs_vl fcpv where fcpv.application_id=fav.application_id and fcpv.srs_flag in ('Y','Q') and fcpv.enabled_flag='Y' order by fcpv.user_concurrent_program_name AR اسم البرنامج المتزامن FND يقتصر على SRS الممكّن فقط D FND gleichzeitiger Programmname beschränkt auf SRS aktiviert nur E Nombre del programa concurrente FND restringido sólo a los SRS habilitados F FND nom du programme concurrent limité à SRS activé uniquement I Nome del programma concorrente FND limitato al solo SRS abilitato JA FND 同時接続プログラム名をSRSに限定した場合のみ有効になります。 KO SRS로만 제한된 FND 동시 프로그램 이름 사용 가능 PTB FND nome do programa concorrente restrito à SRS habilitado apenas RU Одновременное имя программы FND, ограниченное только включенной SRS S FND: s samtidiga programnamn är endast begränsat till SRS aktiverat TR FND eşzamanlı program adı yalnızca SRS etkinleştirilmiş olarak sınırlandırılmıştır US FND concurrent program name restricted to SRS enabled only ZHS FND并发程序名称仅限于SRS启用。 8E2FF36EDEB079D2E0530100007F1FF2 FND Concurrent Program Name (all languages) Y select fcpt.user_concurrent_program_name value, '('||fcpt.language||') '||fav.application_name||nvl2(fcpt.description,': ',null)||fcpt.description description from fnd_application_vl fav, fnd_concurrent_programs fcp, fnd_concurrent_programs_tl fcpt where fcp.application_id=fav.application_id and fcp.srs_flag in ('Y','Q') and fcp.enabled_flag='Y' and fcp.application_id=fcpt.application_id and fcp.concurrent_program_id=fcpt.concurrent_program_id and fcpt.language=fcpt.source_lang order by fcpt.user_concurrent_program_name AR اسم البرنامج المتزامن بأي من اللغات المثبتة (وليس فقط لغة تسجيل الدخول) D Gleichzeitiger Programmname in einer beliebigen der installierten Sprachen (nicht nur der Anmeldesprache) E Nombre del programa concurrente en cualquiera de los idiomas instalados (no sólo el idioma de inicio de sesión) F Nom du programme simultané dans l'une des langues installées (pas seulement la langue de connexion) I Nome del programma concorrente in una qualsiasi delle lingue installate (non solo la lingua di login) JA インストールされているいずれかの言語での同時使用プログラム名 (ログイン言語だけではありません) KO 설치된 모든 언어로 된 동시 프로그램 이름 (로그인 언어뿐만 아니라) PTB Nome do programa concorrente em qualquer um dos idiomas instalados (não apenas o idioma de login) RU Одновременное имя программы на любом из установленных языков (а не только на языке входа в систему). S Samtidigt programnamn på något av de installerade språken (inte bara inloggningsspråket) TR Yüklü dillerden herhangi birinde eşzamanlı program adı (sadece giriş dili değil) US Concurrent program name in any of the installed languages (not just the login language) ZHS 用任何一种安装的语言（不仅仅是登录语言）并发的程序名称。 8E2FF36EDEA079D2E0530100007F1FF2 FND Concurrent Program Short Name (SRS enabled only) Y select fcpv.concurrent_program_name value, fav.application_name||': '||fcpv.user_concurrent_program_name description from fnd_application_vl fav, fnd_concurrent_programs_vl fcpv where fav.application_id=fcpv.application_id and fcpv.srs_flag in ('Y','Q') and fcpv.enabled_flag='Y' order by fcpv.concurrent_program_name AR الاسم المختصر للبرنامج المتزامن (البرامج الممكّنة والتي يمكن للمستخدم إرسالها فقط) D Kurzname des konkurrierenden Programms (nur freigegebene und vom Benutzer einreichbare Programme) E Nombre corto del programa concurrente (sólo para programas habilitados y que puedan ser enviados por el usuario) F Nom court du programme simultané (programmes activés et soumis par l'utilisateur uniquement) I Nome breve del programma concorrente (solo programmi abilitati e inviabili dall'utente) JA 同時使用プログラムの短縮名 (有効なプログラムとユーザーサブミット可能なプログラムのみ) KO 동시 프로그램 축약 이름 (사용 가능 및 사용자 제출 가능 프로그램 만 해당) PTB Nome curto do programa concorrente (somente programas habilitados e que podem ser submetidos pelo usuário) RU Одновременное короткое имя программы (только включенные и доступные для отправки пользователю программы). S Samtidigt programkortnamn (endast aktiverade och program som kan skickas av användare) TR Eşzamanlı program kısa adı (yalnızca etkin ve kullanıcı tarafından gönderilebilir programlar) US Concurrent program short name (enabled and user submittable programs only) ZHS 并发程序简称（仅启用和用户可提交的程序）。 8E2FF36EDEA779D2E0530100007F1FF2 FND Form Name Y select ffv.form_name value, fav.application_name||': '||ffv.user_form_name||nvl2(ffv.description,': '||ffv.description,null) description from fnd_application_vl fav, fnd_form_vl ffv where fav.application_id=ffv.application_id order by ffv.form_name US 8E2FF36EDEBB79D2E0530100007F1FF2 FND Function Name Y select fffv.function_name value, flvv.meaning||nvl2(fffv.description,': ',null)||fffv.description description from fnd_form_functions_vl fffv, fnd_lookup_values_vl flvv where fffv.type=flvv.lookup_code(+) and flvv.lookup_type(+)='FORM_FUNCTION_TYPE' and flvv.view_application_id(+)='0' and flvv.security_group_id(+)=0 order by fffv.function_name US 8E2FF36EDE9379D2E0530100007F1FF2 FND Menu Name Y select fmv.menu_name value, fmv.user_menu_name description from fnd_menus_vl fmv order by fmv.menu_name US 8E2FF36EDE8F79D2E0530100007F1FF2 FND Request Group Y select frg.request_group_name value, frg.description from fnd_request_groups frg where (:$flex$.fnd_application_name is null or frg.application_id in (select fav.application_id from fnd_application_vl fav where fav.application_name=:$flex$.fnd_application_name)) order by frg.request_group_name US 8E2FF36EDEBA79D2E0530100007F1FF2 FND User Form Name (wildcard) select ffv.user_form_name value, fav.application_name||': '||ffv.form_name||nvl2(ffv.description,': '||ffv.description,null) description from fnd_application_vl fav, fnd_form_vl ffv where fav.application_id=ffv.application_id order by ffv.user_form_name US 8E2FF36EDEBC79D2E0530100007F1FF2 FND User Function Name (wildcard) select fffv.user_function_name value, flvv.meaning||nvl2(fffv.description,': ',null)||fffv.description description from fnd_form_functions_vl fffv, fnd_lookup_values_vl flvv where 1=1 and fffv.type=flvv.lookup_code(+) and flvv.lookup_type(+)='FORM_FUNCTION_TYPE' and flvv.view_application_id(+)='0' and flvv.security_group_id(+)=0 order by fffv.user_function_name US 8E2FF36EDE8B79D2E0530100007F1FF2 FND User Menu Name Y select fmv.user_menu_name value, fmv.menu_name||': '||fmv.description description from fnd_menus_vl fmv order by fmv.user_menu_name US 8E2FF36EDEB179D2E0530100007F1FF2 FND User Name (wildcard, active) Y select fu.user_name value, coalesce( trim(papf.first_name||' '||papf.last_name), fu.description, fu.email_address, papf.email_address ) description from fnd_user fu, (select papf.* from per_all_people_f papf where sysdate between papf.effective_start_date and papf.effective_end_date) papf where trunc(sysdate) between fu.start_date and nvl(fu.end_date,sysdate) and fu.employee_id=papf.person_id(+) order by fu.user_name US 8E2FF36EDE8879D2E0530100007F1FF2 HR Operating Unit (all) Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) order by hou.name US 8E2FF36EDEA279D2E0530100007F1FF2 INV Organization Code (all) Y select ood.organization_code value, ood.organization_name||' ('||ftv.territory_short_name||', '||hla.town_or_city||decode(mp.organization_id,mp.master_organization_id,null,', '||mp0.organization_code)||')' description from org_organization_definitions ood, mtl_parameters mp, mtl_parameters mp0, hr_all_organization_units haou, hr_locations_all hla, fnd_territories_vl ftv where ood.organization_id=mp.organization_id and (:$flex$.operating_unit is null or ood.operating_unit in (select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and (:$flex$.ledger is null or ood.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and nvl(ood.disable_date,sysdate)>=sysdate and mp.master_organization_id=mp0.organization_id and ood.organization_id=haou.organization_id(+) and haou.location_id=hla.location_id(+) and hla.country=ftv.territory_code(+) order by ood.organization_code US All active inventory organization codes 9A9B9ECEEED90E90E053BA6B6358D80EY with func as ( select /*+ materialize*/ fffv.function_id from fnd_form_functions_vl fffv, fnd_form_vl ffv where 2=2 and '&show_function'='Y' and fffv.form_id=ffv.form_id(+) and fffv.application_id=ffv.application_id(+) ), nav as ( select /*+ materialize*/ sys_connect_by_path(fmev.prompt,'-> ') navigation_path_orig_, sys_connect_by_path(fmev.user_menu_name ,'-> ') menu_path_, sys_connect_by_path(to_char(fmev.entry_sequence,'000000.0'),'>') entry_sequence_, fmev.menu_id, connect_by_root fmev.function_id function_id from (select fmt.user_menu_name, fmev.* from fnd_menu_entries_vl fmev, fnd_menus_tl fmt where '&show_function'='Y' and fmev.sub_menu_id=fmt.menu_id(+) and fmt.language(+)=userenv('lang')) fmev connect by nocycle prior fmev.menu_id=fmev.sub_menu_id start with '&show_function'='Y' and fmev.function_id in (select func.function_id from func) ), prof as ( select /*+ materialize*/ distinct x.security_profile_id, x.security_profile, decode('&expand_operating_units','Y',haouv.name,listagg(haouv.name,chr(10)) within group (order by haouv.name) over (partition by x.security_profile_id)) operating_unit from ( select psp.security_profile_name security_profile, psp.security_profile_id, psp.business_group_id, psp.view_all_flag, nvl(pol.organization_id,nvl(hou.organization_id,hou0.organization_id)) organization_id from per_security_profiles psp, (select -1 view_all, hou.* from hr_operating_units hou) hou0, (select hou.* from hr_operating_units hou) hou, (select pol.* from per_organization_list pol, hr_operating_units hou where pol.organization_id=hou.organization_id) pol where decode(psp.view_all_flag,'N',psp.security_profile_id)=pol.security_profile_id(+) and decode(psp.view_all_flag,'Y',psp.business_group_id)=hou.business_group_id(+) and decode(psp.view_all_flag,'Y',nvl2(psp.business_group_id,null,-1))=hou0.view_all(+) ) x, hr_all_organization_units_vl haouv where x.organization_id=haouv.organization_id(+) ), org as ( select distinct listagg(oav.organization_code,chr(10)) within group (order by oav.organization_code) over (partition by oav.resp_application_id, oav.responsibility_id) organization, oav.resp_application_id, oav.responsibility_id from org_access_view oav ), usr as ( select /*+ materialize*/ furg.responsibility_application_id, furg.responsibility_id, furg.user_id, xxen_util.user_name(furg.user_id) user_name, nvl(fu.email_address,papf.email_address) email, papf.first_name||' '||papf.last_name person, haouv.name person_bg from fnd_user_resp_groups furg, fnd_user fu, (select papf.* from per_all_people_f papf where sysdate between papf.effective_start_date and papf.effective_end_date+1) papf, hr_all_organization_units_vl haouv where 3=3 and '&show_user'='Y' and furg.user_id=fu.user_id and fu.employee_id=papf.person_id(+) and papf.business_group_id=haouv.organization_id(+) ) --------------SQL starts here------------- select /*+ dynamic_sampling(3) */ z.responsibility_name responsibility, z.application_name, &col1 z.request_group_application, z.request_group_name, &col_conc z.user_menu_name, z.security_profile, z.operating_unit, z.organization, z.responsibility_key, &col2 z.menu_name, z.sql_session_init, z.resp_application_id application_id, z.responsibility_id from ( select y.*, case when y.fffv_type<>'SUBFUNCTION' and y.navigation_path_orig not like '%-> ' and y.navigation_path_orig not like '%-> -> %' then substr(y.navigation_path_orig,4) end navigation_path, prof.security_profile, case when prof.security_profile_id is not null then prof.operating_unit else (select haouv.name from hr_all_organization_units_vl haouv where y.org_id=haouv.organization_id) end operating_unit, org.organization from ( select frv.responsibility_name, fav.application_name, usr.user_name, usr.email, usr.person, usr.person_bg, xxen_util.reverse(nav.navigation_path_orig_,'-> ') navigation_path_orig, fffv.user_function_name, xxen_util.meaning(fffv.type,'FORM_FUNCTION_TYPE',0) function_type, ffv.user_form_name, fffv.web_html_call html_call, fav3.application_name request_group_application, frg.request_group_name, decode(frgu.request_unit_type,'P','Program','A','Application','S','Set') assignment_type, decode(frgu.request_unit_type, 'P',fcpv.user_concurrent_program_name, 'A',fav2.application_name, 'S',frsv.user_request_set_name ) assignment_name, fmv.user_menu_name, frv.responsibility_key, nvl(fcpv.user_concurrent_program_name,fcpv2.user_concurrent_program_name) concurrent_program, nvl(fcpv.concurrent_program_name,fcpv2.concurrent_program_name) conc_program_code, fmv.menu_name||'-> '||substr(xxen_util.reverse(nav.menu_path_,'-> '),4) menu_path, fffv.function_name, ffv.form_name, fffv.parameters, fmv.menu_name, coalesce( (select fpov.profile_option_value from fnd_profile_option_values fpov where usr.user_id=fpov.level_value and fpov.level_id=10004 and fpov.application_id=602 and fpov.profile_option_id=3796), (select fpov.profile_option_value from fnd_profile_option_values fpov where frv.responsibility_id=fpov.level_value and frv.application_id=fpov.level_value_application_id and fpov.level_id=10003 and fpov.application_id=602 and fpov.profile_option_id=3796), (select fpov.profile_option_value from fnd_profile_option_values fpov where fpov.level_value=0 and fpov.level_id=10001 and fpov.application_id=602 and fpov.profile_option_id=3796) ) security_profile_id, coalesce( (select fpov.profile_option_value from fnd_profile_option_values fpov where usr.user_id=fpov.level_value and fpov.level_id=10004 and fpov.application_id=0 and fpov.profile_option_id=1991), (select fpov.profile_option_value from fnd_profile_option_values fpov where frv.responsibility_id=fpov.level_value and frv.application_id=fpov.level_value_application_id and fpov.level_id=10003 and fpov.application_id=0 and fpov.profile_option_id=1991), (select fpov.profile_option_value from fnd_profile_option_values fpov where fpov.level_value=0 and fpov.level_id=10001 and fpov.application_id=0 and fpov.profile_option_id=1991) ) org_id, fffv.type fffv_type, xxen_util.reverse(nav.entry_sequence_,'>') entry_sequence, frv.application_id resp_application_id, frv.responsibility_id, frgu.request_unit_type, frgu.unit_application_id, frgu.request_unit_id, nvl(fcpv.application_id,fcpv2.application_id) conc_application_id, nvl(fcpv.concurrent_program_id,fcpv2.concurrent_program_id) concurrent_program_id, usr.user_id, fcmf.function_id, case when usr.user_id is not null then 'begin fnd_global.apps_initialize('||usr.user_id||','||usr.responsibility_id||','||usr.responsibility_application_id||'); mo_global.init; '|| nvl2(frv.default_mo_org,'fnd_profile.put(''MFG_ORGANIZATION_ID'','''||frv.default_mo_org||'''); ',null)||'gl_security_pkg.init; end;' end sql_session_init from fnd_application_vl fav, (select (select oav.organization_id from org_access_view oav where frv.application_id=oav.resp_application_id and frv.responsibility_id=oav.responsibility_id and rownum=1) default_mo_org, frv.* from fnd_responsibility_vl frv) frv, fnd_application_vl fav3, fnd_request_groups frg, (select frgu.* from fnd_request_group_units frgu where '&show_concurrent'='Y') frgu, (select fcpv.* from fnd_concurrent_programs_vl fcpv where fcpv.srs_flag in ('Y','Q') and fcpv.enabled_flag='Y') fcpv, (select fcpv2.* from fnd_concurrent_programs_vl fcpv2 where 4=4 and '&show_concurrent'='Y' and fcpv2.srs_flag in ('Y','Q') and fcpv2.enabled_flag='Y') fcpv2, fnd_application_vl fav2, fnd_request_sets_vl frsv, fnd_menus_vl fmv, usr, (select fcmf.* from fnd_compiled_menu_functions fcmf where '&show_function'='Y' and fcmf.function_id in (select func.function_id from func) and nvl(fcmf.grant_flag,'Y')='Y') fcmf, nav, fnd_form_functions_vl fffv, fnd_form_vl ffv, fnd_mo_product_init fmpi where 1=1 and fav.application_id=frv.application_id and frv.group_application_id=fav3.application_id(+) and frv.group_application_id=frg.application_id(+) and frv.request_group_id=frg.request_group_id(+) and frg.application_id=frgu.application_id(+) and frg.request_group_id=frgu.request_group_id(+) and decode(frgu.request_unit_type,'P',frgu.unit_application_id)=fcpv.application_id(+) and decode(frgu.request_unit_type,'P',frgu.request_unit_id)=fcpv.concurrent_program_id(+) and decode(frgu.request_unit_type,'A',frgu.unit_application_id)=fav2.application_id(+) and decode(frgu.request_unit_type,'A',frgu.unit_application_id)=fcpv2.application_id(+) and decode(frgu.request_unit_type,'S',frgu.unit_application_id)=frsv.application_id(+) and decode(frgu.request_unit_type,'S',frgu.request_unit_id)=frsv.request_set_id(+) and frv.responsibility_id=usr.responsibility_id(+) and frv.application_id=usr.responsibility_application_id(+) and frv.menu_id=fmv.menu_id(+) and frv.menu_id=fcmf.menu_id(+) and fcmf.menu_id=nav.menu_id(+) and fcmf.function_id=nav.function_id(+) and fcmf.function_id=fffv.function_id(+) and fffv.application_id=ffv.application_id(+) and fffv.form_id=ffv.form_id(+) and fav.application_short_name=fmpi.application_short_name(+) ) y, prof, org where y.security_profile_id=prof.security_profile_id(+) and y.responsibility_id=org.responsibility_id(+) and y.resp_application_id=org.resp_application_id(+) ) z where 5=5 order by z.application_name, z.responsibility_name, z.user_name, case when z.navigation_path is not null and z.fffv_type<>'SUBFUNCTION' then 1 else 2 end, z.entry_sequence, z.menu_path, z.user_function_name, z.operating_unit 49A8B1A8037B08ACE0530100007FEB91 not ( nvl(:User_Name_like,'x')='%' and (nvl(:User_Form_Name_like,'x')='%' or nvl(:Form_Name,'x')='%' or nvl(:User_Function_Name_like,'x')='%') or nvl(:Concurrent_Program_Name_like,'x')='%' and (nvl(:User_Form_Name_like,'x')='%' or nvl(:Form_Name,'x')='%' or nvl(:User_Function_Name_like,'x')='%') or nvl(:Concurrent_Program_Name_like,'x')='%' and nvl(:User_Name_like,'x')='%') US FND Responsibility Access 11i Responsibilites and related data such as users, concurrent programs, menus, functions, forms, data access set and security profiles and associated ledgers and operating units. This report basically answers all system access related questions. It shows which users or responsibilities have acess to which functions, forms, concurrent programs, ledgers, operating units or inventory organizations. Depending on parameter selection, this report shows for example: - responsibilities and related menus and request groups - responsibilities, menus, included forms, functions and their full menu navigation path - users and their assigned active responsibilities - users, assigned responsibilities and the concurrent programs they have access to - concurrent programs and the responsibilities that they can be run from - forms or functions and the responsibilities and users that can access them - responsibilities and navigation paths to access a certain form or function from a given user - operating units that a particular responsibility or user has access to through MOAC security profiles or profile option 'MO: Operating Unit' The parameters 'User', 'Form', 'Function' and 'Concurrent Program' are optional and can either be populated to filter records for a particular value only or entered with % to show all values or left blank to not show data related to that parameter. If the user parameter is left blank for example, then the report does not show any user names and shows information related to responsibility level only. Example: To show all users having access to the user maintenance form, enter parameters as follows: User Name: % User Form Name: Define Application User Please note that the SQL currently doesn't consider menu exclusions yet, which means that it's not 100% accurate as excluded functions would still show up in the report. Please enter more restrictive parameters. Enginatics &col1 &col2 &col_conc &expand_operating_units &show_concurrent &show_function &show_user 1=1 2=2 3=3 4=4 5=5 1 10 1=1 upper(frv.responsibility_name) like upper(:responsibility_name) LOV custom Y select frv.responsibility_name value, frv.description from fnd_responsibility_vl frv where :$flex$.user_name_like is null or (frv.application_id,frv.responsibility_id) in ( select furg.responsibility_application_id, furg.responsibility_id from fnd_user fu, fnd_user_resp_groups furg where fu.user_name=:$flex$.user_name_like and fu.user_id=furg.user_id ) order by frv.responsibility_name F Nom de la responsabilité US Responsibility Name 2 20 3=3 upper(fu.user_name) like upper(:user_name) LOV FND User Name (wildcard, active) 8E2FF36EDEB179D2E0530100007F1FF2 Y select fu.user_name value, coalesce( trim(papf.first_name||' '||papf.last_name), fu.description, fu.email_address, papf.email_address ) description from fnd_user fu, (select papf.* from per_all_people_f papf where sysdate between papf.effective_start_date and papf.effective_end_date) papf where trunc(sysdate) between fu.start_date and nvl(fu.end_date,sysdate) and fu.employee_id=papf.person_id(+) order by fu.user_name select fu.user_name from fnd_user fu where fu.user_id=fnd_global.user_id F Nom d'utilisateur comme US User Name like 3 &col1 z.user_name, z.email, z.person, z.person_bg, F Nom d'utilisateur comme US User Name like 4 &show_user Y F Nom d'utilisateur comme US User Name like 5 1=1 frv.responsibility_id=usr.responsibility_id and frv.application_id=usr.responsibility_application_id F Nom d'utilisateur comme US User Name like 6 30 1=1 fav.application_name=:application_name LOV FND Application Name 8E2FF36EDE9879D2E0530100007F1FF2 Y select fav.application_name value, fav.application_short_name description from fnd_application_vl fav order by fav.application_name US Application 7 40 1=1 (frv.application_id, frv.responsibility_id) in (select oav.resp_application_id, oav.responsibility_id from org_access_view oav where oav.organization_code=:organization_code) LOV INV Organization Code (all) 8E2FF36EDEA279D2E0530100007F1FF2 Y select ood.organization_code value, ood.organization_name||' ('||ftv.territory_short_name||', '||hla.town_or_city||decode(mp.organization_id,mp.master_organization_id,null,', '||mp0.organization_code)||')' description from org_organization_definitions ood, mtl_parameters mp, mtl_parameters mp0, hr_all_organization_units haou, hr_locations_all hla, fnd_territories_vl ftv where ood.organization_id=mp.organization_id and (:$flex$.operating_unit is null or ood.operating_unit in (select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and (:$flex$.ledger is null or ood.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and nvl(ood.disable_date,sysdate)>=sysdate and mp.master_organization_id=mp0.organization_id and ood.organization_id=haou.organization_id(+) and haou.location_id=hla.location_id(+) and hla.country=ftv.territory_code(+) order by ood.organization_code F Accès à l'inventaire Org US Access to Inventory Org 8 50 5=5 z.operating_unit like '%'||:operating_unit||'%' LOV HR Operating Unit (all) 8E2FF36EDE8879D2E0530100007F1FF2 Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) order by hou.name F Accès à l'unité opérationnelle US Access to Operating Unit 9 60 1=1 (frgu.request_unit_id, frgu.unit_application_id, frgu.request_unit_type) in ( select fcpv.concurrent_program_id, fcpv.application_id, 'P' from fnd_concurrent_programs_vl fcpv where upper(fcpv.user_concurrent_program_name) like upper(:user_concurrent_program_name) and fcpv.srs_flag in ('Y','Q') and fcpv.enabled_flag='Y' union all select fcpv.application_id, fcpv.application_id, 'A' from fnd_concurrent_programs_vl fcpv where upper(fcpv.user_concurrent_program_name) like upper(:user_concurrent_program_name) and fcpv.srs_flag in ('Y','Q') and fcpv.enabled_flag='Y' ) LOV FND Concurrent Program Name (SRS enabled only) 8E2FF36EDE8279D2E0530100007F1FF2 select fcpv.user_concurrent_program_name value, fav.application_name||nvl2(fcpv.description,': ',null)||fcpv.description description from fnd_application_vl fav, fnd_concurrent_programs_vl fcpv where fcpv.application_id=fav.application_id and fcpv.srs_flag in ('Y','Q') and fcpv.enabled_flag='Y' order by fcpv.user_concurrent_program_name F Nom du programme concomitant comme US Concurrent Program Name like 10 &col2 z.conc_program_code, F Nom du programme concomitant comme US Concurrent Program Name like 11 &col_conc z.concurrent_program, z.assignment_type, z.assignment_name, F Nom du programme concomitant comme US Concurrent Program Name like 12 &show_concurrent Y F Nom du programme concomitant comme US Concurrent Program Name like 13 4=4 upper(fcpv2.user_concurrent_program_name) like upper(:user_concurrent_program_name) F Nom du programme concomitant comme US Concurrent Program Name like 14 70 1=1 (frgu.request_unit_id, frgu.unit_application_id, frgu.request_unit_type) in ( select fcpt.concurrent_program_id, fcpt.application_id, 'P' from fnd_concurrent_programs fcp, fnd_concurrent_programs_tl fcpt where fcp.application_id=fcpt.application_id and fcp.concurrent_program_id=fcpt.concurrent_program_id and fcpt.user_concurrent_program_name=:user_conc_name_all_languages and fcp.srs_flag in ('Y','Q') and fcp.enabled_flag='Y' union all select fcpt.application_id, fcpt.application_id, 'A' from fnd_concurrent_programs fcp, fnd_concurrent_programs_tl fcpt where fcp.application_id=fcpt.application_id and fcp.concurrent_program_id=fcpt.concurrent_program_id and fcpt.user_concurrent_program_name=:user_conc_name_all_languages and fcp.srs_flag in ('Y','Q') and fcp.enabled_flag='Y' ) LOV FND Concurrent Program Name (all languages) 8E2FF36EDEB079D2E0530100007F1FF2 Y select fcpt.user_concurrent_program_name value, '('||fcpt.language||') '||fav.application_name||nvl2(fcpt.description,': ',null)||fcpt.description description from fnd_application_vl fav, fnd_concurrent_programs fcp, fnd_concurrent_programs_tl fcpt where fcp.application_id=fav.application_id and fcp.srs_flag in ('Y','Q') and fcp.enabled_flag='Y' and fcp.application_id=fcpt.application_id and fcp.concurrent_program_id=fcpt.concurrent_program_id and fcpt.language=fcpt.source_lang order by fcpt.user_concurrent_program_name US Concurrent Progr. (all languages) 15 &col2 z.conc_program_code, US Concurrent Progr. (all languages) 16 &col_conc z.concurrent_program, z.assignment_type, z.assignment_name, US Concurrent Progr. (all languages) 17 &show_concurrent Y US Concurrent Progr. (all languages) 18 4=4 fcpv2.user_concurrent_program_name in ( select fcpt.user_concurrent_program_name from fnd_concurrent_programs_tl fcpt0, fnd_concurrent_programs_tl fcpt where fcpt0.user_concurrent_program_name=:user_conc_name_all_languages and fcpt0.application_id=fcpt.application_id and fcpt0.concurrent_program_id=fcpt.concurrent_program_id and fcpt.language=userenv('lang') ) US Concurrent Progr. (all languages) 19 80 1=1 (frgu.request_unit_id, frgu.unit_application_id, frgu.request_unit_type) in ( select fcpv.concurrent_program_id, fcpv.application_id, 'P' from fnd_concurrent_programs_vl fcpv where upper(fcpv.concurrent_program_name) like upper(:concurrent_program_name) and fcpv.srs_flag in ('Y','Q') and fcpv.enabled_flag='Y' union all select fcpv.application_id, fcpv.application_id, 'A' from fnd_concurrent_programs_vl fcpv where upper(fcpv.concurrent_program_name) like upper(:concurrent_program_name) and fcpv.srs_flag in ('Y','Q') and fcpv.enabled_flag='Y' ) LOV FND Concurrent Program Short Name (SRS enabled only) 8E2FF36EDEA079D2E0530100007F1FF2 Y select fcpv.concurrent_program_name value, fav.application_name||': '||fcpv.user_concurrent_program_name description from fnd_application_vl fav, fnd_concurrent_programs_vl fcpv where fav.application_id=fcpv.application_id and fcpv.srs_flag in ('Y','Q') and fcpv.enabled_flag='Y' order by fcpv.concurrent_program_name F Programme concomitant Nom court US Concurrent Program Short Name 20 &col2 z.conc_program_code, F Programme concomitant Nom court US Concurrent Program Short Name 21 &col_conc z.concurrent_program, z.assignment_type, z.assignment_name, F Programme concomitant Nom court US Concurrent Program Short Name 22 &show_concurrent Y F Programme concomitant Nom court US Concurrent Program Short Name 23 4=4 upper(fcpv2.concurrent_program_name) like upper(:concurrent_program_name) F Programme concomitant Nom court US Concurrent Program Short Name 24 90 1=1 frg.request_group_name=:request_group LOV FND Request Group 8E2FF36EDE8F79D2E0530100007F1FF2 Y select frg.request_group_name value, frg.description from fnd_request_groups frg where (:$flex$.fnd_application_name is null or frg.application_id in (select fav.application_id from fnd_application_vl fav where fav.application_name=:$flex$.fnd_application_name)) order by frg.request_group_name F Groupe de demande US Request Group 25 100 2=2 ( upper(fffv.user_function_name) like upper(:menu_entry) or upper(fffv.function_name) like upper(:menu_entry) or upper(ffv.user_form_name) like upper(:menu_entry) or upper(ffv.form_name) like upper(:menu_entry) ) Char F Entrée de menu comme Recherche par joker pour les noms de fonctions et de formulaires (à la fois, interne et système) US Menu Entry like Wildcard search for function and form names (both, internal and system) 26 &col1 z.navigation_path, z.user_function_name, z.function_type, z.user_form_name, z.html_call, F Entrée de menu comme US Menu Entry like 27 &col2 z.menu_path, z.function_name, z.form_name, z.parameters, F Entrée de menu comme US Menu Entry like 28 &show_function Y F Entrée de menu comme US Menu Entry like 29 1=1 frv.menu_id=fcmf.menu_id F Entrée de menu comme US Menu Entry like 30 110 2=2 upper(fffv.user_function_name) like upper(:user_function_name) LOV FND User Function Name (wildcard) 8E2FF36EDEBC79D2E0530100007F1FF2 select fffv.user_function_name value, flvv.meaning||nvl2(fffv.description,': ',null)||fffv.description description from fnd_form_functions_vl fffv, fnd_lookup_values_vl flvv where 1=1 and fffv.type=flvv.lookup_code(+) and flvv.lookup_type(+)='FORM_FUNCTION_TYPE' and flvv.view_application_id(+)='0' and flvv.security_group_id(+)=0 order by fffv.user_function_name F Nom de la fonction utilisateur comme US User Function Name like 31 &col1 z.navigation_path, z.user_function_name, z.function_type, z.user_form_name, z.html_call, F Nom de la fonction utilisateur comme US User Function Name like 32 &col2 z.menu_path, z.function_name, z.form_name, z.parameters, F Nom de la fonction utilisateur comme US User Function Name like 33 &show_function Y F Nom de la fonction utilisateur comme US User Function Name like 34 1=1 frv.menu_id=fcmf.menu_id F Nom de la fonction utilisateur comme US User Function Name like 35 120 2=2 fffv.function_name=:function_name LOV FND Function Name 8E2FF36EDEBB79D2E0530100007F1FF2 Y select fffv.function_name value, flvv.meaning||nvl2(fffv.description,': ',null)||fffv.description description from fnd_form_functions_vl fffv, fnd_lookup_values_vl flvv where fffv.type=flvv.lookup_code(+) and flvv.lookup_type(+)='FORM_FUNCTION_TYPE' and flvv.view_application_id(+)='0' and flvv.security_group_id(+)=0 order by fffv.function_name F Nom de la fonction US Function Name 36 &col1 z.navigation_path, z.user_function_name, z.function_type, z.user_form_name, z.html_call, F Nom de la fonction US Function Name 37 &col2 z.menu_path, z.function_name, z.form_name, z.parameters, F Nom de la fonction US Function Name 38 &show_function Y F Nom de la fonction US Function Name 39 1=1 frv.menu_id=fcmf.menu_id F Nom de la fonction US Function Name 40 130 2=2 upper(ffv.user_form_name) like upper(:user_form_name) LOV FND User Form Name (wildcard) 8E2FF36EDEBA79D2E0530100007F1FF2 select ffv.user_form_name value, fav.application_name||': '||ffv.form_name||nvl2(ffv.description,': '||ffv.description,null) description from fnd_application_vl fav, fnd_form_vl ffv where fav.application_id=ffv.application_id order by ffv.user_form_name F Nom du formulaire de l'utilisateur comme US User Form Name like 41 &col1 z.navigation_path, z.user_function_name, z.function_type, z.user_form_name, z.html_call, F Nom du formulaire de l'utilisateur comme US User Form Name like 42 &col2 z.menu_path, z.function_name, z.form_name, z.parameters, F Nom du formulaire de l'utilisateur comme US User Form Name like 43 &show_function Y F Nom du formulaire de l'utilisateur comme US User Form Name like 44 1=1 frv.menu_id=fcmf.menu_id F Nom du formulaire de l'utilisateur comme US User Form Name like 45 140 2=2 ffv.form_name=:form_name LOV FND Form Name 8E2FF36EDEA779D2E0530100007F1FF2 Y select ffv.form_name value, fav.application_name||': '||ffv.user_form_name||nvl2(ffv.description,': '||ffv.description,null) description from fnd_application_vl fav, fnd_form_vl ffv where fav.application_id=ffv.application_id order by ffv.form_name F Nom du formulaire US Form Name 46 &col1 z.navigation_path, z.user_function_name, z.function_type, z.user_form_name, z.html_call, F Nom du formulaire US Form Name 47 &col2 z.menu_path, z.function_name, z.form_name, z.parameters, F Nom du formulaire US Form Name 48 &show_function Y F Nom du formulaire US Form Name 49 1=1 frv.menu_id=fcmf.menu_id F Nom du formulaire US Form Name 50 150 1=1 fmv.user_menu_name=:user_menu_name LOV FND User Menu Name 8E2FF36EDE8B79D2E0530100007F1FF2 Y select fmv.user_menu_name value, fmv.menu_name||': '||fmv.description description from fnd_menus_vl fmv order by fmv.user_menu_name F Nom du menu utilisateur US User Menu Name 51 160 1=1 fmv.menu_name=:menu_name LOV FND Menu Name 8E2FF36EDE9379D2E0530100007F1FF2 Y select fmv.menu_name value, fmv.user_menu_name description from fnd_menus_vl fmv order by fmv.menu_name F Nom du menu US Menu Name 52 170 &expand_operating_units Y LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description Y F Étendre les unités d'exploitation multiples US Expand Multiple Operating Units :$flex$.fnd_application_name Application Request Group :$flex$.user_name_like User Name like Responsibility Name