DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.IEM_EMAIL_ACCOUNTS_V

Object Details
Object Name: IEM_EMAIL_ACCOUNTS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIEM.IEM_EMAIL_ACCOUNTS_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


This view is mainly used by the JTF_RESOURCE module. The view displays a mapping between an Interaction Center and Email accounts.


[View Source]

Columns
Name Datatype Length Mandatory Comments
INTERACTION_CENTER_ID NUMBER (15) Yes Interaction center ID. Primary Key fom IEO_SVR_GROUPS.
CONFIG_NAME VARCHAR2 (256)
Email Account Name.
VALUE_TYPE VARCHAR2 (40)
Email Account ID. Primary Key from IEM_EMAIL_ACCOUNTS.
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT INTERACTION_CENTER_ID
,      CONFIG_NAME
,      VALUE_TYPE
FROM APPS.IEM_EMAIL_ACCOUNTS_V;

Dependencies

[top of page]

APPS.IEM_EMAIL_ACCOUNTS_V references the following:

SchemaAPPS
SynonymIEM_EMAIL_ACCOUNTS
SynonymIEM_EMAIL_ICNTR_MAPS

APPS.IEM_EMAIL_ACCOUNTS_V is not referenced by any database object