APPS.INV_PICK_WAVE_PICK_CONFIRM_PUB dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 385: UPDATE mtl_material_transactions_temp mmtt

381: end loop;
382: end if;
383: end if;
384:
385: UPDATE mtl_material_transactions_temp mmtt
386: SET mmtt.transaction_quantity = -1 * ABS(Round(mmtt.transaction_quantity,5)),
387: mmtt.primary_quantity = -1 * ABS(Round(mmtt.primary_quantity,5))
388: WHERE mmtt.transaction_header_id = l_transaction_header_id
389: AND mmtt.transaction_action_id in (1, 2, 3, 21, 28, 29, 32, 34);

Line 560: FROM mtl_material_transactions_temp mmtt

556: DELETE FROM mtl_transaction_lots_temp
557: WHERE group_header_id = l_transaction_header_id
558: AND transaction_temp_id NOT IN
559: ( SELECT mmtt.transaction_temp_id
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

Line 568: FROM mtl_material_transactions_temp mmtt

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
569: WHERE mmtt.transaction_header_id = l_transaction_header_id
570: AND mmtt.transaction_temp_id IS NOT NULL)
571: AND transaction_temp_id NOT IN
572: ( SELECT mtlt.serial_transaction_temp_id

Line 583: FROM mtl_material_transactions_temp

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
584: WHERE transaction_header_id = l_transaction_header_id)
585: AND current_organization_id in (select organization_id
586: FROM mtl_material_transactions_temp
587: WHERE transaction_header_id = l_transaction_header_id);

Line 586: FROM mtl_material_transactions_temp

582: AND inventory_item_id in (select inventory_item_id
583: FROM mtl_material_transactions_temp
584: WHERE transaction_header_id = l_transaction_header_id)
585: AND current_organization_id in (select organization_id
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) */

Line 596: FROM MTL_MATERIAL_TRANSACTIONS_TEMP

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
596: FROM MTL_MATERIAL_TRANSACTIONS_TEMP
597: WHERE TRANSACTION_HEADER_ID = l_transaction_header_id);
598:
599: -- End of change for Bug 5879916
600: