APPS.WMS_TASK_MGMT_PUB dependencies on MTL_SERIAL_NUMBERS_TEMP

Line 1665: FROM mtl_serial_numbers_temp

1661: BEGIN
1662: --serial quantity
1663: SELECT sum(1)
1664: INTO l_msnt_transaction_qty
1665: FROM mtl_serial_numbers_temp
1666: WHERE transaction_temp_id IN
1667: (SELECT serial_transaction_temp_id
1668: FROM mtl_transaction_lots_temp
1669: WHERE transaction_temp_id = p_transaction_temp_id

Line 1716: FROM mtl_serial_numbers_temp

1712: END IF;
1713: --Serial quantity
1714: SELECT sum(1)
1715: INTO l_msnt_transaction_qty
1716: FROM mtl_serial_numbers_temp
1717: WHERE transaction_temp_id = p_transaction_temp_id;
1718: IF l_msnt_transaction_qty <> l_mmtt_transaction_quantity THEN
1719: x_return_status := 'E';
1720: IF g_debug = 1 THEN

Line 2131: This helper procedure performs the splitting for the serial records contained in mtl_serial_numbers_temp table

2127: END split_mtlt;
2128:
2129: -------------------------------------------------------------------------------------------------------------------
2130: /*Procedure split_serial()
2131: This helper procedure performs the splitting for the serial records contained in mtl_serial_numbers_temp table
2132: */
2133: -------------------------------------------------------------------------------------------------------------------
2134:
2135: PROCEDURE split_serial( p_orig_transaction_temp_id IN NUMBER ,

Line 2149: FROM mtl_serial_numbers_temp msnt

2145: CURSOR C_MSNT
2146: IS
2147: SELECT rowid,
2148: msnt.*
2149: FROM mtl_serial_numbers_temp msnt
2150: WHERE transaction_temp_id = p_orig_transaction_temp_id
2151: ORDER BY fm_serial_number;
2152: l_procedure_name VARCHAR2(20) := 'SPLIT_SERIAL';
2153: l_transaction_remaining_qty NUMBER;

Line 2165: UPDATE mtl_serial_numbers_temp

2161: END IF;
2162: FOR msnt IN C_MSNT
2163: LOOP
2164: l_transaction_remaining_qty := l_transaction_remaining_qty - 1;
2165: UPDATE mtl_serial_numbers_temp
2166: SET transaction_temp_id = p_new_transaction_temp_id ,
2167: last_updated_by = FND_GLOBAL.USER_ID
2168: WHERE rowid = msnt.rowid;
2169: UPDATE mtl_serial_numbers msn

Line 3271: FROM mtl_serial_numbers_temp

3267: END IF;
3268: END IF;
3269: SELECT count(*)
3270: INTO l_msnt_count
3271: FROM mtl_serial_numbers_temp
3272: WHERE transaction_temp_id IN
3273: (SELECT serial_transaction_temp_id
3274: FROM mtl_transaction_lots_temp
3275: WHERE transaction_temp_id = p_transaction_temp_id

Line 3278: DELETE mtl_serial_numbers_temp

3274: FROM mtl_transaction_lots_temp
3275: WHERE transaction_temp_id = p_transaction_temp_id
3276: );
3277: IF l_msnt_count > 0 THEN
3278: DELETE mtl_serial_numbers_temp
3279: WHERE transaction_temp_id IN
3280: (SELECT serial_transaction_temp_id
3281: FROM mtl_transaction_lots_temp
3282: WHERE transaction_temp_id = p_transaction_temp_id

Line 3314: FROM mtl_serial_numbers_temp

3310: END IF;
3311: END IF;
3312: SELECT count (*)
3313: INTO l_msnt_count
3314: FROM mtl_serial_numbers_temp
3315: WHERE transaction_temp_id = p_transaction_temp_id;
3316: IF l_msnt_count > 0 THEN
3317: DELETE mtl_serial_numbers_temp
3318: WHERE transaction_temp_id = p_transaction_temp_id;

Line 3317: DELETE mtl_serial_numbers_temp

3313: INTO l_msnt_count
3314: FROM mtl_serial_numbers_temp
3315: WHERE transaction_temp_id = p_transaction_temp_id;
3316: IF l_msnt_count > 0 THEN
3317: DELETE mtl_serial_numbers_temp
3318: WHERE transaction_temp_id = p_transaction_temp_id;
3319: IF SQL%ROWCOUNT = 0 THEN
3320: IF l_debug = 1 THEN
3321: debug_print ( 'Error deleting MSNT ');

Line 6920: FROM mtl_serial_numbers_temp

6916: MAX(status_id)
6917: INTO x_resultant_task_details(l_index).from_serial_number ,
6918: x_resultant_task_details(l_index).to_serial_number ,
6919: x_resultant_task_details(l_index).serial_status_id
6920: FROM mtl_serial_numbers_temp
6921: WHERE transaction_temp_id = l_mtlt_row.serial_transaction_temp_id;
6922: END IF;
6923: END LOOP;
6924: CLOSE mtlt_changed;

Line 6939: FROM mtl_serial_numbers_temp

6935: INTO x_resultant_task_details(l_index).from_serial_number ,
6936: x_resultant_task_details(l_index).to_serial_number ,
6937: x_resultant_task_details(l_index).serial_status_id ,
6938: x_resultant_task_details(l_index).number_of_serials
6939: FROM mtl_serial_numbers_temp
6940: WHERE transaction_temp_id = new_task_table(i).transaction_temp_id;
6941: END LOOP;
6942: END IF;
6943: IF g_debug = 1 THEN