select tabobjno, typeobjno, typename, typeowner
from ku$_table_types_view
UNION ALL
select tabobjno, typeobjno, typename, typeowner
from ku$_xmlschema_types_view
View Text - HTML Formatted
SELECT TABOBJNO , TYPEOBJNO , TYPENAME , TYPEOWNER
FROM KU$_TABLE_TYPES_VIEW
UNION ALL
SELECT TABOBJNO , TYPEOBJNO , TYPENAME , TYPEOWNER
FROM KU$_XMLSCHEMA_TYPES_VIEW