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_OBJECT_GENEALOGY

Line 17: FROM mtl_object_genealogy mog,

13: p_opSeqNum NUMBER) IS
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

Line 38: FROM mtl_object_genealogy mog,

34: p_lotNumber VARCHAR2) IS
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

Line 222: FROM mtl_object_genealogy mog,

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