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 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US EA0A1BA904720BD6E0530100007F7841 select xrtv.report_name, xrtv.category, xrtv.template_name, nvl2(xrtc.template_id,'column exists','corrupt') template_column_check, xrtp.column_name, xrtp.field_type, xrtp.display_sequence, xrtp.aggregation, xxen_util.user_name(xrtp.created_by) created_by, xxen_util.client_time(xrtp.creation_date) creation_date, xxen_util.user_name(xrtp.last_updated_by) last_updated_by, xxen_util.client_time(xrtp.last_update_date) last_update_date, xrtp.template_id from xxen_report_templates_v xrtv, xxen_report_template_pivot xrtp, xxen_report_template_columns xrtc where 1=1 and xrtv.template_id=xrtp.template_id and xrtp.template_id=xrtc.template_id(+) and xrtp.column_name=xrtc.column_name(+) order by xrtv.category, xrtv.report_name, xrtv.template_name, xrtp.column_name Y US Blitz Report Pivot Colums Validation Checks if records in xxen_report_template_pivot have a corresponding record in xxen_report_template_columns Enginatics 1=1 1 10 1=1 xrtv.report_id in (select xrcav.report_id from xxen_report_category_assigns_v xrcav where xrcav.category=:category) 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 Discoverer US Category 2 20 1=1 xrtc.template_id is null LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Y US Show missing only