APPS.WIP_UTILITIES dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 411: mtl_transaction_lots_temp mtlt,

407: delete from mtl_serial_numbers_temp
408: where transaction_temp_id in
409: ( select msnt.transaction_temp_id
410: from mtl_serial_numbers_temp msnt,
411: mtl_transaction_lots_temp mtlt,
412: mtl_material_transactions_temp mmtt
413: where mmtt.transaction_header_id = p_header_id
414: and mtlt.transaction_temp_id = mmtt.transaction_temp_id
415: and mtlt.serial_transaction_temp_id = msnt.transaction_temp_id

Line 429: delete from mtl_transaction_lots_temp

425: and mmtt.transaction_temp_id = msnt.transaction_temp_id
426: );
427:
428: -- Delete all lots
429: delete from mtl_transaction_lots_temp
430: where transaction_temp_id in
431: ( select mtlt.transaction_temp_id
432: from mtl_material_transactions_temp mmtt,
433: mtl_transaction_lots_temp mtlt

Line 433: mtl_transaction_lots_temp mtlt

429: delete from mtl_transaction_lots_temp
430: where transaction_temp_id in
431: ( select mtlt.transaction_temp_id
432: from mtl_material_transactions_temp mmtt,
433: mtl_transaction_lots_temp mtlt
434: where mmtt.transaction_header_id = p_header_id
435: and mtlt.transaction_temp_id = mmtt.transaction_temp_id
436: );
437:

Line 451: from mtl_transaction_lots_temp mtlt

447: -- Delete all serial numbers tied to lots
448: delete from mtl_serial_numbers_temp msnt
449: where transaction_temp_id in
450: (select mtlt.serial_transaction_temp_id
451: from mtl_transaction_lots_temp mtlt
452: where mtlt.transaction_temp_id = p_temp_id
453: );
454:
455: -- Delete all serial numbers (sn control only)

Line 460: delete from mtl_transaction_lots_temp

456: delete from mtl_serial_numbers_temp
457: where transaction_temp_id = p_temp_id;
458:
459: -- Delete all lots
460: delete from mtl_transaction_lots_temp
461: where transaction_temp_id = p_temp_id;
462:
463: -- Finally, delete all records in mmtt for this transaction
464: delete from mtl_material_transactions_temp