VIEW: APPS.WMS_ELS_GROUPED_TASKS_VL

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')