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_MC_PARAMETERS

Object Details

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

Stores temporary parameters required by Message Componenet to load required data.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IEM_MC_PARAMETERS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	MC_PARAMETER_ID
IEM_MC_PARAMETERS_U2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DELETE_FLAG_Y_N

Columns

Name	Datatype	Length	Mandatory	Comments
MC_PARAMETER_ID	NUMBER	(15)	Yes	Primary Key
ACTION	VARCHAR2	(20)	Yes	Predefined actions like Compose, Preview, Getwork, Inbox
MASTER_ACCOUNT_ID	NUMBER	(15)		From email account Id
ACTIVITY_ID	NUMBER	(15)		IH Activity Id of the message to preview.
TO_ADDRESS_LIST	VARCHAR2	(1024)		Seli-colon seperated list of addresses for the To field.
CC_ADDRESS_LIST	VARCHAR2	(1024)		Seli-colon seperated list of addresses for the CC field.
BCC_ADDRESS_LIST	VARCHAR2	(1024)		Seli-colon seperated list of addresses for the Bcc field.
SUBJECT	VARCHAR2	(1024)		Subject for the email message.
SR_ID	NUMBER	(15)		Service Request Id to associate with the email message
CUSTOMER_ID	NUMBER	(15)		Party Id to use to record Interaction History
CONTACT_ID	NUMBER	(15)		Party Id of the Contact. Not currently used
MES_DOC_ID	NUMBER	(15)		The document Id of the MES template/suggested responce to be used.
MES_CATEGORY_ID	NUMBER	(15)		THe category to display in the compose page.
INTERACTION_ID	NUMBER	(15)		IH Interaction Id to use for recording activities.
DELETE_FLAG_Y_N	VARCHAR2	(1)		If 'Y', it canbe deleted safely along with the associated custom parameters.
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE_CATEGORY	VARCHAR2	(150)		Attribute Category.
CREATED_BY	NUMBER		Yes	FND Who Columns
CREATION_DATE	DATE		Yes	FND Who Columns
LAST_UPDATED_BY	NUMBER		Yes	FND Who Columns
LAST_UPDATE_DATE	DATE		Yes	FND Who Columns
LAST_UPDATE_LOGIN	NUMBER		Yes	FND Who Columns
SECURITY_GROUP_ID	NUMBER			Virtual Private Database Id.
ENCODE	VARCHAR2	(128)		Charater encoding for the outbound message.
CHAR_SET	VARCHAR2	(128)		Character set for the outbound message.
MSG_TYPE	VARCHAR2	(1)		Message type. Valid values (H-html, T-text).
RELATIONSHIP_ID	NUMBER	(15)		Party relationship PARTY_ID related to the interaction.

Query Text

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


SELECT MC_PARAMETER_ID
,      ACTION
,      MASTER_ACCOUNT_ID
,      ACTIVITY_ID
,      TO_ADDRESS_LIST
,      CC_ADDRESS_LIST
,      BCC_ADDRESS_LIST
,      SUBJECT
,      SR_ID
,      CUSTOMER_ID
,      CONTACT_ID
,      MES_DOC_ID
,      MES_CATEGORY_ID
,      INTERACTION_ID
,      DELETE_FLAG_Y_N
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE_CATEGORY
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
,      ENCODE
,      CHAR_SET
,      MSG_TYPE
,      RELATIONSHIP_ID
FROM IEM.IEM_MC_PARAMETERS;

Dependencies

[top of page]

IEM.IEM_MC_PARAMETERS does not reference any database object

IEM.IEM_MC_PARAMETERS is referenced by following:

IEM: IEM_MC_PARAMETERS#