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 |
