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_DISPATCH_GEN dependencies on MTL_SERIAL_NUMBERS_TEMP

Line 2225: INSERT INTO mtl_serial_numbers_temp

2221: OPEN c_msn_attributes(l_cur_serial_number, l_item_id);
2222: FETCH c_msn_attributes INTO l_msn_attribute_rec;
2223: CLOSE c_msn_attributes;
2224:
2225: INSERT INTO mtl_serial_numbers_temp
2226: ( TRANSACTION_TEMP_ID
2227: , LAST_UPDATE_DATE
2228: , LAST_UPDATED_BY
2229: , CREATION_DATE

Line 2362: /*INSERT INTO mtl_serial_numbers_temp

2358: );
2359: END LOOP; --END for each serial number
2360: -- Insert into serial
2361: --mydebug('process_lot_serial: Inserting Serials');
2362: /*INSERT INTO mtl_serial_numbers_temp
2363: (
2364: transaction_temp_id
2365: , last_update_date
2366: , last_updated_by

Line 2416: INSERT INTO mtl_serial_numbers_temp

2412: OPEN c_msn_attributes(l_cur_serial_number, l_item_id);
2413: FETCH c_msn_attributes INTO l_msn_attribute_rec;
2414: CLOSE c_msn_attributes;
2415:
2416: INSERT INTO mtl_serial_numbers_temp
2417: ( TRANSACTION_TEMP_ID
2418: , LAST_UPDATE_DATE
2419: , LAST_UPDATED_BY
2420: , CREATION_DATE

Line 2552: /* INSERT INTO mtl_serial_numbers_temp

2548: , l_msn_attribute_rec.n_attribute10
2549: );
2550: END LOOP; --END for each each serial
2551:
2552: /* INSERT INTO mtl_serial_numbers_temp
2553: (
2554: transaction_temp_id
2555: , last_update_date
2556: , last_updated_by

Line 3443: FROM mtl_serial_numbers_temp msnt

3439: END IF;
3440:
3441: SELECT COUNT(fm_serial_number)
3442: INTO l_serial_exist_cnt
3443: FROM mtl_serial_numbers_temp msnt
3444: WHERE msnt.transaction_temp_id = p_temp_id
3445: AND msnt.fm_serial_number IN(
3446: SELECT serial_number
3447: FROM mtl_serial_numbers

Line 3470: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt

3466: END IF;
3467:
3468: SELECT COUNT(fm_serial_number)
3469: INTO l_total_serial_cnt
3470: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt
3471: WHERE mtlt.transaction_temp_id = p_temp_id
3472: AND msnt.transaction_temp_id = mtlt.serial_transaction_temp_id;
3473:
3474: IF (l_debug = 1) THEN

Line 3776: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt

3772: END IF;
3773:
3774: SELECT COUNT(fm_serial_number)
3775: INTO l_serial_exist_cnt
3776: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt
3777: WHERE mtlt.transaction_temp_id = p_temp_id
3778: AND msnt.transaction_temp_id = mtlt.serial_transaction_temp_id
3779: AND msnt.fm_serial_number IN(
3780: SELECT serial_number

Line 4229: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt

4225: AND(x_match = 1
4226: OR x_match = 3) THEN
4227: SELECT COUNT(fm_serial_number)
4228: INTO l_total_serial_cnt
4229: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt
4230: WHERE mtlt.transaction_temp_id = p_temp_id
4231: AND msnt.transaction_temp_id = mtlt.serial_transaction_temp_id;
4232:
4233: IF (l_debug = 1) THEN

Line 4273: FROM mtl_serial_numbers_temp msnt

4269: END IF;
4270:
4271: SELECT COUNT(fm_serial_number)
4272: INTO l_serial_exist_cnt
4273: FROM mtl_serial_numbers_temp msnt
4274: WHERE msnt.transaction_temp_id = p_temp_id
4275: AND msnt.fm_serial_number IN(
4276: SELECT serial_number
4277: FROM mtl_serial_numbers

Line 4621: FROM mtl_serial_numbers_temp msnt

4617: AND(x_match = 1
4618: OR x_match = 3) THEN
4619: SELECT COUNT(fm_serial_number)
4620: INTO l_total_serial_cnt
4621: FROM mtl_serial_numbers_temp msnt
4622: WHERE msnt.transaction_temp_id = p_temp_id;
4623:
4624: IF (l_debug = 1) THEN
4625: mydebug('lpn_match: SN tot count' || l_total_serial_cnt);

Line 4762: FROM mtl_serial_numbers_temp msnt,

4758: mydebug('lpn_match: l_temp_serial_trans_temp is not null');
4759: END IF;
4760: SELECT 1
4761: INTO l_allocate_serial_flag
4762: FROM mtl_serial_numbers_temp msnt,
4763: mtl_serial_numbers msn
4764: WHERE msnt.transaction_temp_id = l_temp_serial_trans_temp
4765: AND msn.serial_number = msnt.fm_serial_number
4766: AND msn.lpn_id = p_lpn

Line 4777: mtl_serial_numbers_temp msnt,

4773: END IF;
4774: SELECT 1
4775: INTO l_allocate_serial_flag
4776: FROM mtl_material_transactions_temp mmtt,
4777: mtl_serial_numbers_temp msnt,
4778: mtl_serial_numbers msn
4779: WHERE mmtt.transaction_temp_id = p_temp_id
4780: AND mmtt.organization_id = p_org_id
4781: AND mmtt.inventory_item_id = p_item_id

Line 5713: FROM mtl_serial_numbers_temp

5709: SET group_mark_id = NULL
5710: WHERE inventory_item_id = l_item_id
5711: AND current_organization_id = p_org_id
5712: AND serial_number IN(SELECT fm_serial_number
5713: FROM mtl_serial_numbers_temp
5714: WHERE transaction_temp_id IN(SELECT transaction_temp_id
5715: FROM mtl_transaction_lots_temp
5716: WHERE lot_number = l_tabtype(l_counter)
5717: AND transaction_temp_id = p_temp_id));

Line 5719: DELETE FROM mtl_serial_numbers_temp

5715: FROM mtl_transaction_lots_temp
5716: WHERE lot_number = l_tabtype(l_counter)
5717: AND transaction_temp_id = p_temp_id));
5718:
5719: DELETE FROM mtl_serial_numbers_temp
5720: WHERE transaction_temp_id IN(SELECT transaction_temp_id
5721: FROM mtl_transaction_lots_temp
5722: WHERE lot_number = l_tabtype(l_counter)
5723: AND transaction_temp_id = p_temp_id);

Line 5742: FROM mtl_serial_numbers_temp msnt

5738: WHERE msn.inventory_item_id = l_item_id
5739: AND msn.current_organization_id = p_org_id
5740: AND msn.group_mark_id = p_temp_id
5741: AND msn.serial_number IN(SELECT msnt.fm_serial_number
5742: FROM mtl_serial_numbers_temp msnt
5743: WHERE msnt.transaction_temp_id = p_temp_id);
5744:
5745: DELETE FROM mtl_serial_numbers_temp msnt
5746: WHERE msnt.transaction_temp_id = p_temp_id

Line 5745: DELETE FROM mtl_serial_numbers_temp msnt

5741: AND msn.serial_number IN(SELECT msnt.fm_serial_number
5742: FROM mtl_serial_numbers_temp msnt
5743: WHERE msnt.transaction_temp_id = p_temp_id);
5744:
5745: DELETE FROM mtl_serial_numbers_temp msnt
5746: WHERE msnt.transaction_temp_id = p_temp_id
5747: AND msnt.fm_serial_number IN(
5748: SELECT msn.serial_number
5749: FROM mtl_serial_numbers msn

Line 5816: UPDATE mtl_serial_numbers_temp

5812: UPDATE mtl_transaction_lots_temp
5813: SET transaction_temp_id = p_temp_id
5814: WHERE transaction_temp_id = l_mmtt2_txn_temp_id;
5815: ELSIF p_is_serial_control = 'true' THEN
5816: UPDATE mtl_serial_numbers_temp
5817: SET transaction_temp_id = p_temp_id
5818: WHERE transaction_temp_id = l_mmtt2_txn_temp_id;
5819: END IF;
5820:

Line 7513: UPDATE mtl_serial_numbers_temp

7509: LOOP
7510: FETCH lpn_ser_cur INTO l_serial_number;
7511: EXIT WHEN lpn_ser_cur%NOTFOUND;
7512:
7513: UPDATE mtl_serial_numbers_temp
7514: SET transaction_temp_id = l_new_serial_temp_id
7515: WHERE transaction_temp_id = l_lot_serial_temp_id
7516: AND fm_serial_number = l_serial_number
7517: AND to_serial_number = l_serial_number;

Line 7652: INSERT INTO mtl_serial_numbers_temp

7648: LOOP
7649: FETCH lpn_ser_cur INTO l_serial_number;
7650: EXIT WHEN lpn_ser_cur%NOTFOUND;
7651:
7652: INSERT INTO mtl_serial_numbers_temp
7653: (
7654: transaction_temp_id
7655: , last_update_date
7656: , last_updated_by

Line 7709: INSERT INTO mtl_serial_numbers_temp

7705: LOOP
7706: FETCH lpn_ser_cur INTO l_serial_number;
7707: EXIT WHEN lpn_ser_cur%NOTFOUND;
7708:
7709: INSERT INTO mtl_serial_numbers_temp
7710: (
7711: transaction_temp_id
7712: , last_update_date
7713: , last_updated_by

Line 7753: UPDATE mtl_serial_numbers_temp

7749: LOOP
7750: FETCH lpn_ser_cur INTO l_serial_number;
7751: EXIT WHEN lpn_ser_cur%NOTFOUND;
7752:
7753: UPDATE mtl_serial_numbers_temp
7754: SET transaction_temp_id = l_new_temp_id
7755: WHERE transaction_temp_id = p_temp_id
7756: AND fm_serial_number = l_serial_number
7757: AND to_serial_number = l_serial_number;

Line 7773: INSERT INTO mtl_serial_numbers_temp

7769: LOOP
7770: FETCH lpn_ser_cur INTO l_serial_number;
7771: EXIT WHEN lpn_ser_cur%NOTFOUND;
7772:
7773: INSERT INTO mtl_serial_numbers_temp
7774: (
7775: transaction_temp_id
7776: , last_update_date
7777: , last_updated_by

Line 9860: UPDATE mtl_serial_numbers_temp

9856: FROM DUAL;
9857:
9858: l_progress := '310';
9859:
9860: UPDATE mtl_serial_numbers_temp
9861: SET transaction_temp_id = l_new_serial_temp_id
9862: WHERE transaction_temp_id = l_mtlt_rec.serial_transaction_temp_id
9863: AND fm_serial_number = l_fm_serial
9864: AND to_serial_number = l_to_serial;

Line 9933: UPDATE mtl_serial_numbers_temp

9929: END IF;
9930:
9931: l_progress := '380';
9932:
9933: UPDATE mtl_serial_numbers_temp
9934: SET transaction_temp_id = l_new_temp_id
9935: WHERE transaction_temp_id = l_temp_id
9936: AND fm_serial_number = l_fm_serial
9937: AND to_serial_number = l_to_serial;

Line 10123: INSERT INTO mtl_serial_numbers_temp

10119:
10120: l_progress := '460';
10121:
10122: IF p_sn_allocated_flag = 'N' THEN
10123: INSERT INTO mtl_serial_numbers_temp
10124: (
10125: transaction_temp_id
10126: , last_update_date
10127: , last_updated_by

Line 10155: FROM mtl_serial_numbers_temp msnt

10151: SET group_mark_id = l_txn_header_id
10152: WHERE inventory_item_id = l_item_id
10153: AND current_organization_id = p_org_id
10154: AND serial_number IN(SELECT fm_serial_number
10155: FROM mtl_serial_numbers_temp msnt
10156: WHERE msnt.transaction_temp_id = l_new_serial_temp_id);
10157:
10158: --Added bug#4245565.Check if any other MSNT records are there for this serial number.
10159: SELECT count(MSNT.transaction_temp_id)

Line 10161: FROM Mtl_Serial_Numbers_Temp MSNT

10157:
10158: --Added bug#4245565.Check if any other MSNT records are there for this serial number.
10159: SELECT count(MSNT.transaction_temp_id)
10160: INTO l_serial_count
10161: FROM Mtl_Serial_Numbers_Temp MSNT
10162: WHERE MSNT.fm_serial_number = l_fm_serial;
10163:
10164: /*Bug#3957819.IF the serial number is already used , throw an error*/
10165: IF l_serial_count > 1 THEN

Line 10206: INSERT INTO mtl_serial_numbers_temp

10202: l_serial_numeric_to := TO_NUMBER(SUBSTR(l_to_serial, NVL(LENGTH(l_real_serial_prefix), 0) + 1));
10203: l_serial_prefix := (l_serial_numeric_to - l_serial_numeric_frm) + 1;
10204: mydebug('SERIAL_PREFIX IS :' || l_serial_prefix);
10205:
10206: INSERT INTO mtl_serial_numbers_temp
10207: (
10208: transaction_temp_id
10209: , last_update_date
10210: , last_updated_by

Line 10236: FROM mtl_serial_numbers_temp msnt

10232: SET group_mark_id = l_txn_header_id
10233: WHERE inventory_item_id = l_item_id
10234: AND current_organization_id = p_org_id
10235: AND serial_number IN(SELECT fm_serial_number
10236: FROM mtl_serial_numbers_temp msnt
10237: WHERE msnt.transaction_temp_id = l_local_temp_id);
10238:
10239: --Added bug#4245565.Check if any other MSNT records are there for this serial number.
10240: SELECT count(MSNT.transaction_temp_id)

Line 10242: FROM Mtl_Serial_Numbers_Temp MSNT

10238:
10239: --Added bug#4245565.Check if any other MSNT records are there for this serial number.
10240: SELECT count(MSNT.transaction_temp_id)
10241: INTO l_serial_count
10242: FROM Mtl_Serial_Numbers_Temp MSNT
10243: WHERE MSNT.fm_serial_number = l_fm_serial;
10244:
10245:
10246: /*Bug#3957819.IF the serial number is already used , throw an error*/

Line 10308: INSERT INTO mtl_serial_numbers_temp

10304: l_new_serial_temp_id := l_lot_ser_seq;
10305: END IF;
10306:
10307: IF p_sn_allocated_flag = 'N' THEN
10308: INSERT INTO mtl_serial_numbers_temp
10309: (
10310: transaction_temp_id
10311: , last_update_date
10312: , last_updated_by

Line 10336: FROM mtl_serial_numbers_temp

10332: SET group_mark_id = l_txn_header_id
10333: WHERE inventory_item_id = l_item_id
10334: AND current_organization_id = p_org_id
10335: AND serial_number IN(SELECT fm_serial_number
10336: FROM mtl_serial_numbers_temp
10337: WHERE transaction_temp_id = l_new_serial_temp_id);
10338:
10339: --Added bug#4245565.Check if any other MSNT records are there for this serial number.
10340: SELECT count(MSNT.transaction_temp_id)

Line 10342: FROM Mtl_Serial_Numbers_Temp MSNT

10338:
10339: --Added bug#4245565.Check if any other MSNT records are there for this serial number.
10340: SELECT count(MSNT.transaction_temp_id)
10341: INTO l_serial_count
10342: FROM Mtl_Serial_Numbers_Temp MSNT
10343: WHERE MSNT.fm_serial_number = l_fm_serial;
10344:
10345: /*Bug#3957819.IF the serial number is already used , throw an error*/
10346: IF l_serial_count > 1 THEN

Line 10379: INSERT INTO mtl_serial_numbers_temp

10375: l_serial_numeric_to := TO_NUMBER(SUBSTR(l_to_serial, NVL(LENGTH(l_real_serial_prefix), 0) + 1));
10376: l_serial_prefix := (l_serial_numeric_to - l_serial_numeric_frm) + 1;
10377: mydebug('SERIAL_PREFIX IS :' || l_serial_prefix);
10378:
10379: INSERT INTO mtl_serial_numbers_temp
10380: (
10381: transaction_temp_id
10382: , last_update_date
10383: , last_updated_by

Line 10409: FROM mtl_serial_numbers_temp

10405: SET group_mark_id = l_txn_header_id
10406: WHERE inventory_item_id = l_item_id
10407: AND current_organization_id = p_org_id
10408: AND serial_number IN(SELECT fm_serial_number
10409: FROM mtl_serial_numbers_temp
10410: WHERE transaction_temp_id = l_local_temp_id);
10411:
10412: --Added bug#4245565.Check if any other MSNT records are there for this serial number.
10413: SELECT count(MSNT.transaction_temp_id)

Line 10415: FROM Mtl_Serial_Numbers_Temp MSNT

10411:
10412: --Added bug#4245565.Check if any other MSNT records are there for this serial number.
10413: SELECT count(MSNT.transaction_temp_id)
10414: INTO l_serial_count
10415: FROM Mtl_Serial_Numbers_Temp MSNT
10416: WHERE MSNT.fm_serial_number = l_fm_serial;
10417:
10418: /*Bug#3957819.IF the serial number is already used , throw an error*/
10419: IF l_serial_count > 1 THEN

Line 12813: FROM mtl_serial_numbers_temp msnt

12809: CURSOR c_fm_to_serial_number IS
12810: SELECT
12811: msnt.fm_serial_number,
12812: msnt.to_serial_number
12813: FROM mtl_serial_numbers_temp msnt
12814: WHERE msnt.transaction_temp_id = p_pick_slip_id;
12815:
12816: CURSOR c_fm_to_lot_serial_number IS
12817: SELECT

Line 12821: mtl_serial_numbers_temp msnt,

12817: SELECT
12818: msnt.fm_serial_number,
12819: msnt.to_serial_number
12820: FROM
12821: mtl_serial_numbers_temp msnt,
12822: mtl_transaction_lots_temp mtlt
12823: WHERE mtlt.transaction_temp_id = p_pick_slip_id
12824: AND msnt.transaction_temp_id = mtlt.serial_transaction_temp_id;
12825:

Line 12829: l_fm_serial_number MTL_SERIAL_NUMBERS_TEMP.FM_SERIAL_NUMBER%TYPE;

12825:
12826: l_item_id NUMBER := NULL;
12827: l_serial_ctrl_code NUMBER;
12828: l_lot_ctrl_code NUMBER ;
12829: l_fm_serial_number MTL_SERIAL_NUMBERS_TEMP.FM_SERIAL_NUMBER%TYPE;
12830: l_to_serial_number MTL_SERIAL_NUMBERS_TEMP.TO_SERIAL_NUMBER%TYPE;
12831: /*6009436 End */
12832:
12833: BEGIN

Line 12830: l_to_serial_number MTL_SERIAL_NUMBERS_TEMP.TO_SERIAL_NUMBER%TYPE;

12826: l_item_id NUMBER := NULL;
12827: l_serial_ctrl_code NUMBER;
12828: l_lot_ctrl_code NUMBER ;
12829: l_fm_serial_number MTL_SERIAL_NUMBERS_TEMP.FM_SERIAL_NUMBER%TYPE;
12830: l_to_serial_number MTL_SERIAL_NUMBERS_TEMP.TO_SERIAL_NUMBER%TYPE;
12831: /*6009436 End */
12832:
12833: BEGIN
12834: IF (l_debug = 1) THEN

Line 13042: UPDATE mtl_serial_numbers_temp

13038: l_to_serial_number;
13039: END LOOP;
13040: CLOSE c_fm_to_lot_serial_number;
13041:
13042: UPDATE mtl_serial_numbers_temp
13043: SET group_header_id= l_txn_hdr_id
13044: WHERE transaction_temp_id in ( SELECT serial_transaction_temp_id
13045: FROM mtl_transaction_lots_temp
13046: WHERE transaction_temp_id= l_pick_slip_id );

Line 13064: UPDATE mtl_serial_numbers_temp

13060: l_to_serial_number;
13061: END LOOP;
13062: CLOSE c_fm_to_serial_number;
13063:
13064: UPDATE mtl_serial_numbers_temp
13065: SET group_header_id= l_txn_hdr_id
13066: WHERE transaction_temp_id=l_pick_slip_id ;
13067:
13068: END IF;

Line 13434: FROM mtl_serial_numbers_temp msnt

13430: CURSOR c_fm_to_serial_number IS
13431: SELECT
13432: msnt.fm_serial_number,
13433: msnt.to_serial_number
13434: FROM mtl_serial_numbers_temp msnt
13435: WHERE msnt.transaction_temp_id = p_temp_id;
13436:
13437: CURSOR c_fm_to_lot_serial_number IS
13438: SELECT

Line 13442: mtl_serial_numbers_temp msnt,

13438: SELECT
13439: msnt.fm_serial_number,
13440: msnt.to_serial_number
13441: FROM
13442: mtl_serial_numbers_temp msnt,
13443: mtl_transaction_lots_temp mtlt
13444: WHERE mtlt.transaction_temp_id = p_temp_id
13445: AND msnt.transaction_temp_id = mtlt.serial_transaction_temp_id;
13446:

Line 13478: DELETE FROM mtl_serial_numbers_temp msnt

13474:
13475: END LOOP;
13476: CLOSE c_fm_to_lot_serial_number;
13477:
13478: DELETE FROM mtl_serial_numbers_temp msnt
13479: WHERE msnt.transaction_temp_id IN
13480: (SELECT mtlt.serial_transaction_temp_id
13481: FROM mtl_transaction_lots_temp mtlt
13482: WHERE mtlt.transaction_temp_id = p_temp_id);