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

Line 325: SET object_id = (select gen_object_id from mtl_serial_numbers

321: fnd_file.new_line(FND_FILE.LOG,1);
322: END IF;
323:
324: UPDATE mtl_object_genealogy_interface mogi
325: SET object_id = (select gen_object_id from mtl_serial_numbers
326: where current_organization_id = mogi.organization_id
327: and inventory_item_id = mogi.inventory_item_id
328: and serial_number = mogi.serial_number)
329: WHERE batch_id = p_batch_id

Line 333: SET parent_object_id = (select gen_object_id from mtl_serial_numbers

329: WHERE batch_id = p_batch_id
330: AND process_status = 'P';
331:
332: UPDATE mtl_object_genealogy_interface mogi
333: SET parent_object_id = (select gen_object_id from mtl_serial_numbers
334: where current_organization_id = mogi.parent_organization_id
335: and inventory_item_id = mogi.parent_inventory_item_id
336: and serial_number = mogi.parent_serial_number)
337: WHERE batch_id = p_batch_id