Query to Check for Existence Of Any Object In The Database

The relevant query is as follows:

SELECT owner, object_type

FROM     all_objects

WHERE  object_name = ‘<OBJECT_NAME>’;

   ie. object_name = PO_HEADERS_ALL

            OWNER                        OBJECT_TYPE

            ----------------------------------------------------------

            APPS_APPDEMO          SYONONYM

            PODEMO                      TABLE