Here’s a quick query to find the editioning view for a table: SELECT a.* FROM dba_views a, dba_dependencies b WHERE b.name = a.view_name AND a.editioning_view = ‘Y’ AND b.referenced_name ‘EMPLOYEE_TABLE’; And going the other direction, get the table the view is based on: SELECT b.referenced_name FROM dba_views a, dba_dependencies b WHERE b.name = ‘EMPLOYEE_TABLE_VIEW’ AND […]