select
  owner OBJECT_OWNER,
  object_name,
  object_type,
  status 
from dba_objects
where object_type in
      ('FUNCTION','PACKAGE','PACKAGE BODY','PROCEDURE','TRIGGER','VIEW')
  and owner not in ('SYS','SYSTEM','WMSYS') 
  and status = 'INVALID'
  order by owner,object_type,object_name
