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

Line 3288: FROM mtl_serial_numbers msn , mtl_serial_numbers_temp msnt

3284: AND msn.lpn_id = l_cur_lpn_id;
3285: CURSOR msnt_cur(l_transaction_temp_id NUMBER)
3286: IS
3287: SELECT msn.status_id
3288: FROM mtl_serial_numbers msn , mtl_serial_numbers_temp msnt
3289: WHERE msnt.transaction_temp_id = l_transaction_temp_id
3290: AND msn.serial_number BETWEEN msnt.fm_serial_number AND msnt.to_serial_number;
3291:
3292:

Line 3802: FROM mtl_serial_numbers msn , mtl_serial_numbers_temp msnt

3798:
3799: CURSOR msnt_cur(l_transaction_temp_id NUMBER)
3800: IS
3801: SELECT msn.status_id
3802: FROM mtl_serial_numbers msn , mtl_serial_numbers_temp msnt
3803: WHERE msnt.transaction_temp_id = l_transaction_temp_id
3804: AND msn.serial_number BETWEEN msnt.fm_serial_number AND msnt.to_serial_number;
3805:
3806:

Line 3810: -- FROM mtl_serial_numbers msn , mtl_serial_numbers_temp msnt

3806:
3807: -- CURSOR msnt_cur(l_transaction_temp_id NUMBER)
3808: -- IS
3809: -- SELECT msn.status_id
3810: -- FROM mtl_serial_numbers msn , mtl_serial_numbers_temp msnt
3811: -- WHERE msnt.transaction_temp_id = l_transaction_temp_id
3812: -- AND msn.serial_number BETWEEN msnt.fm_serial_number AND msnt.to_serial_number;
3813: BEGIN
3814: IF(g_debug = 1)THEN