MCT_CFG_ACD_USER_ID_V
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: MCT
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
COMM_USER_GUID ACD_USER_ID |
問合せ
| SQL_Statement |
|---|
|
SELECT A.COMM_USER_GUID, A.CONN_USR_PAR_VAL as ACD_USER_ID 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='AcdUserId' |