Blitz Report Category Assignment Upload

Description

Categories: Enginatics, Upload
Repository: Github

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.

- Cre ... more

Copy

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(+)

Parameter Name

SQL text

Validation

Upload Mode

LOV

Create Empty File

LOV

Report Name starts with

lower(xrv.report_name) like lower(:report_name_like)||'%'

LOV

Report Category

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
)