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 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 E811F942597A2075E0530100007FF4F2 Blitz Upload Mode Y select xxen_upload.action_create id, xxen_upload.action_meaning(xxen_upload.action_create) value, null description from dual union all select xxen_upload.action_create || ',' || xxen_upload.action_update id, xxen_upload.action_meaning(xxen_upload.action_create)||', '||xxen_upload.action_meaning(xxen_upload.action_update) value, null description from dual US 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US ED8DCCD3582D4071B4D4C4E93A5D1095Y select null action_, null status_, null message_, null modified_columns_, xrv.report_name, xrv.type_dsp type, xrcav.category, xxen_util.user_name(xrcav.created_by) created_by, xxen_util.client_time(xrcav.creation_date) creation_date, null delete_, null upload_row from xxen_reports_v xrv, (select xrcav.* from xxen_report_category_assigns_v xrcav where :p_upload_mode<>'C') xrcav where 1=1 and nvl(xrv.type,'x')<>'S' and nvl(:p_create_empty_file,'x')<>'Y' and xrv.report_id=xrcav.report_id(+) Initial version of the Blitz Report Category Assignment Upload. U A xxen_report_upload.create_update_category_assignment US Blitz Report Category Assignment Upload Upload to maintain Blitz Report category assignments - the categories that reports and uploads are grouped under. Run modes: - Create with 'Create Empty File' = Yes: opens an empty Excel file to enter new report and category rows. - Create with 'Create Empty File' = blank: queries a list of reports (by name, category or type) as blank rows to assign categories to. - Create, Update: queries existing category assignments, which can be removed by setting the Delete column to Yes. Enter any Category name. If the category does not exist yet, it is created automatically in all installed languages and the report is assigned to it. Set Delete = Yes to remove a report from a category; the category itself is kept even if it becomes empty. Enginatics Upload 1=1 :p_create_empty_file :p_upload_mode 1 10 :p_upload_mode LOV Blitz Upload Mode E811F942597A2075E0530100007FF4F2 Y select xxen_upload.action_create id, xxen_upload.action_meaning(xxen_upload.action_create) value, null description from dual union all select xxen_upload.action_create || ',' || xxen_upload.action_update id, xxen_upload.action_meaning(xxen_upload.action_create)||', '||xxen_upload.action_meaning(xxen_upload.action_update) value, null description from dual C Y US Upload Mode 2 20 :p_create_empty_file LOV custom Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual where :$flex$.upload_mode='C' case when :$flex$.upload_mode='C' and :$flex$.report_name_starts_with is null then 'Y' end US Create Empty File 3 30 1=1 lower(xrv.report_name) like lower(: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 starts with 4 40 1=1 xrv.report_id in ( select xrca.report_id from xxen_report_category_assigns xrca, xxen_report_categories_v xrcv where xrcv.category=: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 Report Category 5 50 1=1 xrv.type_dsp=:type LOV custom Y select xrv.type_dsp value, count(*) description from xxen_reports_v xrv where :$flex$.create_empty_file is null group by xrv.type_dsp order by count(*) desc US Report Type :$flex$.create_empty_file Create Empty File Report Type :$flex$.report_name_starts_with Report Name starts with Create Empty File :$flex$.upload_mode Upload Mode Create Empty File 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 MODIFIED_COLUMNS_ Char varchar2 Y 5 REPORT_NAME LOV custom varchar2 240 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' order by xrv.report_name select xrv.report_id id, xrv.report_name value from xxen_reports_v xrv Y 6 TYPE Char varchar2 9 select xrv.type_dsp from xxen_reports_v xrv where xrv.report_name=:$column$.report_name Y 7 CATEGORY LOV custom varchar2 120 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 Y 8 CREATED_BY Char varchar2 Y 9 CREATION_DATE Date date Y 10 DELETE_ LOV varchar2 Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual 11 UPLOAD_ROW Char varchar2 Y U 1 status_ out Char STATUS_CODE_ U 2 message_ out Char MESSAGE_ U 3 p_report_id in Number REPORT_NAME U 4 p_category in Char CATEGORY U 5 p_delete in Char DELETE_ Error SQL Order By upload_row, report_name, category Success SQL select null action_, xu.status_, xu.message_, xu.modified_columns_, nvl(xrv.report_name,xu.report_name) report_name, nvl(xrv.type_dsp,xu.type) type, nvl(xrcv.category,xu.category) category, xxen_util.user_name(xrca.created_by) created_by, xxen_util.client_time(xrca.creation_date) creation_date, xu.delete_, xu.upload_row from xxen_blitz_report_categ_3829_u xu, xxen_reports_v xrv, xxen_report_categories_v xrcv, xxen_report_category_assigns xrca where xu.status_code_='S' and xu.report_name=xrv.report_name(+) and xu.category=xrcv.category(+) and xrv.report_id=xrca.report_id(+) and xrcv.category_id=xrca.category_id(+) Default value :$column$.report_name REPORT_NAME TYPE