APPS.EAM_WO_IMPORT_DS_PVT dependencies on WIP_SCHED_RELATIONSHIPS

Line 462: FROM WIP_SCHED_RELATIONSHIPS wsr

458: -- Update the rows and set the value of top_wip_entity_id
459: UPDATE EAM_WORK_ORDER_IMPORT ewoi
460: SET top_wip_entity_id = (
461: SELECT distinct wsr.top_level_object_id
462: FROM WIP_SCHED_RELATIONSHIPS wsr
463: WHERE wsr.relationship_type =1
464: AND (ewoi.wip_entity_id = wsr.child_object_id OR ewoi.wip_entity_id = wsr.parent_object_id)
465: )
466: WHERE process_status = 2;