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.INV_LPN_TRX_PUB dependencies on MTL_SERIAL_NUMBERS

Line 530: * Insert a row into MTL_SERIAL_NUMBERS_TEMP

526: RETURN sertrxid;
527: END;
528:
529: /********************************************************************
530: * Insert a row into MTL_SERIAL_NUMBERS_TEMP
531: *******************************************************************/
532: FUNCTION insert_ser_trx(p_ser_number VARCHAR2, p_sertrxid NUMBER)
533: RETURN NUMBER IS
534: retval NUMBER;

Line 1481: FROM mtl_serial_numbers_temp

1477:
1478: CURSOR c_sertmp IS
1479: SELECT fm_serial_number
1480: , to_serial_number
1481: FROM mtl_serial_numbers_temp
1482: WHERE transaction_temp_id = v_sertrxid;
1483:
1484: CURSOR c_lottmp IS
1485: SELECT lot_number

Line 2001: * Insert a row into MTL_SERIAL_NUMBERS_TEMP which is a copy of another msnt row

1997: END IF;
1998: END;
1999:
2000: /********************************************************************
2001: * Insert a row into MTL_SERIAL_NUMBERS_TEMP which is a copy of another msnt row
2002: *******************************************************************/
2003: PROCEDURE copy_msnt(p_source_row_id ROWID, p_new_sertrxid NUMBER, p_new_fm_serial VARCHAR2, p_new_to_serial VARCHAR2) IS
2004: l_api_name CONSTANT VARCHAR2(30) := 'COPY_MSNT';
2005: l_api_version CONSTANT NUMBER := 1.0;

Line 2007: l_sertmp_rec mtl_serial_numbers_temp%ROWTYPE;

2003: PROCEDURE copy_msnt(p_source_row_id ROWID, p_new_sertrxid NUMBER, p_new_fm_serial VARCHAR2, p_new_to_serial VARCHAR2) IS
2004: l_api_name CONSTANT VARCHAR2(30) := 'COPY_MSNT';
2005: l_api_version CONSTANT NUMBER := 1.0;
2006: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2007: l_sertmp_rec mtl_serial_numbers_temp%ROWTYPE;
2008: BEGIN
2009: IF (l_debug = 1) THEN
2010: inv_log_util.TRACE('Call to Copy_MSNT rowid=' || p_source_row_id, 'INV_LPN_TRX_PUB', 9);
2011: inv_log_util.TRACE('newsertrxid=' || p_new_sertrxid || ' newfsn=' || p_new_fm_serial || ' newtsn=' || p_new_to_serial

Line 2017: FROM mtl_serial_numbers_temp

2013: END IF;
2014:
2015: SELECT *
2016: INTO l_sertmp_rec
2017: FROM mtl_serial_numbers_temp
2018: WHERE ROWID = p_source_row_id;
2019:
2020: --Insert new record for split serials
2021: INSERT INTO mtl_serial_numbers_temp

Line 2021: INSERT INTO mtl_serial_numbers_temp

2017: FROM mtl_serial_numbers_temp
2018: WHERE ROWID = p_source_row_id;
2019:
2020: --Insert new record for split serials
2021: INSERT INTO mtl_serial_numbers_temp
2022: (
2023: transaction_temp_id
2024: , last_update_date
2025: , last_updated_by

Line 2298: FROM mtl_serial_numbers msn, mtl_serial_numbers_temp wddmsnt, mtl_serial_numbers_temp trxmsnt

2294: l_dd_rec delivery_detail_cursor%ROWTYPE;
2295:
2296: CURSOR del_serial_cursor(p_wdd_trx_tmp_id NUMBER) IS
2297: SELECT DISTINCT msn.serial_number
2298: FROM mtl_serial_numbers msn, mtl_serial_numbers_temp wddmsnt, mtl_serial_numbers_temp trxmsnt
2299: WHERE msn.current_organization_id = p_organization_id
2300: AND msn.inventory_item_id = p_item_rec.inventory_item_id
2301: AND wddmsnt.transaction_temp_id = p_wdd_trx_tmp_id
2302: AND LENGTH(msn.serial_number) = LENGTH(wddmsnt.fm_serial_number)

Line 2319: FROM mtl_serial_numbers_temp msnt

2315: CURSOR wdd_ser_cur(p_wdd_trx_tmp_id NUMBER, p_start_serial VARCHAR2) IS
2316: SELECT DISTINCT ROWID
2317: , fm_serial_number
2318: , to_serial_number
2319: FROM mtl_serial_numbers_temp msnt
2320: WHERE transaction_temp_id = p_wdd_trx_tmp_id
2321: AND fm_serial_number >= p_start_serial
2322: AND LENGTH(p_start_serial) = LENGTH(fm_serial_number)
2323: ORDER BY fm_serial_number;

Line 2378: FROM mtl_serial_numbers_temp

2374: -- Only one serial in this line check to see if it is part of split.
2375: BEGIN
2376: SELECT 1
2377: INTO l_split_quantity
2378: FROM mtl_serial_numbers_temp
2379: WHERE transaction_temp_id = p_serial_trx_temp_id
2380: AND dd_rec.serial_number BETWEEN fm_serial_number AND NVL(to_serial_number, fm_serial_number)
2381: AND LENGTH(fm_serial_number) = LENGTH(dd_rec.serial_number)
2382: AND ROWNUM < 2;

Line 2499: UPDATE mtl_serial_numbers_temp

2495: AND l_new_to_serial = wdd_ser_rec.to_serial_number) THEN
2496: -- Whole serial range in wdd is part of split.
2497: IF (l_invpcinrectype.transaction_temp_id IS NOT NULL) THEN
2498: -- More than one serial to be put new temp id on it
2499: UPDATE mtl_serial_numbers_temp
2500: SET transaction_temp_id = l_invpcinrectype.transaction_temp_id
2501: WHERE ROWID = wdd_ser_rec.ROWID;
2502: ELSE
2503: -- Single serial being split, remove record from MSNT

Line 2504: DELETE FROM mtl_serial_numbers_temp

2500: SET transaction_temp_id = l_invpcinrectype.transaction_temp_id
2501: WHERE ROWID = wdd_ser_rec.ROWID;
2502: ELSE
2503: -- Single serial being split, remove record from MSNT
2504: DELETE FROM mtl_serial_numbers_temp
2505: WHERE ROWID = wdd_ser_rec.ROWID;
2506: END IF;
2507: ELSE -- Create records for the new serial sub ranges
2508: -- If not a single serial being split, create an new MSNT line for new split WDD line

Line 2535: UPDATE mtl_serial_numbers_temp

2531:
2532: --Update the to serial one less than the beginning of the split serial range
2533: wdd_ser_rec.to_serial_number := l_serial_prefix || LPAD(l_fm_serial_suffix - 1, l_serial_suffix_length, '0');
2534:
2535: UPDATE mtl_serial_numbers_temp
2536: SET to_serial_number = wdd_ser_rec.to_serial_number
2537: WHERE ROWID = wdd_ser_rec.ROWID;
2538: ELSIF(l_new_to_serial < wdd_ser_rec.to_serial_number) THEN
2539: --Update the from serial one greater than the end of the split serial range

Line 2542: UPDATE mtl_serial_numbers_temp

2538: ELSIF(l_new_to_serial < wdd_ser_rec.to_serial_number) THEN
2539: --Update the from serial one greater than the end of the split serial range
2540: wdd_ser_rec.fm_serial_number := l_serial_prefix || LPAD(l_to_serial_suffix, l_serial_suffix_length, '0');
2541:
2542: UPDATE mtl_serial_numbers_temp
2543: SET fm_serial_number = wdd_ser_rec.fm_serial_number
2544: WHERE ROWID = wdd_ser_rec.ROWID;
2545: END IF;
2546: END IF;

Line 4278: DELETE FROM mtl_serial_numbers_temp

4274: || v_mmtt.transaction_batch_id, 1);
4275: END IF;
4276:
4277: -- Remove from MSNT rows with same MMTT transaction_temp_id
4278: DELETE FROM mtl_serial_numbers_temp
4279: WHERE transaction_temp_id IN(SELECT transaction_temp_id
4280: FROM mtl_material_transactions_temp
4281: WHERE transaction_header_id = p_trx_hdr_id -- Bug 5748351
4282: AND transaction_batch_id = v_mmtt.transaction_batch_id);

Line 4285: DELETE FROM mtl_serial_numbers_temp

4281: WHERE transaction_header_id = p_trx_hdr_id -- Bug 5748351
4282: AND transaction_batch_id = v_mmtt.transaction_batch_id);
4283:
4284: -- Remove from MSNT rows with same MTNT transaction_temp_id
4285: DELETE FROM mtl_serial_numbers_temp
4286: WHERE transaction_temp_id IN(SELECT serial_transaction_temp_id
4287: FROM mtl_transaction_lots_temp
4288: WHERE transaction_temp_id IN(SELECT transaction_temp_id
4289: FROM mtl_material_transactions_temp

Line 4324: DELETE FROM mtl_serial_numbers_temp

4320: || v_mmtt.transaction_temp_id, 1);
4321: END IF;
4322:
4323: -- Remove from MSNT rows with same MMTT transaction_temp_id
4324: DELETE FROM mtl_serial_numbers_temp
4325: WHERE transaction_temp_id = v_mmtt.transaction_temp_id;
4326:
4327: -- Remove from MSNT rows with same MTNT transaction_temp_id
4328: DELETE FROM mtl_serial_numbers_temp

Line 4328: DELETE FROM mtl_serial_numbers_temp

4324: DELETE FROM mtl_serial_numbers_temp
4325: WHERE transaction_temp_id = v_mmtt.transaction_temp_id;
4326:
4327: -- Remove from MSNT rows with same MTNT transaction_temp_id
4328: DELETE FROM mtl_serial_numbers_temp
4329: WHERE transaction_temp_id IN(SELECT serial_transaction_temp_id
4330: FROM mtl_transaction_lots_temp
4331: WHERE transaction_temp_id = v_mmtt.transaction_temp_id);
4332:

Line 4686: DELETE FROM mtl_serial_numbers_temp

4682: , lock_flag = 2
4683: WHERE transaction_header_id = p_trx_hdr_id;
4684:
4685: -- Remove from MSNT rows with same MMTT Transaction_header_id
4686: DELETE FROM mtl_serial_numbers_temp
4687: WHERE transaction_temp_id IN(SELECT transaction_temp_id
4688: FROM mtl_material_transactions_temp
4689: WHERE transaction_header_id = p_trx_hdr_id);
4690:

Line 4692: DELETE FROM mtl_serial_numbers_temp

4688: FROM mtl_material_transactions_temp
4689: WHERE transaction_header_id = p_trx_hdr_id);
4690:
4691: -- Remove from MSNT rows with same MTNT Transaction_header_id
4692: DELETE FROM mtl_serial_numbers_temp
4693: WHERE transaction_temp_id IN(SELECT serial_transaction_temp_id
4694: FROM mtl_transaction_lots_temp
4695: WHERE transaction_temp_id IN(SELECT transaction_temp_id
4696: FROM mtl_material_transactions_temp

Line 5391: UPDATE mtl_serial_numbers

5387: , locator_id = nvl(l_loc_id,locator_id) --6374764
5388: WHERE lpn_id = p_lpn_id;
5389:
5390: --Same needs to be done in the serial numbers table
5391: UPDATE mtl_serial_numbers
5392: SET cost_group_id = NULL
5393: WHERE lpn_id = p_lpn_id;
5394: END IF;
5395: ELSIF(l_rcv_txn_type = 'RETURN TO VENDOR'

Line 5476: UPDATE mtl_serial_numbers

5472: SET cost_group_id = NULL
5473: WHERE parent_lpn_id = p_lpn_id;
5474:
5475: --Same needs to be done in the serial numbers table
5476: UPDATE mtl_serial_numbers
5477: SET cost_group_id = NULL
5478: WHERE lpn_id = p_lpn_id;
5479:
5480: -- Since correction is in same lpn, need to change context

Line 5743: UPDATE mtl_serial_numbers

5739: /* Bug 3910656- Added the last condition to the query to update only those
5740: records with the serial_summary_entry as 2. */
5741:
5742: -- If this item is Serial controlled, set cost_group_id for Serials
5743: UPDATE mtl_serial_numbers
5744: SET cost_group_id = p_cost_group_id
5745: WHERE inventory_item_id = p_inventory_item_id
5746: AND lpn_id = p_lpn_id;
5747:

Line 6686: DELETE FROM mtl_serial_numbers_temp

6682: inv_log_util.TRACE('* Done with process_lpn_trx_line, deleting MMTT record for tmpID=' || p_transaction_temp_id, 'INV_LPN_TRX_PUB'
6683: , 1);
6684: END IF;
6685:
6686: DELETE FROM mtl_serial_numbers_temp
6687: WHERE transaction_temp_id = (SELECT transaction_temp_id
6688: FROM mtl_material_transactions_temp
6689: WHERE transaction_temp_id = p_transaction_temp_id
6690: AND inventory_item_id = -1);

Line 6693: DELETE FROM mtl_serial_numbers_temp

6689: WHERE transaction_temp_id = p_transaction_temp_id
6690: AND inventory_item_id = -1);
6691:
6692: IF SQL%ROWCOUNT = 0 THEN
6693: DELETE FROM mtl_serial_numbers_temp
6694: WHERE transaction_temp_id IN(
6695: SELECT serial_transaction_temp_id
6696: FROM mtl_transaction_lots_temp
6697: WHERE transaction_temp_id =