APPS.INVTTMTX dependencies on MTL_SERIAL_NUMBERS

Line 300: mtl_serial_numbers

296:
297: DECLARE
298: -- Delete predefined serial numbers
299: cursor c1 is select group_mark_id from
300: mtl_serial_numbers
301: where group_mark_id = v_trx_header_id
302: and current_status = 6
303: for update of group_mark_id nowait;
304: BEGIN

Line 306: delete mtl_serial_numbers

302: and current_status = 6
303: for update of group_mark_id nowait;
304: BEGIN
305: open c1 ;
306: delete mtl_serial_numbers
307: where group_mark_id = v_trx_header_id
308: and current_status = 6;
309: close c1 ;
310: EXCEPTION

Line 318: mtl_serial_numbers

314:
315: DECLARE
316: -- Unmark serial numbers
317: cursor c2 is select group_mark_id from
318: mtl_serial_numbers
319: where group_mark_id = v_trx_header_id
320: for update of group_mark_id nowait;
321: BEGIN
322: open c2 ;

Line 323: update mtl_serial_numbers

319: where group_mark_id = v_trx_header_id
320: for update of group_mark_id nowait;
321: BEGIN
322: open c2 ;
323: update mtl_serial_numbers
324: set group_mark_id = null,
325: line_mark_id = null,
326: lot_line_mark_id = null
327: where group_mark_id = v_trx_header_id;

Line 337: mtl_serial_numbers_temp

333:
334: DECLARE
335: -- Delete lot and serial records from temp tables
336: cursor c3 is select group_header_id from
337: mtl_serial_numbers_temp
338: where group_header_id = v_trx_header_id
339: for update of group_header_id nowait;
340: BEGIN
341: open c3 ;

Line 342: delete mtl_serial_numbers_temp

338: where group_header_id = v_trx_header_id
339: for update of group_header_id nowait;
340: BEGIN
341: open c3 ;
342: delete mtl_serial_numbers_temp
343: where group_header_id = v_trx_header_id;
344: close c3 ;
345: EXCEPTION
346: WHEN OTHERS then

Line 416: DELETE FROM mtl_serial_numbers_temp

412: WHERE mmtt.transaction_header_id = hdr_id AND mmtt.transaction_temp_id
413: IS NOT NULL AND mmtt.transaction_header_id IS NOT NULL);
414:
415:
416: DELETE FROM mtl_serial_numbers_temp
417: WHERE group_header_id = hdr_id AND
418: transaction_temp_id NOT IN
419: (SELECT mmtt.transaction_temp_id FROM
420: mtl_material_transactions_temp mmtt

Line 767: DELETE /*+ INDEX(MSN MTL_SERIAL_NUMBERS_N2) */

763: null;
764: completed := 4;
765: else
766: -- Bug 4062450 performance change.
767: DELETE /*+ INDEX(MSN MTL_SERIAL_NUMBERS_N2) */
768: FROM mtl_serial_numbers MSN
769: WHERE current_status = 6
770: AND group_mark_id = -1
771: AND (MSN.inventory_item_id, MSN.current_organization_id) in

Line 768: FROM mtl_serial_numbers MSN

764: completed := 4;
765: else
766: -- Bug 4062450 performance change.
767: DELETE /*+ INDEX(MSN MTL_SERIAL_NUMBERS_N2) */
768: FROM mtl_serial_numbers MSN
769: WHERE current_status = 6
770: AND group_mark_id = -1
771: AND (MSN.inventory_item_id, MSN.current_organization_id) in
772: (select inventory_item_id,ORGANIZATION_ID