SYS_PLSQL_NNN_A_B objects

SYS_PLSQL_objects.sql

select 
 o.obj#  , o.owner# , o.name , o.namespace,
 o.type# , o.ctime  , o.stime, o.status,
 o.flags , o.oid$   , o.signature,
  --o.dflcollid,
  'type' d,
  t.typecode,t.hashcode,
  'coll',
  c.*
  ,s.*
from sys.obj$ o, sys.user$ u,sys.type$ t,sys.collection$ c, sys.source$ s
where 1=1
and u.name='&OWNER'
and o.owner#=u.user#
and o.oid$ = t.tvoid(+)
and c.toid(+) = t.tvoid
and o.flags=1048576
and o.type# in (10,13)
and o.obj#=s.obj#(+)
/