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

TABLE: WMS.WMS_DISPATCHED_TASKS_ARCH

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


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


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
WMS_DISPATCHED_TASKS_ARCH_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnLAST_UPDATE_DATE
ColumnORGANIZATION_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
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
FROM WMS.WMS_DISPATCHED_TASKS_ARCH;

Dependencies

[top of page]

WMS.WMS_DISPATCHED_TASKS_ARCH does not reference any database object

WMS.WMS_DISPATCHED_TASKS_ARCH is referenced by following:

SchemaAPPS
SynonymWMS_DISPATCHED_TASKS_ARCH