MCT_CFG_ACD_EXTENSION_V

Details

• Schema: FUSION

• Object owner: MCT

• Object type: VIEW

Columns

Name
COMM_USER_GUID ACD_EXTENSION

Query

SQL_Statement
SELECT A.COMM_USER_GUID, A.CONN_USR_PAR_VAL as ACD_EXTENSION FROM MCT_CFG_CONN_USR_PAR_VAL A, MCT_CFG_CONN_TYP_USR_PAR B,MCT_CFG_COMM_USER C WHERE A.CONN_GUID = C.CONN_GUID AND A.COMM_USER_GUID = C.COMM_USER_GUID AND A.CONN_USER_PAR_GUID = B.CONN_TYP_USR_PAR_GUID and B.par_name='AcdExtension'