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.WIP_AUTOSERIALPROC_PRIV dependencies on MTL_SERIAL_NUMBERS

Line 24: mtl_serial_numbers msn

20: SELECT msn.lot_number lot,
21: count(msn.lot_number) lot_qty
22: FROM mtl_object_genealogy mog,
23: mtl_material_transactions mmt,
24: mtl_serial_numbers msn
25: WHERE mog.object_id = msn.gen_object_id
26: AND msn.last_transaction_id = mmt.transaction_id
27: AND mog.end_date_active IS NULL
28: AND mog.parent_object_id = p_parentObjID

Line 45: mtl_serial_numbers msn

41: SELECT msn.parent_serial_number parent_serial,
42: msn.serial_number serial
43: FROM mtl_object_genealogy mog,
44: mtl_material_transactions mmt,
45: mtl_serial_numbers msn
46: WHERE mog.object_id = msn.gen_object_id
47: AND msn.last_transaction_id = mmt.transaction_id
48: AND mog.end_date_active IS NULL
49: AND mog.parent_object_id = p_parentObjID

Line 229: mtl_serial_numbers msn

225:
226: SELECT mmt.revision revision
227: FROM mtl_object_genealogy mog,
228: mtl_material_transactions mmt,
229: mtl_serial_numbers msn
230: WHERE mog.object_id = msn.gen_object_id
231: AND msn.last_transaction_id = mmt.transaction_id
232: AND mog.end_date_active IS NULL
233: AND mog.parent_object_id = p_parentObjID