reference.RepoObject_reference - V

CREATE View reference.RepoObject_reference
As
Select
    T1.referenced_RepoObject_guid
  , T1.referencing_RepoObject_guid
  , referenced_entity_name               = Max ( T1.referenced_entity_name )
  , referenced_schema_name               = Max ( T1.referenced_schema_name )
  , referenced_type                      = Max ( T1.referenced_type )
  , referenced_external_AntoraComponent  = Max ( T1.referenced_external_AntoraComponent )
  , referenced_external_AntoraModule     = Max ( T1.referenced_external_AntoraModule )
  , referenced_is_external               = Max ( T1.referenced_is_external )
  , referencing_entity_name              = Max ( T1.referencing_entity_name )
  , referencing_schema_name              = Max ( T1.referencing_schema_name )
  , referencing_type                     = Max ( T1.referencing_type )
  , referencing_external_AntoraComponent = Max ( T1.referencing_external_AntoraComponent )
  , referencing_external_AntoraModule    = Max ( T1.referencing_external_AntoraModule )
  , referencing_is_external              = Max ( T1.referencing_is_external )
From
    reference.RepoObject_reference_union As T1
Where
    --avoid cyclic references
    --exclude references `aaa.bbb <- aaa.bbb_ccc_tgt`, we already added `aaa.bbb_ccc_tgt <- aaa.bbb`
    Not Exists
(
    Select
        1
    From
        reference.RepoObject_reference_persistence_target_as_source As T2
    Where
        T2.referenced_RepoObject_guid        = T1.referencing_RepoObject_guid
        And T2.referencing_RepoObject_guid   = T1.referenced_RepoObject_guid
        And T2.has_match_left_and_suffix_tgt = 1
)
    And Not Exists
(
    Select
        1
    From
        reference.RepoObject_reference_persistence_target_as_source_explicit As T2
    Where
        T2.referenced_RepoObject_guid      = T1.referencing_RepoObject_guid
        And T2.referencing_RepoObject_guid = T1.referenced_RepoObject_guid
)
Group By
    T1.referenced_RepoObject_guid
  , T1.referencing_RepoObject_guid
Having
    ( Not ( T1.referenced_RepoObject_guid Is Null ))
    And ( Not ( T1.referencing_RepoObject_guid Is Null ))