Description of problem:

Issue when syncing Ansible Collection on Satellite

How reproducible:

100%

Is this issue a regression from an earlier version:

Not sure.

Steps to Reproduce:

1. Create a repo type ansible collection named "published"

2. Set the URL to https://console.redhat.com/api/automation-hub/content/published/

3. Create the requirement as below

collections:
- name: redhat.satellite
  version: ">1.0.0" 

4. Sync it

The sync will work with no issue

5. Create a repo type ansible collection named "validated"

6. Set the URL to https://console.redhat.com/api/automation-hub/content/validated/

7. Create the requirement as below

collections:
- name: infra.osbuild
  version: ">1.0.0" 

8. Sync it

The sync will fail

Actual behavior:
The sync is failing with the error below

404, message='Not Found', url='https://console.redhat.com/api/automation-hub/content/validated/v3/plugin/ansible/content/validated/collections/index/ansible/posix/' 

Note that the ansible.posix requested is from validated, and on console.redhat.com, we can see only the published one

https://console.redhat.com/ansible/automation-hub/repo/published/ansible/posix/

Expected behavior:
Satellite handle the dependencies in a better/easier way.

Business Impact / Additional info: