XTR Admin - Audit Summary

Description
Categories: BI Publisher, Financials
Application: Treasury
Source: Admin - Audit Summary Report (XML)
Short Name: XTRAUSRM_XML
DB package: XTR_XTRAUSRM_XMLP_PKG
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
Parameter Name SQL text Validation
Display Debug
 
SQL Trace
 
Updated To
 
DateTime
Updated From
 
DateTime
Updated By
 
Column Changed
 
Transaction Reference
 
Event Type
 
Audit Request ID
 
Number