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.

[Home] [Help]

View: WMS_COMPLETED_TASKS_V

Product:	WMS - Warehouse Management
Description:
Implementation/DBA Data:	APPS.WMS_COMPLETED_TASKS_V

View Text

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
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
FROM WMS_DISPATCHED_TASKS_HISTORY WDTH
, MTL_MATERIAL_TRANSACTIONS MMT
WHERE WDTH.TRANSACTION_BATCH_ID IS NULL
AND 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) UNION ALL 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
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
FROM WMS_DISPATCHED_TASKS_HISTORY WDTH
, MTL_MATERIAL_TRANSACTIONS MMT
WHERE WDTH.TRANSACTION_BATCH_ID IS NOT NULL
AND WDTH.TRANSACTION_BATCH_ID=MMT.TRANSACTION_BATCH_ID
AND WDTH.TRANSACTION_BATCH_SEQ=MMT.TRANSACTION_BATCH_SEQ
AND MMT.TRANSACTION_QUANTITY <= DECODE(MMT.TRANSFER_TRANSACTION_ID
, NULL
, MMT.TRANSACTION_QUANTITY
, 0)
AND WDTH.TASK_TYPE 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)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
FROM WMS_DISPATCHED_TASKS_HISTORY WDTH
, MTL_CYCLE_COUNT_ENTRIES MCCE
, MTL_CYCLE_COUNT_HEADERS MCCH
WHERE WDTH.TRANSACTION_ID = MCCE.CYCLE_COUNT_ENTRY_ID
AND WDTH.TASK_TYPE = 3
AND MCCE.CYCLE_COUNT_HEADER_ID = MCCH.CYCLE_COUNT_HEADER_ID

Columns

Name
ROW_ID
TRANSACTION_TEMP_ID
INVENTORY_ITEM_ID
ITEM_DESCRIPTION
ITEM
ORGANIZATION_ID
ORGANIZATION_CODE
ORGANIZATION_NAME
REVISION
LOT_NUMBER
SUBINVENTORY_CODE
LOCATOR_ID
LOCATOR_DESCRIPTION
LOCATOR
TRANSACTION_TYPE_ID
TRANSACTION_TYPE
TRANSACTION_ACTION_ID
TRANSACTION_ACTION
TRANSACTION_SOURCE_TYPE_ID
TRANSACTION_SOURCE_TYPE
TRANSACTION_SOURCE_ID
TRANSACTION_SOURCE_LINE_ID
TRANSACTION_SOURCE_NAME
TRANSFER_ORGANIZATION
TRANSFER_ORGANIZATION_CODE
TRANSFER_ORGANIZATION_NAME
TRANSFER_SUBINVENTORY
TRANSFER_TO_LOCATION
TRANSFER_LOCATOR_DESCRIPTION
TRANSFER_LOCATOR
TRANSACTION_UOM
TRANSACTION_QUANTITY
TASK_ID
USER_TASK_TYPE
USER_TASK_TYPE_CODE
PERSON_ID
LAST_NAME
FIRST_NAME
FULL_NAME
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
EQUIPMENT_ID
EQUIPMENT
EQUIPMENT_DESCRIPTION
EQUIPMENT_INSTANCE
PERSON_RESOURCE_ID
PERSON_RESOURCE_CODE
MACHINE_RESOURCE_ID
MACHINE_RESOURCE_CODE
STATUS
STATUS_CODE
DISPATCHED_TIME
LOADED_TIME
DROP_OFF_TIME
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
PRIORITY
USER_TASK_TYPE_DESCRIPTION
TASK_TYPE
TASK_TYPE_DESCRIPTION
MOVE_ORDER_LINE_ID
PICK_SLIP_NUMBER
CARTONIZATION_ID
ALLOCATED_LPN_ID
CONTAINER_ITEM_ID