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 350: delete from mtl_serial_numbers_temp

346: /* Deletes transaction records from the mtl temp tables */
347: procedure delete_temp_records(p_header_id IN NUMBER) is
348: begin
349: -- Delete all serial numbers tied to lots
350: delete from mtl_serial_numbers_temp
351: where transaction_temp_id in
352: ( select msnt.transaction_temp_id
353: from mtl_serial_numbers_temp msnt,
354: mtl_transaction_lots_temp mtlt,

Line 353: from mtl_serial_numbers_temp msnt,

349: -- Delete all serial numbers tied to lots
350: delete from mtl_serial_numbers_temp
351: where transaction_temp_id in
352: ( select msnt.transaction_temp_id
353: from mtl_serial_numbers_temp msnt,
354: mtl_transaction_lots_temp mtlt,
355: mtl_material_transactions_temp mmtt
356: where mmtt.transaction_header_id = p_header_id
357: and mtlt.transaction_temp_id = mmtt.transaction_temp_id

Line 362: delete from mtl_serial_numbers_temp

358: and mtlt.serial_transaction_temp_id = msnt.transaction_temp_id
359: );
360:
361: -- Delete all serial numbers (sn control only)
362: delete from mtl_serial_numbers_temp
363: where transaction_temp_id in
364: ( select msnt.transaction_temp_id
365: from mtl_serial_numbers_temp msnt,
366: mtl_material_transactions_temp mmtt

Line 365: from mtl_serial_numbers_temp msnt,

361: -- Delete all serial numbers (sn control only)
362: delete from mtl_serial_numbers_temp
363: where transaction_temp_id in
364: ( select msnt.transaction_temp_id
365: from mtl_serial_numbers_temp msnt,
366: mtl_material_transactions_temp mmtt
367: where mmtt.transaction_header_id = p_header_id
368: and mmtt.transaction_temp_id = msnt.transaction_temp_id
369: );

Line 391: delete from mtl_serial_numbers_temp msnt

387: /* Deletes transaction records from the mtl temp tables */
388: procedure delete_temp_records(p_temp_id IN NUMBER) is
389: begin
390: -- Delete all serial numbers tied to lots
391: delete from mtl_serial_numbers_temp msnt
392: where transaction_temp_id in
393: (select mtlt.serial_transaction_temp_id
394: from mtl_transaction_lots_temp mtlt
395: where mtlt.transaction_temp_id = p_temp_id

Line 399: delete from mtl_serial_numbers_temp

395: where mtlt.transaction_temp_id = p_temp_id
396: );
397:
398: -- Delete all serial numbers (sn control only)
399: delete from mtl_serial_numbers_temp
400: where transaction_temp_id = p_temp_id;
401:
402: -- Delete all lots
403: delete from mtl_transaction_lots_temp