APPS.INV_EBI_CHANGE_ORDER_HELPER dependencies on ENG_CHANGE_STATUSES_VL

Line 3551: FROM eng_change_statuses_vl

3547: BEGIN
3548:
3549: SELECT status_name
3550: INTO l_status_name
3551: FROM eng_change_statuses_vl
3552: WHERE status_code = p_status_code;
3553:
3554: RETURN l_status_name;
3555: EXCEPTION

Line 4278: FROM eng_change_statuses_vl

4274: BEGIN
4275: IF (l_is_wf_Set) THEN
4276: SELECT status_name, status_type
4277: INTO l_eco_rec.status_name, l_status_type
4278: FROM eng_change_statuses_vl
4279: WHERE status_code = 1; -- ECO Status Set to 'Open';
4280: l_eco_rec.approval_status_name := get_status_name(p_lookup_type => 'ENG_ECN_APPROVAL_STATUS'
4281: ,p_lookup_code => 1 ); -- Not submitted for approval
4282: ELSE

Line 4287: FROM eng_change_statuses_vl

4283: l_eco_rec.status_name := l_status_name;
4284: IF (l_eco_rec.status_name = 'Implemented' ) THEN
4285: SELECT status_name, status_type
4286: INTO l_eco_rec.status_name, l_status_type
4287: FROM eng_change_statuses_vl
4288: WHERE status_code = 4; -- Scheduled
4289: END IF;
4290: l_eco_rec.approval_status_name := get_status_name(p_lookup_type => 'ENG_ECN_APPROVAL_STATUS'
4291: ,p_lookup_code => 5 ); -- Approved

Line 5142: ,eng_change_statuses_vl ecsv

5138: ,ecot.type_name
5139: FROM
5140: eng_engineering_changes eec
5141: ,mtl_parameters mp
5142: ,eng_change_statuses_vl ecsv
5143: ,eng_ecn_approval_lists eeal
5144: ,hz_parties hp
5145: ,pa_projects_all ppa
5146: ,pa_proj_elements ppe