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 22: FROM mtl_object_genealogy mog,

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

Line 43: FROM mtl_object_genealogy mog,

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

Line 227: FROM mtl_object_genealogy mog,

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