ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 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 8E2FF36EDE9D79D2E0530100007F1FF2 FND Concurrent Program Name Y 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 AR اسم البرنامج المتزامن FND D FND gleichzeitiger Programmname E Nombre del programa concurrente FND F Nom du programme concurrent du FND I Nome del programma concorrente FND JA FND 同時進行プログラム名 KO FND 동시 작업 프로그램 이름 PTB FND nome do programa concorrente RU одновременное имя программы FND S FND-samtidiga programnamn TR FND eşzamanlı program adı US FND concurrent program name ZHS FND并发程序名称 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 用任何一种安装的语言（不仅仅是登录语言）并发的程序名称。 8E2FF36EDEA179D2E0530100007F1FF2 FND Concurrent Program Short Name 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 order by fcpv.concurrent_program_name US 8E2FF36EDEEF79D2E0530100007F1FF2 FND Concurrent Request Phase Y select flvv.meaning value, flvv.lookup_code description from fnd_lookup_values_vl flvv where flvv.lookup_type='CP_PHASE_CODE' and flvv.view_application_id=0 and flvv.security_group_id=0 order by flvv.lookup_code US A3006C2AC4381FC5E0530100007F3DE6 FND Concurrent Request Status Y select flvv.meaning value, flvv.lookup_code description from fnd_lookup_values_vl flvv where flvv.lookup_code not in ('I','R','Z') and flvv.lookup_type='CP_STATUS_CODE' and flvv.view_application_id=0 and flvv.security_group_id=0 order by flvv.meaning 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 8E2FF36EDEA979D2E0530100007F1FF2 FND Request Set Name Y select frsv.user_request_set_name value, frsv.request_set_name description from fnd_request_sets_vl frsv order by frsv.user_request_set_name US 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. 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 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US 9A9BA03534E60E8EE053BA6B63583A7FY select fcr.request_id id, decode(fcr.priority_request_id,fcr.request_id,null,fcr.priority_request_id) priority_id, decode(fcr.parent_request_id,-1,null,fcr.parent_request_id) parent_id, case when fcr.program_application_id=160 and fcr.concurrent_program_id=20392 /*alecdc*/ or fcr.request_type='M' then fcr.description else fcpt.user_concurrent_program_name end program, case when fcr.request_type='M' and fcr.frr_display_sequence is not null then fcpt.user_concurrent_program_name||' ('||fcr.frr_display_sequence||')' else fcr.description end description, flv2.meaning phase, flv1.meaning status, xxen_util.user_name(fcr.requested_by) user_name, haouv.name operating_unit, frt.responsibility_name responsibility, xxen_util.client_time(fcr.actual_start_date) start_date, xxen_util.client_time(fcr.actual_completion_date) completion_date, xxen_util.time(fcr.seconds) time, fcr.seconds, fcr.argument_text_ parameter_text, &argument_display_values xxen_util.client_time(fcr.requested_start_date) requested_start_date, case when nvl(fcrc.class_type,'P')='P' then case when fcr.resubmit_interval_unit_code in ('DAYS','MONTHS') then to_char(xxen_util.client_time(fcr.requested_start_date),'HH24:MI:SS ')||fcr.resubmit_interval||' '||fcr.resubmit_interval_unit_code||' '||fcr.resubmit_interval_type_code else fcr.resubmit_interval||' '||fcr.resubmit_interval_unit_code||' '||fcr.resubmit_interval_type_code end else to_char(xxen_util.client_time(fcr.requested_start_date),'HH24:MI:SS ') ||decode(substr(fcrc.class_info,1,1),'1',' 1 of month ') ||decode(substr(fcrc.class_info,2,1),'1',' 2 of month ') ||decode(substr(fcrc.class_info,3,1),'1',' 3 of month ') ||decode(substr(fcrc.class_info,4,1),'1',' 4 of month ') ||decode(substr(fcrc.class_info,5,1),'1',' 5 of month ') ||decode(substr(fcrc.class_info,6,1),'1',' 6 of month ') ||decode(substr(fcrc.class_info,7,1),'1',' 7 of month ') ||decode(substr(fcrc.class_info,8,1),'1',' 8 of month ') ||decode(substr(fcrc.class_info,9,1),'1',' 9 of month ') ||decode(substr(fcrc.class_info,10,1),'1','10 of month ') ||decode(substr(fcrc.class_info,11,1),'1','11 of month ') ||decode(substr(fcrc.class_info,12,1),'1','12 of month ') ||decode(substr(fcrc.class_info,13,1),'1','13 of month ') ||decode(substr(fcrc.class_info,14,1),'1','14 of month ') ||decode(substr(fcrc.class_info,15,1),'1','15 of month ') ||decode(substr(fcrc.class_info,16,1),'1','16 of month ') ||decode(substr(fcrc.class_info,17,1),'1','17 of month ') ||decode(substr(fcrc.class_info,18,1),'1','18 of month ') ||decode(substr(fcrc.class_info,19,1),'1','19 of month ') ||decode(substr(fcrc.class_info,20,1),'1','20 of month ') ||decode(substr(fcrc.class_info,21,1),'1','21 of month ') ||decode(substr(fcrc.class_info,22,1),'1','22 of month ') ||decode(substr(fcrc.class_info,23,1),'1','23 of month ') ||decode(substr(fcrc.class_info,24,1),'1','24 of month ') ||decode(substr(fcrc.class_info,25,1),'1','25 of month ') ||decode(substr(fcrc.class_info,26,1),'1','26 of month ') ||decode(substr(fcrc.class_info,27,1),'1','27 of month ') ||decode(substr(fcrc.class_info,28,1),'1','28 of month ') ||decode(substr(fcrc.class_info,29,1),'1','29 of month ') ||decode(substr(fcrc.class_info,30,1),'1','30 of month ') ||decode(substr(fcrc.class_info,31,1),'1','31 of month ') ||decode(substr(fcrc.class_info,32,1),'1','Last day of month ') ||decode(substr(fcrc.class_info,33,1),'1','Sun ') ||decode(substr(fcrc.class_info,34,1),'1','Mon ') ||decode(substr(fcrc.class_info,35,1),'1','Tue ') ||decode(substr(fcrc.class_info,36,1),'1','Wed ') ||decode(substr(fcrc.class_info,37,1),'1','Thu ') ||decode(substr(fcrc.class_info,38,1),'1','Fri ') ||decode(substr(fcrc.class_info,39,1),'1','Sat ') end||decode(fcr.increment_dates,'Y',' - increment dates') schedule, xxen_util.time(fcr.wait_seconds) wait_time, fcr.wait_seconds, xxen_util.time(fcr.non_conflict_wait_seconds) non_conflict_wait_time, fcr.non_conflict_wait_seconds, xxen_util.time(fcr.conflict_wait_seconds) conflict_wait_time, fcr.conflict_wait_seconds, case when fcr.program_application_id=160 and fcr.concurrent_program_id=20392 then 'Alert' else decode(fcr.request_type,'P','Req Set Child Program','S','Req Set Stage','M','Req Set','B','Multi Language Set','C','Multi Language Child Program',decode(fcr.priority_request_id,fcr.request_id,'Standalone','Other Subprogram')) end type, fcp.concurrent_program_name short_name, fev.executable_name executable_short_name, flv3.meaning method, fev.execution_file_name, 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, fcd.cd_name, fcd.user_cd_name, gs.sql_id, &sql_text_column gs.event, gse.user_io_time, gse.network_time, gse.system_io_time, gse.configuration_time, gse.application_time, gse.commit_time, gse.concurrency_time, gse.other_time, &delivery_cols fcr.output_file_type, fcr.outfile_name, fcr.ofile_size outfile_size, fcr.logfile_name, fcr.lfile_size logfile_size, fcr.temp_out, fcr.temp_log, fcr.conc_manager, fcr.node, fcr.os_process_manager, fcr.os_process_id os_process_apps, fcr.oracle_process_id os_process_db, fcr.instance_number, fcr.audsid, gs.sid, gs.serial#, case when fcr.program_application_id=160 and fcr.concurrent_program_id=20392 or fcr.request_type='M' then to_number(fcr.argument1) else fcr.program_application_id end app_id, case when fcr.program_application_id=160 and fcr.concurrent_program_id=20392 or fcr.request_type='M' then to_number(fcr.argument2) else fcr.concurrent_program_id end prog_id from ( select fcr.*, ( select fpov.profile_option_value from fnd_profile_option_values fpov where fcr.responsibility_application_id=fpov.level_value_application_id and fcr.responsibility_id=fpov.level_value and fpov.level_value2 is null and fpov.application_id=0 and fpov.profile_option_id=1991 and fpov.level_id=10003 ) org_id_, 86400*greatest(0,nvl(fcr.actual_completion_date,sysdate)-fcr.actual_start_date) seconds, 86400*greatest(0,nvl(fcr.actual_start_date,case when fcr.requested_start_date<sysdate and fcr.phase_code='P' and fcr.hold_flag='N' then sysdate end)-greatest(fcr.request_date,fcr.requested_start_date)) wait_seconds, 86400*greatest(0,nvl(fcr.actual_start_date,case when fcr.requested_start_date<sysdate and fcr.phase_code='P' and fcr.hold_flag='N' then sysdate end)-nvl(nvl(fcr.crm_release_date,case when fcr.requested_start_date<sysdate and fcr.phase_code='P' and fcr.hold_flag='N' and fcr.status_code='Q' and fcr.crm_tstmp is not null then sysdate end),greatest(fcr.request_date,fcr.requested_start_date))) non_conflict_wait_seconds, 86400*greatest(0,nvl(fcr.crm_release_date,case when fcr.requested_start_date<sysdate and fcr.phase_code='P' and fcr.hold_flag='N' and fcr.status_code='Q' and fcr.crm_tstmp is not null then sysdate end)-greatest(fcr.request_date,fcr.requested_start_date)) conflict_wait_seconds, fcpr.plsql_dir||nvl2(fcpr.plsql_out,'/','')||fcpr.plsql_out temp_out, fcpr.plsql_dir||nvl2(fcpr.plsql_log,'/','')||fcpr.plsql_log temp_log, fcqv.user_concurrent_queue_name conc_manager, fcqv.target_node node, fcpr.os_process_id os_process_manager, case when fcr.phase_code='R' and fcr.status_code='R' then fcpr.instance_number end instance_number, case when fcr.phase_code='R' and fcr.status_code='R' then fcr.oracle_session_id end audsid, frr.display_sequence frr_display_sequence, nvl(frr.application_id,fcr.program_application_id) program_application_id_, nvl(frr.concurrent_program_id,fcr.concurrent_program_id) concurrent_program_id_, case when fcr.request_type='M' and frr.parent_request_id is not null then rtrim( replace( frr.argument1||','|| frr.argument2||','|| frr.argument3||','|| frr.argument4||','|| frr.argument5||','|| frr.argument6||','|| frr.argument7||','|| frr.argument8||','|| frr.argument9||','|| frr.argument10||','|| frr.argument11||','|| frr.argument12||','|| frr.argument13||','|| frr.argument14||','|| frr.argument15||','|| frr.argument16||','|| frr.argument17||','|| frr.argument18||','|| frr.argument19||','|| frr.argument20||','|| frr.argument21||','|| frr.argument22||','|| frr.argument23||','|| frr.argument24||','|| frr.argument25||','|| frr.argument26||','|| frr.argument27||','|| frr.argument28||','|| frr.argument29||','|| frr.argument30||','|| frr.argument31||','|| frr.argument32||','|| frr.argument33||','|| frr.argument34||','|| frr.argument35||','|| frr.argument36||','|| frr.argument37||','|| frr.argument38||','|| frr.argument39||','|| frr.argument40||','|| frr.argument41||','|| frr.argument42||','|| frr.argument43||','|| frr.argument44||','|| frr.argument45||','|| frr.argument46||','|| frr.argument47||','|| frr.argument48||','|| frr.argument49||','|| frr.argument50||','|| frr.argument51||','|| frr.argument52||','|| frr.argument53||','|| frr.argument54||','|| frr.argument55||','|| frr.argument56||','|| frr.argument57||','|| frr.argument58||','|| frr.argument59||','|| frr.argument60||','|| frr.argument61||','|| frr.argument62||','|| frr.argument63||','|| frr.argument64||','|| frr.argument65||','|| frr.argument66||','|| frr.argument67||','|| frr.argument68||','|| frr.argument69||','|| frr.argument70||','|| frr.argument71||','|| frr.argument72||','|| frr.argument73||','|| frr.argument74||','|| frr.argument75||','|| frr.argument76||','|| frr.argument77||','|| frr.argument78||','|| frr.argument79||','|| frr.argument80||','|| frr.argument81||','|| frr.argument82||','|| frr.argument83||','|| frr.argument84||','|| frr.argument85||','|| frr.argument86||','|| frr.argument87||','|| frr.argument88||','|| frr.argument89||','|| frr.argument90||','|| frr.argument91||','|| frr.argument92||','|| frr.argument93||','|| frr.argument94||','|| frr.argument95||','|| frr.argument96||','|| frr.argument97||','|| frr.argument98||','|| frr.argument99||','|| frr.argument100, chr(0)), ',') else fcr.argument_text end argument_text_, fcr.rowid row_id from fnd_concurrent_requests fcr, fnd_concurrent_processes fcpr, fnd_concurrent_queues_vl fcqv, ( select frss.display_sequence, frr.* from fnd_run_requests frr, fnd_request_set_programs frsp, fnd_request_set_stages frss where frr.set_application_id=frsp.set_application_id and frr.request_set_id=frsp.request_set_id and frr.request_set_program_id=frsp.request_set_program_id and frsp.set_application_id=frss.set_application_id and frsp.request_set_id=frss.request_set_id and frsp.request_set_stage_id=frss.request_set_stage_id and not exists (select null from fnd_concurrent_requests fcr2 where frr.parent_request_id=fcr2.parent_request_id and fcr2.request_type='S' and fcr2.program_application_id=0 and fcr2.concurrent_program_id=36034) ) frr where 1=1 and fcr.controlling_manager=fcpr.concurrent_process_id(+) and fcpr.queue_application_id=fcqv.application_id(+) and fcpr.concurrent_queue_id=fcqv.concurrent_queue_id(+) and case when fcr.request_type in ('B','M') then fcr.request_id end=frr.parent_request_id(+) ) fcr, fnd_concurrent_programs fcp, fnd_concurrent_programs_tl fcpt, fnd_executables_vl fev, fnd_responsibility_tl frt, fnd_conc_release_classes fcrc, hr_all_organization_units_vl haouv, fnd_conflicts_domain fcd, (select x.* from (select min(fcpa.sequence) over (partition by fcpa.concurrent_request_id,fcpa.action_type) min_sequence, fcpa.* from fnd_conc_pp_actions fcpa where '&show_delivery'='Y' and fcpa.action_type=1 and fcpa.number_of_copies>0) x where x.sequence=x.min_sequence) fcpa1, (select x.* from (select min(fcpa.sequence) over (partition by fcpa.concurrent_request_id,fcpa.action_type) min_sequence, fcpa.* from fnd_conc_pp_actions fcpa where '&show_delivery'='Y' and fcpa.action_type=2) x where x.sequence=x.min_sequence) fcpa2, (select x.* from (select min(fcpa.sequence) over (partition by fcpa.concurrent_request_id,fcpa.action_type) min_sequence, fcpa.* from fnd_conc_pp_actions fcpa where '&show_delivery'='Y' and fcpa.action_type=6) x where x.sequence=x.min_sequence) fcpa6, (select x.* from (select min(fcpa.sequence) over (partition by fcpa.concurrent_request_id,fcpa.action_type) min_sequence, fcpa.* from fnd_conc_pp_actions fcpa where '&show_delivery'='Y' and fcpa.action_type=7 and fcpa.argument1 in ('T','S')) x where x.sequence=x.min_sequence) fcpa7t, (select x.* from (select min(fcpa.sequence) over (partition by fcpa.concurrent_request_id,fcpa.action_type) min_sequence, fcpa.* from fnd_conc_pp_actions fcpa where '&show_delivery'='Y' and fcpa.action_type=7 and fcpa.argument1='E') x where x.sequence=x.min_sequence) fcpa7e, (select x.* from (select min(fcpa.sequence) over (partition by fcpa.concurrent_request_id,fcpa.action_type) min_sequence, fcpa.* from fnd_conc_pp_actions fcpa where '&show_delivery'='Y' and fcpa.action_type=7 and fcpa.argument1='W') x where x.sequence=x.min_sequence) fcpa7w, (select x.* from (select min(fcpa.sequence) over (partition by fcpa.concurrent_request_id,fcpa.action_type) min_sequence, fcpa.* from fnd_conc_pp_actions fcpa where '&show_delivery'='Y' and fcpa.action_type=7 and fcpa.argument1='C') x where x.sequence=x.min_sequence) fcpa7c, (select x.* from (select min(fcro.output_id) over (partition by fcro.concurrent_request_id) min_output_id, fcro.* from fnd_conc_req_outputs fcro where '&show_delivery'='Y') x where x.output_id=x.min_output_id) fcro, fnd_lookup_values flv1, fnd_lookup_values flv2, fnd_lookup_values flv3, gv$session gs, ( select * from ( select gse.inst_id, gse.sid, round(gse.time_waited_micro/1000000,2) time, gse.wait_class from gv$session_event gse ) x pivot (sum(x.time) time for wait_class in ('User I/O' user_io, 'Network' network, 'System I/O' system_io, 'Configuration' configuration, 'Application' application, 'Commit' commit, 'Concurrency' concurrency, 'Other' other)) ) gse, (select gsa.* from gv$sql gsa where '&show_sql_text'='Y') gsa where 2=2 and fcr.program_application_id_=fcp.application_id(+) and fcr.concurrent_program_id_=fcp.concurrent_program_id(+) and fcr.program_application_id_=fcpt.application_id(+) and fcr.concurrent_program_id_=fcpt.concurrent_program_id(+) and fcpt.language(+)=userenv('lang') and fcp.executable_application_id=fev.application_id(+) and fcp.executable_id=fev.executable_id(+) and fcr.responsibility_application_id=frt.application_id(+) and fcr.responsibility_id=frt.responsibility_id(+) and frt.language(+)=userenv('lang') and fcr.release_class_app_id=fcrc.application_id(+) and fcr.release_class_id=fcrc.release_class_id(+) and fcr.org_id_=haouv.organization_id(+) and fcr.cd_id=fcd.cd_id(+) and fcr.request_id=fcpa1.concurrent_request_id(+) and fcr.request_id=fcpa2.concurrent_request_id(+) and fcr.request_id=fcpa6.concurrent_request_id(+) and fcr.request_id=fcpa7t.concurrent_request_id(+) and fcr.request_id=fcpa7e.concurrent_request_id(+) and fcr.request_id=fcpa7w.concurrent_request_id(+) and fcr.request_id=fcpa7c.concurrent_request_id(+) and fcr.request_id=fcro.concurrent_request_id(+) and decode(fcr.phase_code, 'P',decode(fcr.hold_flag,'Y','H',decode(fcp.enabled_flag,'N','U',case when fcr.requested_start_date>sysdate then 'P' else fcr.status_code end)), 'R',decode(fcr.hold_flag,'Y','S',decode(fcr.status_code,'Q','B','I','B',fcr.status_code)), fcr.status_code)=flv1.lookup_code and case when flv1.lookup_code in ('H','S','U','M') then 'I' else fcr.phase_code end=flv2.lookup_code and fev.execution_method_code=flv3.lookup_code(+) and flv1.lookup_type(+)='CP_STATUS_CODE' and flv2.lookup_type(+)='CP_PHASE_CODE' and flv3.lookup_type(+)='CP_EXECUTION_METHOD_CODE' and flv1.language(+)=userenv('lang') and flv2.language(+)=userenv('lang') and flv3.language(+)=userenv('lang') and flv1.view_application_id(+)=0 and flv2.view_application_id(+)=0 and flv3.view_application_id(+)=0 and flv1.security_group_id(+)=0 and flv2.security_group_id(+)=0 and flv3.security_group_id(+)=0 and fcr.instance_number=gs.inst_id(+) and fcr.audsid=gs.audsid(+) and gs.inst_id=gse.inst_id(+) and gs.sid=gse.sid(+) and gs.inst_id=gsa.inst_id(+) and gs.sql_id=gsa.sql_id(+) and gs.sql_child_number=gsa.child_number(+) order by decode(flv2.lookup_code,'R',1,'P',2,'I',3,'C',4), nvl(fcr.actual_start_date,fcr.requested_start_date) desc, fcr.request_id desc, fcr.frr_display_sequence desc, xxen_util.user_name(fcr.requested_by), fcpt.user_concurrent_program_name, frt.responsibility_name Renamed &enable_ lexicals to &show_ 49A8B1A803A508ACE0530100007FEB91 US FND Concurrent Requests 11i Running, scheduled and historic concurrent requests including phase, status, parameters, schedule, timing, delivery and output option information. For performance analysis of running requests, the report contains sid, currently executed sql_id and sql_text and distribution of wait time on different wait classes. Use parameter 'Scheduled or Running' to get a list of all currently scheduled or running requests. Enginatics &argument_display_values &delivery_cols &show_delivery &show_sql_text &sql_text_column 1=1 2=2 1 10 1=1 (fcr.concurrent_program_id,fcr.program_application_id) in ( select fcpt0.concurrent_program_id,fcpt0.application_id from fnd_concurrent_programs_tl fcpt0 where upper(fcpt0.user_concurrent_program_name) like upper(:user_concurrent_program_name) and fcpt0.language=userenv('lang') ) LOV FND Concurrent Program Name 8E2FF36EDE9D79D2E0530100007F1FF2 Y 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 US Concurrent Program Name 2 20 1=1 (fcr.concurrent_program_id,fcr.program_application_id) in ( select fcpt0.concurrent_program_id,fcpt0.application_id from fnd_concurrent_programs_tl fcpt0 where fcpt0.user_concurrent_program_name=:user_conc_name_all_languages ) 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 (fcr.concurrent_program_id,fcr.program_application_id) in (select fcp0.concurrent_program_id,fcp0.application_id from fnd_concurrent_programs fcp0 where fcp0.concurrent_program_name like :concurrent_program_name) LOV FND Concurrent Program Short Name 8E2FF36EDEA179D2E0530100007F1FF2 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 order by fcpv.concurrent_program_name F Programme concomitant Nom court US Concurrent Program Short Name 4 40 1=1 (fcr.priority_request_id=:request_id or fcr.request_id=:request_id) Number F Id de la demande US Request Id 5 50 1=1 fcr.requested_by=xxen_util.user_id(:requested_by) 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 select fu.user_name from fnd_user fu where fu.user_id=fnd_global.user_id and :$flex$.request_id is null and :$flex$.concurrent_program_name is null and :$flex$.concurrent_progr_all_languages is null and :$flex$.concurrent_program_short_name is null and :$flex$.scheduled_or_running is null and :$flex$.waiting_for_x_minutes is null and :$flex$.running_longer_than_x_minutes is null and :$flex$.phase is null and :$flex$.status is null and :$flex$.parameter_text_contains is null and :$flex$.request_set_name is null and :$flex$.execution_method is null and :$flex$.executable_short_name is null and :$flex$.running_from_timestamp is null and :$flex$.running_to_timestamp is null and :$flex$.requested_start_date_from is null and :$flex$.requested_start_date_to is null and :$flex$.node is null and :$flex$.manager_name is null and :$flex$.operating_unit is null and :$flex$.exclude_conc_program_name is null and :$flex$.incremental_alert_mode is null F Demandé par US Requested By 6 60 1=1 ( fcr.actual_start_date>sysdate-:days or fcr.actual_start_date is null and fcr.requested_start_date>sysdate-:days and fcr.requested_start_date<sysdate and fcr.phase_code='P' and fcr.hold_flag='N' ) Number select 7 from dual where :$flex$.request_id is null and :$flex$.concurrent_program_name is null and :$flex$.concurrent_progr_all_languages is null and :$flex$.concurrent_program_short_name is null and :$flex$.scheduled_or_running is null and :$flex$.waiting_for_x_minutes is null and :$flex$.running_longer_than_x_minutes is null and :$flex$.phase is null and :$flex$.status is null and :$flex$.parameter_text_contains is null and :$flex$.request_set_name is null and :$flex$.execution_method is null and :$flex$.executable_short_name is null and :$flex$.running_from_timestamp is null and :$flex$.running_to_timestamp is null and :$flex$.requested_start_date_from is null and :$flex$.requested_start_date_to is null and :$flex$.node is null and :$flex$.manager_name is null and :$flex$.operating_unit is null and :$flex$.exclude_conc_program_name is null and :$flex$.incremental_alert_mode is null F Commencé en quelques jours US Started within Days 7 70 1=1 (fcr.phase_code='P' and fcr.hold_flag='N' or fcr.phase_code='R') LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual F Planifié ou en cours Sélectionnez Oui pour obtenir une liste de toutes les demandes actuellement programmées ou en cours US Scheduled or Running Set this to Yes to get a list of all currently scheduled or running requests 8 80 1=1 (nvl(fcr.actual_start_date,case when fcr.requested_start_date<sysdate and fcr.phase_code='P' and fcr.hold_flag='N' then sysdate end)-fcr.requested_start_date)*1440>=:waiting_minutes Number F Attente de x minutes US Waiting for x Minutes 9 90 1=1 (fcr.actual_completion_date-fcr.actual_start_date)*24*60>:minutes Number F Courir plus de x minutes US Running longer than x Minutes 10 100 2=2 fcr.phase_code=xxen_util.lookup_code(:phase,'CP_PHASE_CODE',0) LOV FND Concurrent Request Phase 8E2FF36EDEEF79D2E0530100007F1FF2 Y select flvv.meaning value, flvv.lookup_code description from fnd_lookup_values_vl flvv where flvv.lookup_type='CP_PHASE_CODE' and flvv.view_application_id=0 and flvv.security_group_id=0 order by flvv.lookup_code US Phase 11 2=2 (fcr.phase_code='I' or fcr.status_code in ('H','S','U','M') or fcr.phase_code in ('P','R') and fcr.hold_flag='Y' or fcr.phase_code='P' and fcp.enabled_flag='N') xxen_util.meaning('I','CP_PHASE_CODE',0) US Phase 12 110 2=2 fcr.status_code=decode(:status,xxen_util.meaning('C','CP_STATUS_CODE',0),'R',xxen_util.lookup_code(:status,'CP_STATUS_CODE',0)) LOV FND Concurrent Request Status A3006C2AC4381FC5E0530100007F3DE6 Y select flvv.meaning value, flvv.lookup_code description from fnd_lookup_values_vl flvv where flvv.lookup_code not in ('I','R','Z') and flvv.lookup_type='CP_STATUS_CODE' and flvv.view_application_id=0 and flvv.security_group_id=0 order by flvv.meaning F Statut US Status 13 2=2 (fcr.status_code='B' or fcr.phase_code='R' and fcr.hold_flag<>'Y' and fcr.status_code in ('Q','I')) xxen_util.meaning('B','CP_STATUS_CODE',0) F Statut US Status 14 2=2 (fcr.status_code='H' or fcr.phase_code='P' and fcr.hold_flag='Y') xxen_util.meaning('H','CP_STATUS_CODE',0) F Statut US Status 15 2=2 (fcr.status_code='P' or fcr.phase_code='P' and fcr.hold_flag='N' and fcp.enabled_flag='Y' and fcr.requested_start_date>sysdate) xxen_util.meaning('P','CP_STATUS_CODE',0) F Statut US Status 16 2=2 (fcr.status_code='S' or fcr.phase_code='R' and fcr.hold_flag='Y') xxen_util.meaning('S','CP_STATUS_CODE',0) F Statut US Status 17 2=2 (fcr.status_code='U' or fcr.phase_code='P' and fcr.hold_flag='N' and fcp.enabled_flag='N') xxen_util.meaning('U','CP_STATUS_CODE',0) F Statut US Status 18 120 &argument_display_values xxen_api.display_request_param_values(fcr.row_id,chr(10)) parameter_display_values, LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Y F Afficher les paramètres Afficher les valeurs Affiche les noms des paramètres et les valeurs d'affichage traduites des valeurs des paramètres de la requête. Veuillez noter qu'un réglage sur "Oui" pourrait ralentir considérablement l'exécution du rapport. US Show Parameters Display Values Shows parameter names and translated display values of request's parameter values. Please note that a setting to 'Yes' could slow down report execution significantly. 19 130 &show_delivery Y LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US Show BI Pub & Delivery Options Shows BI publisher and delivery options information such as the publisher template and output file, postprocessor result, delivery email or ftp information 20 &delivery_cols substr(fcpa1.arguments,1,30) printer, fcpa1.number_of_copies copies, substr(fcpa2.arguments,1,100) notify_name, fnd_conc_request_pkg.role_info (fcpa2.arguments,fcpa2.orig_system,fcpa2.orig_system_id) notify_display_name, fcpa2.orig_system notify_orig_sys, (select xtv.template_name from xdo_templates_vl xtv where fcpa6.argument1=xtv.application_short_name and fcpa6.argument2=xtv.template_code) publisher_template, fcpa6.argument5 publisher_output_format, fcro.file_name publisher_file_name, fcpa6.publisher_return_results, fcpa7p.delivery_name ipp_printer, fcpa7p.argument5 ipp_username, fcpa7p.argument6 ipp_password, fcpa7p.argument3 ipp_copies, decode(fcpa7p.argument4,'3','Portrait','4','Landscape') ipp_orientation, fcpa7e.argument3 email_from, fcpa7e.argument2 email_subject, fcpa7e.argument4 email_to, fcpa7e.argument5 email_cc, fcpa7e.publisher_return_results email_result, fcpa7f.delivery_name fax_server, fcpa7f.argument4 fax_username, fcpa7f.argument5 fax_password, fcpa7f.argument3 fax_number, fcpa7t.argument2 ftp_host, fcpa7t.argument6 ftp_port, fcpa7t.argument3 ftp_username, fcpa7t.argument4 ftp_password, fcpa7t.argument5 ftp_remote_dir, decode(fcpa7t.argument1,'T','N','S','Y') ftp_secure, fcpa7t.publisher_return_results ftp_result, fcpa7w.argument2 webd_host, fcpa7w.argument3 webd_remote_dir, fcpa7w.argument4 webd_port, fcpa7w.argument8 webd_encode, fcpa7w.argument7 webd_auth, fcpa7w.argument5 webd_username, fcpa7w.argument6 webd_password, fcpa7w.publisher_return_results webd_result, fcpa7c.argument2 custom_command, US Show BI Pub & Delivery Options 21 140 &show_sql_text Y LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual F Afficher la session active Texte SQL US Show active session SQL Text 22 &sql_text_column gsa.sql_fulltext, F Afficher la session active Texte SQL US Show active session SQL Text 23 150 1=1 lower(fcr.argument_text) like '%'||lower(:argument_text)||'%' Char F Le texte du paramètre contient US Parameter Text contains 24 160 1=1 fcr.description=:user_request_set_name and (fcr.concurrent_program_id,fcr.program_application_id) in ( select fcp0.concurrent_program_id,fcp0.application_id from fnd_concurrent_programs fcp0, fnd_executables fe0 where fcp0.executable_application_id=fe0.application_id and fcp0.executable_id=fe0.executable_id and fe0.executable_name='FNDRSSUB' ) LOV FND Request Set Name 8E2FF36EDEA979D2E0530100007F1FF2 Y select frsv.user_request_set_name value, frsv.request_set_name description from fnd_request_sets_vl frsv order by frsv.user_request_set_name F Nom de l'ensemble de la demande US Request Set Name 25 170 2=2 (fcr.concurrent_program_id,fcr.program_application_id) in ( select fcp.concurrent_program_id,fcp.application_id from fnd_executables fe, fnd_concurrent_programs fcp where fe.execution_method_code=xxen_util.lookup_code(:execution_method,'CP_EXECUTION_METHOD_CODE',0) and fe.application_id=fcp.executable_application_id and fe.executable_id=fcp.executable_id ) 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 26 180 1=1 (fcr.concurrent_program_id,fcr.program_application_id) in ( select fcp0.concurrent_program_id, fcp0.application_id from fnd_executables fe, fnd_concurrent_programs fcp0 where fe.executable_name=:executable_name and fe.application_id=fcp0.executable_application_id and fe.executable_id=fcp0.executable_id ) 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 27 190 1=1 (fcr.actual_completion_date>=:from_timestamp or fcr.phase_code='R' and fcr.actual_completion_date is null) DateTime F Exécution à partir de l'horodatage Affiche toutes les demandes qui ont été effectuées à une heure précise US Running from Timestamp Shows all requests that ran at a specific timestamp 28 200 1=1 fcr.actual_start_date<=:to_timestamp DateTime :$flex$.Running_from_Timestamp F Exécution de l'horodatage Affiche toutes les demandes qui ont été effectuées à une heure précise US Running to Timestamp Shows all requests that ran at a specific timestamp 29 210 1=1 fcr.requested_start_date>=:requested_start_date_from DateTime F Date de début demandée de US Requested Start Date From 30 220 1=1 fcr.requested_start_date<=:requested_start_date_to DateTime F Date de début demandée jusqu'au US Requested Start Date To 31 230 1=1 fcqv.target_node=:node LOV custom Y select fn.node_name value, fn.host||'.'||fn.domain||'('||fn.server_address||')' description from fnd_nodes fn where fn.support_cp='Y' order by fn.node_name F Nœud US Node 32 240 1=1 fcqv.user_concurrent_queue_name=:conc_manager LOV custom Y select fcqt.user_concurrent_queue_name value, fav.application_name||' - '||fcqt.concurrent_queue_name||nvl2(fcqt.description,': '||fcqt.description,null) description from fnd_concurrent_queues_tl fcqt, fnd_application_vl fav where fcqt.language=userenv('lang') and fcqt.application_id=fav.application_id order by fcqt.user_concurrent_queue_name F Nom du gestionnaire US Manager Name 33 250 2=2 haouv.name=: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 Unité d'exploitation US Operating Unit 34 260 1=1 (fcr.concurrent_program_id,fcr.program_application_id) not in ( select fcpt0.concurrent_program_id,fcpt0.application_id from fnd_concurrent_programs_tl fcpt0 where fcpt0.user_concurrent_program_name=:exclude_user_conc_program_name and fcpt0.language=userenv('lang') ) LOV FND Concurrent Program Name 8E2FF36EDE9D79D2E0530100007F1FF2 Y 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 Exclure le nom du programme Conc US Exclude Conc Program Name 35 270 1=1 fcr.actual_completion_date>= ( select fcr0.actual_start_date from fnd_concurrent_requests fcr, fnd_concurrent_requests fcr0 where fcr.request_id=fnd_global.conc_request_id and fcr.parent_request_id=fcr0.request_id ) LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual F Mode d'alerte incrémentielle Afficher uniquement les demandes depuis le dernier rapport prévu US Incremental Alert Mode Only show requests since the last scheduled report run :$flex$.FND_Concurrent_Execution_Method Execution Method Executable Short Name :$flex$.Running_from_Timestamp Running from Timestamp Y Running to Timestamp :$flex$.concurrent_progr_all_languages Concurrent Progr. (all languages) Requested By :$flex$.concurrent_progr_all_languages Concurrent Progr. (all languages) Started within Days :$flex$.concurrent_program_name Concurrent Program Name Requested By :$flex$.concurrent_program_name Concurrent Program Name Started within Days :$flex$.concurrent_program_short_name Concurrent Program Short Name Requested By :$flex$.concurrent_program_short_name Concurrent Program Short Name Started within Days :$flex$.exclude_conc_program_name Exclude Conc Program Name Requested By :$flex$.exclude_conc_program_name Exclude Conc Program Name Started within Days :$flex$.executable_short_name Executable Short Name Requested By :$flex$.executable_short_name Executable Short Name Started within Days :$flex$.execution_method Execution Method Requested By :$flex$.execution_method Execution Method Started within Days :$flex$.incremental_alert_mode Incremental Alert Mode Requested By :$flex$.incremental_alert_mode Incremental Alert Mode Started within Days :$flex$.manager_name Manager Name Requested By :$flex$.manager_name Manager Name Started within Days :$flex$.node Node Requested By :$flex$.node Node Started within Days :$flex$.operating_unit Operating Unit Requested By :$flex$.operating_unit Operating Unit Started within Days :$flex$.parameter_text_contains Parameter Text contains Requested By :$flex$.parameter_text_contains Parameter Text contains Started within Days :$flex$.phase Phase Requested By :$flex$.phase Phase Started within Days :$flex$.request_id Request Id Requested By :$flex$.request_id Request Id Started within Days :$flex$.request_set_name Request Set Name Requested By :$flex$.request_set_name Request Set Name Started within Days :$flex$.requested_start_date_from Requested Start Date From Y Requested By :$flex$.requested_start_date_from Requested Start Date From Y Started within Days :$flex$.requested_start_date_to Requested Start Date To Y Requested By :$flex$.requested_start_date_to Requested Start Date To Y Started within Days :$flex$.running_from_timestamp Running from Timestamp Y Requested By :$flex$.running_from_timestamp Running from Timestamp Y Started within Days :$flex$.running_longer_than_x_minutes Running longer than x Minutes Requested By :$flex$.running_longer_than_x_minutes Running longer than x Minutes Started within Days :$flex$.running_to_timestamp Running to Timestamp Y Requested By :$flex$.running_to_timestamp Running to Timestamp Y Started within Days :$flex$.scheduled_or_running Scheduled or Running Requested By :$flex$.scheduled_or_running Scheduled or Running Started within Days :$flex$.status Status Requested By :$flex$.status Status Started within Days :$flex$.waiting_for_x_minutes Waiting for x Minutes Requested By :$flex$.waiting_for_x_minutes Waiting for x Minutes Started within Days