DBA Data[Home] [Help]

APPS.WMS_INSERT_WDTH_PVT dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 172: , mtl_material_transactions_temp mmtt

168: ,mmtt.transaction_UOM --ER13869750
169: ,mmtt.secondary_transaction_quantity --ER13869750
170: ,substr(mmtt.secondary_uom_code,1,3) --ER13869750
171: FROM wms_dispatched_tasks wdt
172: , mtl_material_transactions_temp mmtt
173: WHERE wdt.transaction_temp_id = p_transaction_temp_id
174: AND wdt.transaction_temp_id = mmtt.transaction_temp_id
175: );
176:

Line 272: , mtl_material_transactions_temp mmtt

268: ,mmtt.transaction_UOM --ER13869750
269: ,mmtt.secondary_transaction_quantity --ER13869750
270: ,substr(mmtt.secondary_uom_code,1,3) --ER13869750
271: FROM wms_dispatched_tasks wdt
272: , mtl_material_transactions_temp mmtt
273: , wms_dispatched_tasks wdt_orig
274: WHERE mmtt.transaction_temp_id = p_transaction_temp_id
275: AND mmtt.transaction_temp_id = wdt.transaction_temp_id (+)
276: AND wdt_orig.transaction_temp_id = p_orig_transaction_temp_id