Blitz Report Number Format Validation

select 'Report' level_, report_name name, number_format from  xxen_reports_v xr
where
1=1 and
xr.report_id in (select xrv.report_id from xxen_reports_v xrv where xrv.report_name not like 'DBA%')
union
select
'Column' level_,
xrc.column_name name,
xrc.number_format
from
xxen_report_columns xrc
where
2=2 and
(
xrc.column_name like '%amount%' or
xrc.column_name like '%amt%' or
xrc.column_name like '%budget%' or
xrc.column_name like '%balance%' or
xrc.column_name like '%actual%' or
xrc.column_name like '%cost%' or
xrc.column_name like '%gl%' or
xrc.column_name like '%rec%' or
xrc.column_name like '%rev%' or
xrc.column_name like '%mtd%' or
xrc.column_name like '%ytd%' or
xrc.column_name like '%ptd%' or
xrc.column_name like '%payment%' or
xrc.column_name like '%transaction%'
)

select 'Report' level_, report_name name, number_format from xxen_reports_v xr where 1=1 and xr.report_id in (select xrv.report_id from xxen_reports_v xrv where xrv.report_name not like 'DBA%') union select 'Column' level_, xrc.column_name name, xrc.number_format from xxen_report_columns xrc where 2=2 and ( xrc.column_name like '%amount%' or xrc.column_name like '%amt%' or xrc.column_name like '%budget%' or xrc.column_name like '%balance%' or xrc.column_name like '%actual%' or xrc.column_name like '%cost%' or xrc.column_name like '%gl%' or xrc.column_name like '%rec%' or xrc.column_name like '%rev%' or xrc.column_name like '%mtd%' or xrc.column_name like '%ytd%' or xrc.column_name like '%ptd%' or xrc.column_name like '%payment%' or xrc.column_name like '%transaction%' )