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_PICKING_PKG dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 319: from mtl_transaction_lots_temp

315: ) IS
316:
317: cursor c_lot_csr(p_temp_id NUMBER) is
318: select lot_number
319: from mtl_transaction_lots_temp
320: where transaction_temp_id = p_temp_id;
321:
322: cursor c_same_lot_csr(p_temp_id NUMBER, p_lot VARCHAR2) is
323: select primary_quantity, transaction_quantity, serial_transaction_temp_id

Line 324: from mtl_transaction_lots_temp

320: where transaction_temp_id = p_temp_id;
321:
322: cursor c_same_lot_csr(p_temp_id NUMBER, p_lot VARCHAR2) is
323: select primary_quantity, transaction_quantity, serial_transaction_temp_id
324: from mtl_transaction_lots_temp
325: where transaction_temp_id = p_temp_id
326: and lot_number = p_lot;
327:
328: --OVPK Start 1

Line 365: l_mtlt_rec mtl_transaction_lots_temp%ROWTYPE;

361: l_same_lot_pri_qty NUMBER;
362: l_same_lot_tra_qty NUMBER;
363: l_sum_same_lot_pri_qty NUMBER;
364: l_sum_same_lot_tra_qty NUMBER;
365: l_mtlt_rec mtl_transaction_lots_temp%ROWTYPE;
366: l_lot VARCHAR2(2000); --Bug 6148865
367: l_old_lot VARCHAR2(2000); --Bug 6148865
368: l_new_serial_temp_id NUMBER;
369: l_delivery_id NUMBER;

Line 397: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt

393: l_to_serial_number VARCHAR2(30);
394: --
395: CURSOR c_get_serialLots(p_transaction_temp_id NUMBER) IS
396: SELECT msnt.fm_serial_number, msnt.to_serial_number
397: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt
398: WHERE msnt.transaction_temp_id = mtlt.serial_transaction_temp_id
399: AND mtlt.transaction_temp_id = p_transaction_temp_id;
400: -- End Bug 4434111
401: BEGIN

Line 657: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt, mtl_material_transactions_temp mmtt

653: ELSE -- lot controlled
654: --Bug 9473783 Modified the where clause
655: SELECT msnt.transaction_temp_id
656: INTO l_serial_temp_id
657: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt, mtl_material_transactions_temp mmtt
658: WHERE ((msnt.transaction_temp_id = NVL(mtlt.serial_transaction_temp_id, -1)
659: AND mtlt.transaction_temp_id = l_transaction_temp_id)
660: OR (msnt.transaction_temp_id = l_transaction_temp_id
661: AND mmtt.transaction_temp_id = l_transaction_temp_id AND mmtt.lot_number IS NOT NULL ))

Line 761: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt

757: DELETE FROM mtl_serial_numbers_temp
758: WHERE transaction_temp_id IN
759: (
760: SELECT serial_transaction_temp_id
761: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt
762: WHERE msnt.transaction_temp_id = mtlt.serial_transaction_temp_id
763: AND mtlt.transaction_temp_id = l_transaction_temp_id
764: );
765: --

Line 796: from mtl_transaction_lots_temp

792: if l_lot <> nvl(l_old_lot, '-999') then
793: begin
794: select count(*),sum(primary_quantity),sum(transaction_quantity)
795: into l_same_lot_rec_cnt, l_sum_same_lot_pri_qty, l_sum_same_lot_tra_qty
796: from mtl_transaction_lots_temp
797: where transaction_temp_id = l_transaction_temp_id
798: and lot_number = l_lot;
799: exception
800: when NO_DATA_FOUND then

Line 819: from mtl_transaction_lots_temp

815:
816: if nvl(l_same_lot_rec_cnt,0) > 1 then
817: select *
818: into l_mtlt_rec
819: from mtl_transaction_lots_temp
820: where transaction_temp_id = l_transaction_temp_id
821: and lot_number = l_lot
822: and rownum = 1;
823:

Line 870: from mtl_transaction_lots_temp

866: l_mtlt_rec.serial_transaction_temp_id := l_new_serial_temp_id;
867: begin
868: select sum(primary_quantity), sum(transaction_quantity)
869: into l_sum_same_lot_pri_qty, l_sum_same_lot_tra_qty
870: from mtl_transaction_lots_temp
871: where transaction_temp_id = l_transaction_temp_id
872: and lot_number = l_lot;
873: exception
874: when NO_DATA_FOUND then

Line 893: delete mtl_transaction_lots_temp

889: mydebug(' consolidate mtlt 55: primary_quantity = ' || l_mtlt_rec.primary_quantity, l_api_name);
890: mydebug(' consolidate mtlt 55 :transaction_quantity = ' || l_mtlt_rec.transaction_quantity, l_api_name);
891: mydebug(' consolidate mtlt 55 :serial_transaction_temp_id = ' || l_mtlt_rec.serial_transaction_temp_id, l_api_name);
892: END IF;
893: delete mtl_transaction_lots_temp
894: where transaction_temp_id = l_transaction_temp_id
895: and lot_number = l_lot;
896: -- Insert new line into MTLT
897: inv_rcv_common_apis.insert_mtlt(l_mtlt_rec);

Line 902: from mtl_transaction_lots_temp

898:
899: begin
900: select count(*)
901: into l_same_lot_rec_cnt
902: from mtl_transaction_lots_temp
903: where transaction_temp_id = l_transaction_temp_id
904: and lot_number = l_lot;
905: exception
906: when NO_DATA_FOUND then

Line 1239: FROM mtl_transaction_lots_temp mtlt

1235: SELECT 'Y'
1236: INTO l_allocate_lot_flag
1237: FROM DUAL
1238: WHERE EXISTS (SELECT 1
1239: FROM mtl_transaction_lots_temp mtlt
1240: WHERE mtlt.transaction_temp_id = l_transaction_temp_id);
1241: EXCEPTION
1242: WHEN OTHERS THEN
1243: l_allocate_lot_flag := 'N';

Line 1910: FROM mtl_transaction_lots_temp

1906: l_found BOOLEAN;
1907:
1908: CURSOR c_lot_list(p_txn_temp_id IN NUMBER) IS
1909: SELECT lot_number, SUM(primary_quantity)
1910: FROM mtl_transaction_lots_temp
1911: WHERE transaction_temp_id = p_txn_temp_id
1912: GROUP BY lot_number;
1913:
1914: CURSOR c_display_serials(p_txn_temp_id IN NUMBER) IS

Line 1916: FROM mtl_transaction_lots_temp

1912: GROUP BY lot_number;
1913:
1914: CURSOR c_display_serials(p_txn_temp_id IN NUMBER) IS
1915: SELECT DECODE(COUNT(serial_transaction_temp_id), 0, 'N', 'Y')
1916: FROM mtl_transaction_lots_temp
1917: WHERE transaction_temp_id = p_txn_temp_id;
1918: BEGIN
1919: x_return_status := fnd_api.g_ret_sts_success;
1920:

Line 2032: FROM mtl_transaction_lots_temp mtlt, mtl_serial_numbers_temp msnt

2028: l_txn_temp_id NUMBER;
2029:
2030: CURSOR c_serial_list(p_txn_temp_id IN NUMBER, p_lot_num IN VARCHAR2) IS
2031: SELECT msnt.fm_serial_number
2032: FROM mtl_transaction_lots_temp mtlt, mtl_serial_numbers_temp msnt
2033: WHERE p_lot_num IS NOT NULL
2034: AND mtlt.transaction_temp_id = p_txn_temp_id
2035: AND mtlt.lot_number = p_lot_num
2036: AND msnt.transaction_temp_id = mtlt.serial_transaction_temp_id

Line 2138: mtl_transaction_lots_temp mtlt

2134: msnt.fm_serial_number,
2135: msnt.to_serial_number
2136: FROM
2137: mtl_serial_numbers_temp msnt,
2138: mtl_transaction_lots_temp mtlt
2139: WHERE mtlt.transaction_temp_id = p_transaction_temp_id
2140: AND msnt.transaction_temp_id = mtlt.serial_transaction_temp_id;
2141:
2142: l_item_id NUMBER := NULL;

Line 2389: FROM mtl_transaction_lots_temp

2385:
2386: UPDATE mtl_serial_numbers_temp
2387: SET group_header_id= l_txn_hdr_id
2388: WHERE transaction_temp_id in ( SELECT serial_transaction_temp_id
2389: FROM mtl_transaction_lots_temp
2390: WHERE transaction_temp_id= p_transaction_temp_id );
2391: ELSE --Non-Lot item
2392:
2393: OPEN c_fm_to_serial_number;

Line 3978: FROM mtl_transaction_lots_temp

3974:
3975: CURSOR mtlt_changed (p_ttemp_id IN NUMBER)
3976: IS
3977: SELECT *
3978: FROM mtl_transaction_lots_temp
3979: WHERE transaction_temp_id = p_ttemp_id
3980: ORDER BY lot_number;
3981: l_mtlt_row MTL_TRANSACTION_LOTS_TEMP%ROWTYPE;
3982: -- l_split_uom_quantities qty_changed_tbl_type;

Line 3981: l_mtlt_row MTL_TRANSACTION_LOTS_TEMP%ROWTYPE;

3977: SELECT *
3978: FROM mtl_transaction_lots_temp
3979: WHERE transaction_temp_id = p_ttemp_id
3980: ORDER BY lot_number;
3981: l_mtlt_row MTL_TRANSACTION_LOTS_TEMP%ROWTYPE;
3982: -- l_split_uom_quantities qty_changed_tbl_type;
3983: l_task_tbl_qty_count NUMBER := p_split_quantities.COUNT;
3984: l_decimal_precision CONSTANT NUMBER := 5;
3985: l_task_tbl_primary_qty NUMBER;

Line 4504: FROM mtl_transaction_lots_temp

4500: BEGIN
4501: --Lot quantity
4502: SELECT sum(transaction_quantity)
4503: INTO l_mtlt_transaction_qty
4504: FROM mtl_transaction_lots_temp
4505: WHERE transaction_temp_id = p_transaction_temp_id;
4506: IF g_debug = 1 THEN
4507: mydebug( 'l_mtlt_transaction_qty : '||l_mtlt_transaction_qty|| ' l_mmtt_transaction_quantity : '||l_mmtt_transaction_quantity, 'validate_quantities');
4508: END IF;

Line 4531: FROM mtl_transaction_lots_temp

4527: INTO l_msnt_transaction_qty
4528: FROM mtl_serial_numbers_temp
4529: WHERE transaction_temp_id IN
4530: (SELECT serial_transaction_temp_id
4531: FROM mtl_transaction_lots_temp
4532: WHERE transaction_temp_id = p_transaction_temp_id
4533: );
4534: IF l_msnt_transaction_qty <> l_mmtt_transaction_quantity THEN
4535: x_return_status := 'E';

Line 4554: FROM mtl_transaction_lots_temp

4550: BEGIN
4551: --Lot quantity
4552: SELECT sum(transaction_quantity)
4553: INTO l_mtlt_transaction_qty
4554: FROM mtl_transaction_lots_temp
4555: WHERE transaction_temp_id = p_transaction_temp_id;
4556: IF l_mtlt_transaction_qty <> l_mmtt_transaction_quantity THEN
4557: x_return_status := 'E';
4558: IF g_debug = 1 THEN

Line 5266: FROM mtl_transaction_lots_temp mtlt

5262: CURSOR C_MTLT
5263: IS
5264: SELECT rowid,
5265: mtlt.*
5266: FROM mtl_transaction_lots_temp mtlt
5267: WHERE transaction_temp_id = p_orig_transaction_temp_id
5268: ORDER BY lot_number;
5269: l_transaction_remaining_qty NUMBER;
5270: l_primary_remaining_qty NUMBER;

Line 5300: UPDATE mtl_transaction_lots_temp

5296: -- Calculate remaining quantity.
5297: -- Update mtl_lot_number
5298: l_transaction_remaining_qty := l_transaction_remaining_qty - mtlt.transaction_quantity;
5299: l_primary_remaining_qty := l_primary_remaining_qty - mtlt.primary_quantity;
5300: UPDATE mtl_transaction_lots_temp
5301: SET transaction_temp_id = p_new_transaction_temp_id ,
5302: last_updated_by = FND_GLOBAL.USER_ID
5303: WHERE rowid = mtlt.rowid;
5304: IF l_transaction_remaining_qty = 0 THEN

Line 5325: UPDATE mtl_transaction_lots_temp

5321: IF mtlt.serial_transaction_temp_id IS NOT NULL THEN
5322: SELECT mtl_material_transactions_s.NEXTVAL
5323: INTO l_new_serial_txn_temp_id
5324: FROM dual;
5325: UPDATE mtl_transaction_lots_temp
5326: SET serial_transaction_temp_id = l_new_serial_txn_temp_id ,
5327: last_updated_by = FND_GLOBAL.USER_ID
5328: WHERE transaction_temp_id = p_new_transaction_temp_id
5329: AND lot_number = mtlt.lot_number;

Line 5344: UPDATE mtl_transaction_lots_temp

5340: END IF;
5341: l_txn_remaining_qty_mtlt := mtlt.transaction_quantity - l_transaction_remaining_qty;
5342: l_prim_remaining_qty_mtlt := mtlt.primary_quantity - l_primary_remaining_qty;
5343: -- Update the remaining qty in the mtlt after insert.
5344: UPDATE mtl_transaction_lots_temp
5345: SET transaction_quantity = l_txn_remaining_qty_mtlt ,
5346: primary_quantity = l_prim_remaining_qty_mtlt ,
5347: last_updated_by = FND_GLOBAL.USER_ID
5348: WHERE rowid = mtlt.rowid;

Line 5427: INTO mtl_transaction_lots_temp

5423:
5424: BEGIN
5425: x_return_status := 'E';
5426: INSERT
5427: INTO mtl_transaction_lots_temp
5428: (
5429: TRANSACTION_TEMP_ID ,
5430: LAST_UPDATE_DATE ,
5431: LAST_UPDATED_BY ,

Line 5655: FROM mtl_transaction_lots_temp

5651: ATTRIBUTE12 ,
5652: ATTRIBUTE13 ,
5653: ATTRIBUTE14 ,
5654: ATTRIBUTE15
5655: FROM mtl_transaction_lots_temp
5656: WHERE rowid = p_row_id;
5657: x_return_status := 'S';
5658: EXCEPTION
5659: WHEN OTHERS THEN