Valence band hard x-ray photoelectron spectroscopy on 3d transition-metal oxides containing rare-earth elements