View: WMS_ELS_GROUPED_TASKS_VL

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

View Text

SELECT WEB.ELS_GROUP_ID
, WEB.ORGANIZATION_ID
, WEB.SEQUENCE_NUMBER
, WEB.ACTIVITY_ID
, WEB.ACTIVITY_DETAIL_ID
, WEB.OPERATION_ID
, WEB.LABOR_TXN_SOURCE_ID
, WEB.SOURCE_ZONE_ID
, WEB.SOURCE_SUBINVENTORY
, WEB.DESTINATION_ZONE_ID
, WEB.DESTINATION_SUBINVENTORY
, WEB.TASK_METHOD_ID
, WEB.TASK_RANGE_FROM
, WEB.TASK_RANGE_TO
, WEB.GROUP_SIZE
, WEB.EXPECTED_TRAVEL_TIME
, WEB.ACTUAL_TRAVEL_TIME
, 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_GROUPED_TASKS_B WEB
, WMS_ELS_GROUPED_TASKS_TL WEL
WHERE WEB.ELS_GROUP_ID = WEL.ELS_GROUP_ID
AND WEL.LANGUAGE = USERENV('LANG')

Columns