reference.additional_Reference_guid - V

CREATE View reference.additional_Reference_guid
As
Select
    T1.referenced_AntoraComponent
  , T1.referenced_AntoraModule
  , referenced_external_AntoraComponent  = ro1.external_AntoraComponent
  , referenced_external_AntoraModule     = ro1.external_AntoraModule
  , T1.referenced_Schema
  , T1.referenced_Object
  , T1.referenced_Column
  , referenced_fullname                  = ro1.RepoObject_fullname
  , referenced_id                        = ro1.SysObject_id
  , referenced_RepoObject_guid           = ro1.RepoObject_guid
  , referenced_RepoObjectColumn_guid     = roc1.RepoObjectColumn_guid
  , referenced_type                      = ro1.RepoObject_type
  , referenced_is_external               = ro1.is_external
  , T1.referencing_AntoraComponent
  , T1.referencing_AntoraModule
  , referencing_external_AntoraComponent = ro2.external_AntoraComponent
  , referencing_external_AntoraModule    = ro2.external_AntoraModule
  , T1.referencing_Schema
  , T1.referencing_Object
  , T1.referencing_Column
  , referencing_fullname                 = ro2.RepoObject_fullname
  , referencing_id                       = ro2.SysObject_id
  , referencing_RepoObject_guid          = ro2.RepoObject_guid
  , referencing_RepoObjectColumn_guid    = roc2.RepoObjectColumn_guid
  , referencing_type                     = ro2.RepoObject_type
  , referencing_is_external              = ro2.is_external
--, AntoraComponent                      = AntoraComponent.Parameter_value_result
--, AntoraModule                         = AntoraModule.Parameter_value_result
From
    reference.additional_Reference As T1
    Left Outer Join
        repo.RepoObject            As ro1
            On
            ro1.RepoObject_schema_name            = T1.referenced_Schema
            And ro1.RepoObject_name               = T1.referenced_Object
            And
            (
                ro1.is_external                   = 0
                Or
                (
                    ro1.external_AntoraComponent  = T1.referenced_AntoraComponent
                    And ro1.external_AntoraModule = T1.referenced_AntoraModule
                )
            )

    Left Outer Join
        repo.RepoObject            As ro2
            On
            ro2.RepoObject_schema_name            = T1.referencing_Schema
            And ro2.RepoObject_name               = T1.referencing_Object
            And
            (
                ro2.is_external                   = 0
                Or
                (
                    ro2.external_AntoraComponent  = T1.referencing_AntoraComponent
                    And ro2.external_AntoraModule = T1.referencing_AntoraModule
                )
            )

    Left Outer Join
        repo.RepoObjectColumn      As roc1
            On
            roc1.RepoObject_guid                  = ro1.RepoObject_guid
            And roc1.Column_name                  = T1.referenced_Column

    Left Outer Join
        repo.RepoObjectColumn      As roc2
            On
            roc2.RepoObject_guid                  = ro2.RepoObject_guid
            And roc2.Column_name                  = T1.referencing_Column
Where
    Not ro1.RepoObject_guid Is Null
    And Not ro2.RepoObject_guid Is Null

sqlCopied!