select j.obj#, o.obj_num, o.owner_name, o.name
from sys.ku$_schemaobj_view o, sys.jijoin$ j
where o.obj_num in (j.tab1obj#, j.tab2obj#)
group by j.obj#, o.obj_num, o.owner_name, o.name
order by o.obj_num
View Text - HTML Formatted
SELECT J.OBJ# , O.OBJ_NUM , O.OWNER_NAME , O.NAME
FROM SYS.KU$_SCHEMAOBJ_VIEW O , SYS.JIJOIN$ J
WHERE O.OBJ_NUM IN (J.TAB1OBJ# , J.TAB2OBJ#)
GROUP BY J.OBJ# , O.OBJ_NUM , O.OWNER_NAME , O.NAME
ORDER BY O.OBJ_NUM