VIEW: APPS.WMS_ELS_INDIVIDUAL_TASKS_VL

Source

View Text - Preformatted

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

View Text - HTML Formatted

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