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

VIEW: WMS.WMS_DISPATCHED_TASKS_ARCH#

Object Details
Object Name: WMS_DISPATCHED_TASKS_ARCH#
Object Type: VIEW
Owner: WMS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
TASK_ID NUMBER
Yes
TRANSACTION_ID NUMBER
Yes
ORGANIZATION_ID NUMBER
Yes
USER_TASK_TYPE NUMBER
Yes
PERSON_ID NUMBER
Yes
EFFECTIVE_START_DATE DATE
Yes
EFFECTIVE_END_DATE DATE
Yes
EQUIPMENT_ID NUMBER

EQUIPMENT_INSTANCE VARCHAR2 (30)
PERSON_RESOURCE_ID NUMBER

MACHINE_RESOURCE_ID NUMBER

STATUS NUMBER
Yes
DISPATCHED_TIME DATE

LOADED_TIME DATE

DROP_OFF_TIME DATE

LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER

ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
TASK_TYPE NUMBER

PRIORITY NUMBER

TASK_GROUP_ID NUMBER

SUGGESTED_DEST_SUBINVENTORY VARCHAR2 (30)
SUGGESTED_DEST_LOCATOR_ID NUMBER

OPERATION_PLAN_ID NUMBER

MOVE_ORDER_LINE_ID NUMBER

TRANSFER_LPN_ID NUMBER

TRANSACTION_BATCH_ID NUMBER

TRANSACTION_BATCH_SEQ NUMBER

INVENTORY_ITEM_ID NUMBER

REVISION VARCHAR2 (3)
TRANSACTION_QUANTITY NUMBER

TRANSACTION_UOM_CODE VARCHAR2 (3)
SOURCE_SUBINVENTORY_CODE VARCHAR2 (10)
SOURCE_LOCATOR_ID NUMBER

DEST_SUBINVENTORY_CODE VARCHAR2 (10)
DEST_LOCATOR_ID NUMBER

LPN_ID NUMBER

CONTENT_LPN_ID NUMBER

IS_PARENT VARCHAR2 (1)
PARENT_TRANSACTION_ID NUMBER

TRANSFER_ORGANIZATION_ID NUMBER

SOURCE_DOCUMENT_ID NUMBER

OP_PLAN_INSTANCE_ID NUMBER

TASK_METHOD VARCHAR2 (80)
TRANSACTION_TYPE_ID NUMBER

TRANSACTION_SOURCE_TYPE_ID NUMBER

TRANSACTION_ACTION_ID NUMBER

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# references the following:

SchemaWMS
TableWMS_DISPATCHED_TASKS_ARCH
WMS.WMS_DISPATCHED_TASKS_ARCH# is referenced by following:

SchemaAPPS
SynonymWMS_DISPATCHED_TASKS_ARCH