View: WMS_ELS_INDIVIDUAL_TASKS_VL

Product:	WMS - Warehouse Management
Description:	This view represents the MLS database entity WMS_ELS_INDIVIDUAL_TASKS
Implementation/DBA Data:	APPS.WMS_ELS_INDIVIDUAL_TASKS_VL

View Text

SELECT WEB.ELS_DATA_ID
, WEB.ORGANIZATION_ID
, WEB.SEQUENCE_NUMBER
, WEB.ANALYSIS_ID
, WEB.ACTIVITY_ID
, WEB.ACTIVITY_DETAIL_ID
, WEB.OPERATION_ID
, WEB.EQUIPMENT_ID
, WEB.SOURCE_ZONE_ID
, WEB.SOURCE_SUBINVENTORY
, WEB.DESTINATION_ZONE_ID
, WEB.DESTINATION_SUBINVENTORY
, WEB.LABOR_TXN_SOURCE_ID
, WEB.TRANSACTION_UOM
, WEB.FROM_QUANTITY
, WEB.TO_QUANTITY
, WEB.ITEM_CATEGORY_ID
, WEB.OPERATION_PLAN_ID
, WEB.GROUP_ID
, WEB.TASK_TYPE_ID
, WEB.TASK_METHOD_ID
, WEB.EXPECTED_TRAVEL_TIME
, WEB.EXPECTED_TXN_TIME
, WEB.EXPECTED_IDLE_TIME
, WEB.ACTUAL_TRAVEL_TIME
, WEB.ACTUAL_TXN_TIME
, WEB.ACTUAL_IDLE_TIME
, WEB.TRAVEL_TIME_THRESHOLD
, WEB.HISTORY_FLAG
, WEB.ARCHIVE_DATE
, WEB.NUM_TRX_MATCHED
, WEB.LAST_UPDATED_BY
, WEB.LAST_UPDATE_LOGIN
, WEB.CREATED_BY
, WEB.CREATION_DATE
, WEB.LAST_UPDATE_DATE
, WEB.ATTRIBUTE_CATEGORY
, WEB.ATTRIBUTE1
, WEB.ATTRIBUTE2
, WEB.ATTRIBUTE3
, WEB.ATTRIBUTE4
, WEB.ATTRIBUTE5
, WEB.ATTRIBUTE6
, WEB.ATTRIBUTE7
, WEB.ATTRIBUTE8
, WEB.ATTRIBUTE9
, WEB.ATTRIBUTE10
, WEB.ATTRIBUTE11
, WEB.ATTRIBUTE12
, WEB.ATTRIBUTE13
, WEB.ATTRIBUTE14
, WEB.ATTRIBUTE15
, WEL.LANGUAGE
, WEL.SOURCE_LANG
, WEL.DESCRIPTION
FROM WMS_ELS_INDIVIDUAL_TASKS_B WEB
, WMS_ELS_INDIVIDUAL_TASKS_TL WEL
WHERE WEB.ELS_DATA_ID = WEL.ELS_DATA_ID
AND WEL.LANGUAGE = USERENV('LANG')

Columns