DBA Data[Home] [Help]

APPS.AD_ZD_PREP dependencies on REGISTRY$

Line 2100: from sys.registry$ r,

2096: and du.editions_enabled = 'N'
2097: and du.username = fou.oracle_username
2098: and not exists
2099: (select u.name
2100: from sys.registry$ r,
2101: sys.user$ u
2102: where r.status in (1,3,5)
2103: and r.namespace = 'SERVER'
2104: and r.schema# = u.user#

Line 2108: from sys.registry$ r,

2104: and r.schema# = u.user#
2105: and u.name = du.username
2106: union
2107: select u.name
2108: from sys.registry$ r,
2109: sys.registry$schemas s,
2110: sys.user$ u
2111: where r.status in (1,3,5)
2112: and r.namespace = 'SERVER'

Line 2109: sys.registry$schemas s,

2105: and u.name = du.username
2106: union
2107: select u.name
2108: from sys.registry$ r,
2109: sys.registry$schemas s,
2110: sys.user$ u
2111: where r.status in (1,3,5)
2112: and r.namespace = 'SERVER'
2113: and r.cid = s.cid