eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: IEM.IEM_AGENT_ACCOUNTS

Object Details

Object Name:	IEM_AGENT_ACCOUNTS
Object Type:	TABLE
Owner:	IEM
Subobject Name:
Status:	VALID

IEM Agent Accounts

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IEM_AGENT_ACCOUNTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	AGENT_ACCOUNT_ID
IEM_AGENT_ACCOUNTS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	AGENT_ACCOUNT_ID EMAIL_ACCOUNT_ID
IEM_AGENT_ACCOUNTS_U3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RESOURCE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
AGENT_ACCOUNT_ID	NUMBER	(15)	Yes	Unique identifier of Agent
EMAIL_ACCOUNT_ID	NUMBER	(15)	Yes	Id of Email account to which agent is tied
ACCOUNT_NAME	VARCHAR2	(256)		Account name to which the agent is tied
EMAIL_USER	VARCHAR2	(100)		Email account name of the agent
DOMAIN	VARCHAR2	(100)		Domain of the agent
EMAIL_PASSWORD	VARCHAR2	(100)		Password of the agent
REPLY_TO_ADDRESS	VARCHAR2	(100)		Email address to which reply will come
FROM_ADDRESS	VARCHAR2	(100)		From address of the agent
RESOURCE_ID	NUMBER	(15)		FND user id of the agent
SIGNATURE	VARCHAR2	(256)		Signature of the agent
USER_NAME	VARCHAR2	(256)		Name of the user
FROM_NAME	VARCHAR2	(256)		Name appears when sending out email
CREATED_BY	NUMBER	(15)	Yes	FND Who Columns
CREATION_DATE	DATE		Yes	FND Who Columns
LAST_UPDATED_BY	NUMBER	(15)	Yes	FND Who Columns
LAST_UPDATE_DATE	DATE		Yes	FND Who Columns
LAST_UPDATE_LOGIN	NUMBER	(15)		FND Who Columns
ATTRIBUTE1	VARCHAR2	(150)		Attribute for colunm 1 descriptive flexfild segment
ATTRIBUTE2	VARCHAR2	(150)		Attribute for colunm 2 descriptive flexfild segment
ATTRIBUTE3	VARCHAR2	(150)		Attribute for colunm 3 descriptive flexfild segment
ATTRIBUTE4	VARCHAR2	(150)		Attribute for colunm 4 descriptive flexfild segment
ATTRIBUTE5	VARCHAR2	(150)		Attribute for colunm 5 descriptive flexfild segment
ATTRIBUTE6	VARCHAR2	(150)		Attribute for colunm 6 descriptive flexfild segment
ATTRIBUTE7	VARCHAR2	(150)		Attribute for colunm 7 descriptive flexfild segment
ATTRIBUTE8	VARCHAR2	(150)		Attribute for colunm 8 descriptive flexfild segment
ATTRIBUTE9	VARCHAR2	(150)		Attribute for colunm 9 descriptive flexfild segment
ATTRIBUTE10	VARCHAR2	(150)		Attribute for colunm 10 descriptive flexfild segment
ATTRIBUTE11	VARCHAR2	(150)		Attribute for colunm 11 descriptive flexfild segment
ATTRIBUTE12	VARCHAR2	(150)		Attribute for colunm 1 2 descriptive flexfild segment
ATTRIBUTE13	VARCHAR2	(150)		Attribute for colunm 1 3 descriptive flexfild segment
ATTRIBUTE14	VARCHAR2	(150)		Attribute for colunm 14 descriptive flexfild segment
ATTRIBUTE15	VARCHAR2	(150)		Attribute for colunm 15 descriptive flexfild segment
SECURITY_GROUP_ID	NUMBER			Security group Identification

Query Text

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


SELECT AGENT_ACCOUNT_ID
,      EMAIL_ACCOUNT_ID
,      ACCOUNT_NAME
,      EMAIL_USER
,      DOMAIN
,      EMAIL_PASSWORD
,      REPLY_TO_ADDRESS
,      FROM_ADDRESS
,      RESOURCE_ID
,      SIGNATURE
,      USER_NAME
,      FROM_NAME
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      SECURITY_GROUP_ID
FROM IEM.IEM_AGENT_ACCOUNTS;

Dependencies

[top of page]

IEM.IEM_AGENT_ACCOUNTS does not reference any database object

IEM.IEM_AGENT_ACCOUNTS is referenced by following:

IEM: IEM_AGENT_ACCOUNTS#