APPS.WMS_TASK_MGMT_PUB dependencies on MTL_SERIAL_NUMBERS_TEMP

Line 1738: FROM mtl_serial_numbers_temp

1734: BEGIN
1735: --serial quantity
1736: SELECT sum(1)
1737: INTO l_msnt_transaction_qty
1738: FROM mtl_serial_numbers_temp
1739: WHERE transaction_temp_id IN
1740: (SELECT serial_transaction_temp_id
1741: FROM mtl_transaction_lots_temp
1742: WHERE transaction_temp_id = p_transaction_temp_id

Line 1789: FROM mtl_serial_numbers_temp

1785: END IF;
1786: --Serial quantity
1787: SELECT sum(1)
1788: INTO l_msnt_transaction_qty
1789: FROM mtl_serial_numbers_temp
1790: WHERE transaction_temp_id = p_transaction_temp_id;
1791: IF l_msnt_transaction_qty <> l_mmtt_transaction_quantity THEN
1792: x_return_status := 'E';
1793: IF g_debug = 1 THEN

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

2204: END split_mtlt;
2205:
2206: -------------------------------------------------------------------------------------------------------------------
2207: /*Procedure split_serial()
2208: This helper procedure performs the splitting for the serial records contained in mtl_serial_numbers_temp table
2209: */
2210: -------------------------------------------------------------------------------------------------------------------
2211:
2212: PROCEDURE split_serial( p_orig_transaction_temp_id IN NUMBER ,

Line 2226: FROM mtl_serial_numbers_temp msnt

2222: CURSOR C_MSNT
2223: IS
2224: SELECT rowid,
2225: msnt.*
2226: FROM mtl_serial_numbers_temp msnt
2227: WHERE transaction_temp_id = p_orig_transaction_temp_id
2228: ORDER BY fm_serial_number;
2229: l_procedure_name VARCHAR2(20) := 'SPLIT_SERIAL';
2230: l_transaction_remaining_qty NUMBER;

Line 2242: UPDATE mtl_serial_numbers_temp

2238: END IF;
2239: FOR msnt IN C_MSNT
2240: LOOP
2241: l_transaction_remaining_qty := l_transaction_remaining_qty - 1;
2242: UPDATE mtl_serial_numbers_temp
2243: SET transaction_temp_id = p_new_transaction_temp_id ,
2244: last_updated_by = FND_GLOBAL.USER_ID
2245: WHERE rowid = msnt.rowid;
2246: UPDATE mtl_serial_numbers msn

Line 3360: FROM mtl_serial_numbers_temp

3356: END IF;
3357: END IF;
3358: SELECT count(*)
3359: INTO l_msnt_count
3360: FROM mtl_serial_numbers_temp
3361: WHERE transaction_temp_id IN
3362: (SELECT serial_transaction_temp_id
3363: FROM mtl_transaction_lots_temp
3364: WHERE transaction_temp_id = p_transaction_temp_id

Line 3367: DELETE mtl_serial_numbers_temp

3363: FROM mtl_transaction_lots_temp
3364: WHERE transaction_temp_id = p_transaction_temp_id
3365: );
3366: IF l_msnt_count > 0 THEN
3367: DELETE mtl_serial_numbers_temp
3368: WHERE transaction_temp_id IN
3369: (SELECT serial_transaction_temp_id
3370: FROM mtl_transaction_lots_temp
3371: WHERE transaction_temp_id = p_transaction_temp_id

Line 3403: FROM mtl_serial_numbers_temp

3399: END IF;
3400: END IF;
3401: SELECT count (*)
3402: INTO l_msnt_count
3403: FROM mtl_serial_numbers_temp
3404: WHERE transaction_temp_id = p_transaction_temp_id;
3405: IF l_msnt_count > 0 THEN
3406: DELETE mtl_serial_numbers_temp
3407: WHERE transaction_temp_id = p_transaction_temp_id;

Line 3406: DELETE mtl_serial_numbers_temp

3402: INTO l_msnt_count
3403: FROM mtl_serial_numbers_temp
3404: WHERE transaction_temp_id = p_transaction_temp_id;
3405: IF l_msnt_count > 0 THEN
3406: DELETE mtl_serial_numbers_temp
3407: WHERE transaction_temp_id = p_transaction_temp_id;
3408: IF SQL%ROWCOUNT = 0 THEN
3409: IF l_debug = 1 THEN
3410: debug_print ( 'Error deleting MSNT ');

Line 7019: FROM mtl_serial_numbers_temp

7015: MAX(status_id)
7016: INTO x_resultant_task_details(l_index).from_serial_number ,
7017: x_resultant_task_details(l_index).to_serial_number ,
7018: x_resultant_task_details(l_index).serial_status_id
7019: FROM mtl_serial_numbers_temp
7020: WHERE transaction_temp_id = l_mtlt_row.serial_transaction_temp_id;
7021: END IF;
7022: END LOOP;
7023: CLOSE mtlt_changed;

Line 7038: FROM mtl_serial_numbers_temp

7034: INTO x_resultant_task_details(l_index).from_serial_number ,
7035: x_resultant_task_details(l_index).to_serial_number ,
7036: x_resultant_task_details(l_index).serial_status_id ,
7037: x_resultant_task_details(l_index).number_of_serials
7038: FROM mtl_serial_numbers_temp
7039: WHERE transaction_temp_id = new_task_table(i).transaction_temp_id;
7040: END LOOP;
7041: END IF;
7042: IF g_debug = 1 THEN