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: XNP.XNP_MSGS

Object Details

Object Name:	XNP_MSGS
Object Type:	TABLE
Owner:	XNP
FND Design Data:	XNP.XNP_MSGS
Subobject Name:
Status:	VALID

XNP_MSGS stores the actual instance of a message that passes over a network association.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
SYS_IL0000086433C00002$$	LOB	UNIQUE	APPS_TS_TX_DATA
XNP_MSGS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	MSG_ID
XNP_MSGS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	MSG_CODE
XNP_MSGS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORDER_ID
XNP_MSGS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	WI_INSTANCE_ID
XNP_MSGS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	MSG_STATUS MSG_CREATION_DATE
XNP_MSGS_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REFERENCE_ID OPP_REFERENCE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
MSG_ID	NUMBER		Yes	Message Identifier
BODY_TEXT	CLOB	(4000)	Yes	Actual message content in XML format
MSG_CODE	VARCHAR2	(20)	Yes	Short name of the message
MSG_CREATION_DATE	DATE			Date and time the message was created and enqueued
DIRECTION_INDICATOR	VARCHAR2	(1)		Indicates if the message was incoming or outgoing
REFERENCE_ID	VARCHAR2	(1996)		Optional field that can be used to uniquely identify the message
OPP_REFERENCE_ID	VARCHAR2	(1996)		Used by an external system to associate a response with the original message
MSG_VERSION	NUMBER			Version of the message
SENDER_NAME	VARCHAR2	(300)		Name of the sending service provider
RECIPIENT_NAME	VARCHAR2	(40)		Name of the recipient service provider
SEND_RCV_DATE	DATE			Date and time the message was sucessfully sent or received
MSG_STATUS	VARCHAR2	(10)		Indicates whether a message is successfully sent or received. Used by the network adapter to retry sending a message if necessary.
DESCRIPTION	VARCHAR2	(1996)		Textual description of the reason for not sending or receivig a message
RETRIES	NUMBER			Number of attempts made to deliver this message. Reserved for future use.
ORDER_ID	NUMBER			Order to which this message belongs
WI_INSTANCE_ID	NUMBER			Work Item instance to which this message belongs
FA_INSTANCE_ID	NUMBER			Fullfilment action instance to which this message belongs
FE_NAME	VARCHAR2	(40)		Fullfilment element that handles this message
ADAPTER_NAME	VARCHAR2	(40)		Adapter name responsible for sending message to the remote system
UPDATED_BY_USER	VARCHAR2	(40)		Application User who last updated the message
CREATED_BY	NUMBER	(15)	Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
SECURITY_GROUP_ID	NUMBER			Used in hosted environments

Query Text

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


SELECT MSG_ID
,      BODY_TEXT
,      MSG_CODE
,      MSG_CREATION_DATE
,      DIRECTION_INDICATOR
,      REFERENCE_ID
,      OPP_REFERENCE_ID
,      MSG_VERSION
,      SENDER_NAME
,      RECIPIENT_NAME
,      SEND_RCV_DATE
,      MSG_STATUS
,      DESCRIPTION
,      RETRIES
,      ORDER_ID
,      WI_INSTANCE_ID
,      FA_INSTANCE_ID
,      FE_NAME
,      ADAPTER_NAME
,      UPDATED_BY_USER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
FROM XNP.XNP_MSGS;

Dependencies

[top of page]

XNP.XNP_MSGS does not reference any database object

XNP.XNP_MSGS is referenced by following:

APPS: XNP_MSGS