ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN FA69660620698049E0530100007FD06FY select xxen_util.application_name(substr(xrv.report_name,1,instr(xrv.report_name,' ')-1)) application, nvl2(xwrv.web_report_name,'HYPERLINK("https://www.enginatics.com/reports/'||xwrv.web_report_name||'","'||replace(xrv.report_name,'"','""')||'")',xrv.report_name) report_name, nvl2(xwrv.example_file_name,'HYPERLINK("https://www.enginatics.com/example/'||xwrv.web_report_name||'","'||replace(xwrv.example_file_name,'"','""')||'")',null) example_file, nvl(xrv.type_dsp,'Report') type, &release_columns xrv.description, xrv.report_name report_name_sort from xxen_reports_v xrv, xxen_reports@demo xr, xxen_web_reports_v@demo xwrv where 1=1 and xrv.category like '%Enginatics%' and xrv.guid=xr.guid(+) and xr.report_id=xwrv.report_id(+) order by xrv.type_dsp, xrv.report_name US Enginatics Blitz Reports and Uploads Catalog of standard Enginatics uploads and reports. All Enginatics report details can be seen here: https://www.enginatics.com/library/?pg=1&category[]=Enginatics Enginatics &release_columns 1=1 1 10 1=1 xrv.report_name not like '% 11i' LOV custom Y select 'R12' value, null description from dual union all select '11i' value, null description from dual union all select 'both' value, null description from dual R12 R12 US EBS Version 2 1=1 xrv.category not like '%R12 only%' and not exists (select null from xxen_reports_v xrv2 where xrv2.report_name=xrv.report_name||' 11i' and xrv2.category like '%Enginatics%') 11i US EBS Version 3 1=1 (xrv.report_name not like '% 11i' or xrv.category not like '%R12 only%' and not exists (select null from xxen_reports_v xrv2 where xrv2.report_name=xrv.report_name||' 11i' and xrv2.category like '%Enginatics%')) both US EBS Version 4 &release_columns case when xrv.report_name not like '% 11i' then xxen_util.meaning('Y','YES_NO',0) end r12, case when xrv.category not like '%R12 only%' and not exists (select null from xxen_reports_v xrv2 where xrv2.report_name=xrv.report_name||' 11i' and xrv2.category like '%Enginatics%') then xxen_util.meaning('Y','YES_NO',0) end "11i", both US EBS Version 5 20 1=1 nvl(xrv.type_dsp,'Report')=:type LOV custom Y select nvl(xrv.type_dsp,'Report') value, count(*) description from xxen_reports_v xrv group by nvl(xrv.type_dsp,'Report') order by count(*) desc FSG;Report;Upload US Type DB78ABBE0D7D471379FD559E56CA8D6A MDS_Report_Listing_Sorted MARK.SPIRNAK 1 APPLICATION 2 5 DESCRIPTION 3 EXAMPLE_FILE 2 REPORT_NAME 4 TYPE 1 Y S Site 074AE6012268C86227BFD5A7349EAF2E One type per sheet ANDY.HAACK 2 APPLICATION 5 DESCRIPTION 4 EXAMPLE_FILE 3 REPORT_NAME 6 REPORT_NAME_SORT 4 1 TYPE -2 Y -3.0004 TYPE_DSP 1 Y S Site ENGINATICS 074AE6012268C86227BFD5A7349EAF2E MARIIA.KAPNIK 074AE6012268C86227BFD5A7349EAF2E ANDY.HAACK 074AE6012268C86227BFD5A7349EAF2E MARK.SPIRNAK DB78ABBE0D7D471379FD559E56CA8D6A MRUGESH.POOJARY 074AE6012268C86227BFD5A7349EAF2E