[Home] [Help] [Dependency Information]
Object Name: | WMS_DEVICE_REQUESTS_HIST |
---|---|
Object Type: | TABLE |
Owner: | WMS |
FND Design Data: | WMS.WMS_DEVICE_REQUESTS_HIST |
Subobject Name: | |
Status: | VALID |
History Table for device request. This table stores all the device requests that have been submitted.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
WMS_DEVICE_REQUESTS_HIST_U1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | REQUEST_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REQUEST_ID | NUMBER | Request Identifier | ||
TASK_ID | NUMBER | TASK Idetifier | ||
RELATION_ID | NUMBER | Relation Identifier between requests | ||
SEQUENCE_ID | NUMBER | Sequence Identifier | ||
TASK_SUMMARY | VARCHAR2 | (1) | Summary Task flag | |
TASK_TYPE_ID | NUMBER | Task Type Identifier, join to lookup | ||
BUSINESS_EVENT_ID | NUMBER | Yes | Business event identifier, join to lookup | |
ORGANIZATION_ID | NUMBER | Yes | Organization identifier | |
SUBINVENTORY_CODE | VARCHAR2 | (30) | Subinventory | |
LOCATOR_ID | NUMBER | Locator identifier | ||
TRANSFER_ORG_ID | NUMBER | Transfer organization identifier | ||
TRANSFER_SUB_CODE | VARCHAR2 | (30) | Transfer Subinventory | |
TRANSFER_LOC_ID | NUMBER | Transfer locator identifier | ||
INVENTORY_ITEM_ID | NUMBER | Item identifier | ||
REVISION | VARCHAR2 | (10) | Revision | |
UOM | VARCHAR2 | (3) | Unit of measure | |
LOT_NUMBER | VARCHAR2 | (80) | Lot number | |
LOT_QTY | NUMBER | Lot quantity | ||
SERIAL_NUMBER | VARCHAR2 | (30) | Serial number | |
LPN_ID | NUMBER | License plate number identifier | ||
TRANSACTION_QUANTITY | NUMBER | Transaction quantity | ||
DEVICE_ID | NUMBER | Yes | Device identifier | |
STATUS_CODE | VARCHAR2 | (1) | Yes | Status |
STATUS_MSG | VARCHAR2 | (240) | Status explaination | |
OUTFILE_NAME | VARCHAR2 | (240) | Outout file name | |
REQUEST_DATE | DATE | Yes | Request date | |
RESUBMIT_DATE | DATE | Resubmit date | ||
REQUESTED_BY | NUMBER | Yes | Request WHO column | |
RESPONSIBILITY_APPLICATION_ID | NUMBER | Yes | Standard WHO column | |
RESPONSIBILITY_ID | NUMBER | Yes | Standard WHO column | |
CONCURRENT_REQUEST_ID | NUMBER | Concurrent request identifier | ||
PROGRAM_APPLICATION_ID | NUMBER | Concurrent WHO column | ||
PROGRAM_ID | NUMBER | Concurrent WHO column | ||
PROGRAM_UPDATE_DATE | NUMBER | Concurrent WHO column | ||
CREATION_DATE | DATE | Yes | Standard WHO column | |
CREATED_BY | NUMBER | Yes | Standard WHO column | |
LAST_UPDATE_DATE | DATE | Yes | Standard WHO column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard WHO column | |
LAST_UPDATE_LOGIN | NUMBER | Standard WHO column | ||
DEVICE_STATUS | VARCHAR2 | (1) | DEVICE STATUS | |
REASON_ID | NUMBER | reason id | ||
XFER_LPN_ID | NUMBER | Transfer LPN id |
Cut, paste (and edit) the following text to query this object:
SELECT REQUEST_ID
, TASK_ID
, RELATION_ID
, SEQUENCE_ID
, TASK_SUMMARY
, TASK_TYPE_ID
, BUSINESS_EVENT_ID
, ORGANIZATION_ID
, SUBINVENTORY_CODE
, LOCATOR_ID
, TRANSFER_ORG_ID
, TRANSFER_SUB_CODE
, TRANSFER_LOC_ID
, INVENTORY_ITEM_ID
, REVISION
, UOM
, LOT_NUMBER
, LOT_QTY
, SERIAL_NUMBER
, LPN_ID
, TRANSACTION_QUANTITY
, DEVICE_ID
, STATUS_CODE
, STATUS_MSG
, OUTFILE_NAME
, REQUEST_DATE
, RESUBMIT_DATE
, REQUESTED_BY
, RESPONSIBILITY_APPLICATION_ID
, RESPONSIBILITY_ID
, CONCURRENT_REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, DEVICE_STATUS
, REASON_ID
, XFER_LPN_ID
FROM WMS.WMS_DEVICE_REQUESTS_HIST;
WMS.WMS_DEVICE_REQUESTS_HIST does not reference any database object
WMS.WMS_DEVICE_REQUESTS_HIST is referenced by following:
|
|
|