PL/SQL :: Audit Change In A Table?

We need to audit what data has changed from Vendor_B table when compared to Vendor_A table.

There is two tables:

a) VENDOR_A
b) VENDOR_B

VENDOR_A and VENDOR_B table does not share the same structure but have 1 column in common - the ID and may or may not having changed Coordinates.

We need to audit what coordinates has changed from Vendor_B data when compared to Vendor A and get the report back in the format of:

<pre>
               VENDOR_A VENDOR_B                    
ID     Change_date     LONGITUDE     LATITUDE     LONGITUDE     LATITUDE     
873     1/02/2013     -33.46711315     151.3195056     -33.46211316     151.3245057          
694     3/02/2013     -33.46721315     151.3198056     -33.46214312     151.3265053     

</pre>
---------------------------------------------------------------------------------------------------------------------------------------------------
--Found a sample query from Ask Tom but I am not sure how I can apply them to get the structure above.
---------------------------------------------------------------------------------------------------------------------------------------------------
<pre>
create table base_tab (pk number, column1 number, column2 varchar2(30), column3 date);
Create table refresh_tab (pk number, column1 number, column2 varchar2(30), column3 date);
Create table diff (pk number, column1 number, column2 varchar2(30), column3 date, base_tab number,
refresh_tab number, action varchar2(30));

[Code] .....

--clean out the differences table
truncate table diff;

--------------------------------
-- build the difference data
------------------------------------
insert into diff select pk,column1,column2, column3,
count(src1) base_tab, count(src2) refresh_tab, null action
from
( select a.*,

[Code]....