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_EVENT_SUBSCRIBERS

Object Details

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

XNP_EVENT_SUBSCRIBERS stores the list of subscribers for a given event.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
XNP_EVENT_SUBSCRIBERS_U1	NORMAL	UNIQUE	APPS_TS_SEED	EVENT_SUBSCRIBER_ID ZD_EDITION_NAME
XNP_EVENT_SUBSCRIBERS_U2	NORMAL	UNIQUE	APPS_TS_SEED	MSG_CODE FE_ID ZD_EDITION_NAME
XNP_EVENT_SUBSCRIBERS_N1	NORMAL	NONUNIQUE	APPS_TS_SEED	FE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
EVENT_SUBSCRIBER_ID	NUMBER		Yes	Unique identifier assigned upon creation of the subscription version
MSG_CODE	VARCHAR2	(20)	Yes	Short name for the message. The short name will be used as the package name for all the procedures that will be generated by the Message Builder. For example a message with a short name of K1 will have the package named as XNP_K1_U.
FE_ID	NUMBER		Yes	Subscriber's Fulfillment Element to which this event will be published.
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
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

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


SELECT EVENT_SUBSCRIBER_ID
,      MSG_CODE
,      FE_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
,      ZD_EDITION_NAME
FROM XNP.XNP_EVENT_SUBSCRIBERS;

Dependencies

[top of page]

XNP.XNP_EVENT_SUBSCRIBERS does not reference any database object

XNP.XNP_EVENT_SUBSCRIBERS is referenced by following:

XNP: XNP_EVENT_SUBSCRIBERS#