VIEW: SYS.KU$_USER_EDITIONING_VIEW

Source

View Text - Preformatted

select u.user#,
         et.editionable_type
  from sys.user$ u, sys.v$editionable_types et, sys.user_editioning$ ue
  -- PACKAGE and TYPE are inclusive of BODY.
  where et.type# = ue.type# and ue.user# = u.user# and ue.type# not in (11, 14)

View Text - HTML Formatted

SELECT U.USER#
, ET.EDITIONABLE_TYPE
FROM SYS.USER$ U
, SYS.V$EDITIONABLE_TYPES ET
, SYS.USER_EDITIONING$ UE -- PACKAGE
AND TYPE ARE INCLUSIVE OF BODY.
WHERE ET.TYPE# = UE.TYPE#
AND UE.USER# = U.USER#
AND UE.TYPE# NOT IN (11
, 14)