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 513: mtl_serial_numbers_interface msni

509: line_mark_id = NULL,
510: lot_line_mark_id = NULL
511: where msn.ROWID in ( select msn1.ROWID
512: from mtl_serial_numbers msn1 ,
513: mtl_serial_numbers_interface msni
514: where msn1.inventory_item_id = l_rti_rec.item_id
515: and msni.product_code = 'RCV'
516: and msni.product_transaction_id = l_rti_rec.interface_transaction_id
517: and msn1.serial_number between msni.fm_serial_number and msni.to_serial_number

Line 607: mtl_serial_numbers_interface msni

603: line_mark_id = NULL,
604: lot_line_mark_id = NULL
605: where msn.ROWID in ( select msn1.ROWID
606: from mtl_serial_numbers msn1 ,
607: mtl_serial_numbers_interface msni
608: where msn1.inventory_item_id = l_rti_rec.item_id
609: and msni.product_code = 'RCV'
610: and msni.product_transaction_id = l_rti_rec.interface_transaction_id
611: and msn1.serial_number between msni.fm_serial_number and msni.to_serial_number

Line 700: mtl_serial_numbers_interface msni

696: line_mark_id = NULL,
697: lot_line_mark_id = NULL
698: where msn.ROWID in ( select msn1.ROWID
699: from mtl_serial_numbers msn1 ,
700: mtl_serial_numbers_interface msni
701: where msn1.inventory_item_id = l_rti_rec.item_id
702: and msni.product_code = 'RCV'
703: and msni.product_transaction_id = l_rti_rec.interface_transaction_id
704: and msn1.serial_number between msni.fm_serial_number and msni.to_serial_number

Line 795: mtl_serial_numbers_interface msni

791: line_mark_id = NULL,
792: lot_line_mark_id = NULL
793: where msn.ROWID in ( select msn1.ROWID
794: from mtl_serial_numbers msn1 ,
795: mtl_serial_numbers_interface msni
796: where msn1.inventory_item_id = l_rti_rec.item_id
797: and msni.product_code = 'RCV'
798: and msni.product_transaction_id = l_rti_rec.interface_transaction_id
799: and msn1.serial_number between msni.fm_serial_number and msni.to_serial_number

Line 837: DELETE FROM mtl_serial_numbers_interface

833: DELETE FROM mtl_transaction_lots_temp
834: WHERE product_code = 'RCV'
835: AND product_transaction_id = l_rti_rec.interface_transaction_id;
836:
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