VIEW: APPS.WMS_DEVICE_REQUESTS_HIST_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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