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_DISPATCHED_TASKS_HISTORY

Object Details

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

History Table for WMS_DISPATCHED_TASKS. Stores information about all tasks that have been completed

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
WMS_DISPATCHED_TASKS_HISTOR_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	TASK_ID
WMS_DISPATCHED_TASKS_HISTOR_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PERSON_ID EFFECTIVE_START_DATE EFFECTIVE_END_DATE
WMS_DISPATCHED_TASKS_HISTOR_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	USER_TASK_TYPE
WMS_DISPATCHED_TASKS_HISTOR_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DROP_OFF_TIME
WMS_DISPATCHED_TASKS_HISTOR_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRANSFER_LPN_ID
WMS_DISPATCHED_TASKS_HISTOR_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OPERATION_PLAN_ID MOVE_ORDER_LINE_ID
WMS_DISPATCHED_TASKS_HISTOR_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OP_PLAN_INSTANCE_ID
WMS_DISPATCHED_TASKS_HISTOR_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRANSACTION_ID
WMS_DISPATCHED_TASKS_HISTOR_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LAST_UPDATE_DATE ORGANIZATION_ID
WMS_DISPATCHED_TASKS_HISTOR_N9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INVENTORY_ITEM_ID TRANSACTION_ID STATUS ORGANIZATION_ID
WMS_DISPATCHED_TASKS_HISTO_N10	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARENT_TRANSACTION_ID
WMS_DISPATCHED_TASKS_HISTO_N11	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRANSACTION_TEMP_ID
WMS_DISPATCHED_TASKS_HISTO_N12	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SOURCE_DOCUMENT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TASK_ID	NUMBER		Yes	Task Identifier
TRANSACTION_ID	NUMBER		Yes	Transaction Identifier
ORGANIZATION_ID	NUMBER		Yes	Organization identifier for the completed task
USER_TASK_TYPE	NUMBER		Yes	Standard Operation ID of the completed task
PERSON_ID	NUMBER		Yes	Employee Number of the person who performed the task.
EFFECTIVE_START_DATE	DATE		Yes	Task Start Date
EFFECTIVE_END_DATE	DATE		Yes	Task End Date
EQUIPMENT_ID	NUMBER			Inventory Item Id of the Equipment used to perform the task
EQUIPMENT_INSTANCE	VARCHAR2	(30)		Serial Number of the Equipment used to perform the task
PERSON_RESOURCE_ID	NUMBER			Resource Id of the person who performed the task
MACHINE_RESOURCE_ID	NUMBER			Resource Id of the equipment used to perform the task
STATUS	NUMBER		Yes	Task Status
DISPATCHED_TIME	DATE			Dispatched Time
LOADED_TIME	DATE			Loaded Time
DROP_OFF_TIME	DATE			Drop Off Time
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
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive Flexfield structure defining column
ATTRIBUTE1	VARCHAR2	(150)		Descriptive Flexfield Segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive Flexfield Segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive Flexfield Segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive Flexfield Segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive Flexfield Segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive Flexfield Segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive Flexfield Segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive Flexfield Segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive Flexfield Segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive Flexfield Segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive Flexfield Segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive Flexfield Segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive Flexfield Segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive Flexfield Segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive Flexfield Segment
TASK_TYPE	NUMBER			SYSTEM TASK TYPE - FROM WMS_TASK_TYPES LOOKUP
PRIORITY	NUMBER			Task Priority
TASK_GROUP_ID	NUMBER			Column to group tasks together
SUGGESTED_DEST_SUBINVENTORY	VARCHAR2	(30)		Destination subinventory originally suggested by the system, i.e. by pick release
SUGGESTED_DEST_LOCATOR_ID	NUMBER			Destination locator ID originally suggested by the system, i.e. by pick release
OPERATION_PLAN_ID	NUMBER			Operation plan ID
MOVE_ORDER_LINE_ID	NUMBER			Move order line ID
TRANSFER_LPN_ID	NUMBER			Transfer LPN ID of the task
TRANSACTION_BATCH_ID	NUMBER			Batch Id of the Transaction
TRANSACTION_BATCH_SEQ	NUMBER			Batch Sequence of the Transaction
INVENTORY_ITEM_ID	NUMBER			Item identifier
REVISION	VARCHAR2	(3)		Item revision
TRANSACTION_QUANTITY	NUMBER			Transaction quantity
TRANSACTION_UOM_CODE	VARCHAR2	(3)		Transaction unit of measure code
SOURCE_SUBINVENTORY_CODE	VARCHAR2	(10)		Source subinventory code
SOURCE_LOCATOR_ID	NUMBER			Source locator identifier
DEST_SUBINVENTORY_CODE	VARCHAR2	(10)		Destination subinventory code
DEST_LOCATOR_ID	NUMBER			Destination locator identifier
LPN_ID	NUMBER			LPN identifier
CONTENT_LPN_ID	NUMBER			Content LPN identifier
IS_PARENT	VARCHAR2	(1)		Flag to indicate if the current record is a parent task or not
PARENT_TRANSACTION_ID	NUMBER			The parent task ID for the current record
TRANSFER_ORGANIZATION_ID	NUMBER			Organization identifier for the destination organization of this transfer transaction task
SOURCE_DOCUMENT_ID	NUMBER			Connectivity to the transaction history table, e.g. MMT, RCV_TRANSACTIONS
OP_PLAN_INSTANCE_ID	NUMBER			ATF operation plan instance ID
TASK_METHOD	VARCHAR2	(80)		Picking Method for Current Task
TRANSACTION_TYPE_ID	NUMBER			Transaction type ID
TRANSACTION_SOURCE_TYPE_ID	NUMBER			Transaction source type ID
TRANSACTION_ACTION_ID	NUMBER			Transaction action ID
TRANSACTION_TEMP_ID	NUMBER			Transaction Temp ID
SECONDARY_TRANSACTION_QUANTITY	NUMBER			Secondary quantity
SECONDARY_TRANSACTION_UOM_CODE	VARCHAR2	(3)		Secondary unit of measure

Query Text

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


SELECT TASK_ID
,      TRANSACTION_ID
,      ORGANIZATION_ID
,      USER_TASK_TYPE
,      PERSON_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      EQUIPMENT_ID
,      EQUIPMENT_INSTANCE
,      PERSON_RESOURCE_ID
,      MACHINE_RESOURCE_ID
,      STATUS
,      DISPATCHED_TIME
,      LOADED_TIME
,      DROP_OFF_TIME
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      TASK_TYPE
,      PRIORITY
,      TASK_GROUP_ID
,      SUGGESTED_DEST_SUBINVENTORY
,      SUGGESTED_DEST_LOCATOR_ID
,      OPERATION_PLAN_ID
,      MOVE_ORDER_LINE_ID
,      TRANSFER_LPN_ID
,      TRANSACTION_BATCH_ID
,      TRANSACTION_BATCH_SEQ
,      INVENTORY_ITEM_ID
,      REVISION
,      TRANSACTION_QUANTITY
,      TRANSACTION_UOM_CODE
,      SOURCE_SUBINVENTORY_CODE
,      SOURCE_LOCATOR_ID
,      DEST_SUBINVENTORY_CODE
,      DEST_LOCATOR_ID
,      LPN_ID
,      CONTENT_LPN_ID
,      IS_PARENT
,      PARENT_TRANSACTION_ID
,      TRANSFER_ORGANIZATION_ID
,      SOURCE_DOCUMENT_ID
,      OP_PLAN_INSTANCE_ID
,      TASK_METHOD
,      TRANSACTION_TYPE_ID
,      TRANSACTION_SOURCE_TYPE_ID
,      TRANSACTION_ACTION_ID
,      TRANSACTION_TEMP_ID
,      SECONDARY_TRANSACTION_QUANTITY
,      SECONDARY_TRANSACTION_UOM_CODE
FROM WMS.WMS_DISPATCHED_TASKS_HISTORY;

Dependencies

[top of page]

WMS.WMS_DISPATCHED_TASKS_HISTORY does not reference any database object

WMS.WMS_DISPATCHED_TASKS_HISTORY is referenced by following:

WMS: WMS_DISPATCHED_TASKS_HISTORY#