APPS.ENGECOBO dependencies on ENG_CHANGE_STATUSES_VL

Line 1816: l_eco_status_name eng_change_statuses_vl.status_name%TYPE; -- bug 3571079

1812: l_old_effectivity_date DATE;
1813: component_seq_id NUMBER;
1814: St_Number NUMBER;
1815:
1816: l_eco_status_name eng_change_statuses_vl.status_name%TYPE; -- bug 3571079
1817:
1818: -- Added for Bug-5725081
1819:
1820: v_component_quantity_to NUMBER ;

Line 2173: FROM eng_change_statuses_vl

2169: -- Fetch the status corresponding to status_code =4 i.e 'Scheduled'
2170: BEGIN
2171: SELECT status_name
2172: INTO l_eco_status_name
2173: FROM eng_change_statuses_vl
2174: WHERE status_code = l_status_type;
2175: EXCEPTION
2176: WHEN OTHERS THEN
2177: l_eco_status_name := eco_rec.eco_status;

Line 4103: FROM eng_lifecycle_statuses els1, eng_change_statuses_vl ecs1

4099: WHERE els.entity_id1 = p_local_change_id
4100: AND els.entity_name = 'ENG_CHANGE'
4101: AND els.sequence_number =
4102: (SELECT min(sequence_number)
4103: FROM eng_lifecycle_statuses els1, eng_change_statuses_vl ecs1
4104: WHERE els1.entity_id1 = p_local_change_id
4105: AND els1.entity_name = 'ENG_CHANGE'
4106: AND els1.status_code = ecs1.status_code
4107: AND ((ecs1.status_type = 4 AND l_schedule_immediately = 'Y')

Line 4496: FROM eng_change_statuses_vl ecs

4492: END IF;
4493: -- Fetch status details
4494: SELECT ecs.status_name
4495: INTO l_status_name
4496: FROM eng_change_statuses_vl ecs
4497: WHERE ecs.status_code = 0;
4498:
4499: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Status = ' || l_status_name);
4500: