ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 6127F8C61A774978E0530100007F056E select z.* from ( select xxen_util.user_name(xrlu.user_id) user_name, fu.start_date user_start_date, xxen_util.client_time(y.first_run_date) first_run_date, xxen_util.client_time(xrlu.last_run_date) last_run_date, y.run_count, y.distinct_reports, xrv.report_name most_popular, y.most_popular_count, count(*) over () user_count from xxen_report_license_users xrlu, fnd_user fu, ( select distinct x.created_by, x.first_run_date, x.run_count, x.distinct_reports, max(x.report_id) keep (dense_rank last order by x.count) over (partition by x.created_by) most_popular, max(x.count) keep (dense_rank last order by x.count) over (partition by x.created_by) most_popular_count from ( select distinct xrr.created_by, xrr.first_run_date, xrr.report_id, count(*) over (partition by xrr.created_by) run_count, count(distinct xrr.report_id) over (partition by xrr.created_by) distinct_reports, count(*) over (partition by xrr.created_by, xrr.report_id) count from (select min(xrr.creation_date) over (partition by xrr.created_by) first_run_date, xrr.* from xxen_report_runs xrr) xrr where nvl(xrr.type,'x')<>'S' and xrr.creation_date>sysdate-60 ) x ) y, xxen_reports_v xrv where xrlu.last_run_date>sysdate-60 and xrlu.user_id=fu.user_id and nvl(fu.end_date,sysdate)>=sysdate and xrlu.user_id=y.created_by(+) and y.most_popular=xrv.report_id(+) ) z where 1=1 order by z.last_run_date desc Y AR Blitz Report License Users مستخدمو Blitz Report النشطون (خلال الـ 60 يومًا الماضية) والتقارير الأكثر تنفيذًا. D Blitz Report License Users Aktive Blitz Report-Benutzer (innerhalb der letzten 60 Tage) und ihre am häufigsten ausgeführten Berichte. E Blitz Report License Users Usuarios activos del Informe Blitz (en los últimos 60 días) y sus informes más frecuentes. F Blitz Report License Users Les utilisateurs des rapports Blitz actifs (au cours des 60 derniers jours) et leurs rapports les plus fréquemment exécutés. I Blitz Report License Users Utenti attivi di Blitz Report (negli ultimi 60 giorni) e i loro rapporti più frequentemente eseguiti. JA Blitz Report License Users アクティブ電撃レポートのユーザー（過去60日以内）と最も頻繁に実行されたレポート KO Blitz Report License Users 활성 Blitz Report 사용자 (지난 60 일 이내) 및 가장 자주 실행 된 보고서. PTB Blitz Report License Users Usuários ativos do Relatório Blitz (nos últimos 60 dias) e seus relatórios mais freqüentemente executados. RU Blitz Report License Users Active Blitz Report пользователи (за последние 60 дней) и их наиболее часто выполняемые отчеты. S Blitz Report License Users Aktiva användare av Blitz-rapporter (under de senaste 60 dagarna) och deras oftast genomförda rapporter. TR Blitz Report License Users Aktif Blitz Raporu kullanıcıları (son 60 gün içinde) ve en sık yürütülen raporları. US Blitz Report License Users Currently active Blitz Report users (running reports within the past 60 days) and their most frequently executeds reports. ZHS Blitz Report License Users 活跃的突击报告用户（在过去60天内）及其最常执行的报告。 Enginatics 1=1 1 10 1=1 z.user_count>=:user_count_from Number US User Count from