DBA Data[Home] [Help]

APPS.EAM_COMMON_UTILITIES_PVT dependencies on EAM_WO_RELATIONSHIPS

Line 3805: FROM eam_wo_relationships

3801: SELECT scheduled_start_date
3802: FROM WIP_DISCRETE_JOBS wdj_child
3803: where wdj_child.wip_entity_id
3804: IN (SELECT child_object_id
3805: FROM eam_wo_relationships
3806: WHERE parent_relationship_type =1
3807: START WITH parent_object_id = p_wip_entity_id
3808: AND parent_relationship_type = 1
3809: CONNECT BY parent_object_id = prior child_object_id

Line 3833: FROM eam_wo_relationships

3829: Select Scheduled_completion_date
3830: from WIP_DISCRETE_JOBS wdj_child
3831: where wdj_child.wip_entity_id
3832: IN (SELECT child_object_id
3833: FROM eam_wo_relationships
3834: WHERE parent_relationship_type =1
3835: START WITH parent_object_id = p_wip_entity_id
3836: AND parent_relationship_type = 1
3837: CONNECT BY parent_object_id = prior child_object_id