List Metadata Exchange Connections

 

SELECT REPOSITORY_ID,

       REPOSITORY_NAME,

       REPO_TYPE_NAME,

       IMW_REPOSITORY.DELETED_FLAG,

       EFF_FROM_DT,

       EFF_TO_DT

FROM IMW_REPOSITORY,

     IMW_REPO_TYPE

WHERE IMW_REPOSITORY.REPO_TYPE_UID = IMW_REPO_TYPE.REPO_TYPE_UID

AND   IMW_REPOSITORY.DELETED_FLAG = 'N'

AND   REPOSITORY_ID <>('IMM_MASTER_REPOSITORY')

ORDER BY REPOSITORY_UID