VIEW: SYS.DBA_XML_NESTED_TABLES

Source

View Text - Preformatted

select x.OWNER,
       x.TABLE_NAME,
       NESTED_TABLE_NAME
  from DBA_XML_TABLES x,
       (
         select TABLE_NAME NESTED_TABLE_NAME,
                connect_by_root PARENT_TABLE_NAME PARENT_TABLE_NAME, OWNER
           from DBA_NESTED_TABLES nt
                connect by prior TABLE_NAME = PARENT_TABLE_NAME
                       and OWNER = OWNER
       ) nt
 where x.TABLE_NAME = nt.PARENT_TABLE_NAME
   and x.OWNER = nt.OWNER

View Text - HTML Formatted

SELECT X.OWNER
, X.TABLE_NAME
, NESTED_TABLE_NAME
FROM DBA_XML_TABLES X
, ( SELECT TABLE_NAME NESTED_TABLE_NAME
, CONNECT_BY_ROOT PARENT_TABLE_NAME PARENT_TABLE_NAME
, OWNER
FROM DBA_NESTED_TABLES NT CONNECT BY PRIOR TABLE_NAME = PARENT_TABLE_NAME
AND OWNER = OWNER ) NT
WHERE X.TABLE_NAME = NT.PARENT_TABLE_NAME
AND X.OWNER = NT.OWNER