[Home] [Help]
SELECT B.SERVER_GROUP_ID INTERACTION_CENTER_ID, A.ACCOUNT_NAME CONFIG_NAME, TO_CHAR(A.EMAIL_ACCOUNT_ID) VALUE_TYPE FROM IEM_EMAIL_ACCOUNTS A, IEM_EMAIL_ICNTR_MAPS B WHERE A.EMAIL_ACCOUNT_ID=B.EMAIL_ACCOUNT_ID
SELECT B.SERVER_GROUP_ID INTERACTION_CENTER_ID
, A.ACCOUNT_NAME CONFIG_NAME
, TO_CHAR(A.EMAIL_ACCOUNT_ID) VALUE_TYPE
FROM IEM_EMAIL_ACCOUNTS A
, IEM_EMAIL_ICNTR_MAPS B
WHERE A.EMAIL_ACCOUNT_ID=B.EMAIL_ACCOUNT_ID
|
|
|
|