DBA Data[Home] [Help]

APPS.EAM_WO_COMP_VALIDATE_PVT dependencies on EAM_WO_RELATIONSHIPS

Line 881: FROM eam_wo_relationships

877: FROM wip_discrete_jobs
878: WHERE wip_entity_id IN
879: (
880: SELECT DISTINCT child_object_id
881: FROM eam_wo_relationships
882: WHERE parent_relationship_type =1
883: START WITH parent_object_id = p_eam_wo_comp_rec.wip_entity_id AND parent_relationship_type = 1
884: CONNECT BY parent_object_id = prior child_object_id AND parent_relationship_type = 1
885: )

Line 930: FROM eam_wo_relationships

926: FROM wip_discrete_jobs
927: WHERE wip_entity_id IN
928: (
929: SELECT DISTINCT parent_object_id
930: FROM eam_wo_relationships
931: WHERE parent_relationship_type =2 and
932: child_object_id = p_eam_wo_comp_rec.wip_entity_id
933: )
934: AND status_type NOT IN (WIP_CONSTANTS.COMP_CHRG,