SELECT REQUEST_SET_ID RSID , REQUEST_SET_TYPE ID , BIS_REQUESTSET_VIEWHISTORY.GET_SYS_LOOKUP_MEANING( 'BIS_REQUEST_SET_TYPE' , REQUEST_SET_TYPE) VALUE FROM BIS_RS_RUN_HISTORY B WHERE B.PHASE_CODE ='C' AND B.STATUS_CODE <> 'X' GROUP BY REQUEST_SET_ID , REQUEST_SET_TYPE