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 19: mtl_serial_numbers msn

15: SELECT msn.lot_number lot,
16: count(msn.lot_number) lot_qty
17: FROM mtl_object_genealogy mog,
18: mtl_material_transactions mmt,
19: mtl_serial_numbers msn
20: WHERE mog.object_id = msn.gen_object_id
21: AND msn.last_transaction_id = mmt.transaction_id
22: AND mog.end_date_active IS NULL
23: AND mog.parent_object_id = p_parentObjID

Line 40: mtl_serial_numbers msn

36: SELECT msn.parent_serial_number parent_serial,
37: msn.serial_number serial
38: FROM mtl_object_genealogy mog,
39: mtl_material_transactions mmt,
40: mtl_serial_numbers msn
41: WHERE mog.object_id = msn.gen_object_id
42: AND msn.last_transaction_id = mmt.transaction_id
43: AND mog.end_date_active IS NULL
44: AND mog.parent_object_id = p_parentObjID

Line 224: mtl_serial_numbers msn

220:
221: SELECT mmt.revision revision
222: FROM mtl_object_genealogy mog,
223: mtl_material_transactions mmt,
224: mtl_serial_numbers msn
225: WHERE mog.object_id = msn.gen_object_id
226: AND msn.last_transaction_id = mmt.transaction_id
227: AND mog.end_date_active IS NULL
228: AND mog.parent_object_id = p_parentObjID