opam is able to deal with several opam repositories per switches. These repositories are ranked to able set an order to override packages from the other repositories below them.
ocaml/opam-repository#29247 shows that this behaviour can be quite confusing because the fact that package comes from one repository or another is hidden.
To remedy that i think we should at least show when installing/removing/upgrading/reinstalling/... the origin of packages that are present in more than one repository, similarly to what is done when installing a pinned package.