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_LABEL dependencies on MTL_SERIAL_NUMBERS

Line 2364: FROM mtl_serial_numbers

2360: AND (p_lot_number is null or p_lot_number='')
2361: AND (l_lot_control_code <> 1) THEN
2362: SELECT lot_number
2363: INTO l_lot_number
2364: FROM mtl_serial_numbers
2365: WHERE current_organization_id = p_organization_id
2366: AND inventory_item_id = p_inventory_item_id
2367: AND serial_number = l_range_serial_numbers(i);
2368:

Line 3847: FROM mtl_serial_numbers_temp msnt , mtl_serial_numbers msn

3843: ORDER BY wlc.serial_summary_entry DESC ;
3844:
3845: CURSOR msnt_cur is
3846: SELECT msnt.status_id status_id
3847: FROM mtl_serial_numbers_temp msnt , mtl_serial_numbers msn
3848: WHERE msnt.transaction_temp_id = p_transaction_id
3849: AND msnt.status_id is not null
3850: UNION
3851: SELECT msn.status_id status_id

Line 3852: FROM mtl_serial_numbers_temp msnt , mtl_serial_numbers msn

3848: WHERE msnt.transaction_temp_id = p_transaction_id
3849: AND msnt.status_id is not null
3850: UNION
3851: SELECT msn.status_id status_id
3852: FROM mtl_serial_numbers_temp msnt , mtl_serial_numbers msn
3853: WHERE msnt.transaction_temp_id = p_transaction_id
3854: AND msn.serial_number BETWEEN msnt.fm_serial_number AND msnt.to_serial_number
3855: AND msn.current_organization_id = p_organization_id
3856: AND msnt.status_id is NULL;

Line 3860: FROM mtl_serial_numbers msn

3856: AND msnt.status_id is NULL;
3857:
3858: CURSOR msn_cur(l_lpn_id NUMBER) IS
3859: SELECT status_id
3860: FROM mtl_serial_numbers msn
3861: WHERE msn.lpn_id = l_lpn_id
3862: AND msn.current_organization_id = p_organization_id
3863: AND serial_number not in (select serial_number from
3864: mtl_serial_numbers msn1,mtl_serial_numbers_temp msnt

Line 3864: mtl_serial_numbers msn1,mtl_serial_numbers_temp msnt

3860: FROM mtl_serial_numbers msn
3861: WHERE msn.lpn_id = l_lpn_id
3862: AND msn.current_organization_id = p_organization_id
3863: AND serial_number not in (select serial_number from
3864: mtl_serial_numbers msn1,mtl_serial_numbers_temp msnt
3865: where msnt.transaction_temp_id = p_transaction_id
3866: and msn1.serial_number BETWEEN msnt.fm_serial_number AND msnt.to_serial_number);
3867:
3868: CURSOR mmtt_cur(l_inventory_item_id NUMBER , l_lot_number VARCHAR2) IS