View: WMS_DEVICE_REQUESTS_HIST_V

Product:	WMS - Warehouse Management
Description:	Device Request History. It is used for View Device Request History form
Implementation/DBA Data:	APPS.WMS_DEVICE_REQUESTS_HIST_V

View Text

SELECT WDRH.ROWID ROW_ID
, WDRH.REQUEST_ID
, WDRH.TASK_ID
, WDRH.RELATION_ID
, WDRH.SEQUENCE_ID
, WDRH.TASK_SUMMARY
, WDRH.TASK_TYPE_ID
, ML2.MEANING TASK_TYPE
, WDRH.BUSINESS_EVENT_ID
, ML.MEANING BUSINESS_EVENT
, WDRH.ORGANIZATION_ID
, MP.ORGANIZATION_CODE
, WDRH.SUBINVENTORY_CODE
, WDRH.LOCATOR_ID
, MILK1.CONCATENATED_SEGMENTS LOCATOR
, WDRH.TRANSFER_ORG_ID
, MP2.ORGANIZATION_CODE TRANSFER_ORG_CODE
, WDRH.TRANSFER_SUB_CODE
, WDRH.TRANSFER_LOC_ID
, MILK2.CONCATENATED_SEGMENTS TRANSFER_LOCATOR
, WDRH.INVENTORY_ITEM_ID
, MSI.SEGMENT1 ITEM
, WDRH.REVISION
, WDRH.UOM
, WDRH.LOT_NUMBER
, WDRH.LOT_QTY
, WDRH.SERIAL_NUMBER
, WDRH.LPN_ID
, WLPN.LICENSE_PLATE_NUMBER
, WDRH.TRANSACTION_QUANTITY
, WDRH.DEVICE_ID
, WD.NAME DEVICE_NAME
, WD.DEVICE_TYPE_ID
, ML3.MEANING DEVICE_TYPE
, WDRH.STATUS_CODE
, WDRH.STATUS_MSG
, WDRH.OUTFILE_NAME
, WDRH.REQUEST_DATE
, WDRH.RESUBMIT_DATE
, WDRH.CONCURRENT_REQUEST_ID
, WDRH.REQUESTED_BY
, WDRH.RESPONSIBILITY_APPLICATION_ID
, WDRH.RESPONSIBILITY_ID
, WDRH.CREATION_DATE
, WDRH.CREATED_BY
, WDRH.LAST_UPDATE_DATE
, WDRH.LAST_UPDATED_BY
, WDRH.LAST_UPDATE_LOGIN
, WDRH.DEVICE_STATUS
, WDRH.REASON_ID
, WDRH.XFER_LPN_ID
, WE.EPC
FROM WMS_DEVICE_REQUESTS_HIST WDRH
, MFG_LOOKUPS ML
, MFG_LOOKUPS ML2
, MFG_LOOKUPS ML3
, MTL_PARAMETERS MP
, MTL_PARAMETERS MP2
, MTL_ITEM_LOCATIONS_KFV MILK1
, MTL_ITEM_LOCATIONS_KFV MILK2
, MTL_SYSTEM_ITEMS MSI
, WMS_DEVICES_VL WD
, WMS_LICENSE_PLATE_NUMBERS WLPN
, WMS_EPC WE
WHERE ML.LOOKUP_TYPE= 'WMS_BUS_EVENT_TYPES'
AND ML.LOOKUP_CODE = WDRH.BUSINESS_EVENT_ID
AND ML2.LOOKUP_TYPE(+) = 'WMS_TASK_TYPES'
AND ML2.LOOKUP_CODE(+) = WDRH.TASK_TYPE_ID
AND MP.ORGANIZATION_ID = WDRH.ORGANIZATION_ID
AND MP2.ORGANIZATION_ID(+) = WDRH.TRANSFER_ORG_ID
AND MILK1.ORGANIZATION_ID(+) = WDRH.ORGANIZATION_ID
AND MILK1.SUBINVENTORY_CODE(+) = WDRH.SUBINVENTORY_CODE
AND MILK1.INVENTORY_LOCATION_ID(+) = WDRH.LOCATOR_ID
AND MILK2.ORGANIZATION_ID (+) = WDRH.TRANSFER_ORG_ID
AND MILK2.SUBINVENTORY_CODE(+) = WDRH.TRANSFER_SUB_CODE
AND MILK2.INVENTORY_LOCATION_ID(+) = WDRH.TRANSFER_LOC_ID
AND MSI.ORGANIZATION_ID(+) = WDRH.ORGANIZATION_ID
AND MSI.INVENTORY_ITEM_ID(+) = WDRH.INVENTORY_ITEM_ID
AND WD.DEVICE_ID = WDRH.DEVICE_ID
AND WLPN.LPN_ID(+) = WDRH.LPN_ID
AND ML3.LOOKUP_TYPE = 'WMS_DEVICE_TYPES'
AND ML3.LOOKUP_CODE = WD.DEVICE_TYPE_ID
AND WE.LPN_ID(+) = WLPN.LPN_ID

Columns