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 2433: FROM mtl_serial_numbers

2429: THEN
2430: --Bug8329454
2431: SELECT lot_number,revision
2432: INTO l_lot_number,l_revision
2433: FROM mtl_serial_numbers
2434: WHERE current_organization_id = p_organization_id
2435: AND inventory_item_id = p_inventory_item_id
2436: AND serial_number = l_range_serial_numbers(i);
2437:

Line 3946: FROM mtl_serial_numbers_temp msnt , mtl_serial_numbers msn

3942: ORDER BY wlc.serial_summary_entry DESC ;
3943:
3944: CURSOR msnt_cur is
3945: SELECT msnt.status_id status_id
3946: FROM mtl_serial_numbers_temp msnt , mtl_serial_numbers msn
3947: WHERE msnt.transaction_temp_id = p_transaction_id
3948: AND msnt.status_id is not null
3949: UNION
3950: SELECT msn.status_id status_id

Line 3951: FROM mtl_serial_numbers_temp msnt , mtl_serial_numbers msn

3947: WHERE msnt.transaction_temp_id = p_transaction_id
3948: AND msnt.status_id is not null
3949: UNION
3950: SELECT msn.status_id status_id
3951: FROM mtl_serial_numbers_temp msnt , mtl_serial_numbers msn
3952: WHERE msnt.transaction_temp_id = p_transaction_id
3953: AND msn.serial_number BETWEEN msnt.fm_serial_number AND msnt.to_serial_number
3954: AND msn.current_organization_id = p_organization_id
3955: AND msnt.status_id is NULL;

Line 3959: FROM mtl_serial_numbers msn

3955: AND msnt.status_id is NULL;
3956:
3957: CURSOR msn_cur(l_lpn_id NUMBER) IS
3958: SELECT status_id
3959: FROM mtl_serial_numbers msn
3960: WHERE msn.lpn_id = l_lpn_id
3961: AND msn.current_organization_id = p_organization_id
3962: AND serial_number not in (select serial_number from
3963: mtl_serial_numbers msn1,mtl_serial_numbers_temp msnt

Line 3963: mtl_serial_numbers msn1,mtl_serial_numbers_temp msnt

3959: FROM mtl_serial_numbers msn
3960: WHERE msn.lpn_id = l_lpn_id
3961: AND msn.current_organization_id = p_organization_id
3962: AND serial_number not in (select serial_number from
3963: mtl_serial_numbers msn1,mtl_serial_numbers_temp msnt
3964: where msnt.transaction_temp_id = p_transaction_id
3965: and msn1.serial_number BETWEEN msnt.fm_serial_number AND msnt.to_serial_number);
3966:
3967: CURSOR mmtt_cur(l_inventory_item_id NUMBER , l_lot_number VARCHAR2) IS