SYSTEM.AD_INVOKER dependencies on OBJ$

Line 13: from fnd_oracle_userid fou, sys.user$ u, sys.obj$ o, sys.procedure$ p

9: select /*+ ORDERED */
10: u.name owner, o.name object_name,
11: decode(o.type#, 7, 'PROCEDURE', 8, 'FUNCTION', 9, 'PACKAGE', '??')
12: object_type
13: from fnd_oracle_userid fou, sys.user$ u, sys.obj$ o, sys.procedure$ p
14: where fou.read_only_flag = 'U'
15: and fou.install_group_num = 1
16: and u.name = fou.oracle_username
17: and o.owner# = u.user#

Line 28: from sys.obj$ o, ad_timestamps t, fnd_oracle_userid fou, sys.user$ u,

24: select /*+ FULL(o), ORDERED */
25: u.name owner, o.name object_name,
26: decode(o.type#, 7, 'PROCEDURE', 8, 'FUNCTION', 9, 'PACKAGE', '??')
27: object_type
28: from sys.obj$ o, ad_timestamps t, fnd_oracle_userid fou, sys.user$ u,
29: sys.procedure$ p
30: where fou.read_only_flag = 'U'
31: and fou.install_group_num = 1
32: and u.name = fou.oracle_username