DBA Data[Home] [Help]

APPS.ENGECOBO dependencies on ENG_LIFECYCLE_STATUSES

Line 3973: FROM eng_lifecycle_statuses els

3969: -- for TTM case since the processing is per organization and the submit change
3970: -- would have been enabled this is not going to be called
3971: CURSOR c_get_init_status IS
3972: SELECT els.status_code
3973: FROM eng_lifecycle_statuses els
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)

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')