ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 49A8B1A8039308ACE0530100007FEB91Y with anchors as ( select distinct y.report_id, listagg(y.anchor,', ') within group (order by y.anchor) over (partition by y.report_id) anchors from ( select distinct xr.report_id, dbms_lob.substr(regexp_substr(regexp_substr(xr.sql_text,'(\D|^)(\d+)=\2(\D|$)',1,x.column_value),'\d+=\d+')) anchor from (select xrv.report_id, regexp_replace(replace(xrv.sql_text_full,''''''),'''[^'']*''','''x''') sql_text from xxen_reports_v xrv where 1=1) xr, table(xxen_util.rowgen(regexp_count(xr.sql_text,'(\D|^)(\d+)=\2(\D|$)'))) x where '&show_anchors_lexicals_binds'='Y' ) y), lexicals as ( select distinct y.report_id, listagg(y.lexical,', ') within group (order by y.lexical) over (partition by y.report_id) lexicals from ( select distinct xr.report_id, lower(dbms_lob.substr(regexp_substr(xr.sql_text,'&\w+',1,x.column_value))) lexical from (select xrv.report_id, xrv.sql_text_full sql_text from xxen_reports_v xrv where 1=1 and xrv.sql_text_full like '%&%') xr, table(xxen_util.rowgen(regexp_count(xr.sql_text,'&\w+'))) x where '&show_anchors_lexicals_binds'='Y' ) y), binds as ( select distinct y.report_id, listagg(y.bind,', ') within group (order by y.bind) over (partition by y.report_id) binds from ( select distinct xr.report_id, lower(dbms_lob.substr(regexp_substr(xr.sql_text,':\w+',1,x.column_value))) bind from (select xrv.report_id, regexp_replace(replace(xrv.sql_text_full,''''''),'''[^'']*''','''x''') sql_text from xxen_reports_v xrv where 1=1 and xrv.sql_text_full like '%:%') xr, table(xxen_util.rowgen(regexp_count(xr.sql_text,':\w+'))) x where '&show_anchors_lexicals_binds'='Y' ) y) select xrv.report_name, xxen_util.application_name(substr(xrv.report_name,1,instr(xrv.report_name,' ')-1)) application, xrv.type_dsp type, xrv.category, &columns regexp_substr(xrv.description,chr(10)||'Object IDs: (.+)'||chr(10),1,1,null,1) object_use_key, xrv.description, &modification xrv.version, (select max(xrh.creation_date) from xxen_reports_h xrh where xrv.report_id=xrh.report_id) sql_last_update_date, xxen_util.user_name((select distinct max(xrh.created_by) keep (dense_rank last order by xrh.creation_date) over () from xxen_reports_h xrh where xrv.report_id=xrh.report_id)) sql_last_updated_by, xrv0.report_name copied_from, (select max(xrh.creation_date) from xxen_reports_h xrh where xrv.copied_from_guid=xrh.guid) copied_from_sql_last_upd_date, xxen_util.user_name((select distinct max(xrh.created_by) keep (dense_rank last order by xrh.creation_date) over () from xxen_reports_h xrh where xrv.copied_from_guid=xrh.guid)) copied_from_sql_last_updatd_by, xrv.db_package, xrv.email, xrv.output_format, xrv.row_limit, xrv.time_limit, xrv.custom_postprocess, xrv.output_file_name, xrv.server_output_directory, xrv.server_file_name, xrv.request_type, xrv.target_database, decode(xrv.upload_type,'I','Interface Table','A','API') upload_type, xxen_util.meaning(xrv.upload_create_only,'YES_NO',0) upload_create_only, xrv.upload_object, xrv.upload_post_procedure, xrv.upload_excel_validation, xxen_util.user_name(xrv.created_by) created_by, xxen_util.client_time(xrv.creation_date) creation_date, xxen_util.user_name(xrv.last_updated_by) last_updated_by, xxen_util.client_time(xrv.last_update_date) last_update_date, xxen_util.yes(xrv.disabled) disabled, decode(xrv.parameter_count,0,to_number(null),xrv.parameter_count) parameter_count, decode(xrv.template_count,0,to_number(null),xrv.template_count) template_count, (select count(distinct xra.id1||','||xra.id2) from xxen_report_assignments xra where xrv.report_id=xra.report_id and xra.include_exclude='I') assignments_count, (select count(distinct xra.id1||','||xra.id2) from xxen_report_assignments xra where xrv.report_id=xra.report_id and xra.assignment_level='Application' and xra.include_exclude='I') application_assignments, (select count(distinct xra.id1||','||xra.id2) from xxen_report_assignments xra where xrv.report_id=xra.report_id and xra.assignment_level='Request Group' and xra.include_exclude='I') request_group_assignments, (select count(distinct xra.id1||','||xra.id2) from xxen_report_assignments xra where xrv.report_id=xra.report_id and xra.assignment_level='Form' and xra.include_exclude='I') forms_assignments, &anchors_lexicals_binds xrv.required_parameters, xrv.required_parameters_message, xrv.sql_length, xrv.sql_text, xrv.report_id, xrv.guid from ( select x.*, row_number() over (partition by x.type_ order by x.seeded_flag nulls first,x.seeded_blitz_report_flag nulls first,x.report_id desc) row_num from ( select xrv.*, (select count(*) from xxen_report_parameters xrp where xrv.report_id=xrp.report_id and xrp.display_sequence is not null) parameter_count, (select count(*) from xxen_report_templates xrt where xrv.report_id=xrt.report_id) template_count, (select 'Y' from fnd_user fu where fu.user_name in ('ANONYMOUS','ENGINATICS') and xrv.created_by=fu.user_id) seeded_flag, xxen_report.is_seeded_blitz_report(xrv.guid) seeded_blitz_report_flag, decode(xrv.type,'U','U') type_ from xxen_reports_v xrv ) x ) xrv, xxen_reports_v xrv0, (select xrpv.* from xxen_report_parameters_v xrpv where '&show_parameters'='Y') xrpv, (select xrav.* from xxen_report_assignments_v xrav where '&show_assignments'='Y') xrav, (select count(*) execution_count, xrr.report_id from xxen_report_runs xrr where 3=3 and '&show_exec_count'='Y' group by xrr.report_id) y, (select xupv.* from xxen_upload_parameters_v xupv where '&show_upload_parameters'='Y') xupv, (select xucv.* from xxen_upload_columns_v xucv where '&show_upload_columns'='Y') xucv, anchors, lexicals, binds where 1=1 and 2=2 and xrv.copied_from_guid=xrv0.guid(+) and xrv.report_id=xrpv.report_id(+) and xrv.report_id=xrav.report_id(+) and xrv.report_id=y.report_id(+) and xrv.report_id=xupv.report_id(+) and xrv.report_id=xucv.report_id(+) and xrv.report_id=anchors.report_id(+) and xrv.report_id=lexicals.report_id(+) and xrv.report_id=binds.report_id(+) order by &order_by_free_30_reports y.execution_count desc nulls last, xrv.report_name, xrpv.sort_order, decode(xupv.source,'U',1,2), xupv.display_sequence, xucv.column_number, xrav.include_exclude desc, decode(xrav.assignment_level, 'Site',1, 'Application',2, 'Organization',3, 'Request Group',4, 'Responsibility',5, 'User',6 ), xrav.level_value Show Parameters, Show Upload Parameters, Show Upload Columns and Show Assignments are mutually exclusive, to avoid a cartesian product of the detail rows. Show Upload Parameters shows the procedure each parameter belongs to (upload or post processing procedure) and the setup of the mapped upload column. AR Blitz Reports تقارير Blitz مع المعلمات والتعيينات. إذا كنت تستخدم الإصدار المجاني من Blitz Report ، فإن العمود "Free 30 Reports" يعرض التقارير التي تم تضمينها حاليًا. D Blitz Reports Blitz Reports mit Parametern und Zuordnungen. Wenn Sie die kostenlose Version von Blitz Report verwenden, wird in der Spalte 'Free 30 Reports' angezeigt, welche Reports aktuell enthalten sind. E Blitz Reports Informes Blitz con parámetros y asignaciones. Si está utilizando la versión gratuita de Blitz Report, la columna 'Free 30 Reports' muestra los informes que se incluyen actualmente. F Blitz Reports Rapports de Blitz avec paramètres et affectations. Si vous utilisez la version gratuite de Blitz Report, la colonne "30 rapports gratuits" indique quels rapports sont actuellement inclus. I Blitz Reports Blitz Report con parametri e assegnazioni. Se stai usando la versione gratuita di Blitz Report, la colonna 'Free 30 Reports' mostra quali rapporti sono attualmente inclusi. JA Blitz Reports 電撃レポートにパラメータと割り当てを追加しました。 電撃レポートの無料版を使用している場合、「Free 30 Reports」の欄には、現在どのレポートが含まれているかが表示されます。 KO Blitz Reports 매개 변수 및 할당이있는 블리츠 보고서. Blitz Report의 무료 버전을 사용하는 경우 'Free 30 Reports'열에 현재 포함 된 보고서가 표시됩니다. PTB Blitz Reports Relatórios Blitz com parâmetros e atribuições. Se você estiver usando a versão gratuita do Blitz Report, a coluna 'Free 30 Reports' mostra quais relatórios estão incluídos atualmente. RU Blitz Reports Блиц-отчеты с параметрами и назначениями. Если вы используете бесплатную версию Blitz Report, в колонке "Бесплатные 30 отчетов" показано, какие отчеты включены в данный момент. S Blitz Reports Blitz-rapporter med parametrar och uppdrag. Om du använder den kostnadsfria versionen av Blitz Report, visar kolumnen 'Gratis 30 rapporter' vilka rapporter som för närvarande ingår. TR Blitz Reports Parametreler ve atamalarla Blitz Raporları. Blitz Raporunun ücretsiz sürümünü kullanıyorsanız, 'Ücretsiz 30 Rapor' sütunu şu anda hangi raporların dahil olduğunu gösterir. US Blitz Reports All Enginatics report details can be seen here: https://www.enginatics.com/library/?pg=1&category[]=Enginatics Blitz Reports with parameters and assignments. Show Parameters, Show Upload Parameters, Show Upload Columns and Show Assignments list different detail rows and can be used only one at a time: each is greyed out while another one is set, and Parameter Name or Parameter Type count as Show Parameters. Show Upload Parameters includes the setup of the upload column each parameter maps to. If you are using the free version of Blitz Report, you can use the parameter 'Sort by Free 30 Reports' to show your free reports in column 'Free 30 Reports'. ZHS Blitz Reports 带参数和任务的闪电战报告。 如果您使用的是免费版的Blitz Report，"免费30份报告 "一栏会显示当前包括哪些报告。 Enginatics &anchors_lexicals_binds &columns &modification &order_by_free_30_reports &show_anchors_lexicals_binds &show_assignments &show_exec_count &show_parameters &show_upload_columns &show_upload_parameters 1=1 2=2 3=3 1 10 1=1 xrv.report_id in ( select xrca.report_id from xxen_report_category_assigns xrca, xxen_report_categories_v xrcv where xrcv.category=:category and xrcv.category_id=xrca.category_id ) LOV Blitz Report Category 8E2FF36EDEFA79D2E0530100007F1FF2 select xrcv.category value, (select count(*) from xxen_report_category_assigns xrca where xrcv.category_id=xrca.category_id) description from xxen_report_categories_v xrcv order by xrcv.category F Catégorie US Category 2 20 1=1 xrv.report_id not in ( select xrca.report_id from xxen_report_category_assigns xrca, xxen_report_categories_v xrcv where xrcv.category=:not_in_category and xrcv.category_id=xrca.category_id ) LOV Blitz Report Category 8E2FF36EDEFA79D2E0530100007F1FF2 select xrcv.category value, (select count(*) from xxen_report_category_assigns xrca where xrcv.category_id=xrca.category_id) description from xxen_report_categories_v xrcv order by xrcv.category US Not in Category 3 30 1=1 xrv.type_dsp=:type LOV Blitz Report Type 028C2F5E98A1A51DE0630100007F0DD5 select xrv.type_dsp value, count(*) description from xxen_reports_v xrv group by xrv.type_dsp order by count(*) desc US Type 4 40 1=1 xrv.report_name=:report_name LOV Blitz Report Name 8E2FF36EDEA879D2E0530100007F1FF2 select xrv.report_name value, xrv.type_dsp||nvl2(xrv.type,' ',null)||nvl2(xrv.category,'('||xrv.category||') ',null)||substrb(xrv.description,1,4000-lengthb(xrv.type_dsp||nvl2(xrv.type,' ',null)||nvl2(xrv.category,'('||xrv.category||') ',null))) description from xxen_reports_v xrv where nvl(xrv.type,'x')<>'S' and (fnd_profile.value('XXEN_REPORT_ACCESS')='S' or nvl(xrv.type,'x')<>'U') order by xrv.report_name F Nom du rapport US Report Name 5 45 1=1 xrv.report_name<>:report_name LOV Blitz Report Name 8E2FF36EDEA879D2E0530100007F1FF2 select xrv.report_name value, xrv.type_dsp||nvl2(xrv.type,' ',null)||nvl2(xrv.category,'('||xrv.category||') ',null)||substrb(xrv.description,1,4000-lengthb(xrv.type_dsp||nvl2(xrv.type,' ',null)||nvl2(xrv.category,'('||xrv.category||') ',null))) description from xxen_reports_v xrv where nvl(xrv.type,'x')<>'S' and (fnd_profile.value('XXEN_REPORT_ACCESS')='S' or nvl(xrv.type,'x')<>'U') order by xrv.report_name US Report name <> 6 50 1=1 lower(xrv.report_name) like lower(:report_name_like) LOV Blitz Report Name (wildcard) B04763D730F050D7E0530100007F06B3 Y select xrv.report_name value, xrv.type_dsp||nvl2(xrv.type,' ',null)||nvl2(xrv.category,'('||xrv.category||') ',null)||substrb(xrv.description,1,4000-lengthb(xrv.type_dsp||nvl2(xrv.type,' ',null)||nvl2(xrv.category,'('||xrv.category||') ',null))) description from xxen_reports_v xrv order by xrv.report_name F Nom du rapport comme US Report Name like 7 60 1=1 xrv.report_id in (select xrpv.report_id from xxen_report_parameters_v xrpv where xrpv.parameter_name=:parameter_name) LOV custom select distinct xrpv.parameter_name value, count(*) over (partition by xrpv.parameter_name) description from xxen_report_parameters_v xrpv where xrpv.report_name=nvl(:$flex$.report_name,xrpv.report_name) and xrpv.display_sequence is not null order by xrpv.parameter_name F Nom du paramètre US Parameter Name 8 &columns xrpv.display_sequence, xrpv.parameter_name, nvl2(xrpv.display_sequence,'Parameter'||row_number() over (partition by xrpv.report_id order by xrpv.display_sequence),null) concurrent_prog_parameter_name, xrpv.anchor, xrpv.sql_text parameter_sql_text, xrpv.parameter_type_dsp, xrpv.lov_name, xrpv.lov_query_dsp lov_query, xxen_util.yes(xrpv.free_text) free_text, xxen_util.meaning(xrpv.filter_before_display_dsp,'YES_NO',0) filter_before_display, xrpv.matching_value, xrpv.default_value, xxen_util.meaning(xrpv.required,'YES_NO',0) required, xxen_util.user_name(xrpv.created_by) param_created_by, xxen_util.client_time(xrpv.creation_date) param_creation_date, xxen_util.user_name(xrpv.last_updated_by) param_last_updated_by, xxen_util.client_time(xrpv.last_update_date) param_last_update_date, F Nom du paramètre US Parameter Name 9 &show_parameters Y F Nom du paramètre US Parameter Name 10 2=2 xrpv.parameter_name=:parameter_name US Parameter Name 11 70 1=1 xrv.report_id in (select xrpv.report_id from xxen_report_parameters_v xrpv where xrpv.parameter_type_dsp=:parameter_type) LOV custom select 'Char' value, 'description' description from dual union all select 'Date' value, 'description' description from dual union all select 'DateTime' value, 'description' description from dual union all select 'Number' value, 'description' description from dual union all select 'LOV' value, 'description' description from dual union all select 'LOV custom' value, 'description' description from dual union all select 'LOV Oracle' value, 'description' description from dual US Parameter Type 12 &columns xrpv.display_sequence, xrpv.parameter_name, nvl2(xrpv.display_sequence,'Parameter'||row_number() over (partition by xrpv.report_id order by xrpv.display_sequence),null) concurrent_prog_parameter_name, xrpv.anchor, xrpv.sql_text parameter_sql_text, xrpv.parameter_type_dsp, xrpv.lov_name, xrpv.lov_query_dsp lov_query, xxen_util.yes(xrpv.free_text) free_text, xxen_util.meaning(xrpv.filter_before_display_dsp,'YES_NO',0) filter_before_display, xrpv.matching_value, xrpv.default_value, xxen_util.meaning(xrpv.required,'YES_NO',0) required, xxen_util.user_name(xrpv.created_by) param_created_by, xxen_util.client_time(xrpv.creation_date) param_creation_date, xxen_util.user_name(xrpv.last_updated_by) param_last_updated_by, xxen_util.client_time(xrpv.last_update_date) param_last_update_date, US Parameter Type 13 &show_parameters Y US Parameter Type 14 2=2 xrpv.parameter_type_dsp=:parameter_type US Parameter Type 15 80 &columns xrpv.display_sequence, xrpv.parameter_name, nvl2(xrpv.display_sequence,'Parameter'||row_number() over (partition by xrpv.report_id order by xrpv.display_sequence),null) concurrent_prog_parameter_name, xrpv.anchor, xrpv.sql_text parameter_sql_text, xrpv.parameter_type_dsp, xrpv.lov_name, xrpv.lov_query_dsp lov_query, xxen_util.yes(xrpv.free_text) free_text, xxen_util.meaning(xrpv.filter_before_display_dsp,'YES_NO',0) filter_before_display, xrpv.matching_value, xrpv.default_value, xxen_util.meaning(xrpv.required,'YES_NO',0) required, xxen_util.user_name(xrpv.created_by) param_created_by, xxen_util.client_time(xrpv.creation_date) param_creation_date, xxen_util.user_name(xrpv.last_updated_by) param_last_updated_by, xxen_util.client_time(xrpv.last_update_date) param_last_update_date, LOV custom select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual where :$flex$.show_upload_parameters is null and :$flex$.show_upload_columns is null and :$flex$.show_assignments is null F Afficher les paramètres US Show Parameters 16 &show_parameters Y F Afficher les paramètres US Show Parameters 17 90 &show_upload_parameters Y LOV custom select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual where :$flex$.parameter_name is null and :$flex$.parameter_type is null and :$flex$.show_parameters is null and :$flex$.show_upload_columns is null and :$flex$.show_assignments is null US Show Upload Parameters 18 &columns decode(xupv.source,'P',xrv.upload_post_procedure,xrv.upload_object) upload_parameter_procedure, xupv.parameter_name upload_parameter_name, xupv.in_out upload_parameter_in_out, xupv.parameter_type upload_parameter_type, xupv.column_name_dsp upload_column_name, xupv.id_or_value_dsp upload_param_id_or_value, xupv.value_to_id_query upload_param_value_to_id_query, xupv.column_type_dsp upload_column_type, xupv.lov_name upload_column_lov_name, xxen_util.yes(xupv.free_text) upload_column_free_text, xxen_util.meaning(xupv.filter_before_display_dsp,'YES_NO',0) upload_col_lov_fil_before_disp, xupv.lov_query_dsp upload_column_lov_query, xupv.default_value upload_column_default_value, xupv.comments upload_column_comments, xxen_util.meaning(xupv.required,'YES_NO',0) upload_column_required, xxen_util.meaning(xupv.read_only,'YES_NO',0) upload_column_read_only, xxen_util.meaning(xupv.hidden,'YES_NO',0) upload_column_hidden, xxen_util.meaning(xupv.group_validation,'YES_NO',0) upload_column_group_validation, xxen_util.user_name(xupv.created_by) upload_param_created_by, xxen_util.client_time(xupv.creation_date) upload_param_creation_date, xxen_util.user_name(xupv.last_updated_by) upload_param_last_updated_by, xxen_util.client_time(xupv.last_update_date) upload_param_last_update_date, US Show Upload Parameters 19 100 &show_upload_columns Y LOV custom select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual where :$flex$.parameter_name is null and :$flex$.parameter_type is null and :$flex$.show_parameters is null and :$flex$.show_upload_parameters is null and :$flex$.show_assignments is null US Show Upload Columns 20 &columns xucv.column_name_dsp upload_column_name, xucv.column_type_dsp upload_column_type, xucv.lov_name upload_column_lov_name, xxen_util.yes(xucv.free_text) upload_column_free_text, xxen_util.meaning(xucv.filter_before_display_dsp,'YES_NO',0) upload_col_lov_fil_before_disp, xucv.lov_query_dsp upload_column_lov_query, xucv.value_to_id_query upload_col_value_to_id_query, xucv.default_value upload_column_default_value, xucv.comments upload_column_comments, xxen_util.meaning(xucv.required,'YES_NO',0) upload_column_required, xxen_util.meaning(xucv.read_only,'YES_NO',0) upload_column_read_only, xxen_util.meaning(xucv.hidden,'YES_NO',0) upload_column_hidden, xxen_util.meaning(xucv.group_validation,'YES_NO',0) upload_column_group_validation, xxen_util.user_name(xucv.created_by) upload_column_created_by, xxen_util.client_time(xucv.creation_date) upload_column_creation_date, xxen_util.user_name(xucv.last_updated_by) upload_column_last_updated_by, xxen_util.client_time(xucv.last_update_date) upload_column_last_update_date, US Show Upload Columns 21 110 &show_assignments Y LOV custom select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual where :$flex$.parameter_name is null and :$flex$.parameter_type is null and :$flex$.show_parameters is null and :$flex$.show_upload_parameters is null and :$flex$.show_upload_columns is null F Afficher les affectations US Show Assignments 22 &columns xxen_util.meaning(xrav.include_exclude,'INCLUDE_EXCLUDE',0) include_exclude, xrav.assignment_level, xrav.level_value, xxen_util.user_name(xrav.created_by) assignment_created_by, xxen_util.client_time(xrav.creation_date) assignment_creation_date, xxen_util.user_name(xrav.last_updated_by) assignment_last_updated_by, xxen_util.client_time(xrav.last_update_date) assignment_last_update_date, F Afficher les affectations US Show Assignments 23 120 3=3 xrr.creation_date>sysdate-:exec_count_days Number 60 F Afficher les exécutions dans les x jours US Show executions within x days 24 &columns y.execution_count, F Afficher les exécutions dans les x jours US Show executions within x days 25 &show_exec_count Y F Afficher les exécutions dans les x jours US Show executions within x days 26 130 1=1 xrv.disabled='Y' LOV Oracle Yes_No select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description Y F Désactivé US Disabled 27 1=1 xrv.disabled is null N US Disabled 28 140 1=1 xrv.db_package is not null LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual F Le paquet DB existe US DB Package exists 29 150 &order_by_free_30_reports free_30_reports, xrv.row_num, LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US Sort by Free 30 Reports 30 &columns xxen_util.meaning(case when xrv.row_num<=1 or xrv.type_ is null and xrv.row_num<=30 or xrv.seeded_blitz_report_flag='Y' then 'Y' end,'YES_NO',0) free_30_reports, US Sort by Free 30 Reports 31 160 &anchors_lexicals_binds anchors.anchors, lexicals.lexicals, binds.binds, LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual F Inclure les ancres et les liens US Include Anchors and Binds 32 &show_anchors_lexicals_binds Y F Inclure les ancres et les liens US Include Anchors and Binds 33 170 1=1 xrv.report_id in (select xrp.report_id from xxen_report_parameters xrp where lower(xrp.sql_text) like '%'||lower(:param_sql_text)||'%') Char F Le paramètre SQL Text contient US Parameter SQL Text contains 34 &columns xrpv.display_sequence, xrpv.parameter_name, nvl2(xrpv.display_sequence,'Parameter'||row_number() over (partition by xrpv.report_id order by xrpv.display_sequence),null) concurrent_prog_parameter_name, xrpv.anchor, xrpv.sql_text parameter_sql_text, xrpv.parameter_type_dsp, xrpv.lov_name, xrpv.lov_query_dsp lov_query, xxen_util.yes(xrpv.free_text) free_text, xxen_util.meaning(xrpv.filter_before_display_dsp,'YES_NO',0) filter_before_display, xrpv.matching_value, xrpv.default_value, xxen_util.meaning(xrpv.required,'YES_NO',0) required, xxen_util.user_name(xrpv.created_by) param_created_by, xxen_util.client_time(xrpv.creation_date) param_creation_date, xxen_util.user_name(xrpv.last_updated_by) param_last_updated_by, xxen_util.client_time(xrpv.last_update_date) param_last_update_date, F Le paramètre SQL Text contient US Parameter SQL Text contains 35 &show_parameters Y F Le paramètre SQL Text contient US Parameter SQL Text contains 36 180 1=1 xrv.report_id in (select xrp.report_id from xxen_report_parameters xrp where (xrp.parameter_type, xrp.lov_id) in ( select 'LOV', xrplv.lov_id from xxen_report_parameter_lovs_v xrplv where xrplv.lov_name=:lov_name union all select 'LOV Oracle', ffvs.flex_value_set_id from fnd_flex_value_sets ffvs where ffvs.flex_value_set_name=:lov_name )) LOV custom select xrplv.lov_name value, xrplv.description, 1 sort from xxen_report_parameter_lovs_v xrplv union all select ffvs.flex_value_set_name value, decode(ffvs.validation_type,'F','Table: ','Value: ')||ffvs.description description, 2 sort from fnd_flex_value_sets ffvs where ffvs.flex_value_set_name not like '$FLEX$.%' and (ffvs.validation_type='F' or ffvs.validation_type in ('D','I','X','Y') and exists (select null from fnd_flex_values ffv where ffvs.flex_value_set_id=ffv.flex_value_set_id)) order by sort,value F Utilisation de LOV US Using LOV 37 &columns xrpv.display_sequence, xrpv.parameter_name, nvl2(xrpv.display_sequence,'Parameter'||row_number() over (partition by xrpv.report_id order by xrpv.display_sequence),null) concurrent_prog_parameter_name, xrpv.anchor, xrpv.sql_text parameter_sql_text, xrpv.parameter_type_dsp, xrpv.lov_name, xrpv.lov_query_dsp lov_query, xxen_util.yes(xrpv.free_text) free_text, xxen_util.meaning(xrpv.filter_before_display_dsp,'YES_NO',0) filter_before_display, xrpv.matching_value, xrpv.default_value, xxen_util.meaning(xrpv.required,'YES_NO',0) required, xxen_util.user_name(xrpv.created_by) param_created_by, xxen_util.client_time(xrpv.creation_date) param_creation_date, xxen_util.user_name(xrpv.last_updated_by) param_last_updated_by, xxen_util.client_time(xrpv.last_update_date) param_last_update_date, F Utilisation de LOV US Using LOV 38 &show_parameters Y F Utilisation de LOV US Using LOV 39 190 1=1 xrv.report_id in (select xrp.report_id from xxen_report_parameters xrp where lower(xrp.matching_value) like '%'||:matching_value||'%') Char F La valeur correspondante contient US Matching Value contains 40 &columns xrpv.display_sequence, xrpv.parameter_name, nvl2(xrpv.display_sequence,'Parameter'||row_number() over (partition by xrpv.report_id order by xrpv.display_sequence),null) concurrent_prog_parameter_name, xrpv.anchor, xrpv.sql_text parameter_sql_text, xrpv.parameter_type_dsp, xrpv.lov_name, xrpv.lov_query_dsp lov_query, xxen_util.yes(xrpv.free_text) free_text, xxen_util.meaning(xrpv.filter_before_display_dsp,'YES_NO',0) filter_before_display, xrpv.matching_value, xrpv.default_value, xxen_util.meaning(xrpv.required,'YES_NO',0) required, xxen_util.user_name(xrpv.created_by) param_created_by, xxen_util.client_time(xrpv.creation_date) param_creation_date, xxen_util.user_name(xrpv.last_updated_by) param_last_updated_by, xxen_util.client_time(xrpv.last_update_date) param_last_update_date, F La valeur correspondante contient US Matching Value contains 41 &show_parameters Y F La valeur correspondante contient US Matching Value contains 42 200 2=2 lower(xrpv.default_value) like '%'||:default_value||'%' Char F La valeur par défaut contient US Default Value contains 43 &columns xrpv.display_sequence, xrpv.parameter_name, nvl2(xrpv.display_sequence,'Parameter'||row_number() over (partition by xrpv.report_id order by xrpv.display_sequence),null) concurrent_prog_parameter_name, xrpv.anchor, xrpv.sql_text parameter_sql_text, xrpv.parameter_type_dsp, xrpv.lov_name, xrpv.lov_query_dsp lov_query, xxen_util.yes(xrpv.free_text) free_text, xxen_util.meaning(xrpv.filter_before_display_dsp,'YES_NO',0) filter_before_display, xrpv.matching_value, xrpv.default_value, xxen_util.meaning(xrpv.required,'YES_NO',0) required, xxen_util.user_name(xrpv.created_by) param_created_by, xxen_util.client_time(xrpv.creation_date) param_creation_date, xxen_util.user_name(xrpv.last_updated_by) param_last_updated_by, xxen_util.client_time(xrpv.last_update_date) param_last_update_date, F La valeur par défaut contient US Default Value contains 44 &show_parameters Y F La valeur par défaut contient US Default Value contains 45 210 1=1 ( xrv.creation_date>:modified_date_from or xrv.report_id in (select xrh.report_id from xxen_reports_h xrh where xrh.creation_date>:modified_date_from) or xrv.report_id in (select xrp.report_id from xxen_report_parameters xrp where xrp.last_update_date>:modified_date_from) ) Date F Date de modification du Shows any report which had either the report SQL or parameter created or updated after the given date US Modified Date From Shows any report which had either the report SQL or parameter created or updated after the given date 46 &modification case when xrv.creation_date>:modified_date_from then 'New report' else nvl( (select 'SQL updated' from xxen_reports_h xrh where xrv.report_id=xrh.report_id and xrh.creation_date>:modified_date_from and rownum=1), (select 'Parameters updated' from xxen_report_parameters xrp where xrv.report_id=xrp.report_id and xrp.last_update_date>:modified_date_from and rownum=1) ) end modification, F Date de modification du US Modified Date From 47 220 1=1 xrv.created_by=xxen_util.user_id(:created_by) LOV FND User Name 8E2FF36EDE8479D2E0530100007F1FF2 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 F Créé par US Created By 48 230 1=1 xrv.created_by<>xxen_util.user_id(:not_created_by) LOV FND User Name 8E2FF36EDE8479D2E0530100007F1FF2 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 F Non créé par US Not Created By 49 240 1=1 xrv.creation_date>=:creation_date_from Date F Date de création du US Creation Date From 50 250 1=1 xrv.last_update_date>=:last_update_date_from Date F Date de la dernière mise à jour du US Last Update Date From 51 260 1=1 xrv.last_updated_by=xxen_util.user_id(:last_updated_by) LOV FND User Name 8E2FF36EDE8479D2E0530100007F1FF2 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 F Dernière mise à jour par US Last Updated By 52 270 1=1 xrv.last_updated_by<>xxen_util.user_id(:not_last_updated_by) LOV FND User Name 8E2FF36EDE8479D2E0530100007F1FF2 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 F Non Dernière mise à jour par US Not Last Updated By 53 280 2=2 (xrv.last_updated_by=xxen_util.user_id(:last_updated_by_rep_param) or xrpv.last_updated_by=xxen_util.user_id(:last_updated_by_rep_param)) LOV FND User Name 8E2FF36EDE8479D2E0530100007F1FF2 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 Updated By (Report or Param) 54 290 2=2 (xrv.last_update_date>=:last_update_date or xrpv.last_update_date>=:last_update_date) Date US Update Date From (Report or Param) 55 295 1=1 exists (select null from xxen_reports_h xrh where xrv.report_id=xrh.report_id and xrh.creation_date>=:sql_last_update_date_from) Date US SQL Last Update Date From 56 300 1=1 exists (select null from xxen_reports_h xrh0 where xrv.copied_from_guid=xrh0.guid and nvl((select max(xrh.creation_date) from xxen_reports_h xrh where xrv.report_id=xrh.report_id and lower(xrh.comments) like '%merged%'),xrv.creation_date)<xrh0.creation_date) LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual F Rapports copiés non fusionnés Copied reports where the original report was recently updated and the copied report didn't get updated with a 'merge' comment in the version history US Non merged copied reports Copied reports where the original report was recently updated and the copied report didn't get updated with a 'merge' comment in the version history 57 310 1=1 xrv.report_id not in (select xra.report_id from xxen_report_assignments xra where xra.assignment_level='All' or xra.assignment_level=:assignment_level) LOV custom select 'All' id, 'All' value, null description from dual union all select 'Site' id, 'Site' value, null description from dual union all select 'Application' id, 'Application' value, null description from dual union all select 'Request Group' id, 'Request Group' value, null description from dual union all select 'Responsibility' id, 'Responsibility' value, null description from dual union all select 'User' id, 'User' value, null description from dual union all select 'Form' id, 'Form' value, null description from dual US Not assigned to level 3038B38831EC82585EE38A16545AF91A Enginatics Reports ENGINATICS 3 APPLICATION 4 DESCRIPTION 1 REPORT_NAME 2 TYPE 1 S Site ENGINATICS 3038B38831EC82585EE38A16545AF91A ANDY.HAACK 3038B38831EC82585EE38A16545AF91A DAVID.MWANGI 3038B38831EC82585EE38A16545AF91A MARK.SPIRNAK 3038B38831EC82585EE38A16545AF91A