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: -- Bug 14261335

Line 10162: FROM mtl_serial_numbers_temp msnt,

10158: --Added bug#4245565.Check if any other MSNT records are there for this serial number.
10159: -- Bug 14261335
10160: SELECT COUNT(msnt.transaction_temp_id)
10161: INTO l_serial_count
10162: FROM mtl_serial_numbers_temp msnt,
10163: mtl_material_transactions_temp mmtt,
10164: mtl_transaction_lots_temp mtlt
10165: WHERE mmtt.transaction_temp_id = mtlt.transaction_temp_id
10166: AND msnt.transaction_temp_id = mtlt.serial_transaction_temp_id

Line 10214: INSERT INTO mtl_serial_numbers_temp

10210: l_serial_numeric_to := TO_NUMBER(SUBSTR(l_to_serial, NVL(LENGTH(l_real_serial_prefix), 0) + 1));
10211: l_serial_prefix := (l_serial_numeric_to - l_serial_numeric_frm) + 1;
10212: mydebug('SERIAL_PREFIX IS :' || l_serial_prefix);
10213:
10214: INSERT INTO mtl_serial_numbers_temp
10215: (
10216: transaction_temp_id
10217: , last_update_date
10218: , last_updated_by

Line 10244: FROM mtl_serial_numbers_temp msnt

10240: SET group_mark_id = l_txn_header_id
10241: WHERE inventory_item_id = l_item_id
10242: AND current_organization_id = p_org_id
10243: AND serial_number IN(SELECT fm_serial_number
10244: FROM mtl_serial_numbers_temp msnt
10245: WHERE msnt.transaction_temp_id = l_local_temp_id);
10246:
10247: --Added bug#4245565.Check if any other MSNT records are there for this serial number.
10248: -- Bug 14261335

Line 10251: FROM mtl_serial_numbers_temp msnt,

10247: --Added bug#4245565.Check if any other MSNT records are there for this serial number.
10248: -- Bug 14261335
10249: SELECT COUNT(msnt.transaction_temp_id)
10250: INTO l_serial_count
10251: FROM mtl_serial_numbers_temp msnt,
10252: mtl_material_transactions_temp mmtt
10253: WHERE mmtt.transaction_temp_id = msnt.transaction_temp_id
10254: AND mmtt.inventory_item_id = l_item_id
10255: AND mmtt.organization_id = p_org_id

Line 10321: INSERT INTO mtl_serial_numbers_temp

10317: l_new_serial_temp_id := l_lot_ser_seq;
10318: END IF;
10319:
10320: IF p_sn_allocated_flag = 'N' THEN
10321: INSERT INTO mtl_serial_numbers_temp
10322: (
10323: transaction_temp_id
10324: , last_update_date
10325: , last_updated_by

Line 10349: FROM mtl_serial_numbers_temp

10345: SET group_mark_id = l_txn_header_id
10346: WHERE inventory_item_id = l_item_id
10347: AND current_organization_id = p_org_id
10348: AND serial_number IN(SELECT fm_serial_number
10349: FROM mtl_serial_numbers_temp
10350: WHERE transaction_temp_id = l_new_serial_temp_id);
10351:
10352: --Added bug#4245565.Check if any other MSNT records are there for this serial number.
10353: -- Bug 14261335

Line 10356: FROM mtl_serial_numbers_temp msnt,

10352: --Added bug#4245565.Check if any other MSNT records are there for this serial number.
10353: -- Bug 14261335
10354: SELECT COUNT(msnt.transaction_temp_id)
10355: INTO l_serial_count
10356: FROM mtl_serial_numbers_temp msnt,
10357: mtl_material_transactions_temp mmtt,
10358: mtl_transaction_lots_temp mtlt
10359: WHERE mmtt.transaction_temp_id = mtlt.transaction_temp_id
10360: AND msnt.transaction_temp_id = mtlt.serial_transaction_temp_id

Line 10400: INSERT INTO mtl_serial_numbers_temp

10396: l_serial_numeric_to := TO_NUMBER(SUBSTR(l_to_serial, NVL(LENGTH(l_real_serial_prefix), 0) + 1));
10397: l_serial_prefix := (l_serial_numeric_to - l_serial_numeric_frm) + 1;
10398: mydebug('SERIAL_PREFIX IS :' || l_serial_prefix);
10399:
10400: INSERT INTO mtl_serial_numbers_temp
10401: (
10402: transaction_temp_id
10403: , last_update_date
10404: , last_updated_by

Line 10430: FROM mtl_serial_numbers_temp

10426: SET group_mark_id = l_txn_header_id
10427: WHERE inventory_item_id = l_item_id
10428: AND current_organization_id = p_org_id
10429: AND serial_number IN(SELECT fm_serial_number
10430: FROM mtl_serial_numbers_temp
10431: WHERE transaction_temp_id = l_local_temp_id);
10432:
10433: --Added bug#4245565.Check if any other MSNT records are there for this serial number.
10434: -- Bug 14261335

Line 10437: FROM mtl_serial_numbers_temp msnt,

10433: --Added bug#4245565.Check if any other MSNT records are there for this serial number.
10434: -- Bug 14261335
10435: SELECT COUNT(msnt.transaction_temp_id)
10436: INTO l_serial_count
10437: FROM mtl_serial_numbers_temp msnt,
10438: mtl_material_transactions_temp mmtt
10439: WHERE mmtt.transaction_temp_id = msnt.transaction_temp_id
10440: AND mmtt.inventory_item_id = l_item_id
10441: AND mmtt.organization_id = p_org_id

Line 13065: FROM mtl_serial_numbers_temp msnt

13061: CURSOR c_fm_to_serial_number IS
13062: SELECT
13063: msnt.fm_serial_number,
13064: msnt.to_serial_number
13065: FROM mtl_serial_numbers_temp msnt
13066: WHERE msnt.transaction_temp_id = p_pick_slip_id;
13067:
13068: CURSOR c_fm_to_lot_serial_number IS
13069: SELECT

Line 13073: mtl_serial_numbers_temp msnt,

13069: SELECT
13070: msnt.fm_serial_number,
13071: msnt.to_serial_number
13072: FROM
13073: mtl_serial_numbers_temp msnt,
13074: mtl_transaction_lots_temp mtlt
13075: WHERE mtlt.transaction_temp_id = p_pick_slip_id
13076: AND msnt.transaction_temp_id = mtlt.serial_transaction_temp_id;
13077:

Line 13081: l_fm_serial_number MTL_SERIAL_NUMBERS_TEMP.FM_SERIAL_NUMBER%TYPE;

13077:
13078: l_item_id NUMBER := NULL;
13079: l_serial_ctrl_code NUMBER;
13080: l_lot_ctrl_code NUMBER ;
13081: l_fm_serial_number MTL_SERIAL_NUMBERS_TEMP.FM_SERIAL_NUMBER%TYPE;
13082: l_to_serial_number MTL_SERIAL_NUMBERS_TEMP.TO_SERIAL_NUMBER%TYPE;
13083: /*6009436 End */
13084:
13085: BEGIN

Line 13082: l_to_serial_number MTL_SERIAL_NUMBERS_TEMP.TO_SERIAL_NUMBER%TYPE;

13078: l_item_id NUMBER := NULL;
13079: l_serial_ctrl_code NUMBER;
13080: l_lot_ctrl_code NUMBER ;
13081: l_fm_serial_number MTL_SERIAL_NUMBERS_TEMP.FM_SERIAL_NUMBER%TYPE;
13082: l_to_serial_number MTL_SERIAL_NUMBERS_TEMP.TO_SERIAL_NUMBER%TYPE;
13083: /*6009436 End */
13084:
13085: BEGIN
13086: IF (l_debug = 1) THEN

Line 13294: UPDATE mtl_serial_numbers_temp

13290: l_to_serial_number;
13291: END LOOP;
13292: CLOSE c_fm_to_lot_serial_number;
13293:
13294: UPDATE mtl_serial_numbers_temp
13295: SET group_header_id= l_txn_hdr_id
13296: WHERE transaction_temp_id in ( SELECT serial_transaction_temp_id
13297: FROM mtl_transaction_lots_temp
13298: WHERE transaction_temp_id= l_pick_slip_id );

Line 13316: UPDATE mtl_serial_numbers_temp

13312: l_to_serial_number;
13313: END LOOP;
13314: CLOSE c_fm_to_serial_number;
13315:
13316: UPDATE mtl_serial_numbers_temp
13317: SET group_header_id= l_txn_hdr_id
13318: WHERE transaction_temp_id=l_pick_slip_id ;
13319:
13320: END IF;

Line 13687: FROM mtl_serial_numbers_temp msnt

13683: CURSOR c_fm_to_serial_number IS
13684: SELECT
13685: msnt.fm_serial_number,
13686: msnt.to_serial_number
13687: FROM mtl_serial_numbers_temp msnt
13688: WHERE msnt.transaction_temp_id = p_temp_id;
13689:
13690: CURSOR c_fm_to_lot_serial_number IS
13691: SELECT

Line 13695: mtl_serial_numbers_temp msnt,

13691: SELECT
13692: msnt.fm_serial_number,
13693: msnt.to_serial_number
13694: FROM
13695: mtl_serial_numbers_temp msnt,
13696: mtl_transaction_lots_temp mtlt
13697: WHERE mtlt.transaction_temp_id = p_temp_id
13698: AND msnt.transaction_temp_id = mtlt.serial_transaction_temp_id;
13699:

Line 13731: DELETE FROM mtl_serial_numbers_temp msnt

13727:
13728: END LOOP;
13729: CLOSE c_fm_to_lot_serial_number;
13730:
13731: DELETE FROM mtl_serial_numbers_temp msnt
13732: WHERE msnt.transaction_temp_id IN
13733: (SELECT mtlt.serial_transaction_temp_id
13734: FROM mtl_transaction_lots_temp mtlt
13735: WHERE mtlt.transaction_temp_id = p_temp_id);