APPS.WMS_RCV_PUP_PVT dependencies on WMS_DISPATCHED_TASKS

Line 2499: WHERE EXISTS (SELECT /*+ INDEX (wdt, WMS_DISPATCHED_TASKS_N2) */ 'LOADED'

2495: BEGIN
2496: SELECT 1
2497: INTO l_xfer_lpn_loaded
2498: FROM dual
2499: WHERE EXISTS (SELECT /*+ INDEX (wdt, WMS_DISPATCHED_TASKS_N2) */ 'LOADED'
2500: FROM mtl_material_transactions_temp mmtt,
2501: wms_dispatched_tasks wdt
2502: WHERE mmtt.organization_id = l_tmp_mmtt_rec.organization_id
2503: AND mmtt.transaction_temp_id = wdt.transaction_temp_id

Line 2501: wms_dispatched_tasks wdt

2497: INTO l_xfer_lpn_loaded
2498: FROM dual
2499: WHERE EXISTS (SELECT /*+ INDEX (wdt, WMS_DISPATCHED_TASKS_N2) */ 'LOADED'
2500: FROM mtl_material_transactions_temp mmtt,
2501: wms_dispatched_tasks wdt
2502: WHERE mmtt.organization_id = l_tmp_mmtt_rec.organization_id
2503: AND mmtt.transaction_temp_id = wdt.transaction_temp_id
2504: AND wdt.organization_id = l_tmp_mmtt_rec.organization_id
2505: AND wdt.task_type = 2