Find out the relevent table name of a given constraint

Below query can be used to get the table name for a given constraint.This will help you to find out dependencies very easily.

SELECT TABLE_NAME
FROM ALL_CONSTRAINTS
WHERE OWNER = '[owner/schema name]'
AND CONSTRAINT_NAME = '[constraint_name]'