ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDF1179D2E0530100007F1FF2 DIS Business Area Y select eb.ba_name value, eb.ba_description description from eul_us.eul5_bas eb order by eb.ba_name AR منطقة أعمال Discoverer D Geschäftsfeld Discoverer E Área de negocio Discoverer F Espace entreprises Discoverer I Area di business Discoverer JA ディスカバリーの営業エリア KO Discoverer 사업 영역 PTB Área de negócios do Discoverer RU Первооткрывательское направление деятельности S Discoverer affärsområde TR Discoverer iş alanı US Discoverer business area ZHS 发现者商业区 8E2FF36EDF3879D2E0530100007F1FF2 DIS End User Layer Y select lower(do.owner) value, do.created description from dba_objects do where do.object_type='TABLE' and do.object_name='EUL5_VERSIONS' order by do.created desc AR طبقة المستخدم النهائي للمكتشف D Entdecker-Endbenutzerschicht E Capa de usuario final de Discoverer F Couche utilisateur final Discoverer I Livello utente finale Discoverer JA 発見者エンドユーザー層 KO Discoverer 최종 사용자 계층 PTB Camada do usuário final do Discoverer RU Уровень конечного пользователя S Discoverer-slutanvändarlager TR Discoverer son kullanıcı katmanı US Discoverer end user layer ZHS 发现者终端用户层 8E2FF36EDEE079D2E0530100007F1FF2 DIS Folder Y select eo.obj_name value, nvl(eo.sobj_ext_table,eo.obj_developer_key)||nvl2(eo.obj_description,' ('||eo.obj_description||')',null) description from eul_us.eul5_objs eo order by eo.obj_name AR مجلد Discoverer D Entdecker-Ordner E Carpeta Discoverer F Dossier Discoverer I Cartella Discoverer JA 発見者フォルダ KO Discoverer 폴더 PTB Pasta do descobridor RU Папка первооткрывателя S Discoverer-mapp TR Discoverer klasörü US Discoverer folder ZHS 发现者文件夹 8E2FF36EDF3179D2E0530100007F1FF2 DIS View Name Y select distinct eo.sobj_ext_table value, max(eo.obj_name) over (partition by eo.sobj_ext_table) description from eul_us.eul5_objs eo where eo.sobj_ext_table is not null order by eo.sobj_ext_table AR اسم عرض المجلد القياسي لـ Discoverer D Name der Discoverer-Standardordneransicht E Nombre de la vista de la carpeta estándar de Discoverer F Nom de la vue standard du dossier Discoverer I Nome della vista cartella standard Discoverer JA ディスカバーラー標準のフォルダ ビュー名 KO Discoverer 표준 폴더보기 이름 PTB Nome da pasta de visualização padrão do Discoverer RU Отключить стандартное имя просмотра папок S Discoverer standard mappvy namn TR Discoverer standart klasör görünümü adı US Discoverer standard folder view name ZHS 发现者标准文件夹视图名称 8E2FF36EDF2079D2E0530100007F1FF2 DIS Workbook Y select ed.doc_name value, ed.doc_description||' ('||ed.doc_developer_key||')' description from eul_us.eul5_documents ed order by ed.doc_name AR مصنف Discoverer D Entdecker-Arbeitsmappe E Cuaderno de trabajo Discoverer F Manuel du découvreur I Libro di lavoro Discoverer JA ディスカバラーワークブック KO Discoverer 워크 북 PTB Livro de exercícios do descobridor RU рабочая тетрадь первооткрывателя S Discoverer-arbetsbok TR Discoverer çalışma kitabı US Discoverer workbook ZHS 发现者工作手册 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. 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US B243189456DD2E8EE0530100007F249D select y.month, y.user_count, (select count(distinct eqs2.qs_created_by) from &eul.eul5_qpp_stats eqs2 where eqs2.qs_created_date>=y.month-60 and eqs2.qs_created_date<y.month) user_count_60_days, &qs_created_by y.execution_count, y.workbook_count, y.sheet_count, y.use_key_count, y."1 Folder Count", y."2 Folder Count", y."3 Folder Count", y."4 Folder Count", y."5 Folder Count", y.">5 Folder Count" from ( select distinct x.month, count(distinct x.qs_created_by) over (partition by x.month) user_count, &qs_created_by count(*) over (partition by &qs_created_by x.month) execution_count, count(distinct x.workbook_owner||x.workbook) over (partition by &qs_created_by x.month) workbook_count, count(distinct x.workbook_owner||x.workbook||x.sheet) over (partition by &qs_created_by x.month) sheet_count, count(distinct x.use_key) over (partition by &qs_created_by x.month) use_key_count, count(distinct decode(x.folder_count,1,x.use_key)) over (partition by &qs_created_by x.month) "1 Folder Count", count(distinct decode(x.folder_count,2,x.use_key)) over (partition by &qs_created_by x.month) "2 Folder Count", count(distinct decode(x.folder_count,3,x.use_key)) over (partition by &qs_created_by x.month) "3 Folder Count", count(distinct decode(x.folder_count,4,x.use_key)) over (partition by &qs_created_by x.month) "4 Folder Count", count(distinct decode(x.folder_count,5,x.use_key)) over (partition by &qs_created_by x.month) "5 Folder Count", count(distinct case when x.folder_count>5 then x.use_key end) over (partition by &qs_created_by x.month) ">5 Folder Count" from ( select eqs.qs_id id, eqs.qs_created_by, upper(eqs.qs_doc_owner) workbook_owner, eqs.qs_doc_name workbook, eqs.qs_doc_details sheet, trunc(eqs.qs_created_date,'month') month, eqs.qs_created_date, length(eqs.qs_object_use_key)-length(translate(eqs.qs_object_use_key,'x.','x'))+1 folder_count, eqs.qs_object_use_key use_key from &eul.eul5_qpp_stats eqs where 1=1 ) x ) y order by y.month desc, y.execution_count desc, y.workbook_count desc Y AR DIS Worksheet Execution Summary ملخص إحصائي للوصول إلى ورقة عمل Discoverer من الجدول eul5_qpp_stats لإظهار عدد مستخدمي Discoverer النشطين وعدد المصنفات وأوراق العمل المختلفة التي تم تنفيذها وعدد المجلدات المختلفة (المجموعات) التي تستند إليها. D DIS Worksheet Execution Summary Zusammenfassung der Discoverer-Arbeitsblatt-Zugriffsstatistik aus der Tabelle eul5_qpp_stats, um die Anzahl der aktiven Discoverer-Benutzer, die Anzahl der verschiedenen ausgeführten Arbeitsmappen und Arbeitsblätter und die Anzahl der verschiedenen Ordner (Kombinationen), auf denen diese basieren, anzuzeigen. E DIS Worksheet Execution Summary Resumen estadístico de acceso a la hoja de trabajo de Discoverer de la tabla eul5_qpp_stats para mostrar el número de usuarios activos de Discoverer, el número de diferentes libros y hojas de trabajo ejecutados y el número de diferentes carpetas (combinaciones) en las que se basan. F DIS Worksheet Execution Summary Résumé des statistiques d'accès aux feuilles de travail Discoverer à partir du tableau eul5_qpp_stats pour montrer le nombre d'utilisateurs Discoverer actifs, le nombre de différents classeurs et feuilles de travail exécutés et le nombre de dossiers différents (combinaisons) sur lesquels ils sont basés. I DIS Worksheet Execution Summary Riepilogo statistico di accesso ai fogli di lavoro Discoverer dalla tabella eul5_qpp_stats per mostrare il numero di utenti Discoverer attivi, il numero di diverse cartelle di lavoro e fogli di lavoro eseguiti e il numero di diverse cartelle (combinazioni) su cui questi sono basati. JA DIS Worksheet Execution Summary テーブル eul5_qpp_stats からの Discoverer ワークシート アクセス統計情報の要約は、アクティブな Discoverer ユーザーの数、実行されたさまざまなワークブックとワークシートの数、およびこれらが基になっているさまざまなフォルダの数 (組み合わせ) を示します。 KO DIS Worksheet Execution Summary Discoverer 워크 시트는 eul5_qpp_stats 테이블의 통계 요약에 액세스하여 활성 Discoverer 사용자 수, 실행 된 서로 다른 워크 북 및 워크 시트 수 및 이들이 기반으로하는 서로 다른 폴더 (조합) 수를 표시합니다. PTB DIS Worksheet Execution Summary Resumo estatístico de acesso à planilha Discoverer da tabela eul5_qpp_stats para mostrar o número de usuários Discoverer ativos, número de diferentes planilhas e pastas de trabalho executadas e o número de diferentes pastas (combinações) em que estas se baseiam. RU DIS Worksheet Execution Summary Доступ к статистической информации по рабочим листовкам Первооткрывателя из таблицы eul5_qpp_stats, чтобы показать количество активных пользователей Первооткрывателя, количество выполненных различных рабочих книг и рабочих листов и количество различных папок (комбинаций), на которых они основаны. S DIS Worksheet Execution Summary Discoverers kalkylblad får statistiköversikt från tabellen eul5_qpp_stats för att visa antalet aktiva Discoverer-användare, antalet olika arbetsböcker och kalkylblad som körs och antalet olika mappar (kombinationer) som dessa baseras på. TR DIS Worksheet Execution Summary Discoverer çalışma sayfası erişim istatistik özeti eul5_qpp_stats tablosundan aktif Discoverer kullanıcılarının sayısını, yürütülen farklı çalışma kitaplarının ve çalışma sayfalarının sayısını ve bunların dayandığı farklı klasör (kombinasyon) sayısını gösterir. US DIS Worksheet Execution Summary Discoverer worksheet access statistic summary from table eul5_qpp_stats to show the number of active Discoverer users, number of different workbooks and worksheets executed and the number of different folder (combinations) that these are based on. ZHS DIS Worksheet Execution Summary 发现者工作表访问统计摘要从表eul5_qpp_stats中显示活跃的发现者用户数、执行的不同工作簿和工作表的数量，以及这些工作簿和工作表所基于的不同文件夹（组合）的数量。 Enginatics &eul &qs_created_by 1=1 1 10 1=1 eqs.qs_doc_name=:workbook LOV DIS Workbook 8E2FF36EDF2079D2E0530100007F1FF2 Y select ed.doc_name value, ed.doc_description||' ('||ed.doc_developer_key||')' description from eul_us.eul5_documents ed order by ed.doc_name US Workbook 2 20 1=1 eqs.qs_created_by in (select '#'||fu.user_id from fnd_user fu where fu.user_name=:user_name) LOV FND User Name 8E2FF36EDE8479D2E0530100007F1FF2 Y Y select fu.user_name value, trim(coalesce( trim(papf.first_name||' '||papf.last_name), fu.description, fu.email_address, papf.email_address )||fu.inactive) description from (select case when sysdate between fu.start_date and nvl(fu.end_date,sysdate) then null else ' (inactive)' end inactive, fu.* from fnd_user fu) fu, (select papf.* from per_all_people_f papf where sysdate between papf.effective_start_date and papf.effective_end_date) papf, ( select distinct furg.user_id, count(*) over (partition by furg.user_id) resp_count, max(fr.responsibility_key) over (partition by furg.user_id) max_responsibility_key from fnd_responsibility fr, fnd_user_resp_groups_direct furg where fr.responsibility_id=furg.responsibility_id and fr.application_id=furg.responsibility_application_id ) furg where fu.employee_id=papf.person_id(+) and fu.user_id=furg.user_id(+) and not (furg.resp_count=1 and furg.max_responsibility_key='IRC_EXT_CANDIDATE') order by fu.inactive desc, fu.user_name US Submitted by User 3 30 1=1 eqs.qs_id in ( select eqs0.qs_id from ( select eqs.qs_id, trim(regexp_substr(eqs.qs_object_use_key,'[^\.]+',1,rowgen.column_value)) obj_id from eul_us.eul5_qpp_stats eqs, table(xxen_util.rowgen(regexp_count(eqs.qs_object_use_key,'\.')+1)) rowgen ) eqs0 where eqs0.obj_id in ( select ebol.bol_obj_id from eul_us.eul5_bas eb, eul_us.eul5_ba_obj_links ebol where eb.ba_name=:business_area and eb.ba_id=ebol.bol_ba_id) ) LOV DIS Business Area 8E2FF36EDF1179D2E0530100007F1FF2 Y select eb.ba_name value, eb.ba_description description from eul_us.eul5_bas eb order by eb.ba_name US Business Area 4 40 1=1 eqs.qs_id in ( select eqs0.qs_id from ( select eqs.qs_id, trim(regexp_substr(eqs.qs_object_use_key,'[^\.]+',1,rowgen.column_value)) obj_id from eul_us.eul5_qpp_stats eqs, table(xxen_util.rowgen(regexp_count(eqs.qs_object_use_key,'\.')+1)) rowgen ) eqs0 where eqs0.obj_id in ( select eo.obj_id from eul_us.eul5_objs eo where eo.obj_name=:folder ) ) LOV DIS Folder 8E2FF36EDEE079D2E0530100007F1FF2 Y select eo.obj_name value, nvl(eo.sobj_ext_table,eo.obj_developer_key)||nvl2(eo.obj_description,' ('||eo.obj_description||')',null) description from eul_us.eul5_objs eo order by eo.obj_name US Folder 5 50 1=1 eqs.qs_id in ( select eqs0.qs_id from ( select eqs.qs_id, trim(regexp_substr(eqs.qs_object_use_key,'[^\.]+',1,rowgen.column_value)) obj_id from eul_us.eul5_qpp_stats eqs, table(xxen_util.rowgen(regexp_count(eqs.qs_object_use_key,'\.')+1)) rowgen ) eqs0 where eqs0.obj_id in ( select eo.obj_id from eul_us.eul5_objs eo where eo.sobj_ext_table=:view_name ) ) LOV DIS View Name 8E2FF36EDF3179D2E0530100007F1FF2 Y select distinct eo.sobj_ext_table value, max(eo.obj_name) over (partition by eo.sobj_ext_table) description from eul_us.eul5_objs eo where eo.sobj_ext_table is not null order by eo.sobj_ext_table US View Name 6 60 1=1 eqs.qs_created_date>sysdate-:days Number nvl(fnd_profile.value('XXEN_REPORT_DISCOVERER_IMPORT_LOV_ACCESS_HISTORY_DAYS'),90) US Accessed within Days 7 70 1=1 eqs.qs_created_date>=:start_date_from Date US Start Date From 8 80 1=1 eqs.qs_created_date<:start_date_to+1 Date US Start Date To 9 90 &eul <parameter_value> LOV DIS End User Layer 8E2FF36EDF3879D2E0530100007F1FF2 Y select lower(do.owner) value, do.created description from dba_objects do where do.object_type='TABLE' and do.object_name='EUL5_VERSIONS' order by do.created desc xxen_util.dis_default_eul Y US End User Layer 10 100 &qs_created_by qs_created_by, LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US Show User Details