APPS.INV_PICK_WAVE_PICK_CONFIRM_PUB dependencies on MTL_SERIAL_NUMBERS

Line 564: DELETE FROM mtl_serial_numbers_temp

560: FROM mtl_material_transactions_temp mmtt
561: WHERE mmtt.transaction_header_id = l_transaction_header_id
562: AND mmtt.transaction_temp_id IS NOT NULL);
563:
564: DELETE FROM mtl_serial_numbers_temp
565: WHERE group_header_id = l_transaction_header_id
566: AND transaction_temp_id NOT IN
567: ( SELECT mmtt.transaction_temp_id
568: FROM mtl_material_transactions_temp mmtt

Line 579: DELETE FROM mtl_serial_numbers

575: AND mtlt.serial_transaction_temp_id IS NOT NULL);
576:
577: -- Bug 5879916
578: /*
579: DELETE FROM mtl_serial_numbers
580: WHERE current_status = 6
581: AND group_mark_id = -1
582: AND inventory_item_id in (select inventory_item_id
583: FROM mtl_material_transactions_temp

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

586: FROM mtl_material_transactions_temp
587: WHERE transaction_header_id = l_transaction_header_id);
588: */
589:
590: DELETE /*+ INDEX(MSN MTL_SERIAL_NUMBERS_N2) */
591: FROM mtl_serial_numbers MSN
592: WHERE MSN.current_status = 6
593: AND MSN.group_mark_id = -1
594: AND (MSN.INVENTORY_ITEM_ID,MSN.CURRENT_ORGANIZATION_ID) IN

Line 591: FROM mtl_serial_numbers MSN

587: WHERE transaction_header_id = l_transaction_header_id);
588: */
589:
590: DELETE /*+ INDEX(MSN MTL_SERIAL_NUMBERS_N2) */
591: FROM mtl_serial_numbers MSN
592: WHERE MSN.current_status = 6
593: AND MSN.group_mark_id = -1
594: AND (MSN.INVENTORY_ITEM_ID,MSN.CURRENT_ORGANIZATION_ID) IN
595: (SELECT INVENTORY_ITEM_ID,ORGANIZATION_ID