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 528: mtl_serial_numbers_temp msnt

524: line_mark_id = NULL,
525: lot_line_mark_id = NULL
526: where msn.ROWID in ( select msn1.ROWID
527: from mtl_serial_numbers msn1 ,
528: mtl_serial_numbers_temp msnt
529: where msn1.inventory_item_id = l_rti_rec.item_id
530: and msnt.product_code = 'RCV'
531: and msnt.product_transaction_id = l_rti_rec.interface_transaction_id
532: and msn1.serial_number between msnt.fm_serial_number and msnt.to_serial_number

Line 622: mtl_serial_numbers_temp msnt

618: line_mark_id = NULL,
619: lot_line_mark_id = NULL
620: where msn.ROWID in ( select msn1.ROWID
621: from mtl_serial_numbers msn1 ,
622: mtl_serial_numbers_temp msnt
623: where msn1.inventory_item_id = l_rti_rec.item_id
624: and msnt.product_code = 'RCV'
625: and msnt.product_transaction_id = l_rti_rec.interface_transaction_id
626: and msn1.serial_number between msnt.fm_serial_number and msnt.to_serial_number

Line 715: mtl_serial_numbers_temp msnt

711: line_mark_id = NULL,
712: lot_line_mark_id = NULL
713: where msn.ROWID in ( select msn1.ROWID
714: from mtl_serial_numbers msn1 ,
715: mtl_serial_numbers_temp msnt
716: where msn1.inventory_item_id = l_rti_rec.item_id
717: and msnt.product_code = 'RCV'
718: and msnt.product_transaction_id = l_rti_rec.interface_transaction_id
719: and msn1.serial_number between msnt.fm_serial_number and msnt.to_serial_number

Line 810: mtl_serial_numbers_temp msnt

806: line_mark_id = NULL,
807: lot_line_mark_id = NULL
808: where msn.ROWID in ( select msn1.ROWID
809: from mtl_serial_numbers msn1 ,
810: mtl_serial_numbers_temp msnt
811: where msn1.inventory_item_id = l_rti_rec.item_id
812: and msnt.product_code = 'RCV'
813: and msnt.product_transaction_id = l_rti_rec.interface_transaction_id
814: and msn1.serial_number between msnt.fm_serial_number and msnt.to_serial_number

Line 841: DELETE FROM mtl_serial_numbers_temp

837: DELETE FROM mtl_serial_numbers_interface
838: WHERE product_code = 'RCV'
839: AND product_transaction_id = l_rti_rec.interface_transaction_id;
840:
841: DELETE FROM mtl_serial_numbers_temp
842: WHERE product_code = 'RCV'
843: AND product_transaction_id = l_rti_rec.interface_transaction_id;
844:
845: IF (l_prev_lpn_group_id <> l_rti_rec.lpn_group_id) THEN

Line 1140: -- Delete/Clear mtl_serial_numbers_temp rows

1136: print_debug('rcv_txn_clean_up - Finished clean up : 221',4);
1137: END IF;
1138:
1139:
1140: -- Delete/Clear mtl_serial_numbers_temp rows
1141: -- Delete/Clear mtl_transaction_lots_temp rows
1142: -- If the Transaction Fails
1143:
1144: IF (l_debug = 1) THEN

Line 1149: delete from mtl_serial_numbers_temp msnt

1145: print_debug('TXN_MOBILE_TIMEOUT_CLEANUP - cleanup msnt 1',4);
1146: END IF;
1147:
1148:
1149: delete from mtl_serial_numbers_temp msnt
1150: where msnt.transaction_temp_id in
1151: ( select interface_transaction_id
1152: from rcv_transactions_interface
1153: where group_id = p_group_id )

Line 1160: delete from mtl_serial_numbers_temp msnt

1156: IF (l_debug = 1) THEN
1157: print_debug('TXN_MOBILE_TIMEOUT_CLEANUP - cleanup msnt 2',4);
1158: END IF;
1159:
1160: delete from mtl_serial_numbers_temp msnt
1161: where msnt.transaction_temp_id in
1162: ( select mtlt.serial_transaction_temp_id
1163: from mtl_transaction_lots_temp mtlt
1164: where mtlt.transaction_temp_id in (