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_ASSET_MOVE_UTIL dependencies on MTL_OBJECT_GENEALOGY

Line 670: SELECT parent_object_id into l_parent_object_id FROM mtl_object_genealogy WHERE object_id =

666:
667: BEGIN
668: --selecting parent_object_id
669: /*
670: SELECT parent_object_id into l_parent_object_id FROM mtl_object_genealogy WHERE object_id =
671: (SELECT gen_object_id FROM mtl_serial_numbers WHERE serial_number =
672: (SELECT serial_number FROM csi_item_instances WHERE instance_id = p_instance_id)
673: )
674: AND parent_object_id IN (SELECT gen_object_id FROM mtl_serial_numbers)

Line 680: FROM mtl_object_genealogy

676: AND Nvl(end_DATE_ACTIVE,SYSDATE+1)>=sysdate ;
677: */ --commented for the bug 7129016
678:
679: SELECT parent_object_id into l_parent_object_id
680: FROM mtl_object_genealogy
681: WHERE object_id =p_gen_object_id
682: AND parent_object_id IN (SELECT gen_object_id FROM mtl_serial_numbers)
683: AND START_DATE_ACTIVE<=SYSDATE
684: AND Nvl(end_DATE_ACTIVE,SYSDATE+1)>=sysdate ;