[Home] [Help]
373: IS
374: SELECT parent_object_id,
375: child_object_id,
376: level
377: FROM WIP_SCHED_RELATIONSHIPS
378: WHERE parent_object_type_id = 1
379: AND child_object_type_id = 1
380: AND not exists (select 1 from ahl_workorders awo1
381: where awo1.wip_entity_id = parent_object_id