APPS.WMS_RCV_PUP_PVT dependencies on WMS_DISPATCHED_TASKS

Line 2543: WHERE EXISTS (SELECT /*+ INDEX (wdt, WMS_DISPATCHED_TASKS_U2) */ 'LOADED' --Bug#8555935 Changed index WMS_DISPATCHED_TASKS_N2 to WMS_DISPATCHED_TASKS_U2

2539: BEGIN
2540: SELECT 1
2541: INTO l_xfer_lpn_loaded
2542: FROM dual
2543: WHERE EXISTS (SELECT /*+ INDEX (wdt, WMS_DISPATCHED_TASKS_U2) */ 'LOADED' --Bug#8555935 Changed index WMS_DISPATCHED_TASKS_N2 to WMS_DISPATCHED_TASKS_U2
2544: FROM mtl_material_transactions_temp mmtt,
2545: wms_dispatched_tasks wdt
2546: WHERE mmtt.organization_id = l_tmp_mmtt_rec.organization_id
2547: AND mmtt.transaction_temp_id = wdt.transaction_temp_id

Line 2545: wms_dispatched_tasks wdt

2541: INTO l_xfer_lpn_loaded
2542: FROM dual
2543: WHERE EXISTS (SELECT /*+ INDEX (wdt, WMS_DISPATCHED_TASKS_U2) */ 'LOADED' --Bug#8555935 Changed index WMS_DISPATCHED_TASKS_N2 to WMS_DISPATCHED_TASKS_U2
2544: FROM mtl_material_transactions_temp mmtt,
2545: wms_dispatched_tasks wdt
2546: WHERE mmtt.organization_id = l_tmp_mmtt_rec.organization_id
2547: AND mmtt.transaction_temp_id = wdt.transaction_temp_id
2548: AND wdt.organization_id = l_tmp_mmtt_rec.organization_id
2549: AND wdt.task_type = 2