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 8E2FF36EDEBE79D2E0530100007F1FF2 FND Application Short Name Y select fav.application_short_name value, fav.application_name description from fnd_application_vl fav order by fav.application_short_name US 8E2FF36EDED979D2E0530100007F1FF2 FND Concurrent Execution Method Y select flvv.meaning value, flvv.lookup_code description from fnd_lookup_values_vl flvv where flvv.lookup_type='CP_EXECUTION_METHOD_CODE' and flvv.view_application_id=0 and flvv.security_group_id=0 order by flvv.meaning US 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 用任何一种安装的语言（不仅仅是登录语言）并发的程序名称。 8E2FF36EDE9179D2E0530100007F1FF2 FND Concurrent Program Name (wildcard) select fcpt.user_concurrent_program_name value, fav.application_name||nvl2(fcpt.description,': ',null)||fcpt.description description from fnd_application_vl fav, fnd_concurrent_programs_tl fcpt where fcpt.language=userenv('lang') and fcpt.application_id=fav.application_id order by fcpt.user_concurrent_program_name US 8E2FF36EDEAD79D2E0530100007F1FF2 FND Executable Short Name Y select fev.executable_name value, fav.application_name||': '||case when fev.description is null and fev.user_executable_name<>fev.executable_name then fev.user_executable_name else fev.description end description from fnd_application_vl fav, fnd_executables_vl fev where fav.application_id=fev.application_id and (:$flex$.FND_Concurrent_Execution_Method is null or xxen_util.contains(:$flex$.FND_Concurrent_Execution_Method,xxen_util.meaning(fev.execution_method_code,'CP_EXECUTION_METHOD_CODE',0))='Y') order by fev.executable_name US 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US 49A8B1A8036D08ACE0530100007FEB91 select fcpv.user_concurrent_program_name program, fcpv.description, fav.application_name, fav.application_short_name, fcpv.concurrent_program_name short_name, xxen_util.meaning(fcpv.enabled_flag,'YES_NO',0) enabled_flag, fev.executable_name executable_short_name, xxen_util.meaning(fev.execution_method_code,'CP_EXECUTION_METHOD_CODE',0) method, fev.execution_file_name, fcpv.execution_options options, xxen_util.meaning(fcpv.output_file_type,'CP_OUTPUT_FILE_TYPE',0) output_format, fcrc.request_class_name type, fcpv.increment_proc incrementor, xxen_util.meaning(fcpv.multi_org_category,'CONC_PROGRAM_CATEGORY',0) operating_unit_mode, case when fcpoi.business_event_map like '%Y%' then fcpoi.business_event_map end business_events, fcpoi.node_name1 target_node, fcpoi.connstr1 two_task, &column_parameters case when fev.description is null and fev.user_executable_name<>fev.executable_name then fev.user_executable_name else fev.description end executable_description, xxen_util.user_name(fcpv.created_by) created_by, xxen_util.client_time(fcpv.creation_date) creation_date, xxen_util.user_name(fcpv.last_updated_by) last_updated_by, xxen_util.client_time(fcpv.last_update_date) last_update_date, fcpv.concurrent_program_id from fnd_application_vl fav, fnd_concurrent_programs_vl fcpv, fnd_executables_vl fev, (select fdfcuv.* from fnd_descr_flex_col_usage_vl fdfcuv where '&show_parameters'='Y') fdfcuv, fnd_flex_value_sets ffvs, fnd_concurrent_request_class fcrc, fnd_conc_prog_onsite_info fcpoi where 1=1 and fav.application_id=fcpv.application_id and fcpv.executable_application_id=fev.application_id and fcpv.executable_id=fev.executable_id and fcpv.application_id=fdfcuv.application_id(+) and '$SRS$.'||fcpv.concurrent_program_name=fdfcuv.descriptive_flexfield_name(+) and fdfcuv.descriptive_flex_context_code(+)='Global Data Elements' and fdfcuv.flex_value_set_id=ffvs.flex_value_set_id(+) and fcpv.class_application_id=fcrc.application_id(+) and fcpv.concurrent_class_id=fcrc.request_class_id(+) and fcpv.concurrent_program_id=fcpoi.concurrent_program_id(+) and fcpv.application_id=fcpoi.program_application_id(+) order by fav.application_name, fcpv.user_concurrent_program_name, fdfcuv.column_seq_num Y AR FND Concurrent Programs and Executables البرامج المتزامنة والملفات التنفيذية ومعلمات البرنامج D FND Concurrent Programs and Executables Gleichzeitige Programme, ausführbare Dateien und Programmparameter E FND Concurrent Programs and Executables Programas concurrentes, ejecutables y parámetros de programa F FND Concurrent Programs and Executables Programmes, exécutables et paramètres de programme simultanés I FND Concurrent Programs and Executables Programmi concorrenti, eseguibili e parametri di programma JA FND Concurrent Programs and Executables 並行プログラム、実行可能ファイル、プログラムパラメータ KO FND Concurrent Programs and Executables 동시 프로그램, 실행 파일 및 프로그램 매개 변수 PTB FND Concurrent Programs and Executables Programas simultâneos, executáveis e parâmetros do programa RU FND Concurrent Programs and Executables Параметры параллельных программ, исполняемых файлов и программ S FND Concurrent Programs and Executables Samtidiga program, körbara filer och programparametrar TR FND Concurrent Programs and Executables Eşzamanlı programlar, çalıştırılabilirler ve program parametreleri US FND Concurrent Programs and Executables Concurrent programs, executables and program parameters ZHS FND Concurrent Programs and Executables 并发程序、可执行文件和程序参数 Enginatics R12 only &column_parameters &show_parameters 1=1 1 10 1=1 upper(fcpv.user_concurrent_program_name) like upper(:user_concurrent_program_name) LOV FND Concurrent Program Name (wildcard) 8E2FF36EDE9179D2E0530100007F1FF2 select fcpt.user_concurrent_program_name value, fav.application_name||nvl2(fcpt.description,': ',null)||fcpt.description description from fnd_application_vl fav, fnd_concurrent_programs_tl fcpt where fcpt.language=userenv('lang') and fcpt.application_id=fav.application_id order by fcpt.user_concurrent_program_name F Nom du programme concomitant comme US Concurrent Program Name like 2 20 1=1 fcpv.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') ) 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) 3 30 1=1 upper(fcpv.concurrent_program_name) like upper(:concurrent_program_name) LOV custom 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 order by fcpv.concurrent_program_name F Programme concomitant Nom court US Concurrent Progr. Short Name like 4 40 1=1 fcpv.enabled_flag=:enabled_flag 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 F Activé US Enabled 5 50 1=1 fcpv.creation_date>=:creation_date_from Date F Date de création du US Creation Date From 6 60 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 F Nom de l'application US Application Name 7 70 1=1 fav.application_short_name=:short_name LOV FND Application Short Name 8E2FF36EDEBE79D2E0530100007F1FF2 Y select fav.application_short_name value, fav.application_name description from fnd_application_vl fav order by fav.application_short_name F Nom court de l'application US Application Short Name 8 80 1=1 fev.user_executable_name=:executable_name LOV custom Y select fev.user_executable_name value, fav.application_name||': '||fev.executable_name description from fnd_application_vl fav, fnd_executables_vl fev where fav.application_id=fev.application_id order by fev.executable_name F Nom de l'exécutable US Executable Name 9 90 1=1 fev.executable_name=:executable_short_name LOV FND Executable Short Name 8E2FF36EDEAD79D2E0530100007F1FF2 Y select fev.executable_name value, fav.application_name||': '||case when fev.description is null and fev.user_executable_name<>fev.executable_name then fev.user_executable_name else fev.description end description from fnd_application_vl fav, fnd_executables_vl fev where fav.application_id=fev.application_id and (:$flex$.FND_Concurrent_Execution_Method is null or xxen_util.contains(:$flex$.FND_Concurrent_Execution_Method,xxen_util.meaning(fev.execution_method_code,'CP_EXECUTION_METHOD_CODE',0))='Y') order by fev.executable_name F Nom court de l'exécutable US Executable Short Name 10 100 1=1 case when fev.description is null and fev.user_executable_name<>fev.executable_name then fev.user_executable_name else fev.description end=:executable_description LOV custom Y select case when fev.description is null and fev.user_executable_name<>fev.executable_name then fev.user_executable_name else fev.description end value, fav.application_name||': '||fev.executable_name description from fnd_application_vl fav, fnd_executables_vl fev where fav.application_id=fev.application_id order by case when fev.description is null and fev.user_executable_name<>fev.executable_name then fev.user_executable_name else fev.description end F Description de l'exécutable US Executable Description 11 110 1=1 fev.execution_method_code=xxen_util.lookup_code(:execution_method,'CP_EXECUTION_METHOD_CODE',0) LOV FND Concurrent Execution Method 8E2FF36EDED979D2E0530100007F1FF2 Y select flvv.meaning value, flvv.lookup_code description from fnd_lookup_values_vl flvv where flvv.lookup_type='CP_EXECUTION_METHOD_CODE' and flvv.view_application_id=0 and flvv.security_group_id=0 order by flvv.meaning F Méthode d'exécution US Execution Method 12 120 1=1 lower(fev.execution_file_name) like lower(:execution_file_name) Char F Nom du fichier d'exécution comme US Execution File Name like 13 130 1=1 fcpv.output_file_type=xxen_util.lookup_code(:output_format,'CP_OUTPUT_FILE_TYPE',0) LOV custom Y select flv.meaning value, flv.lookup_code description from fnd_lookup_values flv where flv.lookup_type='CP_OUTPUT_FILE_TYPE' and flv.language=userenv('lang') and flv.view_application_id=0 and flv.security_group_id=0 order by flv.meaning F Format de sortie US Output Format 14 140 &show_parameters Y LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual F Afficher les paramètres US Show Parameters 15 &column_parameters fdfcuv.column_seq_num parameter_sequence, fdfcuv.end_user_column_name parameter, fdfcuv.form_left_prompt prompt, fdfcuv.description, fdfcuv.srw_param token, ffvs.flex_value_set_name value_set, xxen_report_ebs.oracle_lov_query(ffvs.flex_value_set_id) lov_query, xxen_util.meaning(fdfcuv.default_type,'FLEX_DEFAULT_TYPE',0) default_type, fdfcuv.default_value, xxen_util.yes(fdfcuv.required_flag) required, xxen_util.yes(fdfcuv.display_flag) display, fdfcuv.display_size, ffvs.flex_value_set_id, F Afficher les paramètres US Show Parameters 16 150 1=1 fdfcuv.default_type=xxen_util.lookup_code(:parameter_default_type,'FLEX_DEFAULT_TYPE',0) LOV custom Y select flv.meaning value, flv.lookup_code||' ('||count(*)||')' description from fnd_descr_flex_column_usages fdfcu, fnd_lookup_values flv where fdfcu.descriptive_flexfield_name like '$SRS$.%' and fdfcu.default_type=flv.lookup_code and flv.lookup_type='FLEX_DEFAULT_TYPE' and flv.view_application_id=0 and flv.language=userenv('lang') and flv.security_group_id=0 group by flv.meaning, flv.lookup_code order by count(*) desc F Paramètre Défaut Type US Parameter Default Type 17 &column_parameters fdfcuv.column_seq_num parameter_sequence, fdfcuv.end_user_column_name parameter, fdfcuv.form_left_prompt prompt, fdfcuv.srw_param token, ffvs.flex_value_set_name value_set, xxen_report_ebs.oracle_lov_query(ffvs.flex_value_set_id) lov_query, xxen_util.meaning(fdfcuv.default_type,'FLEX_DEFAULT_TYPE',0) default_type, fdfcuv.default_value, decode(fdfcuv.required_flag,'Y','Yes') required, decode(fdfcuv.display_flag,'Y','Yes') display, F Paramètre Défaut Type US Parameter Default Type 18 &show_parameters Y F Paramètre Défaut Type US Parameter Default Type 19 160 1=1 ( fcpv.concurrent_program_name in ('RGFSGXML','RGRARG','XXEN_REPORT','') or lower(fcpv.user_concurrent_program_name) like '% report' or fev.execution_method_code='P' or fev.executable_name='XDODTEXE' ) and fcpv.user_concurrent_program_name not like 'Transfer %' and fcpv.user_concurrent_program_name not like 'Create %' LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual F Afficher uniquement les rapports US Show Reports only :$flex$.FND_Concurrent_Execution_Method Execution Method Executable Short Name