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_TRANSACTION_LOTS_TEMP

Line 1578: FROM mtl_transaction_lots_temp mtlt

1574:
1575: CURSOR mtlt_csr IS
1576: SELECT mtlt.lot_number
1577: , mtlt.transaction_quantity
1578: FROM mtl_transaction_lots_temp mtlt
1579: WHERE mtlt.transaction_temp_id = p_temp_id;
1580:
1581: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1582: BEGIN

Line 2155: UPDATE mtl_transaction_lots_temp

2151: IF (l_debug = 1) THEN
2152: mydebug('process_lot_serial: Inserting Lots');
2153: END IF;
2154:
2155: UPDATE mtl_transaction_lots_temp
2156: SET transaction_quantity = l_qty
2157: , primary_quantity = l_pr_qty
2158: , last_update_date = SYSDATE
2159: , last_updated_by = l_user_id

Line 2172: FROM mtl_transaction_lots_temp

2168: -- Get sequence for serial tran id
2169:
2170: SELECT NVL(serial_transaction_temp_id, 0)
2171: INTO l_lot_ser_seq
2172: FROM mtl_transaction_lots_temp
2173: WHERE transaction_temp_id = l_temp_id
2174: AND lot_number = l_lot;
2175:
2176: IF l_lot_ser_seq = 0 THEN

Line 2185: UPDATE mtl_transaction_lots_temp

2181: l_ser_seq := l_lot_ser_seq;
2182: END IF;
2183:
2184: --mydebug('process_lot_serial: Inserting Lots and.....');
2185: UPDATE mtl_transaction_lots_temp
2186: SET transaction_quantity = l_qty
2187: , primary_quantity = l_pr_qty
2188: , serial_transaction_temp_id = l_ser_seq
2189: , last_update_date = SYSDATE

Line 2733: FROM mtl_transaction_lots_temp mtlt

2729:
2730: CURSOR lot_csr IS
2731: SELECT mtlt.primary_quantity
2732: , mtlt.lot_number
2733: FROM mtl_transaction_lots_temp mtlt
2734: WHERE mtlt.transaction_temp_id = p_temp_id;
2735:
2736: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2737: BEGIN

Line 3007: FROM wms_lpn_contents wlc, mtl_transaction_lots_temp mtlt

3003: INTO l_item_cnt
3004: FROM DUAL
3005: WHERE EXISTS(
3006: SELECT 1
3007: FROM wms_lpn_contents wlc, mtl_transaction_lots_temp mtlt
3008: WHERE wlc.parent_lpn_id = p_lpn
3009: AND wlc.organization_id = p_org_id
3010: AND wlc.inventory_item_id = p_item_id
3011: AND NVL(wlc.revision, '-999') = NVL(p_rev, '-999')

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 5715: FROM mtl_transaction_lots_temp

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));
5718:
5719: DELETE FROM mtl_serial_numbers_temp

Line 5721: FROM mtl_transaction_lots_temp

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);
5724: END IF;
5725:

Line 5726: DELETE FROM mtl_transaction_lots_temp

5722: WHERE lot_number = l_tabtype(l_counter)
5723: AND transaction_temp_id = p_temp_id);
5724: END IF;
5725:
5726: DELETE FROM mtl_transaction_lots_temp
5727: WHERE lot_number = l_tabtype(l_counter)
5728: AND transaction_temp_id = p_temp_id;
5729: END LOOP;
5730: END IF;

Line 5812: UPDATE mtl_transaction_lots_temp

5808: , primary_quantity = primary_quantity + l_mmtt2_primary_qty
5809: WHERE transaction_temp_id = p_temp_id;
5810:
5811: IF p_is_lot_control = 'true' THEN
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

Line 6874: FROM mtl_transaction_lots_temp

6870: WHERE parent_lpn_id = p_lpn_id;
6871:
6872: CURSOR mtlt_lot_cur(v_lot_number VARCHAR2) IS
6873: SELECT *
6874: FROM mtl_transaction_lots_temp
6875: WHERE transaction_temp_id = p_temp_id
6876: AND lot_number = v_lot_number;
6877:
6878: -- Increased lot size to 80 Char - Mercy Thomas - B4625329

Line 6884: l_mtlt_rec mtl_transaction_lots_temp%ROWTYPE;

6880: l_lpn_lot_qty NUMBER;
6881: l_lpn_lot_primary_qty NUMBER;
6882: l_lpn_uom_code VARCHAR2(3);
6883: l_lot_primary_qty NUMBER;
6884: l_mtlt_rec mtl_transaction_lots_temp%ROWTYPE;
6885: l_allocate_serial_flag NUMBER := 0;
6886: l_new_serial_temp_id NUMBER;
6887: l_lot_serial_temp_id NUMBER;
6888: l_temp_lpn_id NUMBER;

Line 7524: UPDATE mtl_transaction_lots_temp

7520: CLOSE lpn_ser_cur;
7521:
7522: -- also update the original mtlt record with remaining qty
7523:
7524: UPDATE mtl_transaction_lots_temp
7525: SET primary_quantity = primary_quantity - l_mtlt_rec.primary_quantity
7526: , transaction_quantity = transaction_quantity - l_mtlt_rec.transaction_quantity
7527: WHERE transaction_temp_id = p_temp_id
7528: AND lot_number = l_lpn_lot_number;

Line 7535: UPDATE mtl_transaction_lots_temp

7531: mydebug('multiple_lpn_pick: link original mtlt to new mmtt');
7532: END IF;
7533:
7534: -- link the original mtlt to new mmtt
7535: UPDATE mtl_transaction_lots_temp
7536: SET transaction_temp_id = l_new_temp_id
7537: WHERE transaction_temp_id = p_temp_id
7538: AND lot_number = l_lpn_lot_number;
7539: END IF;

Line 7632: UPDATE mtl_transaction_lots_temp

7628: IF (l_debug = 1) THEN
7629: mydebug('multiple_lpn_pick: PriMQty' || l_mtlt_rec.primary_quantity);
7630: END IF;
7631:
7632: UPDATE mtl_transaction_lots_temp
7633: SET primary_quantity = primary_quantity - l_mtlt_rec.primary_quantity
7634: , transaction_quantity = transaction_quantity - l_mtlt_rec.transaction_quantity
7635: WHERE transaction_temp_id = p_temp_id
7636: AND lot_number = l_lpn_lot_number;

Line 7690: UPDATE mtl_transaction_lots_temp

7686: l_new_serial_temp_id := NULL;
7687: END IF;
7688:
7689: -- link the original mtlt to new mmtt
7690: UPDATE mtl_transaction_lots_temp
7691: SET transaction_temp_id = l_new_temp_id
7692: , serial_transaction_temp_id = NVL(l_new_serial_temp_id, serial_transaction_temp_id)
7693: WHERE transaction_temp_id = p_temp_id
7694: AND lot_number = l_lpn_lot_number;

Line 8883: l_mtlt_rec mtl_transaction_lots_temp%ROWTYPE;

8879: l_to_serial_number inv_reservation_global.serial_number_tbl_type;
8880: l_mtl_reservation_tbl_count NUMBER;
8881: l_error_code NUMBER;
8882: l_pick_qty_remaining NUMBER;
8883: l_mtlt_rec mtl_transaction_lots_temp%ROWTYPE;
8884: l_local_temp_id NUMBER;
8885: l_orig_txn_qty NUMBER;
8886: l_orig_primary_qty NUMBER;
8887: l_content_parent_lpn_id NUMBER;

Line 9840: FROM mtl_transaction_lots_temp

9836: END IF;
9837:
9838: SELECT *
9839: INTO l_mtlt_rec
9840: FROM mtl_transaction_lots_temp
9841: WHERE transaction_temp_id = l_temp_id
9842: AND lot_number = p_lot;
9843:
9844: l_progress := '300';

Line 9900: UPDATE mtl_transaction_lots_temp

9896: -- Insert new line into MTLT
9897: inv_rcv_common_apis.insert_mtlt(l_mtlt_rec);
9898: l_progress := '350';
9899:
9900: UPDATE mtl_transaction_lots_temp
9901: SET primary_quantity = primary_quantity - l_mtlt_rec.primary_quantity
9902: , transaction_quantity = transaction_quantity - l_mtlt_rec.transaction_quantity
9903: , last_update_date = SYSDATE
9904: , last_updated_by = l_user_id

Line 9916: DELETE FROM mtl_transaction_lots_temp

9912: END IF;
9913:
9914: --Cleaning original MTLT if txn qty is zero
9915:
9916: DELETE FROM mtl_transaction_lots_temp
9917: WHERE transaction_quantity = 0
9918: AND lot_number = p_lot
9919: AND transaction_temp_id = p_temp_id;
9920:

Line 10106: FROM mtl_transaction_lots_temp

10102: IF (l_serial_code > 1
10103: AND l_serial_code <> 6) THEN
10104: SELECT NVL(serial_transaction_temp_id, 0)
10105: INTO l_lot_ser_seq
10106: FROM mtl_transaction_lots_temp
10107: WHERE transaction_temp_id = l_local_temp_id
10108: AND lot_number = l_lot;
10109:
10110: l_progress := '450';

Line 10164: mtl_transaction_lots_temp mtlt

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
10167: AND mmtt.inventory_item_id = l_item_id
10168: AND mmtt.organization_id = p_org_id

Line 10186: UPDATE mtl_transaction_lots_temp

10182:
10183: l_progress := '490';
10184:
10185: BEGIN
10186: UPDATE mtl_transaction_lots_temp
10187: SET transaction_quantity = l_qty
10188: , primary_quantity = l_pr_qty
10189: , serial_transaction_temp_id = l_new_serial_temp_id
10190: , last_update_date = SYSDATE

Line 10306: FROM mtl_transaction_lots_temp

10302: IF (l_serial_code > 1
10303: AND l_serial_code <> 6) THEN
10304: SELECT NVL(serial_transaction_temp_id, 0)
10305: INTO l_lot_ser_seq
10306: FROM mtl_transaction_lots_temp
10307: WHERE transaction_temp_id = l_local_temp_id
10308: AND lot_number = l_lot;
10309:
10310: l_progress := '560';

Line 10358: mtl_transaction_lots_temp mtlt

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
10361: AND mmtt.inventory_item_id = l_item_id
10362: AND mmtt.organization_id = p_org_id

Line 10377: UPDATE mtl_transaction_lots_temp

10373:
10374: l_progress := '580';
10375: END IF;
10376:
10377: UPDATE mtl_transaction_lots_temp
10378: SET transaction_quantity = l_qty
10379: , primary_quantity = l_pr_qty
10380: , serial_transaction_temp_id = l_new_serial_temp_id
10381: , last_update_date = SYSDATE

Line 13074: mtl_transaction_lots_temp mtlt

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:
13078: l_item_id NUMBER := NULL;

Line 13297: FROM mtl_transaction_lots_temp

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 );
13299: ELSE --Non-Lot item
13300:
13301: OPEN c_fm_to_serial_number;

Line 13696: mtl_transaction_lots_temp mtlt

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:
13700: BEGIN

Line 13734: FROM mtl_transaction_lots_temp mtlt

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);
13736:
13737: END IF;
13738:

Line 13739: DELETE FROM mtl_transaction_lots_temp mtlt

13735: WHERE mtlt.transaction_temp_id = p_temp_id);
13736:
13737: END IF;
13738:
13739: DELETE FROM mtl_transaction_lots_temp mtlt
13740: WHERE mtlt.transaction_temp_id = p_temp_id;
13741:
13742: END IF;
13743:

Line 14199: FROM mtl_lot_numbers_all_v mln, mtl_transaction_lots_temp mtlt

14195: IF (p_lpn_id IS NULL
14196: OR p_lpn_id = 0) THEN
14197: SELECT COUNT(*)
14198: INTO x_lot_num_lov_count
14199: FROM mtl_lot_numbers_all_v mln, mtl_transaction_lots_temp mtlt
14200: WHERE mln.organization_id = p_organization_id
14201: AND mln.inventory_item_id = p_item_id
14202: AND mln.lot_number LIKE(p_lot_number || '%')
14203: AND mtlt.lot_number = mln.lot_number

Line 14223: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers_all_v mln, mtl_transaction_lots_temp mtlt, wms_lpn_contents wlc

14219: ELSE
14220: -- It however remains same for LPNs
14221: SELECT COUNT(*)
14222: INTO x_lot_num_lov_count
14223: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers_all_v mln, mtl_transaction_lots_temp mtlt, wms_lpn_contents wlc
14224: WHERE mln.organization_id = p_organization_id
14225: AND mln.inventory_item_id = p_item_id
14226: AND mln.lot_number LIKE(p_lot_number || '%')
14227: AND moq.lot_number = mln.lot_number

Line 14261: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers_all_v mln, mtl_transaction_lots_temp mtlt

14257: IF (p_lpn_id IS NULL
14258: OR p_lpn_id = 0) THEN
14259: SELECT COUNT(*)
14260: INTO x_lot_num_lov_count
14261: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers_all_v mln, mtl_transaction_lots_temp mtlt
14262: WHERE mln.organization_id = p_organization_id
14263: AND mln.inventory_item_id = p_item_id
14264: AND mln.lot_number LIKE(p_lot_number || '%')
14265: AND moq.lot_number = mln.lot_number

Line 14290: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers_all_v mln, mtl_transaction_lots_temp mtlt, wms_lpn_contents wlc

14286: ) = 'Y';
14287: ELSE
14288: SELECT COUNT(*)
14289: INTO x_lot_num_lov_count
14290: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers_all_v mln, mtl_transaction_lots_temp mtlt, wms_lpn_contents wlc
14291: WHERE mln.organization_id = p_organization_id
14292: AND mln.inventory_item_id = p_item_id
14293: AND mln.lot_number LIKE(p_lot_number || '%')
14294: AND moq.lot_number = mln.lot_number

Line 15562: mtl_transaction_lots_temp mtlt

15558: null,
15559: mtlt.lot_number
15560: INTO l_sub,l_loc,l_rev,l_lpn,l_ser,l_lot
15561: from mtl_material_Transactions_temp mmtt,
15562: mtl_transaction_lots_temp mtlt
15563: where mmtt.inventory_item_id = p_inventory_item_id
15564: and mmtt.organization_id = p_organization_id
15565: and mmtt.transfer_lpn_id = p_transfer_lpn_id
15566: and mmtt.content_lpn_id is null