APPS.INV_PICK_WAVE_PICK_CONFIRM_PUB dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 386: UPDATE mtl_material_transactions_temp mmtt

382: end if;
383: end if;
384:
385: --bug 8841933 added secondary_qty
386: UPDATE mtl_material_transactions_temp mmtt
387: SET mmtt.transaction_quantity = -1 * ABS(Round(mmtt.transaction_quantity,5)),
388: mmtt.primary_quantity = -1 * ABS(Round(mmtt.primary_quantity,5)),
389: mmtt.secondary_transaction_quantity = -1 * ABS(mmtt.secondary_transaction_quantity)
390: WHERE mmtt.transaction_header_id = l_transaction_header_id

Line 562: FROM mtl_material_transactions_temp mmtt

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

Line 570: FROM mtl_material_transactions_temp mmtt

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

Line 585: FROM mtl_material_transactions_temp

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

Line 588: FROM mtl_material_transactions_temp

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

Line 598: FROM MTL_MATERIAL_TRANSACTIONS_TEMP

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