DBA Data[Home] [Help]

APPS.AD_ZD dependencies on OBJ$

Line 445: sys.obj$ obj

441: 14, 'TYPE BODY', 'ERROR') object_type
442: , obj.namespace namespace
443: , obj.obj# object_id
444: from
445: sys.obj$ obj
446: , ( select
447: xusr.user#
448: , xusr.ext_username user_name
449: , ed.name edition_name

Line 452: , (select * from sys.obj$

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
456: select

Line 462: , (select * from sys.obj$ where owner#=0 and type#=57) ed

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)
466: and obj.remoteowner is null ) co