FND Design Data [Home] [Help]

View: IEM_EMAIL_ACCOUNTS_V

Product: IEM - Email Center
Description: Map email accounts to Interaction centers.
Implementation/DBA Data: ViewAPPS.IEM_EMAIL_ACCOUNTS_V
View Text

SELECT B.SERVER_GROUP_ID INTERACTION_CENTER_ID
, A.ACCOUNT_NAME CONFIG_NAME
, TO_CHAR(A.EMAIL_ACCOUNT_ID) VALUE_TYPE
FROM IEM.IEM_EMAIL_ACCOUNTS A
, IEM.IEM_EMAIL_ICNTR_MAPS B
WHERE A.EMAIL_ACCOUNT_ID=B.EMAIL_ACCOUNT_ID

Columns

Name
INTERACTION_CENTER_ID
CONFIG_NAME
VALUE_TYPE