eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMS_TASK_MGMT_PUB dependencies on MTL_SERIAL_NUMBERS

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 2169: UPDATE mtl_serial_numbers msn

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
2170: SET msn.group_mark_id = p_new_transaction_temp_id ,
2171: last_updated_by = FND_GLOBAL.USER_ID
2172: WHERE msn.inventory_item_id = p_inventory_item_id
2173: AND serial_number = msnt.fm_serial_number

Line 3244: FROM mtl_serial_numbers

3240: IF l_serial_control_code IN(2, 5) THEN --If serial controlled
3241: IF l_lot_control_code = 2 THEN -- If lot controlled also
3242: SELECT count (*)
3243: INTO l_msn_count
3244: FROM mtl_serial_numbers
3245: WHERE group_mark_id IN
3246: (SELECT serial_transaction_temp_id
3247: FROM mtl_transaction_lots_temp
3248: WHERE transaction_temp_id = p_transaction_temp_id

Line 3251: UPDATE mtl_serial_numbers

3247: FROM mtl_transaction_lots_temp
3248: WHERE transaction_temp_id = p_transaction_temp_id
3249: );
3250: IF l_msn_count > 0 THEN
3251: UPDATE mtl_serial_numbers
3252: SET group_mark_id = NULL,
3253: line_mark_id = NULL,
3254: lot_line_mark_id = NULL
3255: WHERE group_mark_id IN

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 3295: FROM mtl_serial_numbers

3291: END IF;
3292: ELSE -- only serial controlled but not lot controlled.
3293: SELECT count(*)
3294: INTO l_msn_count
3295: FROM mtl_serial_numbers
3296: WHERE group_mark_id = p_transaction_temp_id ;
3297: IF l_msn_count > 0 THEN
3298: UPDATE mtl_serial_numbers
3299: SET group_mark_id = NULL,

Line 3298: UPDATE mtl_serial_numbers

3294: INTO l_msn_count
3295: FROM mtl_serial_numbers
3296: WHERE group_mark_id = p_transaction_temp_id ;
3297: IF l_msn_count > 0 THEN
3298: UPDATE mtl_serial_numbers
3299: SET group_mark_id = NULL,
3300: line_mark_id = NULL,
3301: lot_line_mark_id = NULL
3302: WHERE group_mark_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