APPS.INV_MWB_QUERY_MANAGER dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 1530: FROM mtl_material_transactions_temp mmtt, wms_dispatched_tasks wdt

1526: WHERE lpn_id = rec.lpn_id;
1527:
1528: UPDATE MTL_MWB_GTMP
1529: SET loaded = (SELECT 1
1530: FROM mtl_material_transactions_temp mmtt, wms_dispatched_tasks wdt
1531: WHERE wdt.status = 4
1532: AND wdt.task_type <> 2
1533: AND wdt.transaction_temp_id = mmtt.transaction_temp_id
1534: AND (mmtt.content_lpn_id = rec.lpn_id