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


VIEW: APPS.WMS_TASKS_V

Object Details
Object Name: WMS_TASKS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewWMS.WMS_TASKS_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
TRANSACTION_TEMP_ID NUMBER

INVENTORY_ITEM_ID NUMBER

ITEM_DESCRIPTION VARCHAR2 (240)
ITEM VARCHAR2 (40)
ORGANIZATION_ID NUMBER

ORGANIZATION_CODE VARCHAR2 (3)
ORGANIZATION_NAME VARCHAR2 (240)
REVISION VARCHAR2 (3)
LOT_NUMBER VARCHAR2 (80)
SUBINVENTORY_CODE VARCHAR2 (10)
LOCATOR_ID NUMBER

LOCATOR_DESCRIPTION VARCHAR2 (50)
LOCATOR VARCHAR2 (1)
TRANSACTION_TYPE_ID NUMBER

TRANSACTION_TYPE VARCHAR2 (240)
TRANSACTION_ACTION_ID NUMBER

TRANSACTION_ACTION VARCHAR2 (80)
TRANSACTION_SOURCE_TYPE_ID NUMBER

TRANSACTION_SOURCE_TYPE VARCHAR2 (30)
TRANSACTION_SOURCE_ID NUMBER

TRANSACTION_SOURCE_LINE_ID NUMBER

TRANSACTION_SOURCE_NAME VARCHAR2 (80)
TRANSFER_ORGANIZATION NUMBER

TRANSFER_ORGANIZATION_CODE VARCHAR2 (3)
TRANSFER_ORGANIZATION_NAME VARCHAR2 (240)
TRANSFER_SUBINVENTORY VARCHAR2 (10)
TRANSFER_TO_LOCATION NUMBER

TRANSFER_LOCATOR_DESCRIPTION VARCHAR2 (50)
TRANSFER_LOCATOR VARCHAR2 (1)
TRANSACTION_UOM VARCHAR2 (3)
TRANSACTION_QUANTITY NUMBER

TASK_ID NUMBER

USER_TASK_TYPE NUMBER

USER_TASK_TYPE_CODE VARCHAR2 (4)
PERSON_ID NUMBER

LAST_NAME VARCHAR2 (150)
FIRST_NAME VARCHAR2 (150)
FULL_NAME VARCHAR2 (240)
EFFECTIVE_START_DATE DATE

EFFECTIVE_END_DATE DATE

EQUIPMENT_ID NUMBER

EQUIPMENT VARCHAR2 (40)
EQUIPMENT_DESCRIPTION VARCHAR2 (240)
EQUIPMENT_INSTANCE VARCHAR2 (30)
PERSON_RESOURCE_ID NUMBER

PERSON_RESOURCE_CODE VARCHAR2 (10)
MACHINE_RESOURCE_ID NUMBER

MACHINE_RESOURCE_CODE VARCHAR2 (10)
STATUS NUMBER

STATUS_CODE VARCHAR2 (80)
DISPATCHED_TIME DATE

LOADED_TIME DATE

DROP_OFF_TIME DATE

LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER

CREATION_DATE DATE

CREATED_BY NUMBER

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)
PRIORITY NUMBER

USER_TASK_TYPE_DESCRIPTION VARCHAR2 (240)
TASK_TYPE NUMBER

TASK_TYPE_DESCRIPTION VARCHAR2 (80)
MOVE_ORDER_LINE_ID NUMBER

PICK_SLIP_NUMBER NUMBER

Query Text

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


SELECT ROW_ID
,      TRANSACTION_TEMP_ID
,      INVENTORY_ITEM_ID
,      ITEM_DESCRIPTION
,      ITEM
,      ORGANIZATION_ID
,      ORGANIZATION_CODE
,      ORGANIZATION_NAME
,      REVISION
,      LOT_NUMBER
,      SUBINVENTORY_CODE
,      LOCATOR_ID
,      LOCATOR_DESCRIPTION
,      LOCATOR
,      TRANSACTION_TYPE_ID
,      TRANSACTION_TYPE
,      TRANSACTION_ACTION_ID
,      TRANSACTION_ACTION
,      TRANSACTION_SOURCE_TYPE_ID
,      TRANSACTION_SOURCE_TYPE
,      TRANSACTION_SOURCE_ID
,      TRANSACTION_SOURCE_LINE_ID
,      TRANSACTION_SOURCE_NAME
,      TRANSFER_ORGANIZATION
,      TRANSFER_ORGANIZATION_CODE
,      TRANSFER_ORGANIZATION_NAME
,      TRANSFER_SUBINVENTORY
,      TRANSFER_TO_LOCATION
,      TRANSFER_LOCATOR_DESCRIPTION
,      TRANSFER_LOCATOR
,      TRANSACTION_UOM
,      TRANSACTION_QUANTITY
,      TASK_ID
,      USER_TASK_TYPE
,      USER_TASK_TYPE_CODE
,      PERSON_ID
,      LAST_NAME
,      FIRST_NAME
,      FULL_NAME
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      EQUIPMENT_ID
,      EQUIPMENT
,      EQUIPMENT_DESCRIPTION
,      EQUIPMENT_INSTANCE
,      PERSON_RESOURCE_ID
,      PERSON_RESOURCE_CODE
,      MACHINE_RESOURCE_ID
,      MACHINE_RESOURCE_CODE
,      STATUS
,      STATUS_CODE
,      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
,      PRIORITY
,      USER_TASK_TYPE_DESCRIPTION
,      TASK_TYPE
,      TASK_TYPE_DESCRIPTION
,      MOVE_ORDER_LINE_ID
,      PICK_SLIP_NUMBER
FROM APPS.WMS_TASKS_V;

Dependencies

[top of page]

APPS.WMS_TASKS_V references the following:

SchemaAPPS
SynonymBOM_RESOURCES
SynonymBOM_STANDARD_OPERATIONS
SynonymHR_ALL_ORGANIZATION_UNITS
ViewMFG_LOOKUPS
ViewMTL_ITEM_LOCATIONS_KFV
SynonymMTL_MATERIAL_TRANSACTIONS
SynonymMTL_MATERIAL_TRANSACTIONS_TEMP
SynonymMTL_PARAMETERS
SynonymMTL_SYSTEM_ITEMS_KFV
SynonymMTL_TRANSACTION_LOTS_TEMP
SynonymMTL_TRANSACTION_LOT_NUMBERS
SynonymMTL_TRANSACTION_TYPES
SynonymMTL_TXN_SOURCE_TYPES
SynonymPER_ALL_PEOPLE_F
SynonymWMS_DISPATCHED_TASKS
SynonymWMS_DISPATCHED_TASKS_HISTORY

APPS.WMS_TASKS_V is not referenced by any database object