ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 6BFCF276C844675EE0530100007FC56CY select xrplv.type, xrplv.lov_name, xrplv.report_name, xrplv.parameter_name, xrplv.column_name, xrplv.description, xxen_util.meaning(xrplv.filter_before_display,'YES_NO',0) filter_before_display, xrlc.status count_status, xrlc.filter_change, xrlc.row_count, xxen_util.client_time(xrlc.last_update_date) count_date, decode(xrplv.usage_count,0,to_number(null),xrplv.usage_count) usage_count, xrplv.version, (select max(xrplh.creation_date) from xxen_report_parameter_lovs_h xrplh where xrplv.lov_id=xrplh.lov_id) last_sql_update_date, xxen_util.user_name(xrplv.created_by) created_by, xxen_util.client_time(xrplv.creation_date) creation_date, xxen_util.user_name(xrplv.last_updated_by) last_updated_by, xxen_util.client_time(xrplv.last_update_date) last_update_date, xrplv.lov_query, length(xrplv.lov_query) lov_query_size, xrplv.lov_id, xrplv.report_id, xrplv.parameter_id from ( select 'LOV' type, xrplv.lov_name, to_char(null) report_name, to_char(null) parameter_name, to_char(null) column_name, xrplv.description, xrplv.filter_before_display, (select count(*) from xxen_report_parameters xrp where xrp.parameter_type='LOV' and xrplv.lov_id=xrp.lov_id)+ (select count(*) from xxen_upload_columns xuc where xuc.column_type='LOV' and xrplv.lov_id=xuc.lov_id) usage_count, xrplv.version, xrplv.created_by, xrplv.creation_date, xrplv.last_updated_by, xrplv.last_update_date, xrplv.lov_query, xrplv.lov_id, to_number(null) report_id, to_number(null) parameter_id, to_char(xrplv.lov_id) count_key from xxen_report_parameter_lovs_v xrplv union all select 'Parameter' type, to_char(null) lov_name, xrt.report_name, xrpt.parameter_name, to_char(null) column_name, xrpt.description, xrp.filter_before_display, to_number(null) usage_count, to_number(null) version, xrp.created_by, xrp.creation_date, xrp.last_updated_by, xrp.last_update_date, xrp.lov_query, to_number(null) lov_id, xrp.report_id, xrp.parameter_id, to_char(xrp.parameter_id) count_key from xxen_report_parameters xrp, xxen_report_parameters_tl xrpt, xxen_reports_tl xrt where xrp.parameter_type='LOV' and xrp.lov_id is null and xrp.display_sequence is not null and xrp.parameter_id=xrpt.parameter_id and xrpt.language=userenv('lang') and xrp.report_id=xrt.report_id and xrt.language=userenv('lang') union all select 'Upload Column' type, to_char(null) lov_name, xrt.report_name, to_char(null) parameter_name, xuc.column_name, xuc.comments description, xuc.filter_before_display, to_number(null) usage_count, to_number(null) version, xuc.created_by, xuc.creation_date, xuc.last_updated_by, xuc.last_update_date, xuc.lov_query, to_number(null) lov_id, xuc.report_id, to_number(null) parameter_id, xuc.report_id||'.'||xuc.column_name count_key from xxen_upload_columns xuc, xxen_reports_tl xrt where xuc.column_type='LOV' and xuc.lov_id is null and xuc.report_id=xrt.report_id and xrt.language=userenv('lang') ) xrplv, ( select xrlc.*, decode(xrlc.type,'LOV',to_char(xrlc.lov_id),'Parameter',to_char(xrlc.parameter_id),xrlc.report_id||'.'||xrlc.column_name) count_key from xxen_report_lov_counts xrlc ) xrlc where 1=1 and xrplv.type=xrlc.type(+) and xrplv.count_key=xrlc.count_key(+) Custom LOVs of report parameters and upload columns added, with the last count of Blitz Report Update LOV Filter Before Display. AR Blitz Report LOVs قائمة القيم Blitz Report D Blitz Report LOVs Liste der Werte des Blitzberichts E Blitz Report LOVs Lista de valores del Informe Blitz F Blitz Report LOVs Liste des valeurs du rapport Blitz I Blitz Report LOVs Elenco dei valori del Blitz Report JA Blitz Report LOVs 電撃レポート値一覧 KO Blitz Report LOVs Blitz Report 값 목록 PTB Blitz Report LOVs Lista de valores do Relatório Blitz RU Blitz Report LOVs Блиц-список значений S Blitz Report LOVs Blitz Report-lista över värden TR Blitz Report LOVs Blitz Raporu değer listesi US Blitz Report LOVs Blitz Report lists of values: shared LOVs, and the custom LOVs of report parameters and upload columns. The count columns show the last result of the concurrent program Blitz Report Update LOV Filter Before Display, which sets filter before display on LOVs with more rows than its row limit and removes it from LOVs within the limit. ZHS Blitz Report LOVs 突击检查报告数值清单 Enginatics 1=1 1 5 1=1 xrplv.type=:type LOV custom select x.value, null description from ( select 1 sort, 'LOV' value from dual union all select 2 sort, 'Parameter' value from dual union all select 3 sort, 'Upload Column' value from dual ) x order by x.sort US Type LOV lists the shared LOVs, Parameter and Upload Column the custom LOVs of report parameters and upload columns. 2 10 1=1 lower(xrplv.lov_name) like lower(:lov_name)||'%' Char F Le nom de LOV commence par US LOV Name starts with 3 20 1=1 lower(xrplv.lov_query) like '%'||lower(:search_text)||'%' Char F Le texte SQL contient US SQL Text contains 4 30 1=1 lower(xrplv.lov_query) like '%'||lower(:search_text2)||'%' LOV FND Table or View Name 8E2FF36EDEFE79D2E0530100007F1FF2 select ft.table_name value, fav.application_name description from fnd_tables ft, fnd_application_vl fav where ft.application_id=fav.application_id union all select fv.view_name value, fav.application_name description from fnd_views fv, fnd_application_vl fav where fv.application_id=fav.application_id order by 1 F Basé sur le tableau US Based on Table 5 40 1=1 xrplv.lov_id in ( select xrpv.lov_id from xxen_report_parameters_v xrpv where xrpv.parameter_name=:parameter_name and xrpv.parameter_type='LOV' and xrpv.lov_id is not null ) LOV custom select distinct xrpv.parameter_name value, null description from xxen_report_parameters_v xrpv where xrpv.parameter_type='LOV' and xrpv.lov_id is not null order by xrpv.parameter_name F Utilisé par Paramètre US Used by Parameter 6 50 1=1 nvl(xrplv.filter_before_display,'N')=:filter_before_display 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 US Filter Before Display 7 60 1=1 xrplv.last_update_date>=sysdate-:days Number F Mise à jour dans les x jours US Updated within x Days 8 70 1=1 xrplv.last_update_date>=:date_from Date F Date de la dernière mise à jour du US Last Update Date From 9 80 1=1 xrplv.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 10 90 1=1 xrplv.lov_id in (select xrp.lov_id from xxen_report_parameters xrp where xrp.parameter_type='LOV' and xrp.lov_id is not null) LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual F Utilisé par un paramètre US Used by a Parameter 11 100 1=1 xrplv.lov_id not in (select xrp.lov_id from xxen_report_parameters xrp where xrp.parameter_type='LOV' and xrp.lov_id is not null) LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual F Non utilisé par aucun paramètre US Not Used by any Parameter