APPS.INV_PICK_WAVE_PICK_CONFIRM_PUB dependencies on MTL_SERIAL_NUMBERS

Line 566: DELETE FROM mtl_serial_numbers_temp

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

Line 581: DELETE FROM mtl_serial_numbers

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

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

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

Line 593: FROM mtl_serial_numbers MSN

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