eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.WMS_ACTIVE_EXCEPTIONS_V

Source

View Text - Preformatted


SELECT MMTT.ROWID , MMTT.TRANSACTION_TEMP_ID , MMTT.INVENTORY_ITEM_ID , NULL , NULL , MMTT.ORGANIZATION_ID , NULL , NULL , MMTT.REVISION , NULL , MMTT.SUBINVENTORY_CODE , MMTT.LOCATOR_ID , NULL , NULL , MMTT.TRANSACTION_TYPE_ID , NULL , MMTT.TRANSACTION_ACTION_ID , NULL , MMTT.TRANSACTION_SOURCE_TYPE_ID , NULL , MMTT.TRANSACTION_SOURCE_ID , MMTT.TRX_SOURCE_LINE_ID , MMTT.TRANSACTION_SOURCE_NAME , MMTT.TRANSFER_ORGANIZATION , NULL , NULL , MMTT.TRANSFER_SUBINVENTORY , MMTT.TRANSFER_TO_LOCATION , NULL , NULL , MMTT.TRANSACTION_UOM , MMTT.TRANSACTION_QUANTITY , WDT.TASK_ID , NVL(WDT.USER_TASK_TYPE, MMTT.STANDARD_OPERATION_ID) , NULL , WDT.PERSON_ID , NULL , NULL , NULL , WDT.EFFECTIVE_START_DATE , WDT.EFFECTIVE_END_DATE , WDT.EQUIPMENT_ID , NULL , NULL , WDT.EQUIPMENT_INSTANCE , WDT.PERSON_RESOURCE_ID , NULL , WDT.MACHINE_RESOURCE_ID , NULL , NVL(WDT.STATUS,1) , NULL , WDT.DISPATCHED_TIME , WDT.LOADED_TIME , WDT.DROP_OFF_TIME , MMTT.LAST_UPDATE_DATE , MMTT.LAST_UPDATED_BY , MMTT.CREATION_DATE , MMTT.CREATED_BY , MMTT.LAST_UPDATE_LOGIN , WDT.ATTRIBUTE_CATEGORY , WDT.ATTRIBUTE1 , WDT.ATTRIBUTE2 , WDT.ATTRIBUTE3 , WDT.ATTRIBUTE4 , WDT.ATTRIBUTE5 , WDT.ATTRIBUTE6 , WDT.ATTRIBUTE7 , WDT.ATTRIBUTE8 , WDT.ATTRIBUTE9 , WDT.ATTRIBUTE10 , WDT.ATTRIBUTE11 , WDT.ATTRIBUTE12 , WDT.ATTRIBUTE13 , WDT.ATTRIBUTE14 , WDT.ATTRIBUTE15 , WDT.PRIORITY , NULL , NVL(WDT.TASK_TYPE, MMTT.WMS_TASK_TYPE) , NULL , MMTT.MOVE_ORDER_LINE_ID , MMTT.PICK_SLIP_NUMBER , WE.REASON_ID , NULL , MMTT.CARTONIZATION_ID , MMTT.ALLOCATED_LPN_ID , MMTT.CONTAINER_ITEM_ID FROM WMS_DISPATCHED_TASKS WDT, MTL_MATERIAL_TRANSACTIONS_TEMP MMTT, WMS_EXCEPTIONS WE WHERE WDT.TRANSACTION_TEMP_ID = MMTT.TRANSACTION_TEMP_ID AND WDT.TASK_TYPE = MMTT.WMS_TASK_TYPE AND MMTT.PARENT_LINE_ID IS NULL AND WE.TRANSACTION_HEADER_ID = MMTT.TRANSACTION_HEADER_ID AND NVL(WE.WMS_TASK_TYPE, 1) = MMTT.WMS_TASK_TYPE UNION ALL SELECT MCCE.ROWID , MCCE.CYCLE_COUNT_ENTRY_ID , MCCE.INVENTORY_ITEM_ID , NULL , NULL , MCCE.ORGANIZATION_ID , NULL , NULL , MCCE.REVISION , NULL , MCCE.SUBINVENTORY , MCCE.LOCATOR_ID , NULL , NULL , TO_NUMBER(NULL) , NULL , TO_NUMBER(NULL) , NULL , 9 , NULL , TO_NUMBER(NULL) , TO_NUMBER(NULL) , MCCH.CYCLE_COUNT_HEADER_NAME , TO_NUMBER(NULL) , NULL , NULL , NULL , TO_NUMBER(NULL) , NULL , NULL , NULL , TO_NUMBER(NULL) , WDT.TASK_ID , NVL(WDT.USER_TASK_TYPE, MCCE.STANDARD_OPERATION_ID) , NULL , WDT.PERSON_ID , NULL , NULL , NULL , WDT.EFFECTIVE_START_DATE , WDT.EFFECTIVE_END_DATE , WDT.EQUIPMENT_ID , NULL , NULL , WDT.EQUIPMENT_INSTANCE , WDT.PERSON_RESOURCE_ID , NULL , WDT.MACHINE_RESOURCE_ID , NULL , NVL(WDT.STATUS,1) , NULL , WDT.DISPATCHED_TIME , WDT.LOADED_TIME , WDT.DROP_OFF_TIME , MCCE.LAST_UPDATE_DATE , MCCE.LAST_UPDATED_BY , MCCE.CREATION_DATE , MCCE.CREATED_BY , MCCE.LAST_UPDATE_LOGIN , WDT.ATTRIBUTE_CATEGORY , WDT.ATTRIBUTE1 , WDT.ATTRIBUTE2 , WDT.ATTRIBUTE3 , WDT.ATTRIBUTE4 , WDT.ATTRIBUTE5 , WDT.ATTRIBUTE6 , WDT.ATTRIBUTE7 , WDT.ATTRIBUTE8 , WDT.ATTRIBUTE9 , WDT.ATTRIBUTE10 , WDT.ATTRIBUTE11 , WDT.ATTRIBUTE12 , WDT.ATTRIBUTE13 , WDT.ATTRIBUTE14 , WDT.ATTRIBUTE15 , WDT.PRIORITY , NULL , NVL(WDT.TASK_TYPE, 3) , NULL , TO_NUMBER(NULL) , TO_NUMBER(NULL) , WE.REASON_ID , NULL , TO_NUMBER(NULL) , TO_NUMBER(NULL) , TO_NUMBER(NULL) FROM WMS_DISPATCHED_TASKS WDT, MTL_CYCLE_COUNT_ENTRIES MCCE, WMS_EXCEPTIONS WE, MTL_CYCLE_COUNT_HEADERS MCCH WHERE WDT.TRANSACTION_TEMP_ID = MCCE.CYCLE_COUNT_ENTRY_ID AND WDT.TASK_TYPE = 3 AND WE.TASK_ID = MCCE.CYCLE_COUNT_ENTRY_ID AND WE.WMS_TASK_TYPE = 3 AND MCCE.CYCLE_COUNT_HEADER_ID = MCCH.CYCLE_COUNT_HEADER_ID

View Text - HTML Formatted

SELECT MMTT.ROWID
, MMTT.TRANSACTION_TEMP_ID
, MMTT.INVENTORY_ITEM_ID
, NULL
, NULL
, MMTT.ORGANIZATION_ID
, NULL
, NULL
, MMTT.REVISION
, NULL
, MMTT.SUBINVENTORY_CODE
, MMTT.LOCATOR_ID
, NULL
, NULL
, MMTT.TRANSACTION_TYPE_ID
, NULL
, MMTT.TRANSACTION_ACTION_ID
, NULL
, MMTT.TRANSACTION_SOURCE_TYPE_ID
, NULL
, MMTT.TRANSACTION_SOURCE_ID
, MMTT.TRX_SOURCE_LINE_ID
, MMTT.TRANSACTION_SOURCE_NAME
, MMTT.TRANSFER_ORGANIZATION
, NULL
, NULL
, MMTT.TRANSFER_SUBINVENTORY
, MMTT.TRANSFER_TO_LOCATION
, NULL
, NULL
, MMTT.TRANSACTION_UOM
, MMTT.TRANSACTION_QUANTITY
, WDT.TASK_ID
, NVL(WDT.USER_TASK_TYPE
, MMTT.STANDARD_OPERATION_ID)
, NULL
, WDT.PERSON_ID
, NULL
, NULL
, NULL
, WDT.EFFECTIVE_START_DATE
, WDT.EFFECTIVE_END_DATE
, WDT.EQUIPMENT_ID
, NULL
, NULL
, WDT.EQUIPMENT_INSTANCE
, WDT.PERSON_RESOURCE_ID
, NULL
, WDT.MACHINE_RESOURCE_ID
, NULL
, NVL(WDT.STATUS
, 1)
, NULL
, WDT.DISPATCHED_TIME
, WDT.LOADED_TIME
, WDT.DROP_OFF_TIME
, MMTT.LAST_UPDATE_DATE
, MMTT.LAST_UPDATED_BY
, MMTT.CREATION_DATE
, MMTT.CREATED_BY
, MMTT.LAST_UPDATE_LOGIN
, WDT.ATTRIBUTE_CATEGORY
, WDT.ATTRIBUTE1
, WDT.ATTRIBUTE2
, WDT.ATTRIBUTE3
, WDT.ATTRIBUTE4
, WDT.ATTRIBUTE5
, WDT.ATTRIBUTE6
, WDT.ATTRIBUTE7
, WDT.ATTRIBUTE8
, WDT.ATTRIBUTE9
, WDT.ATTRIBUTE10
, WDT.ATTRIBUTE11
, WDT.ATTRIBUTE12
, WDT.ATTRIBUTE13
, WDT.ATTRIBUTE14
, WDT.ATTRIBUTE15
, WDT.PRIORITY
, NULL
, NVL(WDT.TASK_TYPE
, MMTT.WMS_TASK_TYPE)
, NULL
, MMTT.MOVE_ORDER_LINE_ID
, MMTT.PICK_SLIP_NUMBER
, WE.REASON_ID
, NULL
, MMTT.CARTONIZATION_ID
, MMTT.ALLOCATED_LPN_ID
, MMTT.CONTAINER_ITEM_ID
FROM WMS_DISPATCHED_TASKS WDT
, MTL_MATERIAL_TRANSACTIONS_TEMP MMTT
, WMS_EXCEPTIONS WE
WHERE WDT.TRANSACTION_TEMP_ID = MMTT.TRANSACTION_TEMP_ID
AND WDT.TASK_TYPE = MMTT.WMS_TASK_TYPE
AND MMTT.PARENT_LINE_ID IS NULL
AND WE.TRANSACTION_HEADER_ID = MMTT.TRANSACTION_HEADER_ID
AND NVL(WE.WMS_TASK_TYPE
, 1) = MMTT.WMS_TASK_TYPE UNION ALL SELECT MCCE.ROWID
, MCCE.CYCLE_COUNT_ENTRY_ID
, MCCE.INVENTORY_ITEM_ID
, NULL
, NULL
, MCCE.ORGANIZATION_ID
, NULL
, NULL
, MCCE.REVISION
, NULL
, MCCE.SUBINVENTORY
, MCCE.LOCATOR_ID
, NULL
, NULL
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, 9
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, MCCH.CYCLE_COUNT_HEADER_NAME
, TO_NUMBER(NULL)
, NULL
, NULL
, NULL
, TO_NUMBER(NULL)
, NULL
, NULL
, NULL
, TO_NUMBER(NULL)
, WDT.TASK_ID
, NVL(WDT.USER_TASK_TYPE
, MCCE.STANDARD_OPERATION_ID)
, NULL
, WDT.PERSON_ID
, NULL
, NULL
, NULL
, WDT.EFFECTIVE_START_DATE
, WDT.EFFECTIVE_END_DATE
, WDT.EQUIPMENT_ID
, NULL
, NULL
, WDT.EQUIPMENT_INSTANCE
, WDT.PERSON_RESOURCE_ID
, NULL
, WDT.MACHINE_RESOURCE_ID
, NULL
, NVL(WDT.STATUS
, 1)
, NULL
, WDT.DISPATCHED_TIME
, WDT.LOADED_TIME
, WDT.DROP_OFF_TIME
, MCCE.LAST_UPDATE_DATE
, MCCE.LAST_UPDATED_BY
, MCCE.CREATION_DATE
, MCCE.CREATED_BY
, MCCE.LAST_UPDATE_LOGIN
, WDT.ATTRIBUTE_CATEGORY
, WDT.ATTRIBUTE1
, WDT.ATTRIBUTE2
, WDT.ATTRIBUTE3
, WDT.ATTRIBUTE4
, WDT.ATTRIBUTE5
, WDT.ATTRIBUTE6
, WDT.ATTRIBUTE7
, WDT.ATTRIBUTE8
, WDT.ATTRIBUTE9
, WDT.ATTRIBUTE10
, WDT.ATTRIBUTE11
, WDT.ATTRIBUTE12
, WDT.ATTRIBUTE13
, WDT.ATTRIBUTE14
, WDT.ATTRIBUTE15
, WDT.PRIORITY
, NULL
, NVL(WDT.TASK_TYPE
, 3)
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, WE.REASON_ID
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
FROM WMS_DISPATCHED_TASKS WDT
, MTL_CYCLE_COUNT_ENTRIES MCCE
, WMS_EXCEPTIONS WE
, MTL_CYCLE_COUNT_HEADERS MCCH
WHERE WDT.TRANSACTION_TEMP_ID = MCCE.CYCLE_COUNT_ENTRY_ID
AND WDT.TASK_TYPE = 3
AND WE.TASK_ID = MCCE.CYCLE_COUNT_ENTRY_ID
AND WE.WMS_TASK_TYPE = 3
AND MCCE.CYCLE_COUNT_HEADER_ID = MCCH.CYCLE_COUNT_HEADER_ID