gn_person_qu.idnumber(rq.candidate) idi, gn_person_qu.lastname(rq.candidate)lnam, gn_person_qu.firstname(rq.candidate)fnam, gn_sex_qu.DESCRIPTION( gn_person_qu.SEX(rq.candidate) )gender, gn_person_qu.BIRTHCOUNTRY(rq.candidate) bcuntry, gn_country_qu.DESCRIPTION(gn_person_qu.BIRTHCOUNTRY(rq.candidate))bcoundes, ac.CITY_CODE, ap_city_qu.DESCRIPTION(ac.CITY_CODE)citdes, rq.unit,REPLACE(ap_unit_qu.lastname(rq.unit),',','')uniname, ap_unit_tree_qu.GetFacultyOfUnit(rq.unit) fac, REPLACE(ap_unit_qu.lastname(ap_unit_tree_qu.GetFacultyOfUnit(rq.unit)),',','')facname, rq.GRADE,rq.FINAL_STEP_IN_GRADE darga ,rq.STATUS_IN_STEP mamad, ap_grade_step_status_qu.DESCRIPTION(rq.GRADE,rq.FINAL_STEP_IN_GRADE ,rq.STATUS_IN_STEP)grdes from ap_request rq, ap_candidate ac where rq.grade in(22, 49, 50, 62, 18,21, 23, 44, 45, 92, 94, 43 ) and rq.REQUEST_STATUS = 40 and rq.new_changed_request <> 5 and rq.to_DATE >= to_date('01/10/2016','dd/mm/YYYY') and rq.from_DATE <= to_date('30/09/2017','dd/mm/YYYY') and rq.candidate = ac.candidate