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_MIGRATION_STORE_TEMP

Object Details

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

Stores workitems for migration.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IEM_MIGRATION_STORE_TEMP_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	MESSAGE_ID MESSAGE_TYPE EMAIL_ACCOUNT_ID
SYS_IL0000402071C00025$$	LOB	UNIQUE	APPS_TS_TX_DATA
IEM_MIGRATION_STORE_TEMP_U2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EMAIL_ACCOUNT_ID MESSAGE_TYPE MIG_STATUS
IEM_MIGRATION_STORE_TEMP_U3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	MIGRATION_ID MIG_STATUS

Columns

Name	Datatype	Length	Comments
MAIL_ID	NUMBER	(15)	Unique Id
MESSAGE_ID	NUMBER	(15)	Message Id.
MIGRATION_ID	NUMBER	(15)	Foreign Key.
MESSAGE_TYPE	VARCHAR2	(1)	Type of message.
EMAIL_ACCOUNT_ID	NUMBER	(15)	Email Account Id.
AGENT_ACCOUNT_ID	NUMBER	(15)	Agent Account Id.
RESOURCE_ID	NUMBER	(15)	Resource Id.
FOLDER_NAME	VARCHAR2	(256)	Name of Folder.
RT_MEDIA_ITEM_ID	NUMBER	(15)	RT key.
MSG_UID	NUMBER	(15)	Unique message id in store.
RFC822_MESSAGE_ID	VARCHAR2	(500)	Unique rfc822 header id.
FROM_STR	VARCHAR2	(1000)	From header
TO_STR	VARCHAR2	(1000)	TO header
REPLY_TO_STR	VARCHAR2	(1000)	Reply to header
CC_STR	VARCHAR2	(1000)	Cc header
BCC_STR	VARCHAR2	(1000)	BCc header
SENT_DATE	VARCHAR2	(60)	Sent date header
SUBJECT	VARCHAR2	(2000)	Subject header.
IH_MEDIA_ITEM_ID	NUMBER	(15)	IH id.
MESSAGE_SIZE	NUMBER	(15)	Message size.
DP_STATUS	VARCHAR2	(1)	Dowmload processor status.
MIG_STATUS	VARCHAR2	(1)	Migration status.
ERROR_TEXT	VARCHAR2	(2000)	Error text.
MESSAGE_TEXT	VARCHAR2	(4000)	Message text.
MESSAGE_CONTENT	BLOB	(4000)	Message content.
CREATED_BY	NUMBER	(15)	FND Who Columns
CREATION_DATE	DATE		FND Who Columns
LAST_UPDATE_DATE	DATE		FND Who Columns
LAST_UPDATED_BY	NUMBER	(15)	FND Who Columns
LAST_UPDATE_LOGIN	NUMBER	(15)	FND Who Columns

Query Text

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


SELECT MAIL_ID
,      MESSAGE_ID
,      MIGRATION_ID
,      MESSAGE_TYPE
,      EMAIL_ACCOUNT_ID
,      AGENT_ACCOUNT_ID
,      RESOURCE_ID
,      FOLDER_NAME
,      RT_MEDIA_ITEM_ID
,      MSG_UID
,      RFC822_MESSAGE_ID
,      FROM_STR
,      TO_STR
,      REPLY_TO_STR
,      CC_STR
,      BCC_STR
,      SENT_DATE
,      SUBJECT
,      IH_MEDIA_ITEM_ID
,      MESSAGE_SIZE
,      DP_STATUS
,      MIG_STATUS
,      ERROR_TEXT
,      MESSAGE_TEXT
,      MESSAGE_CONTENT
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM IEM.IEM_MIGRATION_STORE_TEMP;

Dependencies

[top of page]

IEM.IEM_MIGRATION_STORE_TEMP does not reference any database object

IEM.IEM_MIGRATION_STORE_TEMP is referenced by following:

APPS: IEM_MIGRATION_STORE_TEMP