XTR Admin - Audit Summary

select ausum.AUDIT_RECORDS_FROM, ausum.AUDIT_RECORDS_TO, ausum.NAME_OF_COLUMN_CHANGED, ausum.TABLE_NAME, ausum.NEW_VALUE, ausum.NON_TRANSACTION_REF, ausum.OLD_VALUE,REFERENCE_CODE, ausum.TRANSACTION_REF, ausum.UPDATED_BY_USER, ausum.UPDATED_ON_DATE, auset.EVENT_NAME
		 from XTR_AUDIT_SUMMARY_V ausum, XTR_SETUP_AUDIT_REQMTS_V auset
		 where 
		ausum.AUDIT_REQUEST_ID = nvl(:P_AUDIT_REQUEST_ID, ausum.AUDIT_REQUEST_ID)
		and nvl( ausum.REFERENCE_CODE, '%') like nvl(:P_REFERENCE_CODE,'%')
		and ausum.TABLE_NAME like nvl(:P_EVENT_TYPE,'%')
		and nvl(ausum.NAME_OF_COLUMN_CHANGED, '%') like nvl(:P_COLUMN_CHANGED,'%')
		and nvl(ausum.UPDATED_BY_USER, '%')  like nvl(:P_UPDATE_BY,'%')
		and (trunc(to_date(ausum.updated_on_date,'DD/MM/YYYY HH24:MI:SS')) between :P_A_REQUEST_FROM and :P_A_REQUEST_TO)
		and auset.table_name = ausum.table_name
		ORDER BY 
		12 ASC,4 ASC,8 ASC , non_transaction_ref desc , table_name , to_date ( updated_on_date , 'DD/MM/YYYY HH24:MI:SS' ) desc