look v$fixed_view_definition
v$ are not based on any ohysical table, they are based on x$ which are memory structure