DBA Data[Home] [Help]

APPS.INV_MWB_QUERY_MANAGER dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 1602: FROM mtl_material_transactions_temp mmtt, wms_dispatched_tasks wdt

1598: WHERE lpn_id = rec.lpn_id;
1599:
1600: UPDATE MTL_MWB_GTMP
1601: SET loaded = (SELECT 1
1602: FROM mtl_material_transactions_temp mmtt, wms_dispatched_tasks wdt
1603: WHERE wdt.status = 4
1604: AND wdt.task_type <> 2
1605: AND wdt.transaction_temp_id = mmtt.transaction_temp_id
1606: AND (mmtt.content_lpn_id = rec.lpn_id