As far as I read the user manuals, you can confirm view_type, dependency_type, etc by using [VIEW_DEPENDENCIES](https://community.denodo.com/docs/html/browse/latest/en/vdp/vql/stored_procedures/predefined_stored_procedures/view_dependencies#view-dependencies) stored procedure. In view_type and dependency_type, you can confirm whether the view is JOIN type.
But I don’t think there is a stored procedure that you can confirm the details of join conditions and where clause conditions.
If you want to confirm them, you need to access the configuration page of each view in the Virtual DataPort Administration Tool.
Hope this helps!