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

TABLE: WMS.WMS_DEVICE_ASSIGNMENT_TEMP

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


WMS_DEVICE_ASSIGNMENT_TEMP table stores the information about the current devices the current users are signing on to. The column ASSIGNMENT_TEMP_ID indicates the order of devices signed on. The corresponding records will be removed after the user signs off the devices.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
WMS_DEVICE_ASSIGN_TEMP_U1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnASSIGNMENT_TEMP_ID
WMS_DEVICE_ASSIGN_TEMP_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SEED ColumnEMPLOYEE_ID
Columns
Name Datatype Length Mandatory Comments
ASSIGNMENT_TEMP_ID NUMBER
Yes Device assignment identifier
EMPLOYEE_ID NUMBER
Yes Employee identifier
ORGANIZATION_ID NUMBER

Organization identifier
EQUIPMENT_ID NUMBER

Inventory Item Id of the Equipment being used to perform the task
EQUIPMENT_INSTANCE_ID VARCHAR2 (30)
Serial Number of the Equipment being used to perform the task
DEVICE_ID NUMBER

Device identifier
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
Query Text

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


SELECT ASSIGNMENT_TEMP_ID
,      EMPLOYEE_ID
,      ORGANIZATION_ID
,      EQUIPMENT_ID
,      EQUIPMENT_INSTANCE_ID
,      DEVICE_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM WMS.WMS_DEVICE_ASSIGNMENT_TEMP;

Dependencies

[top of page]

WMS.WMS_DEVICE_ASSIGNMENT_TEMP does not reference any database object

WMS.WMS_DEVICE_ASSIGNMENT_TEMP is referenced by following:

SchemaAPPS
SynonymWMS_DEVICE_ASSIGNMENT_TEMP