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_SERIAL_NUMBERS_INTERFACE

Line 2234: mtl_serial_numbers_interface

2230: SELECT
2231: fm_serial_number,
2232: to_serial_number
2233: FROM
2234: mtl_serial_numbers_interface
2235: WHERE l_intf_txn_id = transaction_interface_id;
2236:
2237: l_wlpnci_total_qty NUMBER;
2238: l_msni_total_qty NUMBER := 0;

Line 2703: UPDATE mtl_serial_numbers_interface

2699:
2700: -- Now update the product code and product_intf_id
2701: IF (l_msni_total_qty > 0) THEN
2702: BEGIN
2703: UPDATE mtl_serial_numbers_interface
2704: SET product_code = 'RCV',
2705: product_transaction_id=l_rti_rec.interface_transaction_id,
2706: transaction_interface_id = l_serial_txn_intf_id
2707: --WHERE transaction_interface_id = l_wlpnci_rec.interface_transaction_id;

Line 10056: Insert into MTL_SERIAL_NUMBERS_INTERFACE

10052:
10053: l_user_id := fnd_global.user_id;
10054: l_login_id := fnd_global.login_id;
10055:
10056: Insert into MTL_SERIAL_NUMBERS_INTERFACE
10057: (
10058: transaction_interface_id,
10059: Source_Code,
10060: Source_Line_Id,

Line 13162: FROM mtl_serial_numbers_interface msni

13158: Loop
13159: BEGIN
13160: SELECT 1
13161: INTO l_serial_disc
13162: FROM mtl_serial_numbers_interface msni
13163: , rcv_transactions_interface rti
13164: where rti.lpn_group_id = p_lpn_group_id
13165: and (rti.lpn_id = l_lpn_contents.lpn_id
13166: OR rti.license_plate_number = l_lpn_contents.license_plate_number)

Line 16158: INSERT INTO mtl_serial_numbers_interface

16154: IF (l_debug = 1) THEN
16155: print_debug('insert_msni_rowid:010: Entry Stamp :' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
16156: END If;
16157:
16158: INSERT INTO mtl_serial_numbers_interface
16159: (TRANSACTION_INTERFACE_ID,
16160: SOURCE_CODE,
16161: SOURCE_LINE_ID,
16162: LAST_UPDATE_DATE,

Line 16345: FROM mtl_serial_numbers_interface

16341: ATTRIBUTE14,
16342: ATTRIBUTE15,
16343: PRODUCT_CODE,
16344: p_product_txn_id
16345: FROM mtl_serial_numbers_interface
16346: WHERE ROWID = p_rowid);
16347:
16348: IF (l_debug = 1) THEN
16349: print_debug('insert_msni_rowid:020: Exit Stamp :' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);

Line 16387: FROM mtl_serial_numbers_interface

16383: CURSOR msni_recs (l_old_rti_id NUMBER) IS
16384: SELECT fm_serial_number,
16385: to_serial_number,
16386: ROWID
16387: FROM mtl_serial_numbers_interface
16388: WHERE product_code = 'RCV'
16389: AND product_transaction_id = l_old_rti_id;
16390:
16391: l_msni_rec msni_recs%ROWTYPE;

Line 16397: FROM mtl_serial_numbers_interface

16393: CURSOR msni_recs_lotserial(l_serial_transaction_temp_id NUMBER) IS
16394: SELECT fm_serial_number,
16395: to_serial_number,
16396: ROWID
16397: FROM mtl_serial_numbers_interface
16398: WHERE transaction_interface_id = l_serial_transaction_temp_id;
16399:
16400: l_remaining_quantity NUMBER;
16401: l_primary_rem_qty NUMBER;

Line 16477: FROM mtl_serial_numbers_interface

16473:
16474: BEGIN
16475: SELECT SUM(inv_serial_number_pub.get_serial_diff(fm_serial_number,to_serial_number))
16476: INTO l_total_serial_qty
16477: FROM mtl_serial_numbers_interface
16478: WHERE product_code = 'RCV'
16479: AND product_transaction_id = l_orig_interface_trx_id;
16480: EXCEPTION
16481: WHEN no_data_found THEN

Line 16583: FROM mtl_serial_numbers_interface msni

16579: mtli.transaction_quantity)
16580: )
16581: = (SELECT SUM(inv_serial_number_pub.get_serial_diff(msni.fm_serial_number,
16582: msni.to_serial_number))
16583: FROM mtl_serial_numbers_interface msni
16584: WHERE msni.transaction_interface_id = mtli.serial_transaction_temp_id));
16585: EXCEPTION
16586: WHEN no_data_found then
16587: l_lot_ser_qty := 0;

Line 16697: FROM mtl_serial_numbers_interface

16693:
16694: BEGIN
16695: SELECT SUM(inv_serial_number_pub.get_serial_diff(fm_serial_number,to_serial_number))
16696: INTO l_total_serial_qty
16697: FROM mtl_serial_numbers_interface
16698: WHERE product_code = 'RCV'
16699: AND product_transaction_id = l_orig_interface_trx_id;
16700: EXCEPTION
16701: WHEN no_data_found THEN

Line 16754: FROM mtl_serial_numbers_interface msni

16750: get_primary_qty(l_to_organization_id,l_item_id,l_uom_code,
16751: mtli.transaction_quantity)
16752: ) = (SELECT SUM(inv_serial_number_pub.get_serial_diff(msni.fm_serial_number,
16753: msni.to_serial_number))
16754: FROM mtl_serial_numbers_interface msni
16755: WHERE msni.transaction_interface_id = mtli.serial_transaction_temp_id));
16756: EXCEPTION
16757: WHEN no_data_found then
16758: l_lot_ser_qty := 0;

Line 16895: UPDATE mtl_serial_numbers_interface

16891: IF (l_debug = 1) THEN
16892: print_debug('split_lot_serial:170: update msni ', 1);
16893: END If;
16894: -- update the msni with new rti id.
16895: UPDATE mtl_serial_numbers_interface
16896: SET product_transaction_id = p_rti_tb(newrti).new_interface_trx_id
16897: WHERE ROWID = l_msni_rec.ROWID;
16898:
16899: END LOOP; -- fetch msni_recs_lotserial

Line 16983: UPDATE mtl_serial_numbers_interface

16979: IF (l_debug = 1) THEN
16980: print_debug('split_lot_serial:210: update msni ', 1);
16981: END If;
16982:
16983: UPDATE mtl_serial_numbers_interface
16984: SET product_transaction_id = p_rti_tb(newrti).new_interface_trx_id,
16985: transaction_interface_id = l_new_serial_txn_temp_id
16986: WHERE ROWID = l_msni_rec.ROWID;
16987:

Line 17033: UPDATE mtl_serial_numbers_interface

17029: IF (l_debug = 1) THEN
17030: print_debug('split_lot_serial:230: update msni ', 1);
17031: END IF;
17032:
17033: UPDATE mtl_serial_numbers_interface
17034: SET fm_serial_number = l_new_from_ser_num
17035: WHERE ROWID = l_msni_rec.ROWID;
17036:
17037: l_remaining_serial_qty := 0;

Line 17086: UPDATE mtl_serial_numbers_interface

17082: print_debug('split_lot_serial:240: update msni ', 1);
17083: print_debug('split_lot_serial:241: new rti '||p_rti_tb(newrti).new_interface_trx_id, 1);
17084: END If;
17085:
17086: UPDATE mtl_serial_numbers_interface
17087: SET product_transaction_id = p_rti_tb(newrti).new_interface_trx_id
17088: WHERE ROWID = l_msni_rec.ROWID;
17089:
17090: l_remaining_quantity := l_remaining_quantity -

Line 17139: UPDATE mtl_serial_numbers_interface

17135: IF (l_debug = 1) THEN
17136: print_debug('split_lot_serial:260: update msni ', 1);
17137: END If;
17138:
17139: UPDATE mtl_serial_numbers_interface
17140: SET fm_serial_number = l_new_from_ser_num
17141: WHERE ROWID = l_msni_rec.ROWID;
17142:
17143: l_remaining_quantity := 0;

Line 17717: FROM mtl_serial_numbers_interface

17713: CYCLES_SINCE_MARK,
17714: NUMBER_OF_REPAIRS,
17715: PRODUCT_CODE,
17716: product_transaction_id
17717: FROM mtl_serial_numbers_interface
17718: WHERE product_code = 'RCV'
17719: AND product_transaction_id = p_rti_id;
17720:
17721: IF (l_debug = 1) THEN

Line 17731: DELETE FROM mtl_serial_numbers_interface

17727: DELETE FROM mtl_transaction_lots_interface
17728: WHERE product_code = 'RCV'
17729: AND product_transaction_id = p_rti_id;
17730:
17731: DELETE FROM mtl_serial_numbers_interface
17732: WHERE product_code = 'RCV'
17733: AND product_transaction_id = p_rti_id;
17734:
17735: EXCEPTION