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_TEMP

Line 138: FROM mtl_serial_numbers_temp msnt,

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

Line 167: FROM mtl_serial_numbers_temp msnt

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

Line 1771: FROM mtl_serial_numbers_temp msnt

1767: END IF;
1768:
1769: SELECT COUNT(fm_serial_number)
1770: INTO l_serial_exist_cnt
1771: FROM mtl_serial_numbers_temp msnt
1772: WHERE msnt.transaction_temp_id = p_temp_id
1773: AND msnt.fm_serial_number IN
1774: ( SELECT serial_number
1775: FROM mtl_serial_numbers

Line 1799: FROM mtl_serial_numbers_temp msnt,

1795:
1796:
1797: SELECT COUNT(fm_serial_number)
1798: INTO l_total_serial_cnt
1799: FROM mtl_serial_numbers_temp msnt,
1800: mtl_transaction_lots_temp mtlt
1801: WHERE mtlt.transaction_temp_id = p_temp_id
1802: AND msnt.transaction_temp_id = mtlt.serial_transaction_temp_id;
1803:

Line 2083: mtl_serial_numbers_temp msnt,

2079:
2080: SELECT COUNT(fm_serial_number)
2081: INTO l_serial_exist_cnt
2082: FROM
2083: mtl_serial_numbers_temp msnt,
2084: mtl_transaction_lots_temp mtlt
2085: WHERE mtlt.transaction_temp_id = p_temp_id
2086: AND msnt.transaction_temp_id = mtlt.serial_transaction_temp_id
2087: AND msnt.fm_serial_number IN

Line 2474: FROM mtl_serial_numbers_temp msnt,

2470: IF p_is_sn_alloc = 'Y' AND p_action = 4 AND ( x_match = 1 OR x_match = 3 ) THEN
2471:
2472: SELECT COUNT(fm_serial_number)
2473: INTO l_total_serial_cnt
2474: FROM mtl_serial_numbers_temp msnt,
2475: mtl_transaction_lots_temp mtlt
2476: WHERE mtlt.transaction_temp_id = p_temp_id
2477: AND msnt.transaction_temp_id = mtlt.serial_transaction_temp_id;
2478:

Line 2524: FROM mtl_serial_numbers_temp msnt

2520: END IF;
2521:
2522: SELECT COUNT(fm_serial_number)
2523: INTO l_serial_exist_cnt
2524: FROM mtl_serial_numbers_temp msnt
2525: WHERE msnt.transaction_temp_id = p_temp_id
2526: AND msnt.fm_serial_number IN
2527: ( SELECT serial_number
2528: FROM mtl_serial_numbers

Line 2821: mtl_serial_numbers_temp msnt

2817: COUNT(fm_serial_number)
2818: INTO
2819: l_total_serial_cnt
2820: FROM
2821: mtl_serial_numbers_temp msnt
2822: WHERE msnt.transaction_temp_id=p_temp_id;
2823: IF (l_debug = 1) THEN
2824: trace('lpn_match: SN tot count'||l_total_serial_cnt);
2825: END IF;

Line 3096: FROM mtl_serial_numbers_temp msnt

3092: CURSOR c_fm_to_serial_number(l_txn_temp_id NUMBER) IS
3093: SELECT
3094: msnt.fm_serial_number,
3095: msnt.to_serial_number
3096: FROM mtl_serial_numbers_temp msnt
3097: WHERE msnt.transaction_temp_id = l_txn_temp_id;
3098:
3099: CURSOR c_fm_to_lot_serial_number(l_txn_temp_id NUMBER) IS
3100: SELECT

Line 3104: mtl_serial_numbers_temp msnt,

3100: SELECT
3101: msnt.fm_serial_number,
3102: msnt.to_serial_number
3103: FROM
3104: mtl_serial_numbers_temp msnt,
3105: mtl_transaction_lots_temp mtlt
3106: WHERE mtlt.transaction_temp_id = l_txn_temp_id
3107: AND msnt.transaction_temp_id = mtlt.serial_transaction_temp_id;
3108: */

Line 4053: DELETE FROM mtl_serial_numbers_temp msnt

4049:
4050: -- Lot controlled item
4051: IF (l_serial_code >1 AND l_serial_code<>6) THEN -- Lot and Serial controlled item
4052:
4053: DELETE FROM mtl_serial_numbers_temp msnt
4054: WHERE msnt.transaction_temp_id IN
4055: (SELECT mtlt.serial_transaction_temp_id
4056: FROM mtl_transaction_lots_temp mtlt
4057: WHERE mtlt.transaction_temp_id = l_txn_temp_id);

Line 4065: DELETE FROM mtl_serial_numbers_temp msnt

4061: WHERE mtlt.transaction_temp_id = l_txn_temp_id;
4062:
4063: ELSIF (l_serial_code >1 AND l_serial_code<>6) THEN --Serial controlled item
4064:
4065: DELETE FROM mtl_serial_numbers_temp msnt
4066: WHERE msnt.transaction_temp_id = l_txn_temp_id;
4067:
4068: END IF;
4069:

Line 4135: DELETE FROM mtl_serial_numbers_temp msnt

4131: IF l_lot_code > 1 THEN
4132:
4133: -- Lot controlled item
4134: IF (l_serial_code >1 AND l_serial_code<>6) THEN -- Lot and Serial controlled item
4135: DELETE FROM mtl_serial_numbers_temp msnt
4136: WHERE msnt.transaction_temp_id IN
4137: (SELECT mtlt.serial_transaction_temp_id
4138: FROM mtl_transaction_lots_temp mtlt
4139: WHERE mtlt.transaction_temp_id = l_txn_temp_id);

Line 4147: DELETE FROM mtl_serial_numbers_temp msnt

4143: WHERE mtlt.transaction_temp_id = l_txn_temp_id;
4144:
4145: ELSIF (l_serial_code >1 AND l_serial_code<>6) THEN --Serial controlled item
4146:
4147: DELETE FROM mtl_serial_numbers_temp msnt
4148: WHERE msnt.transaction_temp_id = l_txn_temp_id;
4149:
4150: END IF;
4151:

Line 4211: DELETE FROM mtl_serial_numbers_temp msnt

4207: IF l_lot_code >1 THEN
4208:
4209: IF (l_serial_code >1 AND l_serial_code<>6) THEN
4210:
4211: DELETE FROM mtl_serial_numbers_temp msnt
4212: WHERE transaction_temp_id IN
4213: (SELECT msnt.transaction_temp_id
4214: FROM mtl_transaction_lots_temp mtlt,
4215: mtl_serial_numbers_temp msnt

Line 4215: mtl_serial_numbers_temp msnt

4211: DELETE FROM mtl_serial_numbers_temp msnt
4212: WHERE transaction_temp_id IN
4213: (SELECT msnt.transaction_temp_id
4214: FROM mtl_transaction_lots_temp mtlt,
4215: mtl_serial_numbers_temp msnt
4216: WHERE mtlt.serial_transaction_temp_id = msnt.transaction_temp_id
4217: AND mtlt.transaction_temp_id =l_txn_temp_id)
4218: AND msnt.fm_serial_number NOT IN
4219: (SELECT serial_number FROM wms_device_requests

Line 4280: DELETE FROM mtl_serial_numbers_temp msnt

4276: ELSIF (l_serial_code >1 AND l_serial_code<>6) THEN
4277:
4278: -- Deleting serials which have not been picked
4279:
4280: DELETE FROM mtl_serial_numbers_temp msnt
4281: WHERE msnt.transaction_temp_id = l_txn_temp_id
4282: AND msnt.fm_serial_number NOT IN
4283: ( SELECT wdr.serial_number FROM
4284: wms_device_requests wdr