ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEFA79D2E0530100007F1FF2 Blitz Report Category Y select xrcv.category value, (select count(*) from xxen_report_category_assigns xrca where xrcv.category_id=xrca.category_id) description from xxen_report_categories_v xrcv order by xrcv.category US 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 B04763D730F050D7E0530100007F06B3 Blitz Report Name (wildcard) 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 order by xrv.report_name US 4B97338EC1653A4BE0630100007F0448 select xrv.report_name, xxen_api.category(xrsc.id) category, nvl(xrv.type_dsp,'Report') type, xrsc.column_number, xxen_report.column_translation(xrsc.column_name) column_header, lower(xrsc.column_name) column_name, xrsc.data_type from xxen_report_sql_columns xrsc, xxen_reports_v xrv where 1=1 and xrsc.id=xrv.report_id order by xrv.report_name, xrsc.column_number Removed description/report_id, reordered column_header before column_name, added lower() for column_name, added Report Type parameter, added multi-value for Category Y XXEN_REPORT_COLS US Blitz Report Columns Report showing all SQL columns of selected Blitz Reports by parsing their SQL on the fly. Use the Category or Report Name parameters to scope the results. Running without filters will parse all enabled reports, which may take several minutes. Enginatics 1=1 1 10 1=1 xrv.report_id in ( select xrca.report_id from xxen_report_categories_v xrcv, xxen_report_category_assigns xrca where xrcv.category=:p_category and xrcv.category_id=xrca.category_id ) LOV Blitz Report Category 8E2FF36EDEFA79D2E0530100007F1FF2 Y select xrcv.category value, (select count(*) from xxen_report_category_assigns xrca where xrcv.category_id=xrca.category_id) description from xxen_report_categories_v xrcv order by xrcv.category US Category 2 20 1=1 nvl(xrv.type_dsp,'Report')=:p_report_type LOV custom Y select distinct nvl(xrv.type_dsp,'Report') value, null description from xxen_reports_v xrv order by 1 US Report Type 3 30 1=1 xrv.report_name=:p_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 4 40 1=1 xrv.report_name like :p_report_name_like LOV Blitz Report Name (wildcard) B04763D730F050D7E0530100007F06B3 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 order by xrv.report_name US Report Name like 5 50 1=1 lower(xxen_report.column_translation(xrsc.column_name)) like '%'||lower(:p_column_header)||'%' US Column Header contains