DBA - Synonyms

As you may know, the user_objects, all_objects and sys_objects views do not always show the correct status for synonyms.
They may show Valid for synonyms with a missing object, or Invalid for synonyms that do have an object.

Seems a bit strange at first, but it is not illogical I suppose.
It is confusing however, so I built a query for this. Not sure if it is 100% OK, but it served my purpose.

A source with useful info:
https://forums.oracle.com/ords/apexds/post/synonym-with-base-objects-dropped-9727

My query:

select obj.owner
      ,obj.object_name
      ,obj.object_type
      ,obj.status
      ,(case
          when obj.object_type = 'SYNONYM'
               and obj2.object_id is null then
           'INVALID'
          else
           obj.status
       end) as status_2
      ,obj2.owner as object_owner_syn
      ,obj2.object_name as object_name_syn
      ,obj2.object_type as object_type_syn
  from all_objects obj
  left join all_synonyms syn on (syn.synonym_name = obj.object_name and obj.object_type = 'SYNONYM')
  left join all_objects obj2 on (obj2.owner = syn.table_owner and obj2.object_name = syn.table_name)
where obj.oracle_maintained <> 'Y' -- do not show standard Oracle users
 and (    (obj.status = 'VALID'   and obj.object_type = 'SYNONYM' and obj2.object_id is     null)
       or (obj.status = 'INVALID' and obj.object_type = 'SYNONYM' and obj2.object_id is not null)
     ) -- show differences only
order by obj.owner
      ,obj.object_name
      ,obj.object_type

(In)valid Synonyms