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_EAM_GENEALOGY_PVT dependencies on CSI_ITEM_INSTANCES

Line 287: FROM csi_item_instances cii, mtl_parameters mp

283: begin
284:
285: SELECT cii.instance_id, mp.maint_organization_id,cii.instance_number
286: INTO l_parent_instance_id , l_maint_orgid,l_parent_instance_number
287: FROM csi_item_instances cii, mtl_parameters mp
288: WHERE cii.serial_number = l_parent_serial_number
289: AND cii.inventory_item_id = l_parent_inventory_item_id
290: AND cii.last_vld_organization_id = mp.organization_id
291: AND cii.last_vld_organization_id= l_organization_id ;

Line 295: FROM csi_item_instances cii

291: AND cii.last_vld_organization_id= l_organization_id ;
292:
293: SELECT cii.instance_number, cii.instance_id
294: INTO l_reference, l_instance_id
295: FROM csi_item_instances cii
296: WHERE cii.serial_number = l_serial_number
297: AND cii.inventory_item_id = l_inventory_item_id
298: AND cii.last_vld_organization_id = l_organization_id;
299:

Line 765: FROM csi_item_instances cii, mtl_parameters mp

761: --Remove Parent Instance from Child Instance - 17
762: begin
763: SELECT cii.instance_id, mp.maint_organization_id
764: INTO l_instance_id , l_maint_orgid
765: FROM csi_item_instances cii, mtl_parameters mp
766: WHERE cii.serial_number = l_serial_number
767: AND cii.inventory_item_id = l_inventory_item_id
768: AND cii.last_vld_organization_id = mp.organization_id
769: AND cii.last_vld_organization_id= l_organization_id ;

Line 773: FROM csi_item_instances cii, mtl_serial_numbers msn

769: AND cii.last_vld_organization_id= l_organization_id ;
770:
771: SELECT cii.instance_number ,cii.instance_id
772: INTO l_reference, l_parent_instance_id
773: FROM csi_item_instances cii, mtl_serial_numbers msn
774: WHERE cii.serial_number = msn.serial_number
775: AND cii.inventory_item_id = msn.inventory_item_id
776: AND cii.last_vld_organization_id = msn.current_organization_id
777: AND msn.gen_object_id= l_parent_object_id ;

Line 812: FROM csi_item_instances cii, mtl_serial_numbers msn

808: --Remove Child Event from parent - 16
809: begin
810: SELECT cii.instance_id, cii.instance_number
811: INTO l_parent_instance_id, l_parent_instance_number
812: FROM csi_item_instances cii, mtl_serial_numbers msn
813: WHERE cii.serial_number = msn.serial_number
814: AND cii.inventory_item_id = msn.inventory_item_id
815: AND msn.gen_object_id = l_parent_object_id;
816:

Line 819: FROM csi_item_instances cii

815: AND msn.gen_object_id = l_parent_object_id;
816:
817: SELECT cii.instance_number
818: INTO l_reference
819: FROM csi_item_instances cii
820: WHERE cii.instance_id = l_instance_id
821: -- AND cii.inventory_item_id = l_inventory_item_id
822: AND cii.last_vld_organization_id = l_organization_id;
823: