ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US 35CCA892508E857FE06362FB09053195Y 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%' ) US Blitz Report Number Format Validation 1=1 2=2 1 10 1=1 (xr.number_format not like '%##0.00' and xr.number_format not like '%##0.00)' and xr.number_format not like '%##0.000' and xr.number_format not like '%##0.000)') LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US Apart from 3 decimal 2 2=2 (xrc.number_format not like '%##0.00' and xrc.number_format not like '%##0.00)' and xrc.number_format not like '%##0.000' and xrc.number_format not like '%##0.000)') US Apart from 3 decimal