DBA Data[Home] [Help]

VIEW: APPS.IEM_EMAIL_ACCOUNTS_V

Source

View Text - Preformatted

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