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_INTERFACE

Line 528: mtl_serial_numbers_interface msni

524: current_status = (CASE WHEN Nvl(previous_status,-1) < 0 THEN current_status ELSE previous_status END),
525: lot_line_mark_id = NULL
526: where msn.ROWID in ( select msn1.ROWID
527: from mtl_serial_numbers msn1 ,
528: mtl_serial_numbers_interface msni
529: where msn1.inventory_item_id = l_rti_rec.item_id
530: and msni.product_code = 'RCV'
531: and msni.product_transaction_id = l_rti_rec.interface_transaction_id
532: and msn1.serial_number between msni.fm_serial_number and msni.to_serial_number

Line 566: mtl_serial_numbers_interface msni

562: last_updated_by = fnd_global.user_id,
563: lot_line_mark_id = NULL
564: where msn.ROWID in ( select msn1.ROWID
565: from mtl_serial_numbers msn1 ,
566: mtl_serial_numbers_interface msni
567: where msn1.inventory_item_id = l_rti_rec.item_id
568: and msni.product_code = 'RCV'
569: and msni.product_transaction_id = l_rti_rec.interface_transaction_id
570: and msn1.serial_number between msni.fm_serial_number and msni.to_serial_number

Line 681: mtl_serial_numbers_interface msni

677: lot_line_mark_id = NULL
678:
679: where msn.ROWID in ( select msn1.ROWID
680: from mtl_serial_numbers msn1 ,
681: mtl_serial_numbers_interface msni
682: where msn1.inventory_item_id = l_rti_rec.item_id
683: and msni.product_code = 'RCV'
684: and msni.product_transaction_id = l_rti_rec.interface_transaction_id
685: and msn1.serial_number between msni.fm_serial_number and msni.to_serial_number

Line 723: mtl_serial_numbers_interface msni

719: last_updated_by = fnd_global.user_id,
720: lot_line_mark_id = NULL
721: where msn.ROWID in ( select msn1.ROWID
722: from mtl_serial_numbers msn1 ,
723: mtl_serial_numbers_interface msni
724: where msn1.inventory_item_id = l_rti_rec.item_id
725: and msni.product_code = 'RCV'
726: and msni.product_transaction_id = l_rti_rec.interface_transaction_id
727: and msn1.serial_number between msni.fm_serial_number and msni.to_serial_number

Line 835: mtl_serial_numbers_interface msni

831: lot_line_mark_id = NULL
832:
833: where msn.ROWID in ( select msn1.ROWID
834: from mtl_serial_numbers msn1 ,
835: mtl_serial_numbers_interface msni
836: where msn1.inventory_item_id = l_rti_rec.item_id
837: and msni.product_code = 'RCV'
838: and msni.product_transaction_id = l_rti_rec.interface_transaction_id
839: and msn1.serial_number between msni.fm_serial_number and msni.to_serial_number

Line 877: mtl_serial_numbers_interface msni

873: last_updated_by = fnd_global.user_id,
874: lot_line_mark_id = NULL
875: where msn.ROWID in ( select msn1.ROWID
876: from mtl_serial_numbers msn1 ,
877: mtl_serial_numbers_interface msni
878: where msn1.inventory_item_id = l_rti_rec.item_id
879: and msni.product_code = 'RCV'
880: and msni.product_transaction_id = l_rti_rec.interface_transaction_id
881: and msn1.serial_number between msni.fm_serial_number and msni.to_serial_number

Line 990: mtl_serial_numbers_interface msni

986: current_status = (CASE WHEN Nvl(previous_status,-1) < 0 THEN current_status ELSE previous_status END),
987: lot_line_mark_id = NULL
988: where msn.ROWID in ( select msn1.ROWID
989: from mtl_serial_numbers msn1 ,
990: mtl_serial_numbers_interface msni
991: where msn1.inventory_item_id = l_rti_rec.item_id
992: and msni.product_code = 'RCV'
993: and msni.product_transaction_id = l_rti_rec.interface_transaction_id
994: and msn1.serial_number between msni.fm_serial_number and msni.to_serial_number

Line 1032: mtl_serial_numbers_interface msni

1028: last_updated_by = fnd_global.user_id,
1029: lot_line_mark_id = NULL
1030: where msn.ROWID in ( select msn1.ROWID
1031: from mtl_serial_numbers msn1 ,
1032: mtl_serial_numbers_interface msni
1033: where msn1.inventory_item_id = l_rti_rec.item_id
1034: and msni.product_code = 'RCV'
1035: and msni.product_transaction_id = l_rti_rec.interface_transaction_id
1036: and msn1.serial_number between msni.fm_serial_number and msni.to_serial_number

Line 1079: DELETE FROM mtl_serial_numbers_interface

1075: DELETE FROM mtl_transaction_lots_temp
1076: WHERE product_code = 'RCV'
1077: AND product_transaction_id = l_rti_rec.interface_transaction_id;
1078:
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