MCT_CFG_DEV_VL

Details

• Schema: FUSION

• Object owner: MCT

• Object type: VIEW

Columns

Name
DEV_GUID OBJECT_VERSION_NUMBER DEV_TYP_GUID CONN_GUID DEV_IMPORT_ID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN ACD_AGENT_DEV_ID DEV_NAME DEV_DESC_TXT DEV_STATUS

Query

SQL_Statement

SELECT MCT_CFG_DEV_B.DEV_GUID DEV_GUID, MCT_CFG_DEV_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, MCT_CFG_DEV_B.DEV_TYP_GUID DEV_TYP_GUID, MCT_CFG_DEV_B.CONN_GUID CONN_GUID, MCT_CFG_DEV_B.DEV_IMPORT_ID DEV_IMPORT_ID, MCT_CFG_DEV_B.CREATED_BY CREATED_BY, MCT_CFG_DEV_B.CREATION_DATE CREATION_DATE, MCT_CFG_DEV_B.LAST_UPDATED_BY LAST_UPDATED_BY, MCT_CFG_DEV_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, MCT_CFG_DEV_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, MCT_CFG_DEV_TL.ACD_AGENT_DEV_ID ACD_AGENT_DEV_ID, MCT_CFG_DEV_TL.DEV_NAME DEV_NAME, MCT_CFG_DEV_TL.DEV_DESC_TXT DEV_DESC_TXT, MCT_CFG_DEV_TL.DEV_STATUS DEV_STATUS FROM MCT_CFG_DEV_B, MCT_CFG_DEV_TL WHERE MCT_CFG_DEV_B.DEV_GUID = MCT_CFG_DEV_TL.DEV_GUID AND MCT_CFG_DEV_TL.LANGUAGE = USERENV('LANG')