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 1832: from eam_wo_relationships

1828:
1829: ----If constraining relationship exists with rebuild source delete it
1830: select count(*)
1831: into constraining_rel
1832: from eam_wo_relationships
1833: where parent_object_id=l_old_rebuild_source
1834: and child_object_id=l_wip_entity_updt
1835: and parent_relationship_type=1;
1836:

Line 1859: from eam_wo_relationships

1855:
1856:
1857: select count(*)
1858: into followup_rel
1859: from eam_wo_relationships
1860: where parent_object_id=l_old_rebuild_source
1861: and child_object_id=l_wip_entity_updt
1862: and parent_relationship_type=4;
1863:

Line 3298: FROM EAM_WO_RELATIONSHIPS

3294: CURSOR c_work_hierarchy IS
3295: SELECT child_object_id,
3296: parent_object_id,
3297: PARENT_RELATIONSHIP_TYPE
3298: FROM EAM_WO_RELATIONSHIPS
3299: WHERE parent_relationship_type = 1
3300: START WITH parent_object_id = p_wip_entity_id
3301: AND parent_relationship_type = 1
3302: CONNECT BY parent_object_id = PRIOR child_object_id

Line 3406: FROM EAM_WO_RELATIONSHIPS

3402: -- Delete any parent for the current work order having type 3 relationship, to create the new one.
3403:
3404:
3405: SELECT parent_object_id INTO l_parent_object_id
3406: FROM EAM_WO_RELATIONSHIPS
3407: WHERE parent_relationship_type = 3
3408: AND child_object_id = c_hierarchy_row.child_object_id;
3409:
3410: