Blitz Report Category Assignments

select
xrv.report_name,
xrcv.category,
xxen_util.user_name(xrca.created_by) created_by,
xrca.creation_date
from
xxen_reports_v xrv,
xxen_report_category_assigns xrca,
xxen_report_categories_v xrcv
where
1=1 and
xrv.report_id=xrca.report_id and
xrca.category_id=xrcv.category_id
order by
xrv.report_name,
xrcv.category

select xrv.report_name, xrcv.category, xxen_util.user_name(xrca.created_by) created_by, xrca.creation_date from xxen_reports_v xrv, xxen_report_category_assigns xrca, xxen_report_categories_v xrcv where 1=1 and xrv.report_id=xrca.report_id and xrca.category_id=xrcv.category_id order by xrv.report_name, xrcv.category