APPS.AD_ZD dependencies on USER$

Line 451: (select * from sys.user$ where type# = 2) xusr

447: xusr.user#
448: , xusr.ext_username user_name
449: , ed.name edition_name
450: from
451: (select * from sys.user$ where type# = 2) xusr
452: , (select * from sys.obj$
453: where owner# = 0 and type# = 57) ed
454: where xusr.spare2 = ed.obj#
455: union

Line 461: (select * from sys.user$ where type#=1 or user#=1) busr

457: busr.user#
458: , busr.name user_name
459: , ed.name edition_name
460: from
461: (select * from sys.user$ where type#=1 or user#=1) busr
462: , (select * from sys.obj$ where owner#=0 and type#=57) ed
463: where ed.name = 'ORA$BASE' ) eusr
464: where obj.owner# = eusr.user#
465: and obj.type# not in (10, 0, 88)