Blitz Report Default Templates

select
xrv.report_name,
xrv.type_dsp type,
xrv.category,
xrt.template_name,
xxen_util.meaning(nvl2(xrdt.user_id,null,'Y'),'YES_NO',0) global_default,
xxen_util.user_name(xrdt.user_id) user_name,
xxen_util.user_name(xrdt.created_by) created_by,
xxen_util.client_time(xrdt.creation_date) creation_date,
xxen_util.user_name(xrdt.last_updated_by) last_updated_by,
xxen_util.client_time(xrdt.last_update_date) last_update_date
from
xxen_reports_v xrv,
xxen_report_default_templates xrdt,
xxen_report_templates xrt
where
1=1 and
xrv.report_id=xrdt.report_id and
xrdt.template_id=xrt.template_id(+)
order by
xrv.report_name,
nvl2(xrdt.user_id,null,'Y'),
user_name

select xrv.report_name, xrv.type_dsp type, xrv.category, xrt.template_name, xxen_util.meaning(nvl2(xrdt.user_id,null,'Y'),'YES_NO',0) global_default, xxen_util.user_name(xrdt.user_id) user_name, xxen_util.user_name(xrdt.created_by) created_by, xxen_util.client_time(xrdt.creation_date) creation_date, xxen_util.user_name(xrdt.last_updated_by) last_updated_by, xxen_util.client_time(xrdt.last_update_date) last_update_date from xxen_reports_v xrv, xxen_report_default_templates xrdt, xxen_report_templates xrt where 1=1 and xrv.report_id=xrdt.report_id and xrdt.template_id=xrt.template_id(+) order by xrv.report_name, nvl2(xrdt.user_id,null,'Y'), user_name