Views Based on which tables ?

[shandj]

You can get the information of view from user_tab_columns table.

Retrieve Table_name, column_name from user_tab_columns for table_name like 'Viewname'

Thanks