DBA_NESTED_TABLES

Description of nested tables contained in all tables

Columns
   ___________________________
 
   OWNER
      Owner of the nested table
   TABLE_NAME
      Name of the nested table
   TABLE_TYPE_OWNER
      Owner of the type of which the nested table was created
   TABLE_TYPE_NAME
      Name of the type of the nested table
   PARENT_TABLE_NAME
      Name of the parent table containing the nested table
   PARENT_TABLE_COLUMN
      Column name of the parent table that corresponds to the nested table
   STORAGE_SPEC
      --
   RETURN_TYPE
      --
   ELEMENT_SUBSTITUTABLE
      Indication of whether the nested table element is substitutable or not

Related:

DBA_OBJECT_TABLES