APPS.WMS_ITEM_LOAD dependencies on MTL_SERIAL_NUMBERS_TEMP

Line 547: FROM mtl_serial_numbers_temp

543: AND NVL(lot_number, '###') = NVL(p_lot_number, '###')
544: AND lpn_id = p_lpn_id
545: AND group_mark_id = p_serial_txn_temp_id
546: AND EXISTS (SELECT 1
547: FROM mtl_serial_numbers_temp
548: WHERE transaction_temp_id = p_serial_txn_temp_id
549: AND serial_number BETWEEN fm_serial_number AND
550: to_serial_number)
551: ORDER BY Nvl(inspection_status,0),LPAD(serial_number, 20);

Line 611: FROM mtl_serial_numbers_temp msnt

607: AND NVL(msn.lot_number, '###') = NVL(p_lot_number, '###')
608: AND msn.lpn_id = p_lpn_id
609: AND msn.group_mark_id = p_serial_txn_temp_id
610: AND EXISTS (SELECT 1
611: FROM mtl_serial_numbers_temp msnt
612: WHERE msnt.transaction_temp_id = p_serial_txn_temp_id
613: AND msn.serial_number BETWEEN msnt.fm_serial_number AND
614: msnt.to_serial_number);
615:

Line 2209: FROM mtl_serial_numbers_temp

2205: l_ser_trx_id NUMBER;
2206: -- Cursor used to get serial pack/unpack info for WIP LPNs
2207: CURSOR wip_serial_cursor IS
2208: SELECT fm_serial_number, to_serial_number
2209: FROM mtl_serial_numbers_temp
2210: WHERE transaction_temp_id = l_ser_trx_id;
2211: -- Variables used to retrieve info from wip_serial_cursor
2212: l_serial_number_ctrl_code NUMBER;
2213: l_lot_control_code NUMBER;

Line 2967: DELETE FROM mtl_serial_numbers_temp

2963: IF (l_ser_trx_id IS NOT NULL) THEN
2964: IF (l_debug = 1) THEN
2965: print_debug('Delete the dummy MSNT records: ' || l_ser_trx_id);
2966: END IF;
2967: DELETE FROM mtl_serial_numbers_temp
2968: WHERE transaction_temp_id = l_ser_trx_id;
2969: END IF;
2970:
2971: IF (l_lot_control_code = 2) THEN

Line 3207: FROM mtl_serial_numbers_temp

3203: SET group_mark_id = NULL
3204: WHERE current_organization_id = p_organization_id
3205: AND group_mark_id = p_serial_txn_temp_id
3206: AND EXISTS (SELECT 1
3207: FROM mtl_serial_numbers_temp
3208: WHERE transaction_temp_id = p_serial_txn_temp_id
3209: AND serial_number BETWEEN fm_serial_number AND
3210: to_serial_number);
3211: EXCEPTION

Line 3233: DELETE FROM mtl_serial_numbers_temp

3229: IF (l_debug = 1) THEN
3230: print_debug('Delete the temporary MSNT records');
3231: END IF;
3232: BEGIN
3233: DELETE FROM mtl_serial_numbers_temp
3234: WHERE transaction_temp_id = p_serial_txn_temp_id;
3235: EXCEPTION
3236: WHEN OTHERS THEN
3237: IF (l_debug = 1) THEN

Line 3439: FROM mtl_serial_numbers_temp

3435: WHERE inventory_item_id = p_inventory_item_id
3436: AND current_organization_id = p_organization_id
3437: AND group_mark_id = p_serial_txn_temp_id
3438: AND EXISTS (SELECT 1
3439: FROM mtl_serial_numbers_temp
3440: WHERE transaction_temp_id = p_serial_txn_temp_id
3441: AND serial_number BETWEEN fm_serial_number AND
3442: to_serial_number);
3443: EXCEPTION

Line 3455: DELETE FROM mtl_serial_numbers_temp

3451: IF (l_debug = 1) THEN
3452: print_debug('Delete the temporary MSNT records');
3453: END IF;
3454: BEGIN
3455: DELETE FROM mtl_serial_numbers_temp
3456: WHERE transaction_temp_id = p_serial_txn_temp_id;
3457: EXCEPTION
3458: WHEN OTHERS THEN
3459: IF (l_debug = 1) THEN