The one which is getting proper access must be having a synonym SDO_GEOM_METADATA_TABLE created for MDSYS.SDO_GEOM_METADATA_TABLE. Others do not.

If you change the FROM clause of you view def from "FROM SDO_GEOM_METADATA_TABLE" to "FROM MDSYS.SDO_GEOM_METADATA_TABLE", it should work for others as well.