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.INV_LPN_TRX_PUB dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 621: * Insert a row into MTL_TRANSACTION_LOTS_TEMP

617: --Added bug 3978111
618: END;
619:
620: /********************************************************************
621: * Insert a row into MTL_TRANSACTION_LOTS_TEMP
622: *******************************************************************/
623: FUNCTION insert_lot_trx(curlpnrec wms_container_pub.wms_container_content_rec_type, trxtmpid NUMBER)
624: RETURN NUMBER IS
625: lotobjid NUMBER;

Line 802: lastlotnum mtl_transaction_lots_temp.lot_number%TYPE;

798: lotobjid NUMBER;
799: v_lasttrxtmpid NUMBER;
800: v_lastitemqty NUMBER;
801: v_lastitemsecqty NUMBER; ---INVCONV KKILLAMS
802: lastlotnum mtl_transaction_lots_temp.lot_number%TYPE;
803: itemqtychanged BOOLEAN := FALSE;
804: lotqtychanged BOOLEAN := FALSE;
805: lotqty NUMBER;
806: lotsecqty NUMBER; --invconv kkillams

Line 1041: UPDATE mtl_transaction_lots_temp

1037: IF (l_debug = 1) THEN
1038: inv_log_util.TRACE('** Going to update last Lot rec1 qty = ' || lotqty, 'INV_LPN_TRX_PUB', 9);
1039: END IF;
1040:
1041: UPDATE mtl_transaction_lots_temp
1042: SET transaction_quantity = lotqty
1043: -- , primary_quantity = lotqty * l_conv_fact /*Bug#5486052.*/
1044: , primary_quantity = lotpriqty --16445970
1045: , secondary_quantity = lotsecqty --INVCONV kkillams

Line 1153: UPDATE mtl_transaction_lots_temp

1149: IF (l_debug = 1) THEN
1150: inv_log_util.TRACE('** Going to update last Lot rec2 qty = ' || lotqty, 'INV_LPN_TRX_PUB', 9);
1151: END IF;
1152:
1153: UPDATE mtl_transaction_lots_temp
1154: SET transaction_quantity = lotqty
1155: --, primary_quantity = lotqty * l_conv_fact /*Bug#5486052.*/
1156: , primary_quantity = lotpriqty --16445970
1157: , secondary_quantity = lotsecqty --INVCONV kkillams

Line 1286: UPDATE mtl_transaction_lots_temp

1282: IF (l_debug = 1) THEN
1283: inv_log_util.TRACE('** Going to upd lst lot3. qty = ' || lotqty, 'INV_LPN_TRX_PUB', 9);
1284: END IF;
1285:
1286: UPDATE mtl_transaction_lots_temp
1287: SET transaction_quantity = lotqty
1288: --, primary_quantity = lotqty * l_conv_fact /*Bug#5486052.*/
1289: , primary_quantity = lotpriqty --16445970
1290: , secondary_quantity = lotsecqty --INVCONV kkillams

Line 1462: UPDATE mtl_transaction_lots_temp

1458: p_mmtt.secondary_transaction_quantity := CASE WHEN v_lastitemsecqty <> 0 THEN v_lastitemsecqty ELSE p_mmtt.secondary_transaction_quantity END; --INVCONV kkillams
1459: itemqtychanged := FALSE;
1460:
1461: IF (lotqtychanged) THEN
1462: UPDATE mtl_transaction_lots_temp
1463: SET transaction_quantity = lotqty
1464: --, primary_quantity = lotqty * l_conv_fact /*Bug#5486052.*/
1465: , primary_quantity = lotpriqty --16445970
1466: , secondary_quantity = lotsecqty --INVCONV kkillams

Line 1688: v_lotnum mtl_transaction_lots_temp.lot_number%TYPE;

1684: v_sertrxid NUMBER;
1685: v_lotfound BOOLEAN := FALSE;
1686: v_serfound BOOLEAN := FALSE;
1687: item_id NUMBER := NULL;
1688: v_lotnum mtl_transaction_lots_temp.lot_number%TYPE;
1689: v_lotqty NUMBER;
1690: v_lotsecqty NUMBER;
1691: v_serqty NUMBER;
1692: l_operation NUMBER := p_operation;

Line 1707: FROM mtl_transaction_lots_temp

1703: , primary_quantity
1704: , transaction_quantity
1705: , secondary_quantity
1706: , serial_transaction_temp_id
1707: FROM mtl_transaction_lots_temp
1708: WHERE transaction_temp_id = p_tempid;
1709:
1710: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1711: BEGIN

Line 3277: FROM mtl_transaction_lots_temp

3273: , primary_quantity
3274: , serial_transaction_temp_id
3275: , secondary_quantity
3276: , secondary_unit_of_measure
3277: FROM mtl_transaction_lots_temp
3278: WHERE transaction_temp_id = p_tempid
3279: ORDER BY lot_number;
3280: BEGIN
3281: -- Check if pricing is tracked by secondary qty

Line 3610: FROM mtl_transaction_lots_temp

3606: /* *****************************************************
3607: CURSOR c_mtlt (p_transaction_temp_id NUMBER) IS
3608: SELECT lot_number
3609: ,primary_quantity
3610: FROM mtl_transaction_lots_temp
3611: WHERE transaction_temp_id = p_transaction_temp_id;
3612: *****************************************************
3613:
3614:

Line 4610: FROM mtl_transaction_lots_temp

4606:
4607: -- Remove from MSNT rows with same MTNT transaction_temp_id
4608: DELETE FROM mtl_serial_numbers_temp
4609: WHERE transaction_temp_id IN(SELECT serial_transaction_temp_id
4610: FROM mtl_transaction_lots_temp
4611: WHERE transaction_temp_id IN(SELECT transaction_temp_id
4612: FROM mtl_material_transactions_temp
4613: WHERE transaction_header_id = p_trx_hdr_id -- Bug 5748351
4614: AND transaction_batch_id = v_mmtt.transaction_batch_id));

Line 4617: DELETE FROM mtl_transaction_lots_temp

4613: WHERE transaction_header_id = p_trx_hdr_id -- Bug 5748351
4614: AND transaction_batch_id = v_mmtt.transaction_batch_id));
4615:
4616: -- Remove from MTLT rows with same MMTT transaction_temp_id
4617: DELETE FROM mtl_transaction_lots_temp
4618: WHERE transaction_temp_id IN(SELECT transaction_temp_id
4619: FROM mtl_material_transactions_temp
4620: WHERE transaction_header_id = p_trx_hdr_id -- Bug 5748351
4621: AND transaction_batch_id = v_mmtt.transaction_batch_id);

Line 4653: FROM mtl_transaction_lots_temp

4649:
4650: -- Remove from MSNT rows with same MTNT transaction_temp_id
4651: DELETE FROM mtl_serial_numbers_temp
4652: WHERE transaction_temp_id IN(SELECT serial_transaction_temp_id
4653: FROM mtl_transaction_lots_temp
4654: WHERE transaction_temp_id = v_mmtt.transaction_temp_id);
4655:
4656: -- Remove from MTLT rows with same MMTT transaction_temp_id
4657: DELETE FROM mtl_transaction_lots_temp

Line 4657: DELETE FROM mtl_transaction_lots_temp

4653: FROM mtl_transaction_lots_temp
4654: WHERE transaction_temp_id = v_mmtt.transaction_temp_id);
4655:
4656: -- Remove from MTLT rows with same MMTT transaction_temp_id
4657: DELETE FROM mtl_transaction_lots_temp
4658: WHERE transaction_temp_id = v_mmtt.transaction_temp_id;
4659:
4660: -- Remove from MMTT rows with same transaction group id
4661: DELETE FROM mtl_material_transactions_temp

Line 5194: FROM mtl_transaction_lots_temp

5190:
5191: -- Remove from MSNT rows with same MTNT Transaction_header_id
5192: DELETE FROM mtl_serial_numbers_temp
5193: WHERE transaction_temp_id IN(SELECT serial_transaction_temp_id
5194: FROM mtl_transaction_lots_temp
5195: WHERE transaction_temp_id IN(SELECT transaction_temp_id
5196: FROM mtl_material_transactions_temp
5197: WHERE transaction_header_id = p_trx_hdr_id));
5198:

Line 5200: DELETE FROM mtl_transaction_lots_temp

5196: FROM mtl_material_transactions_temp
5197: WHERE transaction_header_id = p_trx_hdr_id));
5198:
5199: -- Remove from MTLT rows with same MMTT Transaction_header_id
5200: DELETE FROM mtl_transaction_lots_temp
5201: WHERE transaction_temp_id IN(SELECT transaction_temp_id
5202: FROM mtl_material_transactions_temp
5203: WHERE transaction_header_id = p_trx_hdr_id);
5204:

Line 7778: FROM mtl_transaction_lots_temp

7774: IF SQL%ROWCOUNT = 0 THEN
7775: DELETE FROM mtl_serial_numbers_temp
7776: WHERE transaction_temp_id IN(
7777: SELECT serial_transaction_temp_id
7778: FROM mtl_transaction_lots_temp
7779: WHERE transaction_temp_id =
7780: (SELECT transaction_temp_id
7781: FROM mtl_material_transactions_temp
7782: WHERE transaction_temp_id = p_transaction_temp_id

Line 7790: DELETE FROM mtl_transaction_lots_temp

7786: IF (l_debug = 1) THEN
7787: inv_log_util.TRACE('* No of MSNT records deleted =' || SQL%ROWCOUNT, 'INV_LPN_TRX_PUB', 1);
7788: END IF;
7789:
7790: DELETE FROM mtl_transaction_lots_temp
7791: WHERE transaction_temp_id = (SELECT transaction_temp_id
7792: FROM mtl_material_transactions_temp
7793: WHERE transaction_temp_id = p_transaction_temp_id
7794: AND inventory_item_id = -1);