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_PVT10 dependencies on MTL_SERIAL_NUMBERS_INTERFACE

Line 2220: mtl_serial_numbers_interface msni, mtl_serial_numbers msn

2216: CURSOR mti_serial_curs(p_lot_number VARCHAR2) IS
2217: -- Serial Control
2218: SELECT msn.serial_number
2219: FROM mtl_transactions_interface mti,
2220: mtl_serial_numbers_interface msni, mtl_serial_numbers msn
2221: where mti.transaction_interface_id =msni.transaction_interface_id
2222: and msni.fm_serial_number <= msn.serial_number AND
2223: msni.to_serial_number >= msn.serial_number
2224: and mti.organization_id = msn.current_organization_id

Line 2231: mtl_serial_numbers_interface msni, mtl_serial_numbers msn

2227: UNION
2228: -- Lot and Serial Control
2229: SELECT msn.serial_number
2230: FROM mtl_transactions_interface mti, mtl_transaction_lots_interface mtli,
2231: mtl_serial_numbers_interface msni, mtl_serial_numbers msn
2232: where mti.transaction_interface_id = mtli.transaction_interface_id
2233: and mtli.serial_transaction_temp_id = msni.transaction_interface_id
2234: and msni.fm_serial_number <= msn.serial_number AND
2235: msni.to_serial_number >= msn.serial_number