APPS.EAM_WORKORDERS_JSP dependencies on EAM_WO_RELATIONSHIPS

Line 286: FROM eam_wo_relationships

282: FROM wip_discrete_jobs
283: WHERE wip_entity_id IN
284: (
285: SELECT DISTINCT child_object_id
286: FROM eam_wo_relationships
287: WHERE parent_relationship_type =1
288: START WITH parent_object_id = p_wip_entity_id AND parent_relationship_type = 1
289: CONNECT BY parent_object_id = prior child_object_id AND parent_relationship_type = 1
290: )

Line 315: FROM EAM_WO_RELATIONSHIPS ewr,WIP_DISCRETE_JOBS wdj

311: SELECT '1'
312: INTO dependent_rel
313: FROM DUAL
314: WHERE EXISTS (SELECT ewr.child_object_id
315: FROM EAM_WO_RELATIONSHIPS ewr,WIP_DISCRETE_JOBS wdj
316: WHERE ewr.parent_object_id=p_wip_entity_id AND ewr.parent_relationship_type = 2
317: AND wdj.wip_entity_id=ewr.child_object_id AND (wo_released=1 OR wdj.status_type=3)
318: UNION
319: SELECT ewr.parent_object_id

Line 320: FROM EAM_WO_RELATIONSHIPS ewr,WIP_DISCRETE_JOBS wdj

316: WHERE ewr.parent_object_id=p_wip_entity_id AND ewr.parent_relationship_type = 2
317: AND wdj.wip_entity_id=ewr.child_object_id AND (wo_released=1 OR wdj.status_type=3)
318: UNION
319: SELECT ewr.parent_object_id
320: FROM EAM_WO_RELATIONSHIPS ewr,WIP_DISCRETE_JOBS wdj
321: WHERE ewr.child_object_id=p_wip_entity_id AND ewr.parent_relationship_type = 2
322: AND wdj.wip_entity_id=ewr.parent_object_id AND (wo_released=1 OR wdj.status_type=3)
323: );
324: exception

Line 1863: from eam_wo_relationships

1859:
1860: ----If constraining relationship exists with rebuild source delete it
1861: select count(*)
1862: into constraining_rel
1863: from eam_wo_relationships
1864: where parent_object_id=l_old_rebuild_source
1865: and child_object_id=l_wip_entity_updt
1866: and parent_relationship_type=1;
1867:

Line 1890: from eam_wo_relationships

1886:
1887:
1888: select count(*)
1889: into followup_rel
1890: from eam_wo_relationships
1891: where parent_object_id=l_old_rebuild_source
1892: and child_object_id=l_wip_entity_updt
1893: and parent_relationship_type=4;
1894:

Line 3337: FROM EAM_WO_RELATIONSHIPS

3333: CURSOR c_work_hierarchy IS
3334: SELECT child_object_id,
3335: parent_object_id,
3336: PARENT_RELATIONSHIP_TYPE
3337: FROM EAM_WO_RELATIONSHIPS
3338: WHERE parent_relationship_type = 1
3339: START WITH parent_object_id = p_wip_entity_id
3340: AND parent_relationship_type = 1
3341: CONNECT BY parent_object_id = PRIOR child_object_id

Line 3445: FROM EAM_WO_RELATIONSHIPS

3441: -- Delete any parent for the current work order having type 3 relationship, to create the new one.
3442:
3443:
3444: SELECT parent_object_id INTO l_parent_object_id
3445: FROM EAM_WO_RELATIONSHIPS
3446: WHERE parent_relationship_type = 3
3447: AND child_object_id = c_hierarchy_row.child_object_id;
3448:
3449: