ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEA879D2E0530100007F1FF2 Blitz Report Name 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 nvl(xrv.type,'x')<>'S' and (fnd_profile.value('XXEN_REPORT_ACCESS')='S' or nvl(xrv.type,'x')<>'U') order by xrv.report_name US 18CC3AA7B701B2E0E0630100007F8C79 select xrv.report_name, xrv.type_dsp type, xrv.category, xrt.template_name, xxen_util.meaning(nvl2(xrdt.user_id,null,'Y'),'YES_NO',0) global_default, xxen_util.user_name(xrdt.user_id) user_name, xxen_util.user_name(xrdt.created_by) created_by, xxen_util.client_time(xrdt.creation_date) creation_date, xxen_util.user_name(xrdt.last_updated_by) last_updated_by, xxen_util.client_time(xrdt.last_update_date) last_update_date from xxen_reports_v xrv, xxen_report_default_templates xrdt, xxen_report_templates xrt where 1=1 and xrv.report_id=xrdt.report_id and xrdt.template_id=xrt.template_id(+) order by xrv.report_name, nvl2(xrdt.user_id,null,'Y'), user_name Y US Blitz Report Default Templates Enginatics 1=1 1 10 1=1 xrv.report_name=:report_name LOV Blitz Report Name 8E2FF36EDEA879D2E0530100007F1FF2 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 nvl(xrv.type,'x')<>'S' and (fnd_profile.value('XXEN_REPORT_ACCESS')='S' or nvl(xrv.type,'x')<>'U') order by xrv.report_name US Report Name