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_TIMER_REGISTRY

Object Details

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

XNP_TIMERS_REGISTRY stores a list of all timers in progress. All timers that are enqueued to the timers queue are registered here.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
XNP_TIMER_REGISTRY_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	TIMER_ID
XNP_TIMER_REGISTRY_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TIMER_MESSAGE_CODE
XNP_TIMER_REGISTRY_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	NEXT_TIMER
XNP_TIMER_REGISTRY_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORDER_ID
XNP_TIMER_REGISTRY_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REFERENCE_ID TIMER_MESSAGE_CODE STATUS NEXT_TIMER

Columns

Name	Datatype	Length	Mandatory	Comments
TIMER_ID	NUMBER		Yes	Timer registry identifier assigned by the timer message queue
REFERENCE_ID	VARCHAR2	(80)	Yes	Reference identifier. Examples include a phone number, workflow id, order id or any other similar process identifier.
TIMER_MESSAGE_CODE	VARCHAR2	(20)	Yes	Timer message identifier
STATUS	VARCHAR2	(20)	Yes	Status of the timer. Status values may be ACTIVE, REMOVED, EXPIRED.
START_TIME	DATE		Yes	Timestamp when the timer is enqueued
END_TIME	DATE			Expected end time for the timer to expire. This is the start_time + timer interval.
NEXT_TIMER	VARCHAR2	(20)		Next timer to be enqueued after the delay expires
ORDER_ID	NUMBER			Order ID. Used to track a timer
WI_INSTANCE_ID	NUMBER			Workitem instance id. Used to track a timer
FA_INSTANCE_ID	NUMBER			Fulfillment action instance id. Used to track a timer.
CREATED_BY	NUMBER		Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER		Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER			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 TIMER_ID
,      REFERENCE_ID
,      TIMER_MESSAGE_CODE
,      STATUS
,      START_TIME
,      END_TIME
,      NEXT_TIMER
,      ORDER_ID
,      WI_INSTANCE_ID
,      FA_INSTANCE_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
FROM XNP.XNP_TIMER_REGISTRY;

Dependencies

[top of page]

XNP.XNP_TIMER_REGISTRY does not reference any database object

XNP.XNP_TIMER_REGISTRY is referenced by following:

APPS: XNP_TIMER_REGISTRY