VIEW: SYS.IMP10TYPUSED

Source

View Text - Preformatted

SELECT u.name, o_tab.name, o_typ.oid$
        FROM   sys.obj$ o_tab, sys.user$ u, sys.obj$ o_typ, sys.dependency$ d
        WHERE d.p_obj# = o_typ.obj#
        AND d.d_obj# = o_tab.obj#
        AND o_tab.type# = 2
        AND o_tab.owner# = u.user#

View Text - HTML Formatted

SELECT U.NAME
, O_TAB.NAME
, O_TYP.OID$
FROM SYS.OBJ$ O_TAB
, SYS.USER$ U
, SYS.OBJ$ O_TYP
, SYS.DEPENDENCY$ D
WHERE D.P_OBJ# = O_TYP.OBJ#
AND D.D_OBJ# = O_TAB.OBJ#
AND O_TAB.TYPE# = 2
AND O_TAB.OWNER# = U.USER#