ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEFE79D2E0530100007F1FF2 FND Table or View Name Y 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 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 6BFCF276C844675EE0530100007FC56C select xrplv.lov_name, xrplv.description, xxen_util.meaning(xrplv.validate_from_list,'YES_NO',0) validate_from_list, xxen_util.meaning(xrplv.filter_before_display,'YES_NO',0) filter_before_display, 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 from ( select (select count(*) from xxen_report_parameters xrp where xrp.parameter_type='LOV' and xrplv.lov_id=xrp.lov_id) usage_count, xrplv.* from xxen_report_parameter_lovs_v xrplv ) xrplv where 1=1 Y 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 list of values ZHS Blitz Report LOVs 突击检查报告数值清单 Enginatics 1=1 1 10 1=1 lower(xrplv.lov_name) like lower(:lov_name)||'%' Char F Le nom de LOV commence par US LOV Name starts with 2 20 1=1 lower(xrplv.lov_query) like '%'||lower(:search_text)||'%' Char F Le texte SQL contient US SQL Text contains 3 30 1=1 lower(xrplv.lov_query) like '%'||lower(:search_text2)||'%' LOV FND Table or View Name 8E2FF36EDEFE79D2E0530100007F1FF2 Y 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 4 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 Y 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 5 50 1=1 xrplv.last_update_date>=sysdate-:days Number F Mise à jour dans les x jours US Updated within x Days 6 60 1=1 xrplv.last_update_date>=:date_from Date F Date de la dernière mise à jour du US Last Update Date From 7 70 1=1 xrplv.last_updated_by=xxen_util.user_id(:last_updated_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 Dernière mise à jour par US Last Updated By 8 80 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 Y 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 9 90 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 Y 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