SELECT "OBJ#","OWNER","OBJNAME","TYPE#","NAMESPACE","STATUS","EDITION_NAME" FROM utl_recomp_all_objects
WHERE status IN (4, 5, 6)
AND obj# NOT IN (SELECT obj# FROM utl_recomp_compiled)
View Text - HTML Formatted
SELECT "OBJ#" , "OWNER" , "OBJNAME" , "TYPE#" , "NAMESPACE" , "STATUS" , "EDITION_NAME" FROM UTL_RECOMP_ALL_OBJECTS
WHERE STATUS IN (4 , 5 , 6)
AND OBJ# NOT IN (SELECT OBJ# FROM UTL_RECOMP_COMPILED)