VIEW: WMS.WMS_DEVICE_REQUESTS_HIST#

Source

View Text - Preformatted

select REQUEST_ID REQUEST_ID, TASK_ID TASK_ID, RELATION_ID RELATION_ID, SEQUENCE_ID SEQUENCE_ID, TASK_SUMMARY TASK_SUMMARY, TASK_TYPE_ID TASK_TYPE_ID, BUSINESS_EVENT_ID BUSINESS_EVENT_ID, ORGANIZATION_ID ORGANIZATION_ID, SUBINVENTORY_CODE SUBINVENTORY_CODE, LOCATOR_ID LOCATOR_ID, TRANSFER_ORG_ID TRANSFER_ORG_ID, TRANSFER_SUB_CODE TRANSFER_SUB_CODE, TRANSFER_LOC_ID TRANSFER_LOC_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, REVISION REVISION, UOM UOM, LOT_NUMBER LOT_NUMBER, LOT_QTY LOT_QTY, SERIAL_NUMBER SERIAL_NUMBER, LPN_ID LPN_ID, TRANSACTION_QUANTITY TRANSACTION_QUANTITY, DEVICE_ID DEVICE_ID, STATUS_CODE STATUS_CODE, STATUS_MSG STATUS_MSG, OUTFILE_NAME OUTFILE_NAME, REQUEST_DATE REQUEST_DATE, RESUBMIT_DATE RESUBMIT_DATE, REQUESTED_BY REQUESTED_BY, RESPONSIBILITY_APPLICATION_ID RESPONSIBILITY_APPLICATION_ID, RESPONSIBILITY_ID RESPONSIBILITY_ID, CONCURRENT_REQUEST_ID CONCURRENT_REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, DEVICE_STATUS DEVICE_STATUS, REASON_ID REASON_ID, XFER_LPN_ID XFER_LPN_ID from "WMS"."WMS_DEVICE_REQUESTS_HIST"

View Text - HTML Formatted

SELECT REQUEST_ID REQUEST_ID
, TASK_ID TASK_ID
, RELATION_ID RELATION_ID
, SEQUENCE_ID SEQUENCE_ID
, TASK_SUMMARY TASK_SUMMARY
, TASK_TYPE_ID TASK_TYPE_ID
, BUSINESS_EVENT_ID BUSINESS_EVENT_ID
, ORGANIZATION_ID ORGANIZATION_ID
, SUBINVENTORY_CODE SUBINVENTORY_CODE
, LOCATOR_ID LOCATOR_ID
, TRANSFER_ORG_ID TRANSFER_ORG_ID
, TRANSFER_SUB_CODE TRANSFER_SUB_CODE
, TRANSFER_LOC_ID TRANSFER_LOC_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, REVISION REVISION
, UOM UOM
, LOT_NUMBER LOT_NUMBER
, LOT_QTY LOT_QTY
, SERIAL_NUMBER SERIAL_NUMBER
, LPN_ID LPN_ID
, TRANSACTION_QUANTITY TRANSACTION_QUANTITY
, DEVICE_ID DEVICE_ID
, STATUS_CODE STATUS_CODE
, STATUS_MSG STATUS_MSG
, OUTFILE_NAME OUTFILE_NAME
, REQUEST_DATE REQUEST_DATE
, RESUBMIT_DATE RESUBMIT_DATE
, REQUESTED_BY REQUESTED_BY
, RESPONSIBILITY_APPLICATION_ID RESPONSIBILITY_APPLICATION_ID
, RESPONSIBILITY_ID RESPONSIBILITY_ID
, CONCURRENT_REQUEST_ID CONCURRENT_REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, DEVICE_STATUS DEVICE_STATUS
, REASON_ID REASON_ID
, XFER_LPN_ID XFER_LPN_ID
FROM "WMS"."WMS_DEVICE_REQUESTS_HIST"