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_RECEIVING_TRANSACTION dependencies on MTL_SERIAL_NUMBERS_TEMP

Line 546: mtl_serial_numbers_temp msnt

542: current_status = (CASE WHEN Nvl(previous_status,-1) < 0 THEN current_status ELSE previous_status END),
543: lot_line_mark_id = NULL
544: where msn.ROWID in ( select msn1.ROWID
545: from mtl_serial_numbers msn1 ,
546: mtl_serial_numbers_temp msnt
547: where msn1.inventory_item_id = l_rti_rec.item_id
548: and msnt.product_code = 'RCV'
549: and msnt.product_transaction_id = l_rti_rec.interface_transaction_id
550: and msn1.serial_number between msnt.fm_serial_number and msnt.to_serial_number

Line 583: mtl_serial_numbers_temp msnt

579: last_updated_by = fnd_global.user_id,
580: lot_line_mark_id = NULL
581: where msn.ROWID in ( select msn1.ROWID
582: from mtl_serial_numbers msn1 ,
583: mtl_serial_numbers_temp msnt
584: where msn1.inventory_item_id = l_rti_rec.item_id
585: and msnt.product_code = 'RCV'
586: and msnt.product_transaction_id = l_rti_rec.interface_transaction_id
587: and msn1.serial_number between msnt.fm_serial_number and msnt.to_serial_number

Line 699: mtl_serial_numbers_temp msnt

695: current_status = (CASE WHEN Nvl(previous_status,-1) < 0 THEN current_status ELSE previous_status END),
696: lot_line_mark_id = NULL
697: where msn.ROWID in ( select msn1.ROWID
698: from mtl_serial_numbers msn1 ,
699: mtl_serial_numbers_temp msnt
700: where msn1.inventory_item_id = l_rti_rec.item_id
701: and msnt.product_code = 'RCV'
702: and msnt.product_transaction_id = l_rti_rec.interface_transaction_id
703: and msn1.serial_number between msnt.fm_serial_number and msnt.to_serial_number

Line 740: mtl_serial_numbers_temp msnt

736: last_updated_by = fnd_global.user_id,
737: lot_line_mark_id = NULL
738: where msn.ROWID in ( select msn1.ROWID
739: from mtl_serial_numbers msn1 ,
740: mtl_serial_numbers_temp msnt
741: where msn1.inventory_item_id = l_rti_rec.item_id
742: and msnt.product_code = 'RCV'
743: and msnt.product_transaction_id = l_rti_rec.interface_transaction_id
744: and msn1.serial_number between msnt.fm_serial_number and msnt.to_serial_number

Line 853: mtl_serial_numbers_temp msnt

849: current_status = (CASE WHEN Nvl(previous_status,-1) < 0 THEN current_status ELSE previous_status END),
850: lot_line_mark_id = NULL
851: where msn.ROWID in ( select msn1.ROWID
852: from mtl_serial_numbers msn1 ,
853: mtl_serial_numbers_temp msnt
854: where msn1.inventory_item_id = l_rti_rec.item_id
855: and msnt.product_code = 'RCV'
856: and msnt.product_transaction_id = l_rti_rec.interface_transaction_id
857: and msn1.serial_number between msnt.fm_serial_number and msnt.to_serial_number

Line 894: mtl_serial_numbers_temp msnt

890: last_updated_by = fnd_global.user_id,
891: lot_line_mark_id = NULL
892: where msn.ROWID in ( select msn1.ROWID
893: from mtl_serial_numbers msn1 ,
894: mtl_serial_numbers_temp msnt
895: where msn1.inventory_item_id = l_rti_rec.item_id
896: and msnt.product_code = 'RCV'
897: and msnt.product_transaction_id = l_rti_rec.interface_transaction_id
898: and msn1.serial_number between msnt.fm_serial_number and msnt.to_serial_number

Line 1008: mtl_serial_numbers_temp msnt

1004: current_status = (CASE WHEN Nvl(previous_status,-1) < 0 THEN current_status ELSE previous_status END),
1005: lot_line_mark_id = NULL
1006: where msn.ROWID in ( select msn1.ROWID
1007: from mtl_serial_numbers msn1 ,
1008: mtl_serial_numbers_temp msnt
1009: where msn1.inventory_item_id = l_rti_rec.item_id
1010: and msnt.product_code = 'RCV'
1011: and msnt.product_transaction_id = l_rti_rec.interface_transaction_id
1012: and msn1.serial_number between msnt.fm_serial_number and msnt.to_serial_number

Line 1049: mtl_serial_numbers_temp msnt

1045: last_updated_by = fnd_global.user_id,
1046: lot_line_mark_id = NULL
1047: where msn.ROWID in ( select msn1.ROWID
1048: from mtl_serial_numbers msn1 ,
1049: mtl_serial_numbers_temp msnt
1050: where msn1.inventory_item_id = l_rti_rec.item_id
1051: and msnt.product_code = 'RCV'
1052: and msnt.product_transaction_id = l_rti_rec.interface_transaction_id
1053: and msn1.serial_number between msnt.fm_serial_number and msnt.to_serial_number

Line 1083: DELETE FROM mtl_serial_numbers_temp

1079: DELETE FROM mtl_serial_numbers_interface
1080: WHERE product_code = 'RCV'
1081: AND product_transaction_id = l_rti_rec.interface_transaction_id;
1082:
1083: DELETE FROM mtl_serial_numbers_temp
1084: WHERE product_code = 'RCV'
1085: AND product_transaction_id = l_rti_rec.interface_transaction_id;
1086:
1087: IF (l_prev_lpn_group_id <> l_rti_rec.lpn_group_id) THEN

Line 1382: -- Delete/Clear mtl_serial_numbers_temp rows

1378: print_debug('rcv_txn_clean_up - Finished clean up : 221',4);
1379: END IF;
1380:
1381:
1382: -- Delete/Clear mtl_serial_numbers_temp rows
1383: -- Delete/Clear mtl_transaction_lots_temp rows
1384: -- If the Transaction Fails
1385:
1386: IF (l_debug = 1) THEN

Line 1391: delete from mtl_serial_numbers_temp msnt

1387: print_debug('TXN_MOBILE_TIMEOUT_CLEANUP - cleanup msnt 1',4);
1388: END IF;
1389:
1390:
1391: delete from mtl_serial_numbers_temp msnt
1392: where msnt.transaction_temp_id in
1393: ( select interface_transaction_id
1394: from rcv_transactions_interface
1395: where group_id = p_group_id )

Line 1402: delete from mtl_serial_numbers_temp msnt

1398: IF (l_debug = 1) THEN
1399: print_debug('TXN_MOBILE_TIMEOUT_CLEANUP - cleanup msnt 2',4);
1400: END IF;
1401:
1402: delete from mtl_serial_numbers_temp msnt
1403: where msnt.transaction_temp_id in
1404: ( select mtlt.serial_transaction_temp_id
1405: from mtl_transaction_lots_temp mtlt
1406: where mtlt.transaction_temp_id in (