SQL Query for Supplier Audit Trail Report
My requirement is to create a report based on the supplier audit tables that got created by Audit trail setups on Payables AP_SUPPLIERS and AP_SUPPLIER_SITES_ALL tables.
I have added all the columns that needs to be audited to this audit group. The Audit tables AP_SUPPLIERS_A, AP_SUPPLIER_SITES_ALL_A stores just the old value of the columns changed.
and i can pull the changed values (new values) from the corresponding views AP_SUPPLIERS_AC1 and AP_SUPPLIER_SITES_ALL_AC1 respectively.
So in the report, for each supplier, I want to show all the columns that needs auditing (Supplier Name, Supplier Vendor site code, Address, Paygroup) in the rows and all old and new values in the column wise
I have added all the columns that needs to be audited to this audit group. The Audit tables AP_SUPPLIERS_A, AP_SUPPLIER_SITES_ALL_A stores just the old value of the columns changed.
and i can pull the changed values (new values) from the corresponding views AP_SUPPLIERS_AC1 and AP_SUPPLIER_SITES_ALL_AC1 respectively.
So in the report, for each supplier, I want to show all the columns that needs auditing (Supplier Name, Supplier Vendor site code, Address, Paygroup) in the rows and all old and new values in the column wise
0