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: WMS.WMS_CAROUSEL_DIRECTIVE_QUEUE

Object Details

Object Name:	WMS_CAROUSEL_DIRECTIVE_QUEUE
Object Type:	TABLE
Owner:	WMS
FND Design Data:	WMS.WMS_CAROUSEL_DIRECTIVE_QUEUE
Subobject Name:
Status:	VALID

This table will handle the directive message queue

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
WMS_CAROUSEL_DIRECTIVE_Q_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CAROUSEL_DIRECTIVE_QUEUE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
CAROUSEL_DIRECTIVE_QUEUE_ID	NUMBER		Yes	Carousel Directive Queue Id
REQUEST_ID	NUMBER		Yes	Request Id
TASK_ID	NUMBER		Yes	Task Id
DIRECTIVE	VARCHAR2	(16)	Yes	Directive
BUSINESS_EVENT_ID	NUMBER			Business Event Id
PREV_ID	NUMBER			Previous Id
STATUS	VARCHAR2	(16)		Status
LAST_ATTEMPT	DATE			Last Attempt
ATTEMPTS	NUMBER			Attempts
REQUEST	VARCHAR2	(4000)		Request
SEQUENCE_ID	NUMBER		Yes	Sequence Id
RESPONSE_TIMEOUT	NUMBER		Yes	Response Timeout
MAX_ATTEMPTS	NUMBER		Yes	Response Timeout
SUBINVENTORY	VARCHAR2	(64)	Yes	Subinventory
SEND_PIPE	VARCHAR2	(128)	Yes	Send Pipe Name
PIPE_TIMEOUT	NUMBER		Yes	Pipe Timeout
RESPONSE	VARCHAR2	(4000)		Response
RECEIVE_PIPE	VARCHAR2	(128)	Yes	Receive Pipe Name
DEVICE_ID	NUMBER			Device Id
DEVICE_TYPE_ID	NUMBER			Device Type Id
ADDR	VARCHAR2	(64)		Address
SEGMENT1	VARCHAR2	(64)		Locator Segment
SEGMENT2	VARCHAR2	(64)		Locator Segment
SEGMENT3	VARCHAR2	(64)		Locator Segment
SEGMENT4	VARCHAR2	(64)		Locator Segment
SEGMENT5	VARCHAR2	(64)		Locator Segment
SEGMENT6	VARCHAR2	(64)		Locator Segment
SEGMENT7	VARCHAR2	(64)		Locator Segment
SEGMENT8	VARCHAR2	(64)		Locator Segment
SEGMENT9	VARCHAR2	(64)		Locator Segment
SEGMENT10	VARCHAR2	(64)		Locator Segment
TASK_COUNT	NUMBER			Task Count
TASKS_LEFT	NUMBER			Tasks Left
TASK_GROUP	VARCHAR2	(16)		Task Group
LAST_UPDATE_DATE	DATE		Yes	Standard WHO Column
LAST_UPDATED_BY	NUMBER		Yes	Standard WHO Column
CREATION_DATE	DATE		Yes	Standard WHO Column
CREATED_BY	NUMBER		Yes	Standard WHO Column
LAST_UPDATE_LOGIN	NUMBER			Standard WHO Column

Query Text

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


SELECT CAROUSEL_DIRECTIVE_QUEUE_ID
,      REQUEST_ID
,      TASK_ID
,      DIRECTIVE
,      BUSINESS_EVENT_ID
,      PREV_ID
,      STATUS
,      LAST_ATTEMPT
,      ATTEMPTS
,      REQUEST
,      SEQUENCE_ID
,      RESPONSE_TIMEOUT
,      MAX_ATTEMPTS
,      SUBINVENTORY
,      SEND_PIPE
,      PIPE_TIMEOUT
,      RESPONSE
,      RECEIVE_PIPE
,      DEVICE_ID
,      DEVICE_TYPE_ID
,      ADDR
,      SEGMENT1
,      SEGMENT2
,      SEGMENT3
,      SEGMENT4
,      SEGMENT5
,      SEGMENT6
,      SEGMENT7
,      SEGMENT8
,      SEGMENT9
,      SEGMENT10
,      TASK_COUNT
,      TASKS_LEFT
,      TASK_GROUP
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
FROM WMS.WMS_CAROUSEL_DIRECTIVE_QUEUE;

Dependencies

[top of page]

WMS.WMS_CAROUSEL_DIRECTIVE_QUEUE does not reference any database object

WMS.WMS_CAROUSEL_DIRECTIVE_QUEUE is referenced by following:

APPS: WMS_CAROUSEL_DIRECTIVE_QUEUE