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: CSI.CSI_XNP_MSGS_TEMP

Object Details

Object Name:	CSI_XNP_MSGS_TEMP
Object Type:	TABLE
Owner:	CSI
FND Design Data:	CSI.CSI_XNP_MSGS_TEMP
Subobject Name:
Status:	VALID

Temporary table that holds the unprocessed XNP messages during data correction process.

Storage Details

Tablespace:	APPS_TS_NOLOGGING
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
SYS_IL0000324528C00008$$	LOB	UNIQUE	APPS_TS_NOLOGGING
CSI_XNP_MSGS_TEMP_N01	NORMAL	NONUNIQUE	APPS_TS_NOLOGGING	SOURCE_ID SOURCE_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
MSG_ID	NUMBER		Yes	XNP message id
MSG_CODE	VARCHAR2	(30)		XNP Message code
MSG_STATUS	VARCHAR2	(30)		XNP Message status
SOURCE_ID	NUMBER			XNP message source id
SOURCE_TYPE	VARCHAR2	(30)		Transaction source type
CREATION_DATE	DATE			Creation date
DESCRIPTION	VARCHAR2	(2000)		XNP message description
MSG_TEXT	CLOB	(4000)		XNP message text
PROCESS_FLAG	VARCHAR2	(1)		Internal process flag.

Query Text

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


SELECT MSG_ID
,      MSG_CODE
,      MSG_STATUS
,      SOURCE_ID
,      SOURCE_TYPE
,      CREATION_DATE
,      DESCRIPTION
,      MSG_TEXT
,      PROCESS_FLAG
FROM CSI.CSI_XNP_MSGS_TEMP;

Dependencies

[top of page]

CSI.CSI_XNP_MSGS_TEMP does not reference any database object

CSI.CSI_XNP_MSGS_TEMP is referenced by following:

CSI: CSI_XNP_MSGS_TEMP#