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_DISPATCHABLE_TASKS_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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