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_DEVICE_CONFIRMATION_PUB dependencies on MTL_SERIAL_NUMBERS

Line 137: FROM mtl_serial_numbers_temp msnt,

133:
134: IF l_child_rec.serial_number IS NOT NULL THEN
135: SELECT 1 INTO l_serial_cnt FROM dual WHERE exists
136: (SELECT fm_serial_number--What if RANGE serials ??
137: FROM mtl_serial_numbers_temp msnt,
138: mtl_transaction_lots_temp mtlt
139: WHERE mtlt.transaction_temp_id = p_txn_temp_id
140: AND msnt.transaction_temp_id = mtlt.serial_transaction_temp_id
141: AND msnt.fm_serial_number = l_child_rec.serial_number);

Line 166: FROM mtl_serial_numbers_temp msnt

162:
163: IF l_child_rec.serial_number IS NOT NULL THEN
164: SELECT 1 INTO l_serial_cnt FROM dual WHERE exists
165: (SELECT fm_serial_number
166: FROM mtl_serial_numbers_temp msnt
167: WHERE msnt.transaction_temp_id = p_txn_temp_id
168: AND msnt.fm_serial_number = l_child_rec.serial_number);
169:
170: IF (l_serial_cnt = 0) THEN

Line 555: FROM mtl_serial_numbers

551:
552:
553: CURSOR ser_csr IS
554: SELECT serial_number
555: FROM mtl_serial_numbers
556: WHERE lpn_id = p_lpn
557: AND inventory_item_id = p_item_id
558: AND Nvl(lot_number,-999) = Nvl(p_lot,-999);
559:

Line 1251: FROM mtl_serial_numbers_temp msnt

1247: END IF;
1248:
1249: SELECT COUNT(fm_serial_number)
1250: INTO l_serial_exist_cnt
1251: FROM mtl_serial_numbers_temp msnt
1252: WHERE msnt.transaction_temp_id = p_temp_id
1253: AND msnt.fm_serial_number IN
1254: ( SELECT serial_number
1255: FROM mtl_serial_numbers

Line 1255: FROM mtl_serial_numbers

1251: FROM mtl_serial_numbers_temp msnt
1252: WHERE msnt.transaction_temp_id = p_temp_id
1253: AND msnt.fm_serial_number IN
1254: ( SELECT serial_number
1255: FROM mtl_serial_numbers
1256: WHERE lpn_id = p_lpn
1257: AND inventory_item_id = p_item_id
1258: AND Nvl(revision, '-999') = Nvl(p_rev, '-999')
1259: );

Line 1279: FROM mtl_serial_numbers_temp msnt,

1275:
1276:
1277: SELECT COUNT(fm_serial_number)
1278: INTO l_total_serial_cnt
1279: FROM mtl_serial_numbers_temp msnt,
1280: mtl_transaction_lots_temp mtlt
1281: WHERE mtlt.transaction_temp_id = p_temp_id
1282: AND msnt.transaction_temp_id = mtlt.serial_transaction_temp_id;
1283:

Line 1563: mtl_serial_numbers_temp msnt,

1559:
1560: SELECT COUNT(fm_serial_number)
1561: INTO l_serial_exist_cnt
1562: FROM
1563: mtl_serial_numbers_temp msnt,
1564: mtl_transaction_lots_temp mtlt
1565: WHERE mtlt.transaction_temp_id = p_temp_id
1566: AND msnt.transaction_temp_id = mtlt.serial_transaction_temp_id
1567: AND msnt.fm_serial_number IN

Line 1569: FROM mtl_serial_numbers

1565: WHERE mtlt.transaction_temp_id = p_temp_id
1566: AND msnt.transaction_temp_id = mtlt.serial_transaction_temp_id
1567: AND msnt.fm_serial_number IN
1568: ( SELECT serial_number
1569: FROM mtl_serial_numbers
1570: WHERE lpn_id = p_lpn
1571: AND inventory_item_id = p_item_id
1572: AND Nvl(revision, '-999') = Nvl(p_rev, '-999')
1573: );

Line 1954: FROM mtl_serial_numbers_temp msnt,

1950: IF p_is_sn_alloc = 'Y' AND p_action = 4 AND ( x_match = 1 OR x_match = 3 ) THEN
1951:
1952: SELECT COUNT(fm_serial_number)
1953: INTO l_total_serial_cnt
1954: FROM mtl_serial_numbers_temp msnt,
1955: mtl_transaction_lots_temp mtlt
1956: WHERE mtlt.transaction_temp_id = p_temp_id
1957: AND msnt.transaction_temp_id = mtlt.serial_transaction_temp_id;
1958:

Line 2004: FROM mtl_serial_numbers_temp msnt

2000: END IF;
2001:
2002: SELECT COUNT(fm_serial_number)
2003: INTO l_serial_exist_cnt
2004: FROM mtl_serial_numbers_temp msnt
2005: WHERE msnt.transaction_temp_id = p_temp_id
2006: AND msnt.fm_serial_number IN
2007: ( SELECT serial_number
2008: FROM mtl_serial_numbers

Line 2008: FROM mtl_serial_numbers

2004: FROM mtl_serial_numbers_temp msnt
2005: WHERE msnt.transaction_temp_id = p_temp_id
2006: AND msnt.fm_serial_number IN
2007: ( SELECT serial_number
2008: FROM mtl_serial_numbers
2009: WHERE lpn_id = p_lpn
2010: AND inventory_item_id = p_item_id
2011: AND Nvl(revision, '-999') = Nvl(p_rev, '-999')
2012: );

Line 2301: mtl_serial_numbers_temp msnt

2297: COUNT(fm_serial_number)
2298: INTO
2299: l_total_serial_cnt
2300: FROM
2301: mtl_serial_numbers_temp msnt
2302: WHERE msnt.transaction_temp_id=p_temp_id;
2303: IF (l_debug = 1) THEN
2304: trace('lpn_match: SN tot count'||l_total_serial_cnt);
2305: END IF;

Line 2570: FROM mtl_serial_numbers_temp msnt

2566: CURSOR c_fm_to_serial_number(l_txn_temp_id NUMBER) IS
2567: SELECT
2568: msnt.fm_serial_number,
2569: msnt.to_serial_number
2570: FROM mtl_serial_numbers_temp msnt
2571: WHERE msnt.transaction_temp_id = l_txn_temp_id;
2572:
2573: CURSOR c_fm_to_lot_serial_number(l_txn_temp_id NUMBER) IS
2574: SELECT

Line 2578: mtl_serial_numbers_temp msnt,

2574: SELECT
2575: msnt.fm_serial_number,
2576: msnt.to_serial_number
2577: FROM
2578: mtl_serial_numbers_temp msnt,
2579: mtl_transaction_lots_temp mtlt
2580: WHERE mtlt.transaction_temp_id = l_txn_temp_id
2581: AND msnt.transaction_temp_id = mtlt.serial_transaction_temp_id;
2582: */

Line 3454: DELETE FROM mtl_serial_numbers_temp msnt

3450:
3451: -- Lot controlled item
3452: IF (l_serial_code >1 AND l_serial_code<>6) THEN -- Lot and Serial controlled item
3453:
3454: DELETE FROM mtl_serial_numbers_temp msnt
3455: WHERE msnt.transaction_temp_id IN
3456: (SELECT mtlt.serial_transaction_temp_id
3457: FROM mtl_transaction_lots_temp mtlt
3458: WHERE mtlt.transaction_temp_id = l_txn_temp_id);

Line 3466: DELETE FROM mtl_serial_numbers_temp msnt

3462: WHERE mtlt.transaction_temp_id = l_txn_temp_id;
3463:
3464: ELSIF (l_serial_code >1 AND l_serial_code<>6) THEN --Serial controlled item
3465:
3466: DELETE FROM mtl_serial_numbers_temp msnt
3467: WHERE msnt.transaction_temp_id = l_txn_temp_id;
3468:
3469: END IF;
3470:

Line 3529: DELETE FROM mtl_serial_numbers_temp msnt

3525: IF l_lot_code > 1 THEN
3526:
3527: -- Lot controlled item
3528: IF (l_serial_code >1 AND l_serial_code<>6) THEN -- Lot and Serial controlled item
3529: DELETE FROM mtl_serial_numbers_temp msnt
3530: WHERE msnt.transaction_temp_id IN
3531: (SELECT mtlt.serial_transaction_temp_id
3532: FROM mtl_transaction_lots_temp mtlt
3533: WHERE mtlt.transaction_temp_id = l_txn_temp_id);

Line 3541: DELETE FROM mtl_serial_numbers_temp msnt

3537: WHERE mtlt.transaction_temp_id = l_txn_temp_id;
3538:
3539: ELSIF (l_serial_code >1 AND l_serial_code<>6) THEN --Serial controlled item
3540:
3541: DELETE FROM mtl_serial_numbers_temp msnt
3542: WHERE msnt.transaction_temp_id = l_txn_temp_id;
3543:
3544: END IF;
3545:

Line 3605: DELETE FROM mtl_serial_numbers_temp msnt

3601: IF l_lot_code >1 THEN
3602:
3603: IF (l_serial_code >1 AND l_serial_code<>6) THEN
3604:
3605: DELETE FROM mtl_serial_numbers_temp msnt
3606: WHERE transaction_temp_id IN
3607: (SELECT msnt.transaction_temp_id
3608: FROM mtl_transaction_lots_temp mtlt,
3609: mtl_serial_numbers_temp msnt

Line 3609: mtl_serial_numbers_temp msnt

3605: DELETE FROM mtl_serial_numbers_temp msnt
3606: WHERE transaction_temp_id IN
3607: (SELECT msnt.transaction_temp_id
3608: FROM mtl_transaction_lots_temp mtlt,
3609: mtl_serial_numbers_temp msnt
3610: WHERE mtlt.serial_transaction_temp_id = msnt.transaction_temp_id
3611: AND mtlt.transaction_temp_id =l_txn_temp_id)
3612: AND msnt.fm_serial_number NOT IN
3613: (SELECT serial_number FROM wms_device_requests

Line 3662: DELETE FROM mtl_serial_numbers_temp msnt

3658: ELSIF (l_serial_code >1 AND l_serial_code<>6) THEN
3659:
3660: -- Deleting serials which have not been picked
3661:
3662: DELETE FROM mtl_serial_numbers_temp msnt
3663: WHERE msnt.transaction_temp_id = l_txn_temp_id
3664: AND msnt.fm_serial_number NOT IN
3665: ( SELECT wdr.serial_number FROM
3666: wms_device_requests wdr