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