DBA Data[Home] [Help]

APPS.INV_PARENT_MMTT_PVT dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 55: FROM mtl_material_transactions_temp mmtt

51: ) IS
52: SELECT mmtt.organization_id
53: , mmtt.transfer_lpn_id
54: , wdt.task_id
55: FROM mtl_material_transactions_temp mmtt
56: , wms_dispatched_tasks wdt
57: WHERE mmtt.transaction_temp_id = p_temp_id
58: AND wdt.transaction_temp_id = mmtt.transaction_temp_id;
59:

Line 219: DELETE mtl_material_transactions_temp

215: ELSE
216: DELETE wms_dispatched_tasks
217: WHERE transaction_temp_id = p_parent_temp_id;
218:
219: DELETE mtl_material_transactions_temp
220: WHERE transaction_temp_id = p_parent_temp_id;
221: END IF;
222:
223: EXCEPTION