[Home] [Help] [Dependency Information]
Object Name: | WMS_CAROUSEL_DIRECTIVE_QUEUE# |
---|---|
Object Type: | VIEW |
Owner: | WMS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CAROUSEL_DIRECTIVE_QUEUE_ID | NUMBER | Yes | ||
REQUEST_ID | NUMBER | Yes | ||
TASK_ID | NUMBER | Yes | ||
DIRECTIVE | VARCHAR2 | (16) | Yes | |
BUSINESS_EVENT_ID | NUMBER | |||
PREV_ID | NUMBER | |||
STATUS | VARCHAR2 | (16) | ||
LAST_ATTEMPT | DATE | |||
ATTEMPTS | NUMBER | |||
REQUEST | VARCHAR2 | (4000) | ||
SEQUENCE_ID | NUMBER | Yes | ||
RESPONSE_TIMEOUT | NUMBER | Yes | ||
MAX_ATTEMPTS | NUMBER | Yes | ||
SUBINVENTORY | VARCHAR2 | (64) | Yes | |
SEND_PIPE | VARCHAR2 | (128) | Yes | |
PIPE_TIMEOUT | NUMBER | Yes | ||
RESPONSE | VARCHAR2 | (4000) | ||
RECEIVE_PIPE | VARCHAR2 | (128) | Yes | |
DEVICE_ID | NUMBER | |||
DEVICE_TYPE_ID | NUMBER | |||
ADDR | VARCHAR2 | (64) | ||
SEGMENT1 | VARCHAR2 | (64) | ||
SEGMENT2 | VARCHAR2 | (64) | ||
SEGMENT3 | VARCHAR2 | (64) | ||
SEGMENT4 | VARCHAR2 | (64) | ||
SEGMENT5 | VARCHAR2 | (64) | ||
SEGMENT6 | VARCHAR2 | (64) | ||
SEGMENT7 | VARCHAR2 | (64) | ||
SEGMENT8 | VARCHAR2 | (64) | ||
SEGMENT9 | VARCHAR2 | (64) | ||
SEGMENT10 | VARCHAR2 | (64) | ||
TASK_COUNT | NUMBER | |||
TASKS_LEFT | NUMBER | |||
TASK_GROUP | VARCHAR2 | (16) | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | Yes | ||
LAST_UPDATE_LOGIN | NUMBER |
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#;
|
|
|