APPS.ENGECOBO dependencies on ENG_CHANGE_STATUSES_VL

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

1794: l_old_effectivity_date DATE;
1795: component_seq_id NUMBER;
1796: St_Number NUMBER;
1797:
1798: l_eco_status_name eng_change_statuses_vl.status_name%TYPE; -- bug 3571079
1799:
1800: -- Added for Bug-5725081
1801:
1802: v_component_quantity_to NUMBER ;

Line 2154: FROM eng_change_statuses_vl

2150: -- Fetch the status corresponding to status_code =4 i.e 'Scheduled'
2151: BEGIN
2152: SELECT status_name
2153: INTO l_eco_status_name
2154: FROM eng_change_statuses_vl
2155: WHERE status_code = l_status_type;
2156: EXCEPTION
2157: WHEN OTHERS THEN
2158: l_eco_status_name := eco_rec.eco_status;

Line 3978: FROM eng_lifecycle_statuses els1, eng_change_statuses_vl ecs1

3974: WHERE els.entity_id1 = p_local_change_id
3975: AND els.entity_name = 'ENG_CHANGE'
3976: AND els.sequence_number =
3977: (SELECT min(sequence_number)
3978: FROM eng_lifecycle_statuses els1, eng_change_statuses_vl ecs1
3979: WHERE els1.entity_id1 = p_local_change_id
3980: AND els1.entity_name = 'ENG_CHANGE'
3981: AND els1.status_code = ecs1.status_code
3982: AND ((ecs1.status_type = 4 AND l_schedule_immediately = 'Y')

Line 4371: FROM eng_change_statuses_vl ecs

4367: END IF;
4368: -- Fetch status details
4369: SELECT ecs.status_name
4370: INTO l_status_name
4371: FROM eng_change_statuses_vl ecs
4372: WHERE ecs.status_code = 0;
4373:
4374: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Status = ' || l_status_name);
4375: