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
View Text - HTML Formatted
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