SELECT LPAD(' ', (A.NIVEL - 1) * 2) || OBJ.NAME A,
LPAD(' ', (A.NIVEL - 1) * 2) || CONS.NAME B
FROM SYS.OBJ$ OBJ,
SYS.CON$ CONS,
(SELECT OBJ# OBJ#, CON#, LEVEL NIVEL
FROM SYS.CDEF$
WHERE RCON# IS NOT NULL AND ROBJ# IS NOT NULL
CONNECT BY ROBJ# = PRIOR OBJ# AND ROBJ# != OBJ# AND
PRIOR ROBJ# != PRIOR OBJ#
START WITH ROBJ# = (SELECT OBJ#
FROM SYS.OBJ$
WHERE NAME = UPPER('fnd_concurrent_requests') AND TYPE# = 2 AND
OWNER# = USERENV('SCHEMAID'))) A
WHERE CONS.CON# = A.CON# AND OBJ.OBJ# = A.OBJ# AND OBJ.TYPE# = 2
UNION ALL
SELECT LPAD(' ', (A.NIVEL - 1) * 2) || OBJ.NAME A, TO_CHAR(NULL)
FROM SYS.OBJ$ OBJ,
(SELECT D_OBJ# OBJ#, LEVEL NIVEL
FROM SYS.DEPENDENCY$
CONNECT BY P_OBJ# = PRIOR D_OBJ#
START WITH P_OBJ# = (SELECT OBJ#
FROM SYS.OBJ$
WHERE NAME = UPPER('fnd_concurrent_requests') AND
OWNER# = USERENV('SCHEMAID'))) A
WHERE OBJ.OBJ# = A.OBJ# AND OBJ.TYPE# != 2
Showing posts with label Dependent objects. Show all posts
Showing posts with label Dependent objects. Show all posts
Subscribe to:
Posts (Atom)
Troubleshooting ACFS-07981: Metadata Validation Errors
Troubleshooting ACFS-07981: Metadata Validation Errors Introduction The ACFS-07981 error indicates that an attempt to run an online file ...
-
ORA-00221 Error on write to controlfile Possible Causes and Solutions An error has occurred when trying to create the control file, or on su...
-
How to change password in Oracle Transportation Management(OTM) If you want to change other usernames/passwords, then the list expands be...
-
Mastering ORA-00054: Resolving the "Resource Busy" Error The ORA-00054 error, often accompanied by the message "resource b...