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_WO_NETWORK_DEFAULT_PVT dependencies on EAM_WO_RELATIONSHIPS

Line 192: from eam_wo_relationships where

188: -- I am commenting this out because as per latest design
189: -- on 08/26/2003, we can have 2 relationships for the same
190: -- set of work orders. For eg. type 1 and 3
191: /*select count(*) into l_count
192: from eam_wo_relationships where
193: child_object_id = l_child_object_id
194: and child_object_type_id = l_child_object_type_id
195: and parent_object_id = l_parent_object_id
196: and parent_object_type_id = l_parent_object_type_id;

Line 289: from eam_wo_relationships where

285: -- Check that the Child does not already have an existing relation
286: -- of the same type that is being created currently.
287: if l_parent_maint_obj_src = 1 then -- EAM
288: select count(*) into l_count
289: from eam_wo_relationships where
290: child_object_id = l_child_object_id
291: and child_object_type_id = l_child_object_type_id
292: and parent_relationship_type = l_relationship_type;
293: elsif l_parent_maint_obj_src = 2 then -- CMRO

Line 412: select eam_wo_relationships_s.nextval

408: return;
409: end if;
410:
411: -- insert the type 3 relationship first
412: select eam_wo_relationships_s.nextval
413: into l_wo_relationship_id from dual;
414: insert into eam_wo_relationships
415: ( wo_relationship_id,
416: parent_object_id,

Line 414: insert into eam_wo_relationships

410:
411: -- insert the type 3 relationship first
412: select eam_wo_relationships_s.nextval
413: into l_wo_relationship_id from dual;
414: insert into eam_wo_relationships
415: ( wo_relationship_id,
416: parent_object_id,
417: parent_object_type_id,
418: child_object_id,

Line 483: select eam_wo_relationships_s.nextval

479:
480: end if;
481:
482:
483: select eam_wo_relationships_s.nextval
484: into l_wo_relationship_id from dual;
485: insert into eam_wo_relationships
486: ( wo_relationship_id,
487: parent_object_id,

Line 485: insert into eam_wo_relationships

481:
482:
483: select eam_wo_relationships_s.nextval
484: into l_wo_relationship_id from dual;
485: insert into eam_wo_relationships
486: ( wo_relationship_id,
487: parent_object_id,
488: parent_object_type_id,
489: child_object_id,

Line 566: update eam_wo_relationships set

562:
563: select maintenance_object_source into l_maint_obj_src
564: from wip_discrete_jobs where wip_entity_id = l_relationship_record.parent_object_id;*/
565:
566: update eam_wo_relationships set
567: top_level_object_id = l_top_level_object_id,
568: top_level_object_type_id = l_top_level_object_type_id
569: where
570: parent_object_id = l_relationship_record.parent_object_id

Line 588: select eam_wo_relationships_s.nextval

584:
585: elsif l_relationship_type = 4 then -- Follow up
586:
587:
588: select eam_wo_relationships_s.nextval
589: into l_wo_relationship_id from dual;
590: insert into eam_wo_relationships
591: ( wo_relationship_id,
592: parent_object_id,

Line 590: insert into eam_wo_relationships

586:
587:
588: select eam_wo_relationships_s.nextval
589: into l_wo_relationship_id from dual;
590: insert into eam_wo_relationships
591: ( wo_relationship_id,
592: parent_object_id,
593: parent_object_type_id,
594: child_object_id,

Line 1184: DELETE from EAM_WO_RELATIONSHIPS

1180: return;
1181:
1182: end if;
1183:
1184: DELETE from EAM_WO_RELATIONSHIPS
1185: where parent_object_id = l_prior_object_id
1186: and parent_object_type_id = l_prior_object_type_id
1187: and child_object_id = l_next_object_id
1188: and child_object_type_id = l_next_object_type_id

Line 1540: select eam_wo_relationships_s.nextval

1536:
1537: end if;
1538:
1539:
1540: select eam_wo_relationships_s.nextval
1541: into l_wo_relationship_id from dual;
1542: insert into eam_wo_relationships
1543: ( wo_relationship_id,
1544: parent_object_id,

Line 1542: insert into eam_wo_relationships

1538:
1539:
1540: select eam_wo_relationships_s.nextval
1541: into l_wo_relationship_id from dual;
1542: insert into eam_wo_relationships
1543: ( wo_relationship_id,
1544: parent_object_id,
1545: parent_object_type_id,
1546: child_object_id,

Line 1744: delete from eam_wo_relationships where

1740: end if;
1741:
1742: if l_count = 0 then
1743:
1744: delete from eam_wo_relationships where
1745: child_object_id = l_child_object_id
1746: and child_object_type_id = l_child_object_type_id
1747: and parent_object_id = l_parent_object_id
1748: and parent_object_type_id = l_parent_object_type_id

Line 1889: update eam_wo_relationships set

1885:
1886: select maintenance_object_source into l_maint_obj_src
1887: from wip_discrete_jobs where wip_entity_id = l_relationship_record.parent_object_id;
1888: if l_maint_obj_src = 1 then -- EAM
1889: update eam_wo_relationships set
1890: top_level_object_id = l_child_object_id,
1891: top_level_object_type_id = l_child_object_type_id
1892: where
1893: parent_object_id = l_relationship_record.parent_object_id