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.

[Home] [Help]

APPS.WMS_PICKING_PKG dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 158: from mtl_transaction_lots_temp

154: ) IS
155:
156: cursor c_lot_csr(p_temp_id NUMBER) is
157: select lot_number
158: from mtl_transaction_lots_temp
159: where transaction_temp_id = p_temp_id;
160:
161: cursor c_same_lot_csr(p_temp_id NUMBER, p_lot VARCHAR2) is
162: select primary_quantity, transaction_quantity, serial_transaction_temp_id

Line 163: from mtl_transaction_lots_temp

159: where transaction_temp_id = p_temp_id;
160:
161: cursor c_same_lot_csr(p_temp_id NUMBER, p_lot VARCHAR2) is
162: select primary_quantity, transaction_quantity, serial_transaction_temp_id
163: from mtl_transaction_lots_temp
164: where transaction_temp_id = p_temp_id
165: and lot_number = p_lot;
166:
167: --OVPK Start 1

Line 204: l_mtlt_rec mtl_transaction_lots_temp%ROWTYPE;

200: l_same_lot_pri_qty NUMBER;
201: l_same_lot_tra_qty NUMBER;
202: l_sum_same_lot_pri_qty NUMBER;
203: l_sum_same_lot_tra_qty NUMBER;
204: l_mtlt_rec mtl_transaction_lots_temp%ROWTYPE;
205: l_lot VARCHAR2(2000); --Bug 6148865
206: l_old_lot VARCHAR2(2000); --Bug 6148865
207: l_new_serial_temp_id NUMBER;
208: l_delivery_id NUMBER;

Line 235: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt

231: l_to_serial_number VARCHAR2(30);
232: --
233: CURSOR c_get_serialLots(p_transaction_temp_id NUMBER) IS
234: SELECT msnt.fm_serial_number, msnt.to_serial_number
235: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt
236: WHERE msnt.transaction_temp_id = mtlt.serial_transaction_temp_id
237: AND mtlt.transaction_temp_id = p_transaction_temp_id;
238: -- End Bug 4434111
239: BEGIN

Line 494: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt

490: AND ROWNUM < 2;
491: ELSE -- lot controlled
492: SELECT msnt.transaction_temp_id
493: INTO l_serial_temp_id
494: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt
495: WHERE msnt.transaction_temp_id = NVL(mtlt.serial_transaction_temp_id, -1)
496: AND mtlt.transaction_temp_id = l_transaction_temp_id
497: AND ROWNUM < 2;
498: END IF;

Line 596: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt

592: DELETE FROM mtl_serial_numbers_temp
593: WHERE transaction_temp_id IN
594: (
595: SELECT serial_transaction_temp_id
596: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt
597: WHERE msnt.transaction_temp_id = mtlt.serial_transaction_temp_id
598: AND mtlt.transaction_temp_id = l_transaction_temp_id
599: );
600: --

Line 631: from mtl_transaction_lots_temp

627: if l_lot <> nvl(l_old_lot, '-999') then
628: begin
629: select count(*),sum(primary_quantity),sum(transaction_quantity)
630: into l_same_lot_rec_cnt, l_sum_same_lot_pri_qty, l_sum_same_lot_tra_qty
631: from mtl_transaction_lots_temp
632: where transaction_temp_id = l_transaction_temp_id
633: and lot_number = l_lot;
634: exception
635: when NO_DATA_FOUND then

Line 654: from mtl_transaction_lots_temp

650:
651: if nvl(l_same_lot_rec_cnt,0) > 1 then
652: select *
653: into l_mtlt_rec
654: from mtl_transaction_lots_temp
655: where transaction_temp_id = l_transaction_temp_id
656: and lot_number = l_lot
657: and rownum = 1;
658:

Line 705: from mtl_transaction_lots_temp

701: l_mtlt_rec.serial_transaction_temp_id := l_new_serial_temp_id;
702: begin
703: select sum(primary_quantity), sum(transaction_quantity)
704: into l_sum_same_lot_pri_qty, l_sum_same_lot_tra_qty
705: from mtl_transaction_lots_temp
706: where transaction_temp_id = l_transaction_temp_id
707: and lot_number = l_lot;
708: exception
709: when NO_DATA_FOUND then

Line 728: delete mtl_transaction_lots_temp

724: mydebug(' consolidate mtlt 55: primary_quantity = ' || l_mtlt_rec.primary_quantity, l_api_name);
725: mydebug(' consolidate mtlt 55 :transaction_quantity = ' || l_mtlt_rec.transaction_quantity, l_api_name);
726: mydebug(' consolidate mtlt 55 :serial_transaction_temp_id = ' || l_mtlt_rec.serial_transaction_temp_id, l_api_name);
727: END IF;
728: delete mtl_transaction_lots_temp
729: where transaction_temp_id = l_transaction_temp_id
730: and lot_number = l_lot;
731: -- Insert new line into MTLT
732: inv_rcv_common_apis.insert_mtlt(l_mtlt_rec);

Line 737: from mtl_transaction_lots_temp

733:
734: begin
735: select count(*)
736: into l_same_lot_rec_cnt
737: from mtl_transaction_lots_temp
738: where transaction_temp_id = l_transaction_temp_id
739: and lot_number = l_lot;
740: exception
741: when NO_DATA_FOUND then

Line 1650: FROM mtl_transaction_lots_temp

1646: l_found BOOLEAN;
1647:
1648: CURSOR c_lot_list(p_txn_temp_id IN NUMBER) IS
1649: SELECT lot_number, SUM(primary_quantity)
1650: FROM mtl_transaction_lots_temp
1651: WHERE transaction_temp_id = p_txn_temp_id
1652: GROUP BY lot_number;
1653:
1654: CURSOR c_display_serials(p_txn_temp_id IN NUMBER) IS

Line 1656: FROM mtl_transaction_lots_temp

1652: GROUP BY lot_number;
1653:
1654: CURSOR c_display_serials(p_txn_temp_id IN NUMBER) IS
1655: SELECT DECODE(COUNT(serial_transaction_temp_id), 0, 'N', 'Y')
1656: FROM mtl_transaction_lots_temp
1657: WHERE transaction_temp_id = p_txn_temp_id;
1658: BEGIN
1659: x_return_status := fnd_api.g_ret_sts_success;
1660:

Line 1772: FROM mtl_transaction_lots_temp mtlt, mtl_serial_numbers_temp msnt

1768: l_txn_temp_id NUMBER;
1769:
1770: CURSOR c_serial_list(p_txn_temp_id IN NUMBER, p_lot_num IN VARCHAR2) IS
1771: SELECT msnt.fm_serial_number
1772: FROM mtl_transaction_lots_temp mtlt, mtl_serial_numbers_temp msnt
1773: WHERE p_lot_num IS NOT NULL
1774: AND mtlt.transaction_temp_id = p_txn_temp_id
1775: AND mtlt.lot_number = p_lot_num
1776: AND msnt.transaction_temp_id = mtlt.serial_transaction_temp_id

Line 1878: mtl_transaction_lots_temp mtlt

1874: msnt.fm_serial_number,
1875: msnt.to_serial_number
1876: FROM
1877: mtl_serial_numbers_temp msnt,
1878: mtl_transaction_lots_temp mtlt
1879: WHERE mtlt.transaction_temp_id = p_transaction_temp_id
1880: AND msnt.transaction_temp_id = mtlt.serial_transaction_temp_id;
1881:
1882: l_item_id NUMBER := NULL;

Line 2129: FROM mtl_transaction_lots_temp

2125:
2126: UPDATE mtl_serial_numbers_temp
2127: SET group_header_id= l_txn_hdr_id
2128: WHERE transaction_temp_id in ( SELECT serial_transaction_temp_id
2129: FROM mtl_transaction_lots_temp
2130: WHERE transaction_temp_id= p_transaction_temp_id );
2131: ELSE --Non-Lot item
2132:
2133: OPEN c_fm_to_serial_number;

Line 3550: FROM mtl_transaction_lots_temp

3546:
3547: CURSOR mtlt_changed (p_ttemp_id IN NUMBER)
3548: IS
3549: SELECT *
3550: FROM mtl_transaction_lots_temp
3551: WHERE transaction_temp_id = p_ttemp_id
3552: ORDER BY lot_number;
3553: l_mtlt_row MTL_TRANSACTION_LOTS_TEMP%ROWTYPE;
3554: -- l_split_uom_quantities qty_changed_tbl_type;

Line 3553: l_mtlt_row MTL_TRANSACTION_LOTS_TEMP%ROWTYPE;

3549: SELECT *
3550: FROM mtl_transaction_lots_temp
3551: WHERE transaction_temp_id = p_ttemp_id
3552: ORDER BY lot_number;
3553: l_mtlt_row MTL_TRANSACTION_LOTS_TEMP%ROWTYPE;
3554: -- l_split_uom_quantities qty_changed_tbl_type;
3555: l_task_tbl_qty_count NUMBER := p_split_quantities.COUNT;
3556: l_decimal_precision CONSTANT NUMBER := 5;
3557: l_task_tbl_primary_qty NUMBER;

Line 4076: FROM mtl_transaction_lots_temp

4072: BEGIN
4073: --Lot quantity
4074: SELECT sum(transaction_quantity)
4075: INTO l_mtlt_transaction_qty
4076: FROM mtl_transaction_lots_temp
4077: WHERE transaction_temp_id = p_transaction_temp_id;
4078: IF g_debug = 1 THEN
4079: mydebug( 'l_mtlt_transaction_qty : '||l_mtlt_transaction_qty|| ' l_mmtt_transaction_quantity : '||l_mmtt_transaction_quantity, 'validate_quantities');
4080: END IF;

Line 4103: FROM mtl_transaction_lots_temp

4099: INTO l_msnt_transaction_qty
4100: FROM mtl_serial_numbers_temp
4101: WHERE transaction_temp_id IN
4102: (SELECT serial_transaction_temp_id
4103: FROM mtl_transaction_lots_temp
4104: WHERE transaction_temp_id = p_transaction_temp_id
4105: );
4106: IF l_msnt_transaction_qty <> l_mmtt_transaction_quantity THEN
4107: x_return_status := 'E';

Line 4126: FROM mtl_transaction_lots_temp

4122: BEGIN
4123: --Lot quantity
4124: SELECT sum(transaction_quantity)
4125: INTO l_mtlt_transaction_qty
4126: FROM mtl_transaction_lots_temp
4127: WHERE transaction_temp_id = p_transaction_temp_id;
4128: IF l_mtlt_transaction_qty <> l_mmtt_transaction_quantity THEN
4129: x_return_status := 'E';
4130: IF g_debug = 1 THEN

Line 4836: FROM mtl_transaction_lots_temp mtlt

4832: CURSOR C_MTLT
4833: IS
4834: SELECT rowid,
4835: mtlt.*
4836: FROM mtl_transaction_lots_temp mtlt
4837: WHERE transaction_temp_id = p_orig_transaction_temp_id
4838: ORDER BY lot_number;
4839: l_transaction_remaining_qty NUMBER;
4840: l_primary_remaining_qty NUMBER;

Line 4870: UPDATE mtl_transaction_lots_temp

4866: -- Calculate remaining quantity.
4867: -- Update mtl_lot_number
4868: l_transaction_remaining_qty := l_transaction_remaining_qty - mtlt.transaction_quantity;
4869: l_primary_remaining_qty := l_primary_remaining_qty - mtlt.primary_quantity;
4870: UPDATE mtl_transaction_lots_temp
4871: SET transaction_temp_id = p_new_transaction_temp_id ,
4872: last_updated_by = FND_GLOBAL.USER_ID
4873: WHERE rowid = mtlt.rowid;
4874: IF l_transaction_remaining_qty = 0 THEN

Line 4895: UPDATE mtl_transaction_lots_temp

4891: IF mtlt.serial_transaction_temp_id IS NOT NULL THEN
4892: SELECT mtl_material_transactions_s.NEXTVAL
4893: INTO l_new_serial_txn_temp_id
4894: FROM dual;
4895: UPDATE mtl_transaction_lots_temp
4896: SET serial_transaction_temp_id = l_new_serial_txn_temp_id ,
4897: last_updated_by = FND_GLOBAL.USER_ID
4898: WHERE transaction_temp_id = p_new_transaction_temp_id
4899: AND lot_number = mtlt.lot_number;

Line 4914: UPDATE mtl_transaction_lots_temp

4910: END IF;
4911: l_txn_remaining_qty_mtlt := mtlt.transaction_quantity - l_transaction_remaining_qty;
4912: l_prim_remaining_qty_mtlt := mtlt.primary_quantity - l_primary_remaining_qty;
4913: -- Update the remaining qty in the mtlt after insert.
4914: UPDATE mtl_transaction_lots_temp
4915: SET transaction_quantity = l_txn_remaining_qty_mtlt ,
4916: primary_quantity = l_prim_remaining_qty_mtlt ,
4917: last_updated_by = FND_GLOBAL.USER_ID
4918: WHERE rowid = mtlt.rowid;

Line 4997: INTO mtl_transaction_lots_temp

4993:
4994: BEGIN
4995: x_return_status := 'E';
4996: INSERT
4997: INTO mtl_transaction_lots_temp
4998: (
4999: TRANSACTION_TEMP_ID ,
5000: LAST_UPDATE_DATE ,
5001: LAST_UPDATED_BY ,

Line 5225: FROM mtl_transaction_lots_temp

5221: ATTRIBUTE12 ,
5222: ATTRIBUTE13 ,
5223: ATTRIBUTE14 ,
5224: ATTRIBUTE15
5225: FROM mtl_transaction_lots_temp
5226: WHERE rowid = p_row_id;
5227: x_return_status := 'S';
5228: EXCEPTION
5229: WHEN OTHERS THEN