What do you mean by "Activity"? Inventory transactions? Do you have Locations?
 
If the duplicates are only on the BKICMSTR, to fix them you will have to do it manually: add the quantity on hand then delete one of the records.
 
check for more duplicates:
 
select distinct BKIC_PROD_CODE  from BKICMSTR
group by BKIC_PROD_CODE
having count(BKIC_PROD_CODE ) > 1
order by BKIC_PROD_CODE  
 
do the same for the MTICMSTR table
 
check this post
http://www.istechforum.com/YaBB.pl?num=1281714671/8#8