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_SERIAL_NUMBERS

Line 440: select msn.current_status into l_intransitFlag from mtl_serial_numbers msn,

436: END IF;
437: --Dbms_Output.put_line('Processing isInTransit');
438:
439: BEGIN
440: select msn.current_status into l_intransitFlag from mtl_serial_numbers msn,
441: csi_item_instances cii
442: WHERE cii.INSTANCE_id=p_instance_id
443: AND cii.INVENTORY_ITEM_ID = msn.INVENTORY_ITEM_ID
444: AND cii.SERIAL_NUMBER = msn.SERIAL_NUMBER ;

Line 671: (SELECT gen_object_id FROM mtl_serial_numbers WHERE serial_number =

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)
675: AND START_DATE_ACTIVE<=SYSDATE

Line 674: AND parent_object_id IN (SELECT gen_object_id FROM mtl_serial_numbers)

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)
675: AND START_DATE_ACTIVE<=SYSDATE
676: AND Nvl(end_DATE_ACTIVE,SYSDATE+1)>=sysdate ;
677: */ --commented for the bug 7129016
678:

Line 682: AND parent_object_id IN (SELECT gen_object_id FROM mtl_serial_numbers)

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 ;
685:
686: EXCEPTION

Line 700: from MTL_PARAMETERS mp,csi_item_instances cii, mtl_serial_numbers msn

696: RETURN TRUE;
697: ELSE
698: --Dbms_Output.put_line('searching l_parent_organization_id');
699: select mp.maint_organization_id into l_parent_organization_id
700: from MTL_PARAMETERS mp,csi_item_instances cii, mtl_serial_numbers msn
701: where mp.organization_id=cii.last_vld_organization_id
702: and cii.serial_number=msn.serial_number
703: and cii.INVENTORY_ITEM_ID = msn.INVENTORY_ITEM_ID
704: and cii.last_vld_organization_id = msn.CURRENT_ORGANIZATION_ID