DBA Data[Home] [Help]

VIEW: APPS.JTF_RS_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