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_RCV_INTEGRATION_PVT dependencies on MTL_TRANSACTION_LOTS_INTERFACE

Line 2741: UPDATE mtl_transaction_lots_interface

2737: WHERE transaction_interface_id = l_wlpnci_rec.serial_transaction_intf_id;
2738:
2739: --Bug 9226468 To update mtli we need to check based on the serial_transaction_temp_id but not based on product transaction id
2740: --so that it will not fetch the already processed lots.
2741: UPDATE mtl_transaction_lots_interface
2742: SET serial_transaction_temp_id = l_serial_txn_intf_id
2743: WHERE product_code = 'RCV'
2744: AND serial_transaction_temp_id=l_tmp_ser_txn_id;
2745: --AND product_transaction_id = l_wlpnci_rec.interface_transaction_id;

Line 10655: insert into mtl_transaction_lots_interface (

10651: print_debug('p_transaction_quantity = '|| p_transaction_quantity , 4);
10652: print_debug('p_primary_quantity = '|| p_primary_quantity , 4);
10653: END IF;
10654:
10655: insert into mtl_transaction_lots_interface (
10656: TRANSACTION_INTERFACE_ID,
10657: SOURCE_CODE,
10658: SOURCE_LINE_ID,
10659: LAST_UPDATE_DATE,

Line 13681: , mtl_transaction_lots_interface mtli

13677: ELSE --IF l_lpn_contents.lot_number IS NULL THEN
13678: select sum(mtli.primary_quantity)
13679: into l_rti_qty
13680: from rcv_transactions_interface rti
13681: , mtl_transaction_lots_interface mtli
13682: where rti.lpn_group_id = p_lpn_group_id
13683: and (rti.lpn_id = l_lpn_contents.lpn_id
13684: OR rti.license_plate_number = l_lpn_contents.license_plate_number)
13685: -- 3397823

Line 16668: INSERT INTO mtl_transaction_lots_interface

16664: IF (l_debug = 1) THEN
16665: print_debug('insert_mtli_rowid:010: Entry Stamp :' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
16666: END If;
16667:
16668: INSERT INTO mtl_transaction_lots_interface
16669: (TRANSACTION_INTERFACE_ID,
16670: SOURCE_CODE,
16671: SOURCE_LINE_ID,
16672: LAST_UPDATE_DATE,

Line 16870: FROM mtl_transaction_lots_interface

16866: reason_code,
16867: NULL,
16868: PRODUCT_CODE,
16869: p_product_txn_id
16870: FROM mtl_transaction_lots_interface
16871: WHERE ROWID = p_rowid);
16872:
16873: IF (l_debug = 1) THEN
16874: print_debug('insert_mtli_rowid:020: Exit Stamp :' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);

Line 16876: print_debug('INVCONV, removed sublot_num, Added some more parameters in INSERT INTO mtl_transaction_lots_interface (insert_mtli_rowid)', 1);

16872:
16873: IF (l_debug = 1) THEN
16874: print_debug('insert_mtli_rowid:020: Exit Stamp :' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
16875: /* INVCONV*/
16876: print_debug('INVCONV, removed sublot_num, Added some more parameters in INSERT INTO mtl_transaction_lots_interface (insert_mtli_rowid)', 1);
16877: /*end , INVCONV*/
16878:
16879: END If;
16880: EXCEPTION

Line 17136: FROM mtl_transaction_lots_interface mtli, rcv_lots_supply rls

17132: mtli.transaction_quantity,
17133: mtli.primary_quantity,
17134: mtli.serial_transaction_temp_id,
17135: mtli.ROWID
17136: FROM mtl_transaction_lots_interface mtli, rcv_lots_supply rls
17137: WHERE mtli.product_code = 'RCV'
17138: AND mtli.product_transaction_id = l_old_rti_id
17139: AND mtli.lot_number = rls.lot_num --14573375 removed outer join
17140: AND NVL(rls.shipment_line_id,l_shipment_line_id) = l_shipment_line_id

Line 17149: FROM mtl_transaction_lots_interface mtli

17145: mtli.transaction_quantity,
17146: mtli.primary_quantity,
17147: mtli.serial_transaction_temp_id,
17148: mtli.ROWID
17149: FROM mtl_transaction_lots_interface mtli
17150: WHERE mtli.product_code = 'RCV'
17151: AND mtli.product_transaction_id = l_old_rti_id;
17152:
17153: l_mtli_rec mtli_recs%ROWTYPE;

Line 17243: FROM mtl_transaction_lots_interface

17239:
17240: BEGIN
17241: SELECT SUM(transaction_quantity)
17242: INTO l_total_lot_qty
17243: FROM mtl_transaction_lots_interface
17244: WHERE product_code = 'RCV'
17245: AND product_transaction_id = l_orig_interface_trx_id;
17246: EXCEPTION
17247: WHEN no_data_found THEN

Line 17358: FROM mtl_transaction_lots_interface mtli

17354:
17355: BEGIN
17356: SELECT SUM(mtli.transaction_quantity)
17357: INTO l_lot_ser_qty
17358: FROM mtl_transaction_lots_interface mtli
17359: WHERE mtli.product_code = 'RCV'
17360: AND mtli.product_transaction_id = l_orig_interface_trx_id
17361: AND (mtli.serial_transaction_temp_id IS NULL
17362: OR nvl(mtli.primary_quantity,

Line 17463: FROM mtl_transaction_lots_interface

17459:
17460: BEGIN
17461: SELECT SUM(transaction_quantity)
17462: INTO l_total_lot_qty
17463: FROM mtl_transaction_lots_interface
17464: WHERE product_code = 'RCV'
17465: AND product_transaction_id = l_orig_interface_trx_id
17466: AND (p_rti_tb(newrti).lot_number IS NULL OR (p_rti_tb(newrti).lot_number IS NOT NULL AND lot_number=p_rti_tb(newrti).lot_number)); -- for 13972742
17467: EXCEPTION

Line 17531: FROM mtl_transaction_lots_interface mtli

17527:
17528: BEGIN
17529: SELECT SUM(mtli.transaction_quantity)
17530: INTO l_lot_ser_qty
17531: FROM mtl_transaction_lots_interface mtli
17532: WHERE mtli.product_code = 'RCV'
17533: AND mtli.product_transaction_id = l_orig_interface_trx_id
17534: AND (mtli.serial_transaction_temp_id IS NULL
17535: OR nvl(mtli.primary_quantity,

Line 17731: UPDATE mtl_transaction_lots_interface

17727: l_primary_rem_qty := (l_remaining_quantity*l_mtli_rec.primary_quantity)/l_mtli_rec.transaction_quantity;
17728:
17729: IF (l_mtli_rec.transaction_quantity <= l_remaining_quantity) THEN
17730: -- update the mtli with new rti id.
17731: UPDATE mtl_transaction_lots_interface
17732: SET product_transaction_id = p_rti_tb(newrti).new_interface_trx_id
17733: WHERE ROWID = l_mtli_rec.ROWID;
17734:
17735: IF (l_debug = 1) THEN

Line 17807: UPDATE mtl_transaction_lots_interface

17803: END If;
17804:
17805: -- update the original row
17806: -- For OPM null out the secondary_transaction_quantity
17807: UPDATE mtl_transaction_lots_interface
17808: SET transaction_quantity = transaction_quantity -
17809: l_remaining_quantity,
17810: primary_quantity = primary_quantity - l_primary_rem_qty,
17811: secondary_transaction_quantity = NULL

Line 18466: FROM mtl_transaction_lots_interface

18462: REASON_ID ,
18463: /* end INVCONV */
18464: secondary_transaction_quantity,
18465: reason_code
18466: FROM mtl_transaction_lots_interface
18467: WHERE product_code = 'RCV'
18468: AND product_transaction_id = p_rti_id;
18469:
18470:

Line 18704: DELETE FROM mtl_transaction_lots_interface

18700: AND mtlt.product_transaction_id = p_rti_id
18701: and mtlt.serial_transaction_temp_id is null;
18702:
18703: --delete mtli and msni
18704: DELETE FROM mtl_transaction_lots_interface
18705: WHERE product_code = 'RCV'
18706: AND product_transaction_id = p_rti_id;
18707:
18708: DELETE FROM mtl_serial_numbers_interface