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_MATERIAL_TRANSACTIONS

Line 18: mtl_material_transactions mmt,

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

Line 39: mtl_material_transactions mmt,

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

Line 223: mtl_material_transactions mmt,

219: CURSOR c_revisionComp IS
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