The data_access_capability_application_xref table I believe is missing a unique constraint across data_access_capability_ref and data_access_application_ref. There are duplicate entries.

Example (on staging db):

select * from metadata.data_access_capability_application_xref where data_access_capability_ref = '7a8ca769-8009-4a33-a505-0521dcde66c0'

Compare:

select count(x.*) from metadata.data_access_capability_application_xref x ---> 41

with:

select count(distinct x.*) from metadata.data_access_capability_application_xref x -->33

This inadvertently doubles/triples the number of rows coming back from a join to the table (depending on how many duplicates there are).