APPS.WMS_TXNRSN_ACTIONS_PUB dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 520: FROM mtl_transaction_lots_temp

516: CURSOR get_mtlt_c(p_temp_id NUMBER) IS
517: SELECT primary_quantity
518: , lot_number
519: , secondary_quantity -- bug 8197499
520: FROM mtl_transaction_lots_temp
521: WHERE transaction_temp_id = p_temp_id;
522:
523: CURSOR c_fm_to_serial_number IS
524: SELECT

Line 536: mtl_transaction_lots_temp mtlt

532: msnt.fm_serial_number,
533: msnt.to_serial_number
534: FROM
535: mtl_serial_numbers_temp msnt,
536: mtl_transaction_lots_temp mtlt
537: WHERE mtlt.transaction_temp_id = p_mmtt_id
538: AND msnt.transaction_temp_id = mtlt.serial_transaction_temp_id;
539:
540: -- WF Fix End

Line 874: FROM mtl_transaction_lots_temp mtlt

870: IF l_serial_control_code NOT IN (1,6) THEN --{serial controlled
871: BEGIN
872: SELECT COUNT(*)
873: INTO l_msnt_cnt
874: FROM mtl_transaction_lots_temp mtlt
875: ,mtl_serial_numbers_temp msnt
876: WHERE mtlt.transaction_temp_id = l_mmtt_id
877: AND mtlt.serial_transaction_temp_id = msnt.transaction_temp_id;
878:

Line 944: FROM mtl_transaction_lots_temp mtlt

940:
941: DELETE FROM mtl_serial_numbers_temp msnt
942: WHERE msnt.transaction_temp_id IN
943: (SELECT mtlt.serial_transaction_temp_id
944: FROM mtl_transaction_lots_temp mtlt
945: WHERE mtlt.transaction_temp_id = l_mmtt_id);
946: mdebug('after delete msnt');
947:
948: EXCEPTION

Line 959: --DELETE FROM mtl_transaction_lots_temp mtlt

955: ELSE
956: mdebug('only lot controlled item');
957: END IF;--}
958:
959: --DELETE FROM mtl_transaction_lots_temp mtlt
960: --WHERE mtlt.transaction_temp_id = l_mmtt_id;
961: -- we need to use mtlt later and so far just zero out mtlt, later will delete them
962: mdebug('zero out quantity of the mtlt for lot controlled item');
963: UPDATE mtl_transaction_lots_temp

Line 963: UPDATE mtl_transaction_lots_temp

959: --DELETE FROM mtl_transaction_lots_temp mtlt
960: --WHERE mtlt.transaction_temp_id = l_mmtt_id;
961: -- we need to use mtlt later and so far just zero out mtlt, later will delete them
962: mdebug('zero out quantity of the mtlt for lot controlled item');
963: UPDATE mtl_transaction_lots_temp
964: SET primary_quantity = 0
965: , transaction_quantity = 0
966: , secondary_quantity = DECODE(secondary_quantity,NULL,NULL,0) --bug 8197499
967: WHERE transaction_temp_id IN ( l_mmtt_id ,l_parent_line_id) ; /*9251210*/

Line 1483: -- DELETE FROM mtl_transaction_lots_temp mtlt

1479:
1480: --Bug3633573 following deletion not required for mtlt
1481:
1482: --if l_lot_control_code = 2 then
1483: -- DELETE FROM mtl_transaction_lots_temp mtlt
1484: -- WHERE mtlt.transaction_temp_id = l_mmtt_id;
1485: --end if;
1486:
1487: l_return_status := FND_API.G_RET_STS_SUCCESS;