ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEFA79D2E0530100007F1FF2 Blitz Report Category Y 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 BDF47B6D3CB51EE6E05354749381277A Blitz Report Template Y select xrtv.template_name value, xrtv.owner||nvl2(xrtv.sharing,', '||xrtv.sharing,null)||nvl2(xrtv.global_default,', Global Default',null)||', '||xrtv.report_name description from xxen_report_templates_v xrtv where (:$flex$.report_name is null or xxen_util.contains(:$flex$.report_name,xrtv.report_name)='Y') and (:$flex$.owner is null or xrtv.owner_id in (select fu.user_id from fnd_user fu where xxen_util.contains(:$flex$.owner,fu.user_name)='Y')) order by xrtv.template_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. 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US 9D45860904E70504E0530100007F27A9 select distinct xrtv.report_name, xrtv.report_description, xrtv.category, xrtv.template_name, xrtv.description, xrtv.owner, xrtv.sharing, xxen_util.meaning(xrtv.global_default,'YES_NO',0) global_default, xxen_util.meaning(xrtv.distinct_flag,'YES_NO',0) distinct_flag, count(*) over (partition by xrtv.template_id) column_count, max(xxen_util.meaning(xrtc.aggregation,'AMS_EXPN_BUILDER_OPERATORS',530)) over (partition by xrtv.template_id) max_aggregation, max(nvl2(xrtc.sort_order,xrtc.direction||' ',null)||xrtc.sort_order_) over (partition by xrtv.template_id) max_sort_order, xxen_util.zero_to_null(xrtp.filter_count) filter_count, xxen_util.zero_to_null(xrtp.column_count) column_count, xxen_util.zero_to_null(xrtp.row_count) row_count, xxen_util.zero_to_null(xrtp.value_count) value_count, (select sum(length(xrtf.file_data)) from xxen_report_template_files xrtf where xrtv.template_id=xrtf.template_id) file_size, xrtv.file_name excel_file_name, (select xrtf.sheet_name from xxen_report_template_files xrtf where xrtv.template_id=xrtf.template_id and xrtf.sheet_type='data') data_sheet_name, xxen_util.client_time(xrtv.file_last_modified_date) file_last_modified, xxen_util.user_name(xrtv.created_by) created_by, xxen_util.client_time(xrtv.creation_date) creation_date, xxen_util.user_name(xrtv.last_updated_by) last_updated_by, xxen_util.client_time(xrtv.last_update_date) last_update_date, &columns xrtv.template_id from xxen_report_templates_v xrtv, ( select xxen_util.meaning(xrtc.aggregation,'AMS_EXPN_BUILDER_OPERATORS',530) aggregation_meaning, xxen_util.meaning(case when xrtc.sort_order<0 then 2 else sign(xrtc.sort_order) end,'WMS_SORT_ORDER',700) direction, abs(xrtc.sort_order) sort_order_, xxen_util.meaning(xrtc.sheet_break,'YES_NO',0) sheet_break_, (select distinct listagg(xrtp.field_type,', ') within group (order by xrtp.field_type) over () pivot_field_type from xxen_report_template_pivot xrtp where xrtc.template_id=xrtp.template_id and xrtc.column_name=xrtp.column_name) pivot_field_type, xrtc.* from xxen_report_template_columns xrtc where '&show_columns'='Y' and xrtc.display_sequence is not null ) xrtc, ( select xrtp.template_id, count(decode(xrtp.field_type,'FILTER',1)) filter_count, count(decode(xrtp.field_type,'COLUMN',1)) column_count, count(decode(xrtp.field_type,'ROW',1)) row_count, count(decode(xrtp.field_type,'VALUE',1)) value_count from xxen_report_template_pivot xrtp group by xrtp.template_id ) xrtp where 1=1 and xrtv.template_id=xrtc.template_id(+) and xrtv.template_id=xrtp.template_id(+) order by report_name, owner, xrtv.template_name &column_order_by Y AR Blitz Report Templates عمود Blitz Report أو قوالب تخطيط التجميع المحورية D Blitz Report Templates Blitz Report Spalten- oder Pivot-Aggregations-Layoutvorlagen E Blitz Report Templates Plantillas de diseño de agregación de columnas o pivotes de Blitz Report F Blitz Report Templates Modèles de présentation des colonnes ou des agrégats pivot du rapport Blitz I Blitz Report Templates Modelli di layout di aggregazione a colonne o pivot di Blitz Report JA Blitz Report Templates 電撃レポートの列またはピボット集計レイアウトテンプレート KO Blitz Report Templates Blitz Report 열 또는 피벗 집계 레이아웃 템플릿 PTB Blitz Report Templates Coluna de relatórios Blitz ou modelos de layout de agregação pivot RU Blitz Report Templates Шаблоны компоновки агрегации колонок или шарнирных соединений в блиц-интерфейсе S Blitz Report Templates Blitz-rapportmallar för kolumner eller pivotaggregering TR Blitz Report Templates Blitz Raporu sütunu veya özet toplama düzeni şablonları US Blitz Report Templates Blitz Report column or pivot aggregation layout templates ZHS Blitz Report Templates 突击报告列或数据透视聚合布局模板 Enginatics &column_order_by &columns &show_columns 1=1 1 10 1=1 upper(xrtv.report_name) like upper(:report_name) LOV custom 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 where xrv.report_id in (select xrt.report_id from xxen_report_templates xrt where :$flex$.template_name is null or xxen_util.contains(:$flex$.template_name,xrt.template_name)='Y') order by xrv.report_name F Nom du rapport US Report Name 2 20 1=1 xrtv.template_name=:template_name LOV Blitz Report Template BDF47B6D3CB51EE6E05354749381277A Y select xrtv.template_name value, xrtv.owner||nvl2(xrtv.sharing,', '||xrtv.sharing,null)||nvl2(xrtv.global_default,', Global Default',null)||', '||xrtv.report_name description from xxen_report_templates_v xrtv where (:$flex$.report_name is null or xxen_util.contains(:$flex$.report_name,xrtv.report_name)='Y') and (:$flex$.owner is null or xrtv.owner_id in (select fu.user_id from fnd_user fu where xxen_util.contains(:$flex$.owner,fu.user_name)='Y')) order by xrtv.template_name F Nom du modèle US Template Name 3 30 1=1 xrtv.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 Y 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 4 40 1=1 xrtv.owner_id=xxen_util.user_id(:created_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 F Propriétaire US Owner 5 50 1=1 xrtv.creation_date>=:creation_date_from Date F Date de création du US Creation Date From 6 60 1=1 xrtv.creation_date<:creation_date_to+1 Date US Creation Date To 7 70 1=1 xrtc.creation_date>=:column_creation_date_from Date US Column Creation Date From 8 &column_order_by ,xrtc.display_sequence US Column Creation Date From 9 &columns xrtc.display_sequence, xrtc.column_name, xxen_report.column_translation(xrtc.column_name) translation, xrtc.aggregation_meaning aggregation, xrtc.direction, xrtc.sort_order_, xrtc.sheet_break_, xrtc.pivot_field_type, xxen_util.user_name(xrtc.created_by) column_created_by, xxen_util.client_time(xrtc.creation_date) column_creation_date, xxen_util.user_name(xrtc.last_updated_by) column_last_updated_by, xxen_util.client_time(xrtc.last_update_date) column_last_update_date, US Column Creation Date From 10 &show_columns Y US Column Creation Date From 11 80 1=1 xrtc.creation_date<:column_creation_date_to+1 Date US Column Creation Date To 12 &column_order_by ,xrtc.display_sequence US Column Creation Date To 13 &columns xrtc.display_sequence, xrtc.column_name, xxen_report.column_translation(xrtc.column_name) translation, xrtc.aggregation_meaning aggregation, xrtc.direction, xrtc.sort_order_, xrtc.sheet_break_, xrtc.pivot_field_type, xxen_util.user_name(xrtc.created_by) column_created_by, xxen_util.client_time(xrtc.creation_date) column_creation_date, xxen_util.user_name(xrtc.last_updated_by) column_last_updated_by, xxen_util.client_time(xrtc.last_update_date) column_last_update_date, US Column Creation Date To 14 &show_columns Y US Column Creation Date To 15 90 1=1 xrtv.template_id in (select xrtf.template_id from xxen_report_template_files xrtf) LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual F Modèle Excel Has US Has Excel Template 16 100 &columns xrtc.display_sequence, xrtc.column_name, xxen_report.column_translation(xrtc.column_name) translation, xrtc.aggregation_meaning aggregation, xrtc.direction, xrtc.sort_order_, xrtc.sheet_break_, xrtc.pivot_field_type, xxen_util.user_name(xrtc.created_by) column_created_by, xxen_util.client_time(xrtc.creation_date) column_creation_date, xxen_util.user_name(xrtc.last_updated_by) column_last_updated_by, xxen_util.client_time(xrtc.last_update_date) column_last_update_date, LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual F Afficher les colonnes US Show Columns 17 &column_order_by ,xrtc.display_sequence F Afficher les colonnes US Show Columns 18 &show_columns Y US Show Columns :$flex$.owner Owner Template Name :$flex$.report_name Report Name Template Name :$flex$.template_name Template Name Report Name