ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US 58D5B719827E6A37E053A100140A1EB0Y select era.application_name, errc.category_name, err.report_name, err.view_name, &execution_count err.description, dv.text, xxen_util.user_name(err.report_owner) report_owner, decode(err.seeded_flag,'Y', 'Yes','No') seeded_flag, decode(err.enable_report,'Y', 'Yes','No') enable_report, erv.user_view_name, erv.description view_description, xxen_util.user_name(err.created_by) created_by, err.creation_date, xxen_util.user_name(err.last_updated_by) last_updated_by, err.last_update_date, err.first_flag, err.last_flag, erv.view_owner from ( select case when min(err.creation_date) over (partition by err.view_id)=err.creation_date and min(err.report_id) over (partition by err.view_id,err.creation_date)=err.report_id then 'Y' end first_flag, case when max(err.creation_date) over (partition by err.view_id)=err.creation_date and max(err.report_id) over (partition by err.view_id,err.creation_date)=err.report_id then 'Y' end last_flag, err.* from xxeis.eis_rs_reports err ) err, xxeis.eis_rs_report_categories errc, xxeis.eis_rs_views erv, xxeis.eis_rs_applications era, ( select u.name owner, o.name view_name, xxen_util.long_to_clob('SYS.VIEW$', 'TEXT', v.rowid) text from sys."_CURRENT_EDITION_OBJ" o, sys.view$ v, sys.user$ u where o.obj#=v.obj# and o.owner#=u.user# ) dv where 1=1 and err.category_id=errc.category_id(+) and err.application_id=era.application_id and err.view_id=erv.view_id and erv.view_owner=dv.owner(+) and erv.view_name=dv.view_name(+) order by &execution_order_by era.application_name, errc.category_name, err.report_name US EIS Reports List of EIS reports. This can be used, for example, when migrating from EIS to Blitz Report, to show EIS reports with the database views they are based on, and which ones were used by the business. EIS &execution_count &execution_order_by 1=1 1 10 1=1 lower(dv.text) like '%'||lower(:search_text)||'%' Char F Voir les contenus SQL US View SQL Contains 2 20 1=1 err.first_flag='Y' LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual F Spectacle plus ancien à la séance uniquement US Show oldest per View only 3 40 1=1 err.last_flag='Y' LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual F Spectacle à la carte uniquement US Show latest per View only 4 50 &execution_count (select count(*) from xxeis.eis_rs_processes erp where err.report_id=erp.report_id and erp.creation_date>=sysdate-:submitted_within) executions, Number 180 F Nombre de jours d'exécution US Execution Count within Days 5 &execution_order_by executions desc, F Nombre de jours d'exécution US Execution Count within Days 6 100 1=1 nvl(err.seeded_flag,'N')=:seeded_flag LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description F Drapeau semé US Seeded Flag