View: WMS_DEVICE_REQUESTS_WCSV

Product:	WMS - Warehouse Management
Description:	View on which device request query and device response query can be based
Implementation/DBA Data:	APPS.WMS_DEVICE_REQUESTS_WCSV

View Text

SELECT WDR.REQUEST_ID REQUEST_ID
, WDR.TASK_ID TASK_ID
, WDR.SEQUENCE_ID SEQUENCE_ID
, WDR.TASK_TYPE_ID TASK_TYPE_ID
, WDR.TRANSACTION_QUANTITY QUANTITY
, WDR.SUBINVENTORY_CODE SUBINVENTORY_CODE
, INV_PROJECT.GET_LOCSEGS(MIL.INVENTORY_LOCATION_ID
, MIL.ORGANIZATION_ID) LOCATOR
, WD.NAME DEVICE_NAME
, WD.DEVICE_ID DEVICE_ID
, WD.DEVICE_TYPE_ID DEVICE_TYPE_ID
, ML1.MEANING BUSINESS_EVENT
, WDR.BUSINESS_EVENT_ID BUSINESS_EVENT_ID
, WDR.RELATION_ID RELATION_ID
, WLPN.LICENSE_PLATE_NUMBER LPN
, MSI.SEGMENT1 ITEM
, MIL.SEGMENT1 SEGMENT1
, MIL.SEGMENT2 SEGMENT2
, MIL.SEGMENT3 SEGMENT3
, MIL.SEGMENT4 SEGMENT4
, MIL.SEGMENT5 SEGMENT5
, MIL.SEGMENT6 SEGMENT6
, MIL.SEGMENT7 SEGMENT7
, MIL.SEGMENT8 SEGMENT8
, MIL.SEGMENT9 SEGMENT9
, MIL.SEGMENT10 SEGMENT10
, MIL.SEGMENT11 SEGMENT11
, MIL.SEGMENT12 SEGMENT12
, MIL.SEGMENT13 SEGMENT13
, MIL.SEGMENT14 SEGMENT14
, MIL.SEGMENT15 SEGMENT15
, MIL.SEGMENT16 SEGMENT16
, MIL.SEGMENT17 SEGMENT17
, MIL.SEGMENT18 SEGMENT18
, MIL.SEGMENT19 SEGMENT19
, MIL.SEGMENT20 SEGMENT20
, WDR.TASK_SUMMARY TASK_SUMMARY
, WDR.LOCATOR_ID LOCATOR_ID
, WDR.TRANSFER_ORG_ID TRANSFER_ORG_ID
, WDR.TRANSFER_SUB_CODE TRANSFER_SUB_CODE
, WDR.TRANSFER_LOC_ID TRANSFER_LOC_ID
, WDR.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, WDR.REVISION REVISION
, WDR.UOM UOM
, WDR.LOT_NUMBER LOT_NUMBER
, WDR.LOT_QTY LOT_QTY
, WDR.SERIAL_NUMBER SERIAL_NUMBER
, WDR.TRANSACTION_QUANTITY TRANSACTION_QUANTITY
, WDR.STATUS_CODE STATUS_CODE
, WDR.STATUS_MSG STATUS_MSG
, WDR.OUTFILE_NAME OUTFILE_NAME
FROM WMS_DEVICES WD
, MFG_LOOKUPS ML1
, WMS_DEVICE_REQUESTS WDR
, MTL_ITEM_LOCATIONS MIL
, WMS_LICENSE_PLATE_NUMBERS WLPN
, MTL_SYSTEM_ITEMS MSI
WHERE ML1.LOOKUP_TYPE (+) = 'WMS_BUS_EVENT_TYPES'
AND ML1.LOOKUP_CODE (+) = WDR.BUSINESS_EVENT_ID
AND WD.DEVICE_ID = WDR.DEVICE_ID
AND MIL.ORGANIZATION_ID (+) = WDR.ORGANIZATION_ID
AND MIL.SUBINVENTORY_CODE(+) = WDR.SUBINVENTORY_CODE
AND MIL.INVENTORY_LOCATION_ID(+) = WDR.LOCATOR_ID
AND WLPN.LPN_ID(+) = WDR.LPN_ID
AND MSI.ORGANIZATION_ID(+) = WDR.ORGANIZATION_ID
AND MSI.INVENTORY_ITEM_ID(+) = WDR.INVENTORY_ITEM_ID

Columns