APPS.INV_EBI_CHANGE_ORDER_HELPER dependencies on ENG_CHANGE_STATUSES_VL

Line 2716: FROM eng_change_statuses_vl

2712: BEGIN
2713:
2714: SELECT status_name
2715: INTO l_status_name
2716: FROM eng_change_statuses_vl
2717: WHERE status_code = p_status_code;
2718:
2719: RETURN l_status_name;
2720: EXCEPTION

Line 2841: FROM eng_change_statuses_vl

2837: BEGIN
2838: IF (l_is_wf_Set) THEN
2839: SELECT status_name, status_type
2840: INTO l_eco_rec.status_name, l_status_type
2841: FROM eng_change_statuses_vl
2842: WHERE status_code = 1; -- ECO Status Set to 'Open';
2843: l_eco_rec.approval_status_name := get_status_name(p_lookup_type => 'ENG_ECN_APPROVAL_STATUS'
2844: ,p_lookup_code => 1 ); -- Not submitted for approval
2845: ELSE

Line 2850: FROM eng_change_statuses_vl

2846: l_eco_rec.status_name := l_status_name;
2847: IF (l_eco_rec.status_name = 'Implemented' ) THEN
2848: SELECT status_name, status_type
2849: INTO l_eco_rec.status_name, l_status_type
2850: FROM eng_change_statuses_vl
2851: WHERE status_code = 4; -- Scheduled
2852: END IF;
2853: l_eco_rec.approval_status_name := get_status_name(p_lookup_type => 'ENG_ECN_APPROVAL_STATUS'
2854: ,p_lookup_code => 5 ); -- Approved

Line 4199: ,eng_change_statuses_vl ecsv

4195: ,ecot.type_name
4196: FROM
4197: eng_engineering_changes eec
4198: ,mtl_parameters mp
4199: ,eng_change_statuses_vl ecsv
4200: ,eng_ecn_approval_lists eeal
4201: ,hz_parties hp
4202: ,pa_projects_all ppa
4203: ,pa_proj_elements ppe