Query to Get Database Registry listing database comnponents in use

SELECT comp_name "Component Name"

,      comp_id   "Component ID"

,      version   "Version"

,      status    "Status"

,      namespace xonly_namespace

,      modified  "Modified"

,      schema    xonly_schema

,      procedure xonly_procedure

FROM   dba_registry

ORDER BY 1,2,3