VIEW: WMS.WMS_ELS_TRX_SRC#

Source

View Text - Preformatted

select ELS_TRX_SRC_ID ELS_TRX_SRC_ID, TRANSACTION_DATE TRANSACTION_DATE, ACTIVITY_ID ACTIVITY_ID, ACTIVITY_DETAIL_ID ACTIVITY_DETAIL_ID, OPERATION_ID OPERATION_ID, ORGANIZATION_ID ORGANIZATION_ID, USER_ID USER_ID, EQUIPMENT_ID EQUIPMENT_ID, SOURCE_ZONE_ID SOURCE_ZONE_ID, SOURCE_SUBINVENTORY SOURCE_SUBINVENTORY, DESTINATION_SUBINVENTORY DESTINATION_SUBINVENTORY, FROM_LOCATOR_ID FROM_LOCATOR_ID, TO_LOCATOR_ID TO_LOCATOR_ID, DESTINATION_ZONE_ID DESTINATION_ZONE_ID, LABOR_TXN_SOURCE_ID LABOR_TXN_SOURCE_ID, TRANSACTION_UOM TRANSACTION_UOM, QUANTITY QUANTITY, ITEM_CATEGORY_ID ITEM_CATEGORY_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, OPERATION_PLAN_ID OPERATION_PLAN_ID, GROUP_ID GROUP_ID, TASK_METHOD_ID TASK_METHOD_ID, TASK_TYPE_ID TASK_TYPE_ID, GROUPED_TASK_IDENTIFIER GROUPED_TASK_IDENTIFIER, GROUP_SIZE GROUP_SIZE, MATCH_GROUP MATCH_GROUP, TRAVEL_TIME TRAVEL_TIME, TRANSACTION_TIME TRANSACTION_TIME, IDLE_TIME IDLE_TIME, TRAVEL_AND_IDLE_TIME TRAVEL_AND_IDLE_TIME, TRAVEL_SCORE TRAVEL_SCORE, TXN_SCORE TXN_SCORE, IDLE_SCORE IDLE_SCORE, EMPLOYEE_RATING_TRAVEL EMPLOYEE_RATING_TRAVEL, EMPLOYEE_RATING_TXN EMPLOYEE_RATING_TXN, EMPLOYEE_RATING_IDLE EMPLOYEE_RATING_IDLE, UNATTRIBUTED_FLAG UNATTRIBUTED_FLAG, ELS_DATA_ID ELS_DATA_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE from "WMS"."WMS_ELS_TRX_SRC"

View Text - HTML Formatted

SELECT ELS_TRX_SRC_ID ELS_TRX_SRC_ID
, TRANSACTION_DATE TRANSACTION_DATE
, ACTIVITY_ID ACTIVITY_ID
, ACTIVITY_DETAIL_ID ACTIVITY_DETAIL_ID
, OPERATION_ID OPERATION_ID
, ORGANIZATION_ID ORGANIZATION_ID
, USER_ID USER_ID
, EQUIPMENT_ID EQUIPMENT_ID
, SOURCE_ZONE_ID SOURCE_ZONE_ID
, SOURCE_SUBINVENTORY SOURCE_SUBINVENTORY
, DESTINATION_SUBINVENTORY DESTINATION_SUBINVENTORY
, FROM_LOCATOR_ID FROM_LOCATOR_ID
, TO_LOCATOR_ID TO_LOCATOR_ID
, DESTINATION_ZONE_ID DESTINATION_ZONE_ID
, LABOR_TXN_SOURCE_ID LABOR_TXN_SOURCE_ID
, TRANSACTION_UOM TRANSACTION_UOM
, QUANTITY QUANTITY
, ITEM_CATEGORY_ID ITEM_CATEGORY_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, OPERATION_PLAN_ID OPERATION_PLAN_ID
, GROUP_ID GROUP_ID
, TASK_METHOD_ID TASK_METHOD_ID
, TASK_TYPE_ID TASK_TYPE_ID
, GROUPED_TASK_IDENTIFIER GROUPED_TASK_IDENTIFIER
, GROUP_SIZE GROUP_SIZE
, MATCH_GROUP MATCH_GROUP
, TRAVEL_TIME TRAVEL_TIME
, TRANSACTION_TIME TRANSACTION_TIME
, IDLE_TIME IDLE_TIME
, TRAVEL_AND_IDLE_TIME TRAVEL_AND_IDLE_TIME
, TRAVEL_SCORE TRAVEL_SCORE
, TXN_SCORE TXN_SCORE
, IDLE_SCORE IDLE_SCORE
, EMPLOYEE_RATING_TRAVEL EMPLOYEE_RATING_TRAVEL
, EMPLOYEE_RATING_TXN EMPLOYEE_RATING_TXN
, EMPLOYEE_RATING_IDLE EMPLOYEE_RATING_IDLE
, UNATTRIBUTED_FLAG UNATTRIBUTED_FLAG
, ELS_DATA_ID ELS_DATA_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
FROM "WMS"."WMS_ELS_TRX_SRC"