DBA Data[Home] [Help]

APPS.AHL_PRD_NONROUTINE_PVT dependencies on WIP_SCHED_RELATIONSHIPS

Line 2595: FROM wip_sched_relationships rel START

2591: FROM ahl_workorders
2592: WHERE MASTER_WORKORDER_FLAG = 'N'
2593: AND wip_entity_id in
2594: (SELECT rel.child_object_id
2595: FROM wip_sched_relationships rel START
2596: WITH REL.parent_object_id = (SELECT wip_entity_id FROM ahl_workorders WHERE workorder_id = p_nr_wo_id)
2597: CONNECT BY REL.parent_object_id = PRIOR REL.child_object_id
2598: AND REL.parent_object_type_id = PRIOR REL.child_object_type_id
2599: AND REL.relationship_type = 1