APPS.WMS_ITEM_LOAD dependencies on MTL_SERIAL_NUMBERS

Line 539: FROM mtl_serial_numbers

535: -- Cursor to get the marked serials
536: CURSOR marked_serials_cursor IS
537: SELECT serial_number
538: , Nvl(inspection_status,0) inspection_status
539: FROM mtl_serial_numbers
540: WHERE inventory_item_id = p_inventory_item_id
541: AND current_organization_id = p_organization_id
542: AND NVL(revision, '###') = NVL(p_revision, '###')
543: AND NVL(lot_number, '###') = NVL(p_lot_number, '###')

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 596: FROM wip_lpn_completions_serials wlcs, mtl_serial_numbers msn

592: -- It seems that for WIP LPN completions with serials, each record in
593: -- WIP_LPN_COMPLETIONS_SERIALS contains one and only one serial.
594: CURSOR matched_wip_serials_cursor IS
595: SELECT wlcs.fm_serial_number
596: FROM wip_lpn_completions_serials wlcs, mtl_serial_numbers msn
597: WHERE l_lpn_context = 2
598: AND NVL(wlcs.lot_number, '###') = NVL(p_lot_number, '###')
599: AND wlcs.header_id IN (SELECT reference_id
600: FROM mtl_txn_request_lines

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 3202: UPDATE mtl_serial_numbers

3198: IF (l_debug = 1) THEN
3199: print_debug('Clear the group mark ID for the marked serials');
3200: END IF;
3201: BEGIN
3202: UPDATE mtl_serial_numbers
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

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 3433: UPDATE mtl_serial_numbers

3429: IF (l_debug = 1) THEN
3430: print_debug('Clear the group mark ID for the marked serials');
3431: END IF;
3432: BEGIN
3433: UPDATE mtl_serial_numbers
3434: SET group_mark_id = NULL
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

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