VIEW: APPS.WMS_DEVICE_REQUESTS_WCSV

Source

View Text - Preformatted

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

View Text - HTML Formatted

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