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_TEMP

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 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