APPS.WIP_UTILITIES dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 133: from mtl_material_transactions_temp

129: -- only want to retrieve the assembly completion records
130: -- no label printing for return
131: cursor get_mmtt(x_txn_header_id number) is
132: select transaction_temp_id, rowid
133: from mtl_material_transactions_temp
134: where transaction_header_id = x_txn_header_id
135: and transaction_source_type_id = 5
136: and transaction_action_id = WIP_CONSTANTS.CPLASSY_ACTION;
137: cursor get_mti(x_txn_header_id number) is

Line 224: update mtl_material_transactions_temp

220: -- temp id not assigned to mmtt record (probably no lot/serial),
221: -- generate one
222: select mtl_material_transactions_s.nextval into l_temp_id
223: from sys.dual;
224: update mtl_material_transactions_temp
225: set transaction_temp_id = l_temp_id
226: where rowid = inv_rec.rowid;
227: else
228: l_temp_id := inv_rec.transaction_temp_id;

Line 412: mtl_material_transactions_temp mmtt

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
416: );

Line 423: mtl_material_transactions_temp mmtt

419: delete from mtl_serial_numbers_temp
420: where transaction_temp_id in
421: ( select msnt.transaction_temp_id
422: from mtl_serial_numbers_temp msnt,
423: mtl_material_transactions_temp mmtt
424: where mmtt.transaction_header_id = p_header_id
425: and mmtt.transaction_temp_id = msnt.transaction_temp_id
426: );
427:

Line 432: from mtl_material_transactions_temp mmtt,

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
434: where mmtt.transaction_header_id = p_header_id
435: and mtlt.transaction_temp_id = mmtt.transaction_temp_id
436: );

Line 439: delete from mtl_material_transactions_temp

435: and mtlt.transaction_temp_id = mmtt.transaction_temp_id
436: );
437:
438: -- Finally, delete all records in mmtt for this transaction
439: delete from mtl_material_transactions_temp
440: where transaction_header_id = p_header_id;
441:
442: end delete_temp_records;
443:

Line 464: delete from mtl_material_transactions_temp

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
465: where transaction_header_id = p_temp_id;
466: end delete_temp_records;
467:
468: procedure update_serial(p_serial_number in VARCHAR2,