VIEW: SYS.DBA_EXPORT_OBJECTS

Source

View Text - Preformatted

select unique a.htype,a.name,a.descrip,
 case
  when exists (select 1 from sys.metafilter$ f
                 where f.filter='NAME'
                 and f.type=regexp_substr(a.name,'[A-Z_]+$')) then 'Y'
  else 'N'
 end
 from sys.metanametrans$ a
 where a.descrip is not null order by a.htype,a.name

View Text - HTML Formatted

SELECT UNIQUE A.HTYPE
, A.NAME
, A.DESCRIP
, CASE WHEN EXISTS (SELECT 1
FROM SYS.METAFILTER$ F
WHERE F.FILTER='NAME'
AND F.TYPE=REGEXP_SUBSTR(A.NAME
, '[A-Z_]+$')) THEN 'Y' ELSE 'N' END
FROM SYS.METANAMETRANS$ A
WHERE A.DESCRIP IS NOT NULL ORDER BY A.HTYPE
, A.NAME