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 2757: FROM mtl_serial_numbers msn , mtl_serial_numbers_temp msnt

2753: AND msn.lpn_id = l_cur_lpn_id;
2754: CURSOR msnt_cur(l_transaction_temp_id NUMBER)
2755: IS
2756: SELECT msn.status_id
2757: FROM mtl_serial_numbers msn , mtl_serial_numbers_temp msnt
2758: WHERE msnt.transaction_temp_id = l_transaction_temp_id
2759: AND msn.serial_number BETWEEN msnt.fm_serial_number AND msnt.to_serial_number;
2760:
2761:

Line 3266: FROM mtl_serial_numbers msn , mtl_serial_numbers_temp msnt

3262:
3263: CURSOR msnt_cur(l_transaction_temp_id NUMBER)
3264: IS
3265: SELECT msn.status_id
3266: FROM mtl_serial_numbers msn , mtl_serial_numbers_temp msnt
3267: WHERE msnt.transaction_temp_id = l_transaction_temp_id
3268: AND msn.serial_number BETWEEN msnt.fm_serial_number AND msnt.to_serial_number;
3269:
3270:

Line 3274: -- FROM mtl_serial_numbers msn , mtl_serial_numbers_temp msnt

3270:
3271: -- CURSOR msnt_cur(l_transaction_temp_id NUMBER)
3272: -- IS
3273: -- SELECT msn.status_id
3274: -- FROM mtl_serial_numbers msn , mtl_serial_numbers_temp msnt
3275: -- WHERE msnt.transaction_temp_id = l_transaction_temp_id
3276: -- AND msn.serial_number BETWEEN msnt.fm_serial_number AND msnt.to_serial_number;
3277: BEGIN
3278: IF(g_debug = 1)THEN