VIEW: APPS.WMS_COMPLETED_EXCEPTIONS_V

Source

View Text - Preformatted

SELECT MMT.ROWID , MMT.TRANSACTION_ID , MMT.INVENTORY_ITEM_ID , NULL , NULL , MMT.ORGANIZATION_ID , NULL , NULL , MMT.REVISION , NULL , MMT.SUBINVENTORY_CODE , MMT.LOCATOR_ID , NULL , NULL , MMT.TRANSACTION_TYPE_ID , NULL , MMT.TRANSACTION_ACTION_ID , NULL , MMT.TRANSACTION_SOURCE_TYPE_ID , NULL , MMT.TRANSACTION_SOURCE_ID , MMT.TRX_SOURCE_LINE_ID , MMT.TRANSACTION_SOURCE_NAME , MMT.TRANSFER_ORGANIZATION_ID , NULL , NULL , MMT.TRANSFER_SUBINVENTORY , MMT.TRANSFER_locator_id , NULL , NULL , MMT.TRANSACTION_UOM , ABS(MMT.TRANSACTION_QUANTITY) , WDTH.TASK_ID , WDTH.USER_TASK_TYPE , NULL , WDTH.PERSON_ID , NULL , NULL , NULL , WDTH.EFFECTIVE_START_DATE , WDTH.EFFECTIVE_END_DATE , WDTH.EQUIPMENT_ID , NULL , NULL , WDTH.EQUIPMENT_INSTANCE , WDTH.PERSON_RESOURCE_ID , NULL , WDTH.MACHINE_RESOURCE_ID , NULL , 6 , NULL , WDTH.DISPATCHED_TIME , WDTH.LOADED_TIME , WDTH.DROP_OFF_TIME , MMT.LAST_UPDATE_DATE , MMT.LAST_UPDATED_BY , MMT.CREATION_DATE , MMT.CREATED_BY , MMT.LAST_UPDATE_LOGIN , WDTH.ATTRIBUTE_CATEGORY , WDTH.ATTRIBUTE1 , WDTH.ATTRIBUTE2 , WDTH.ATTRIBUTE3 , WDTH.ATTRIBUTE4 , WDTH.ATTRIBUTE5 , WDTH.ATTRIBUTE6 , WDTH.ATTRIBUTE7 , WDTH.ATTRIBUTE8 , WDTH.ATTRIBUTE9 , WDTH.ATTRIBUTE10 , WDTH.ATTRIBUTE11 , WDTH.ATTRIBUTE12 , WDTH.ATTRIBUTE13 , WDTH.ATTRIBUTE14 , WDTH.ATTRIBUTE15 , WDTH.PRIORITY , NULL , WDTH.TASK_TYPE , NULL , MMT.MOVE_ORDER_LINE_ID , MMT.PICK_SLIP_NUMBER , WE.REASON_ID , NULL , TO_NUMBER(NULL) , TO_NUMBER(NULL) , TO_NUMBER(NULL) FROM WMS_DISPATCHED_TASKS_HISTORY WDTH, MTL_MATERIAL_TRANSACTIONS MMT, WMS_EXCEPTIONS WE WHERE WDTH.TRANSACTION_ID = MMT.TRANSACTION_SET_ID AND MMT.TRANSACTION_QUANTITY <= DECODE(MMT.TRANSFER_TRANSACTION_ID, NULL, MMT.TRANSACTION_QUANTITY, 0) AND WDTH.TASK_TYPE IN (1, 2, 4,5,6) AND WE.TRANSACTION_HEADER_ID = MMT.TRANSACTION_SET_ID AND NVL(WE.WMS_TASK_TYPE, 1) IN (1, 2, 4,5,6) 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) , WDTH.TASK_ID , WDTH.USER_TASK_TYPE , NULL , WDTH.PERSON_ID , NULL , NULL , NULL , WDTH.EFFECTIVE_START_DATE , WDTH.EFFECTIVE_END_DATE , WDTH.EQUIPMENT_ID , NULL , NULL , WDTH.EQUIPMENT_INSTANCE , WDTH.PERSON_RESOURCE_ID , NULL , WDTH.MACHINE_RESOURCE_ID , NULL , 6 , NULL , WDTH.DISPATCHED_TIME , WDTH.LOADED_TIME , WDTH.DROP_OFF_TIME , MCCE.LAST_UPDATE_DATE , MCCE.LAST_UPDATED_BY , MCCE.CREATION_DATE , MCCE.CREATED_BY , MCCE.LAST_UPDATE_LOGIN , WDTH.ATTRIBUTE_CATEGORY , WDTH.ATTRIBUTE1 , WDTH.ATTRIBUTE2 , WDTH.ATTRIBUTE3 , WDTH.ATTRIBUTE4 , WDTH.ATTRIBUTE5 , WDTH.ATTRIBUTE6 , WDTH.ATTRIBUTE7 , WDTH.ATTRIBUTE8 , WDTH.ATTRIBUTE9 , WDTH.ATTRIBUTE10 , WDTH.ATTRIBUTE11 , WDTH.ATTRIBUTE12 , WDTH.ATTRIBUTE13 , WDTH.ATTRIBUTE14 , WDTH.ATTRIBUTE15 , WDTH.PRIORITY , NULL , WDTH.TASK_TYPE , NULL , TO_NUMBER(NULL) , TO_NUMBER(NULL) , WE.REASON_ID , NULL , TO_NUMBER(NULL) , TO_NUMBER(NULL) , TO_NUMBER(NULL) FROM WMS_DISPATCHED_TASKS_HISTORY WDTH, MTL_CYCLE_COUNT_ENTRIES MCCE, WMS_EXCEPTIONS WE, MTL_CYCLE_COUNT_HEADERS MCCH WHERE WDTH.TRANSACTION_ID = MCCE.CYCLE_COUNT_ENTRY_ID AND WDTH.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 MMT.ROWID
, MMT.TRANSACTION_ID
, MMT.INVENTORY_ITEM_ID
, NULL
, NULL
, MMT.ORGANIZATION_ID
, NULL
, NULL
, MMT.REVISION
, NULL
, MMT.SUBINVENTORY_CODE
, MMT.LOCATOR_ID
, NULL
, NULL
, MMT.TRANSACTION_TYPE_ID
, NULL
, MMT.TRANSACTION_ACTION_ID
, NULL
, MMT.TRANSACTION_SOURCE_TYPE_ID
, NULL
, MMT.TRANSACTION_SOURCE_ID
, MMT.TRX_SOURCE_LINE_ID
, MMT.TRANSACTION_SOURCE_NAME
, MMT.TRANSFER_ORGANIZATION_ID
, NULL
, NULL
, MMT.TRANSFER_SUBINVENTORY
, MMT.TRANSFER_LOCATOR_ID
, NULL
, NULL
, MMT.TRANSACTION_UOM
, ABS(MMT.TRANSACTION_QUANTITY)
, WDTH.TASK_ID
, WDTH.USER_TASK_TYPE
, NULL
, WDTH.PERSON_ID
, NULL
, NULL
, NULL
, WDTH.EFFECTIVE_START_DATE
, WDTH.EFFECTIVE_END_DATE
, WDTH.EQUIPMENT_ID
, NULL
, NULL
, WDTH.EQUIPMENT_INSTANCE
, WDTH.PERSON_RESOURCE_ID
, NULL
, WDTH.MACHINE_RESOURCE_ID
, NULL
, 6
, NULL
, WDTH.DISPATCHED_TIME
, WDTH.LOADED_TIME
, WDTH.DROP_OFF_TIME
, MMT.LAST_UPDATE_DATE
, MMT.LAST_UPDATED_BY
, MMT.CREATION_DATE
, MMT.CREATED_BY
, MMT.LAST_UPDATE_LOGIN
, WDTH.ATTRIBUTE_CATEGORY
, WDTH.ATTRIBUTE1
, WDTH.ATTRIBUTE2
, WDTH.ATTRIBUTE3
, WDTH.ATTRIBUTE4
, WDTH.ATTRIBUTE5
, WDTH.ATTRIBUTE6
, WDTH.ATTRIBUTE7
, WDTH.ATTRIBUTE8
, WDTH.ATTRIBUTE9
, WDTH.ATTRIBUTE10
, WDTH.ATTRIBUTE11
, WDTH.ATTRIBUTE12
, WDTH.ATTRIBUTE13
, WDTH.ATTRIBUTE14
, WDTH.ATTRIBUTE15
, WDTH.PRIORITY
, NULL
, WDTH.TASK_TYPE
, NULL
, MMT.MOVE_ORDER_LINE_ID
, MMT.PICK_SLIP_NUMBER
, WE.REASON_ID
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
FROM WMS_DISPATCHED_TASKS_HISTORY WDTH
, MTL_MATERIAL_TRANSACTIONS MMT
, WMS_EXCEPTIONS WE
WHERE WDTH.TRANSACTION_ID = MMT.TRANSACTION_SET_ID
AND MMT.TRANSACTION_QUANTITY <= DECODE(MMT.TRANSFER_TRANSACTION_ID
, NULL
, MMT.TRANSACTION_QUANTITY
, 0)
AND WDTH.TASK_TYPE IN (1
, 2
, 4
, 5
, 6)
AND WE.TRANSACTION_HEADER_ID = MMT.TRANSACTION_SET_ID
AND NVL(WE.WMS_TASK_TYPE
, 1) IN (1
, 2
, 4
, 5
, 6) 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)
, WDTH.TASK_ID
, WDTH.USER_TASK_TYPE
, NULL
, WDTH.PERSON_ID
, NULL
, NULL
, NULL
, WDTH.EFFECTIVE_START_DATE
, WDTH.EFFECTIVE_END_DATE
, WDTH.EQUIPMENT_ID
, NULL
, NULL
, WDTH.EQUIPMENT_INSTANCE
, WDTH.PERSON_RESOURCE_ID
, NULL
, WDTH.MACHINE_RESOURCE_ID
, NULL
, 6
, NULL
, WDTH.DISPATCHED_TIME
, WDTH.LOADED_TIME
, WDTH.DROP_OFF_TIME
, MCCE.LAST_UPDATE_DATE
, MCCE.LAST_UPDATED_BY
, MCCE.CREATION_DATE
, MCCE.CREATED_BY
, MCCE.LAST_UPDATE_LOGIN
, WDTH.ATTRIBUTE_CATEGORY
, WDTH.ATTRIBUTE1
, WDTH.ATTRIBUTE2
, WDTH.ATTRIBUTE3
, WDTH.ATTRIBUTE4
, WDTH.ATTRIBUTE5
, WDTH.ATTRIBUTE6
, WDTH.ATTRIBUTE7
, WDTH.ATTRIBUTE8
, WDTH.ATTRIBUTE9
, WDTH.ATTRIBUTE10
, WDTH.ATTRIBUTE11
, WDTH.ATTRIBUTE12
, WDTH.ATTRIBUTE13
, WDTH.ATTRIBUTE14
, WDTH.ATTRIBUTE15
, WDTH.PRIORITY
, NULL
, WDTH.TASK_TYPE
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, WE.REASON_ID
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
FROM WMS_DISPATCHED_TASKS_HISTORY WDTH
, MTL_CYCLE_COUNT_ENTRIES MCCE
, WMS_EXCEPTIONS WE
, MTL_CYCLE_COUNT_HEADERS MCCH
WHERE WDTH.TRANSACTION_ID = MCCE.CYCLE_COUNT_ENTRY_ID
AND WDTH.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