SELECT name , TYPE , referenced_name , referenced_type FROM user_dependencies WHERE name = 'VIEW_NAME' AND TYPE = 'VIEW' AND referenced_type = 'TABLE';