APPS.AMW_FINDINGS_PKG dependencies on ENG_CHANGE_SUBJECTS

Line 23: from eng_change_subjects ecs_self, eng_engineering_changes eec

19: begin
20:
21: select count ( ecs_self.change_id )
22: into ofcount
23: from eng_change_subjects ecs_self, eng_engineering_changes eec
24: where ecs_self.change_id = eec.change_id
25: and ecs_self.entity_name = self_entity_name
26: and ecs_self.pk1_value = self_pk1_value
27: and ecs_self.subject_level = 1

Line 33: and exists ( select change_id from eng_change_subjects ecs_par1

29: and eec.organization_id = -1
30: and eec.status_type = 1
31: and eec.change_mgmt_type_code = findings_category
32:
33: and exists ( select change_id from eng_change_subjects ecs_par1
34: where ecs_par1.change_id = ecs_self.change_id
35: and ecs_par1.entity_name = nvl ( parent1_entity_name, self_entity_name )
36: and ecs_par1.pk1_value = nvl ( parent1_pk1_value, self_pk1_value )
37: and ecs_par1.subject_level = decode ( parent1_entity_name, NULL, 1, 2 ) )

Line 39: and exists ( select change_id from eng_change_subjects ecs_par2

35: and ecs_par1.entity_name = nvl ( parent1_entity_name, self_entity_name )
36: and ecs_par1.pk1_value = nvl ( parent1_pk1_value, self_pk1_value )
37: and ecs_par1.subject_level = decode ( parent1_entity_name, NULL, 1, 2 ) )
38:
39: and exists ( select change_id from eng_change_subjects ecs_par2
40: where ecs_par2.change_id = ecs_self.change_id
41: and ecs_par2.entity_name = nvl ( parent2_entity_name, self_entity_name )
42: and ecs_par2.pk1_value = nvl ( parent2_pk1_value, self_pk1_value )
43: and ecs_par2.subject_level = decode ( parent2_entity_name, NULL, 1, 3 ) )

Line 45: and exists ( select change_id from eng_change_subjects ecs_par3

41: and ecs_par2.entity_name = nvl ( parent2_entity_name, self_entity_name )
42: and ecs_par2.pk1_value = nvl ( parent2_pk1_value, self_pk1_value )
43: and ecs_par2.subject_level = decode ( parent2_entity_name, NULL, 1, 3 ) )
44:
45: and exists ( select change_id from eng_change_subjects ecs_par3
46: where ecs_par3.change_id = ecs_self.change_id
47: and ecs_par3.entity_name = nvl ( parent3_entity_name, self_entity_name )
48: and ecs_par3.pk1_value = nvl ( parent3_pk1_value, self_pk1_value )
49: and ecs_par3.subject_level = decode ( parent3_entity_name, NULL, 1, 4 ) )

Line 51: and exists ( select change_id from eng_change_subjects ecs_par4

47: and ecs_par3.entity_name = nvl ( parent3_entity_name, self_entity_name )
48: and ecs_par3.pk1_value = nvl ( parent3_pk1_value, self_pk1_value )
49: and ecs_par3.subject_level = decode ( parent3_entity_name, NULL, 1, 4 ) )
50:
51: and exists ( select change_id from eng_change_subjects ecs_par4
52: where ecs_par4.change_id = ecs_self.change_id
53: and ecs_par4.entity_name = nvl ( parent4_entity_name, self_entity_name )
54: and ecs_par4.pk1_value = nvl ( parent4_pk1_value, self_pk1_value )
55: and ecs_par4.subject_level = decode ( parent4_entity_name, NULL, 1, 5 ) );