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

TABLE: XNP.XNP_MSG_ACKS

Object Details
Object Name: XNP_MSG_ACKS
Object Type: TABLE
Owner: XNP
FND Design Data: TableXNP.XNP_MSG_ACKS
Subobject Name:
Status: VALID


XNP_MSG_ACKS stores the relationship between messages in the application. An outgoing message can result in one or more incoming messages. The information in this table can be used by the application process to register or wait for the resulting incoming messages.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
XNP_MSG_ACKS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnMSG_ACK_ID
XNP_MSG_ACKS_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSOURCE_MSG_CODE
ColumnACK_MSG_CODE
Columns
Name Datatype Length Mandatory Comments
MSG_ACK_ID NUMBER
Yes Message Acknowledgement Identifier
SOURCE_MSG_CODE VARCHAR2 (20) Yes Outgoing message type
ACK_MSG_CODE VARCHAR2 (20) Yes Expected incoming message type
CREATED_BY NUMBER (15) Yes Standard who columns
CREATION_DATE DATE
Yes Standard who columns
LAST_UPDATED_BY NUMBER (15) Yes Standard who columns
LAST_UPDATE_DATE DATE
Yes Standard who columns
LAST_UPDATE_LOGIN NUMBER (15)
Standard who columns
SECURITY_GROUP_ID NUMBER

Used in hosted environments
Query Text

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


SELECT MSG_ACK_ID
,      SOURCE_MSG_CODE
,      ACK_MSG_CODE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
FROM XNP.XNP_MSG_ACKS;

Dependencies

[top of page]

XNP.XNP_MSG_ACKS does not reference any database object

XNP.XNP_MSG_ACKS is referenced by following:

SchemaAPPS
SynonymXNP_MSG_ACKS