DBA Data[Home] [Help] [Dependency Information]

TABLE: WMS.WMS_DEVICE_REQUESTS_HIST

Object Details
Object Name: WMS_DEVICE_REQUESTS_HIST
Object Type: TABLE
Owner: WMS
FND Design Data: TableWMS.WMS_DEVICE_REQUESTS_HIST
Subobject Name:
Status: VALID


History Table for device request. This table stores all the device requests that have been submitted.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
WMS_DEVICE_REQUESTS_HIST_U1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnREQUEST_ID
Columns
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
Query Text

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;

Dependencies

[top of page]

WMS.WMS_DEVICE_REQUESTS_HIST does not reference any database object

WMS.WMS_DEVICE_REQUESTS_HIST is referenced by following:

SchemaWMS
ViewWMS_DEVICE_REQUESTS_HIST#