eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WIP_UTILITIES dependencies on MTL_SERIAL_NUMBERS_TEMP

Line 407: delete from mtl_serial_numbers_temp

403: /* Deletes transaction records from the mtl temp tables */
404: procedure delete_temp_records(p_header_id IN NUMBER) is
405: begin
406: -- Delete all serial numbers tied to lots
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,

Line 410: from mtl_serial_numbers_temp msnt,

406: -- Delete all serial numbers tied to lots
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

Line 419: delete from mtl_serial_numbers_temp

415: and mtlt.serial_transaction_temp_id = msnt.transaction_temp_id
416: );
417:
418: -- Delete all serial numbers (sn control only)
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

Line 422: from mtl_serial_numbers_temp msnt,

418: -- Delete all serial numbers (sn control only)
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: );

Line 448: delete from mtl_serial_numbers_temp msnt

444: /* Deletes transaction records from the mtl temp tables */
445: procedure delete_temp_records(p_temp_id IN NUMBER) is
446: begin
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

Line 456: delete from mtl_serial_numbers_temp

452: where mtlt.transaction_temp_id = p_temp_id
453: );
454:
455: -- Delete all serial numbers (sn control only)
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