Query to Find an Object Type

 The relevant query is as follows:

SELECT object_type

FROM   user_objects

WHERE object_name = ‘<OBJECT_NAME>’;