View: WMS_DISPATCHABLE_TASKS_V

Product:	WMS - Warehouse Management
Description:	Dispachable tasks within the warehouse, used by task dispatching engine
Implementation/DBA Data:	APPS.WMS_DISPATCHABLE_TASKS_V

View Text

SELECT TRANSACTION_TEMP_ID TASK_ID
, STANDARD_OPERATION_ID USER_TASK_TYPE_ID
, WMS_TASK_TYPE WMS_TASK_TYPE_ID
, ORGANIZATION_ID ORGANIZATION_ID
, SUBINVENTORY_CODE ZONE
, LOCATOR_ID LOCATOR_ID
, TASK_PRIORITY TASK_PRIORITY
, REVISION REVISION
, LOT_NUMBER LOT_NUMBER
, TRANSACTION_UOM TRANSACTION_UOM
, TRANSACTION_QUANTITY TRANSACTION_QUANTITY
, PICK_RULE_ID PICK_RULE_ID
, PICK_SLIP_NUMBER PICK_SLIP_NUMBER
, CARTONIZATION_ID CARTONIZATION_ID
, INVENTORY_ITEM_ID
, MOVE_ORDER_LINE_ID
FROM MTL_MATERIAL_TRANSACTIONS_TEMP
WHERE WMS_TASK_TYPE IS NOT NULL
AND TRANSACTION_STATUS = 2 UNION ALL SELECT MIN(CYCLE_COUNT_ENTRY_ID) TASK_ID
, MIN(STANDARD_OPERATION_ID) USER_TASK_TYPE_ID
, 3 WMS_TASK_TYPE_ID
, ORGANIZATION_ID ORGANIZATION_ID
, SUBINVENTORY ZONE
, LOCATOR_ID LOCATOR_ID
, MIN(TASK_PRIORITY) TASK_PRIORITY
, REVISION REVISION
, MIN(LOT_NUMBER) LOT_NUMBER
, '' TRANSACTION_UOM
, TO_NUMBER(NULL) TRANSACTION_QUANTITY
, TO_NUMBER(NULL) PICK_RULE_ID
, TO_NUMBER(NULL) PICK_SLIP_NUMBER
, TO_NUMBER(NULL) CARTONIZATION_ID
, INVENTORY_ITEM_ID
, TO_NUMBER(NULL) MOVE_ORDER_LINE_ID
FROM MTL_CYCLE_COUNT_ENTRIES
WHERE ENTRY_STATUS_CODE IN (1
, 3)
AND NVL(EXPORT_FLAG
, 2) = 2 GROUP BY CYCLE_COUNT_HEADER_ID
, ORGANIZATION_ID
, SUBINVENTORY
, LOCATOR_ID
, INVENTORY_ITEM_ID
, REVISION

Columns