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 719: * Insert a row into MTL_SERIAL_NUMBERS_TEMP

715: RETURN sertrxid;
716: END;
717:
718: /********************************************************************
719: * Insert a row into MTL_SERIAL_NUMBERS_TEMP
720: *******************************************************************/
721: FUNCTION insert_ser_trx(p_ser_number VARCHAR2, p_sertrxid NUMBER)
722: RETURN NUMBER IS
723: retval NUMBER;

Line 1698: FROM mtl_serial_numbers_temp

1694:
1695: CURSOR c_sertmp IS
1696: SELECT fm_serial_number
1697: , to_serial_number
1698: FROM mtl_serial_numbers_temp
1699: WHERE transaction_temp_id = v_sertrxid;
1700:
1701: CURSOR c_lottmp IS
1702: SELECT lot_number

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

2214: END IF;
2215: END;
2216:
2217: /********************************************************************
2218: * Insert a row into MTL_SERIAL_NUMBERS_TEMP which is a copy of another msnt row
2219: *******************************************************************/
2220: PROCEDURE copy_msnt(p_source_row_id ROWID, p_new_sertrxid NUMBER, p_new_fm_serial VARCHAR2, p_new_to_serial VARCHAR2) IS
2221: l_api_name CONSTANT VARCHAR2(30) := 'COPY_MSNT';
2222: l_api_version CONSTANT NUMBER := 1.0;

Line 2224: l_sertmp_rec mtl_serial_numbers_temp%ROWTYPE;

2220: PROCEDURE copy_msnt(p_source_row_id ROWID, p_new_sertrxid NUMBER, p_new_fm_serial VARCHAR2, p_new_to_serial VARCHAR2) IS
2221: l_api_name CONSTANT VARCHAR2(30) := 'COPY_MSNT';
2222: l_api_version CONSTANT NUMBER := 1.0;
2223: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2224: l_sertmp_rec mtl_serial_numbers_temp%ROWTYPE;
2225: BEGIN
2226: IF (l_debug = 1) THEN
2227: inv_log_util.TRACE('Call to Copy_MSNT rowid=' || p_source_row_id, 'INV_LPN_TRX_PUB', 9);
2228: inv_log_util.TRACE('newsertrxid=' || p_new_sertrxid || ' newfsn=' || p_new_fm_serial || ' newtsn=' || p_new_to_serial

Line 2234: FROM mtl_serial_numbers_temp

2230: END IF;
2231:
2232: SELECT *
2233: INTO l_sertmp_rec
2234: FROM mtl_serial_numbers_temp
2235: WHERE ROWID = p_source_row_id;
2236:
2237: --Insert new record for split serials
2238: INSERT INTO mtl_serial_numbers_temp

Line 2238: INSERT INTO mtl_serial_numbers_temp

2234: FROM mtl_serial_numbers_temp
2235: WHERE ROWID = p_source_row_id;
2236:
2237: --Insert new record for split serials
2238: INSERT INTO mtl_serial_numbers_temp
2239: (
2240: transaction_temp_id
2241: , last_update_date
2242: , last_updated_by

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

2512: l_dd_rec delivery_detail_cursor%ROWTYPE;
2513:
2514: CURSOR del_serial_cursor(p_wdd_trx_tmp_id NUMBER) IS
2515: SELECT DISTINCT msn.serial_number
2516: FROM mtl_serial_numbers msn, mtl_serial_numbers_temp wddmsnt, mtl_serial_numbers_temp trxmsnt
2517: WHERE msn.current_organization_id = p_organization_id
2518: AND msn.inventory_item_id = p_item_rec.inventory_item_id
2519: AND wddmsnt.transaction_temp_id = p_wdd_trx_tmp_id
2520: AND LENGTH(msn.serial_number) = LENGTH(wddmsnt.fm_serial_number)

Line 2537: FROM mtl_serial_numbers_temp msnt

2533: CURSOR wdd_ser_cur(p_wdd_trx_tmp_id NUMBER, p_start_serial VARCHAR2) IS
2534: SELECT DISTINCT ROWID
2535: , fm_serial_number
2536: , to_serial_number
2537: FROM mtl_serial_numbers_temp msnt
2538: WHERE transaction_temp_id = p_wdd_trx_tmp_id
2539: AND fm_serial_number >= p_start_serial
2540: AND LENGTH(p_start_serial) = LENGTH(fm_serial_number)
2541: ORDER BY fm_serial_number;

Line 2599: FROM mtl_serial_numbers_temp

2595: -- Only one serial in this line check to see if it is part of split.
2596: BEGIN
2597: SELECT 1
2598: INTO l_split_quantity
2599: FROM mtl_serial_numbers_temp
2600: WHERE transaction_temp_id = p_serial_trx_temp_id
2601: AND dd_rec.serial_number BETWEEN fm_serial_number AND NVL(to_serial_number, fm_serial_number)
2602: AND LENGTH(fm_serial_number) = LENGTH(dd_rec.serial_number)
2603: AND ROWNUM < 2;

Line 2724: UPDATE mtl_serial_numbers_temp

2720: AND l_new_to_serial = wdd_ser_rec.to_serial_number) THEN
2721: -- Whole serial range in wdd is part of split.
2722: IF (l_invpcinrectype.transaction_temp_id IS NOT NULL) THEN
2723: -- More than one serial to be put new temp id on it
2724: UPDATE mtl_serial_numbers_temp
2725: SET transaction_temp_id = l_invpcinrectype.transaction_temp_id
2726: WHERE ROWID = wdd_ser_rec.ROWID;
2727: ELSE
2728: -- Single serial being split, remove record from MSNT

Line 2729: DELETE FROM mtl_serial_numbers_temp

2725: SET transaction_temp_id = l_invpcinrectype.transaction_temp_id
2726: WHERE ROWID = wdd_ser_rec.ROWID;
2727: ELSE
2728: -- Single serial being split, remove record from MSNT
2729: DELETE FROM mtl_serial_numbers_temp
2730: WHERE ROWID = wdd_ser_rec.ROWID;
2731: END IF;
2732: ELSE -- Create records for the new serial sub ranges
2733: -- If not a single serial being split, create an new MSNT line for new split WDD line

Line 2760: UPDATE mtl_serial_numbers_temp

2756:
2757: --Update the to serial one less than the beginning of the split serial range
2758: wdd_ser_rec.to_serial_number := l_serial_prefix || LPAD(l_fm_serial_suffix - 1, l_serial_suffix_length, '0');
2759:
2760: UPDATE mtl_serial_numbers_temp
2761: SET to_serial_number = wdd_ser_rec.to_serial_number
2762: WHERE ROWID = wdd_ser_rec.ROWID;
2763: ELSIF(l_new_to_serial < wdd_ser_rec.to_serial_number) THEN
2764: --Update the from serial one greater than the end of the split serial range

Line 2767: UPDATE mtl_serial_numbers_temp

2763: ELSIF(l_new_to_serial < wdd_ser_rec.to_serial_number) THEN
2764: --Update the from serial one greater than the end of the split serial range
2765: wdd_ser_rec.fm_serial_number := l_serial_prefix || LPAD(l_to_serial_suffix, l_serial_suffix_length, '0');
2766:
2767: UPDATE mtl_serial_numbers_temp
2768: SET fm_serial_number = wdd_ser_rec.fm_serial_number
2769: WHERE ROWID = wdd_ser_rec.ROWID;
2770: END IF;
2771: END IF;

Line 4601: DELETE FROM mtl_serial_numbers_temp

4597: || v_mmtt.transaction_batch_id, 1);
4598: END IF;
4599:
4600: -- Remove from MSNT rows with same MMTT transaction_temp_id
4601: DELETE FROM mtl_serial_numbers_temp
4602: WHERE transaction_temp_id IN(SELECT transaction_temp_id
4603: FROM mtl_material_transactions_temp
4604: WHERE transaction_header_id = p_trx_hdr_id -- Bug 5748351
4605: AND transaction_batch_id = v_mmtt.transaction_batch_id);

Line 4608: DELETE FROM mtl_serial_numbers_temp

4604: WHERE transaction_header_id = p_trx_hdr_id -- Bug 5748351
4605: AND transaction_batch_id = v_mmtt.transaction_batch_id);
4606:
4607: -- Remove from MSNT rows with same MTNT transaction_temp_id
4608: DELETE FROM mtl_serial_numbers_temp
4609: WHERE transaction_temp_id IN(SELECT serial_transaction_temp_id
4610: FROM mtl_transaction_lots_temp
4611: WHERE transaction_temp_id IN(SELECT transaction_temp_id
4612: FROM mtl_material_transactions_temp

Line 4647: DELETE FROM mtl_serial_numbers_temp

4643: || v_mmtt.transaction_temp_id, 1);
4644: END IF;
4645:
4646: -- Remove from MSNT rows with same MMTT transaction_temp_id
4647: DELETE FROM mtl_serial_numbers_temp
4648: WHERE transaction_temp_id = v_mmtt.transaction_temp_id;
4649:
4650: -- Remove from MSNT rows with same MTNT transaction_temp_id
4651: DELETE FROM mtl_serial_numbers_temp

Line 4651: DELETE FROM mtl_serial_numbers_temp

4647: DELETE FROM mtl_serial_numbers_temp
4648: WHERE transaction_temp_id = v_mmtt.transaction_temp_id;
4649:
4650: -- Remove from MSNT rows with same MTNT transaction_temp_id
4651: DELETE FROM mtl_serial_numbers_temp
4652: WHERE transaction_temp_id IN(SELECT serial_transaction_temp_id
4653: FROM mtl_transaction_lots_temp
4654: WHERE transaction_temp_id = v_mmtt.transaction_temp_id);
4655:

Line 5186: DELETE FROM mtl_serial_numbers_temp

5182: , lock_flag = 2
5183: WHERE transaction_header_id = p_trx_hdr_id;
5184:
5185: -- Remove from MSNT rows with same MMTT Transaction_header_id
5186: DELETE FROM mtl_serial_numbers_temp
5187: WHERE transaction_temp_id IN(SELECT transaction_temp_id
5188: FROM mtl_material_transactions_temp
5189: WHERE transaction_header_id = p_trx_hdr_id);
5190:

Line 5192: DELETE FROM mtl_serial_numbers_temp

5188: FROM mtl_material_transactions_temp
5189: WHERE transaction_header_id = p_trx_hdr_id);
5190:
5191: -- Remove from MSNT rows with same MTNT Transaction_header_id
5192: DELETE FROM mtl_serial_numbers_temp
5193: WHERE transaction_temp_id IN(SELECT serial_transaction_temp_id
5194: FROM mtl_transaction_lots_temp
5195: WHERE transaction_temp_id IN(SELECT transaction_temp_id
5196: FROM mtl_material_transactions_temp

Line 6024: UPDATE mtl_serial_numbers

6020: , locator_id = nvl(l_loc_id,locator_id) --6374764
6021: WHERE lpn_id = p_lpn_id;
6022:
6023: --Same needs to be done in the serial numbers table
6024: UPDATE mtl_serial_numbers
6025: SET cost_group_id = NULL
6026: WHERE lpn_id = p_lpn_id;
6027: END IF;
6028: ELSIF(l_rcv_txn_type = 'RETURN TO VENDOR'

Line 6109: UPDATE mtl_serial_numbers

6105: SET cost_group_id = NULL
6106: WHERE parent_lpn_id = p_lpn_id;
6107:
6108: --Same needs to be done in the serial numbers table
6109: UPDATE mtl_serial_numbers
6110: SET cost_group_id = NULL
6111: WHERE lpn_id = p_lpn_id;
6112:
6113: -- Since correction is in same lpn, need to change context

Line 6474: UPDATE mtl_serial_numbers

6470:
6471: -- If this item is Serial controlled, set cost_group_id for Serials
6472: --bug# 9651496,9764650
6473: IF (p_transaction_action_id = inv_globals.g_action_intransitreceipt) THEN
6474: UPDATE mtl_serial_numbers
6475: SET cost_group_id = p_cost_group_id
6476: WHERE inventory_item_id = p_inventory_item_id
6477: AND lpn_id = p_lpn_id
6478: AND serial_number IN ( SELECT fm_serial_number

Line 6479: FROM mtl_serial_numbers_temp

6475: SET cost_group_id = p_cost_group_id
6476: WHERE inventory_item_id = p_inventory_item_id
6477: AND lpn_id = p_lpn_id
6478: AND serial_number IN ( SELECT fm_serial_number
6479: FROM mtl_serial_numbers_temp
6480: WHERE transaction_temp_id = p_transaction_temp_id);
6481: ELSE
6482: UPDATE mtl_serial_numbers
6483: SET cost_group_id = p_cost_group_id

Line 6482: UPDATE mtl_serial_numbers

6478: AND serial_number IN ( SELECT fm_serial_number
6479: FROM mtl_serial_numbers_temp
6480: WHERE transaction_temp_id = p_transaction_temp_id);
6481: ELSE
6482: UPDATE mtl_serial_numbers
6483: SET cost_group_id = p_cost_group_id
6484: WHERE inventory_item_id = p_inventory_item_id
6485: AND lpn_id = p_lpn_id;
6486: IF (l_debug = 1) THEN

Line 7768: DELETE FROM mtl_serial_numbers_temp

7764: inv_log_util.TRACE('* Done with process_lpn_trx_line, deleting MMTT record for tmpID=' || p_transaction_temp_id, 'INV_LPN_TRX_PUB'
7765: , 1);
7766: END IF;
7767:
7768: DELETE FROM mtl_serial_numbers_temp
7769: WHERE transaction_temp_id = (SELECT transaction_temp_id
7770: FROM mtl_material_transactions_temp
7771: WHERE transaction_temp_id = p_transaction_temp_id
7772: AND inventory_item_id = -1);

Line 7775: DELETE FROM mtl_serial_numbers_temp

7771: WHERE transaction_temp_id = p_transaction_temp_id
7772: AND inventory_item_id = -1);
7773:
7774: IF SQL%ROWCOUNT = 0 THEN
7775: DELETE FROM mtl_serial_numbers_temp
7776: WHERE transaction_temp_id IN(
7777: SELECT serial_transaction_temp_id
7778: FROM mtl_transaction_lots_temp
7779: WHERE transaction_temp_id =