select 
object_name,
user_name,
object_id,
start_time,
object_folder_path

from
(
select start_time,
     user_name,
     object_id,
     object_name,
     object_folder_path,
     top_folder_name,
     top_folder_id,
     event_detail_value,
     row_number() over (partition by  object_id, object_name,user_name,object_folder_path,top_folder_name,top_folder_id 
     order by start_time desc) my_row_number

      from(

  select ae.start_time,
         ae.user_name,
         ae.object_id,
         ae.object_name,
         ae.object_folder_path,
         ae.top_folder_name,
         ae.top_folder_id,
         event_detail_value event_detail_value
    from ADS_EVENT ae, ADS_EVENT_DETAIL ad 

   where 
   ae.object_type_id in ('AYfjfcAV7cNPh33akDfm2RE') and ae.event_id = ad.event_id
)b) a

where my_row_number=1