MCT_CFG_CONN_VL

Details

• Schema: FUSION

• Object owner: MCT

• Object type: VIEW

Columns

Name
CONN_GUID OBJECT_VERSION_NUMBER CONN_TYP_GUID CONN_INPUT_PAR_STR USE_TRANSPORT_LIB IS_DEFAULT_CONN_FLG GLOBAL_FUNCTION_NAME CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN CONN_NAME CONN_DESC_TXT CONN_STATUS

Query

SQL_Statement

SELECT MCT_CFG_CONN_B.CONN_GUID CONN_GUID, MCT_CFG_CONN_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, MCT_CFG_CONN_B.CONN_TYP_GUID CONN_TYP_GUID, MCT_CFG_CONN_B.CONN_INPUT_PAR_STR CONN_INPUT_PAR_STR, MCT_CFG_CONN_B.USE_TRANSPORT_LIB USE_TRANSPORT_LIB, MCT_CFG_CONN_B.IS_DEFAULT_CONN_FLG IS_DEFAULT_CONN_FLG, MCT_CFG_CONN_B.GLOBAL_FUNCTION_NAME GLOBAL_FUNCTION_NAME, MCT_CFG_CONN_B.CREATED_BY CREATED_BY, MCT_CFG_CONN_B.CREATION_DATE CREATION_DATE, MCT_CFG_CONN_B.LAST_UPDATED_BY LAST_UPDATED_BY, MCT_CFG_CONN_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, MCT_CFG_CONN_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, MCT_CFG_CONN_TL.CONN_NAME CONN_NAME, MCT_CFG_CONN_TL.CONN_DESC_TXT CONN_DESC_TXT, MCT_CFG_CONN_TL.CONN_STATUS CONN_STATUS FROM MCT_CFG_CONN_B, MCT_CFG_CONN_TL WHERE MCT_CFG_CONN_B.CONN_GUID = MCT_CFG_CONN_TL.CONN_GUID AND MCT_CFG_CONN_TL.LANGUAGE = USERENV('LANG')