SELECT B.REQUEST_SET_ID ID , USER_REQUEST_SET_NAME VALUE , SYSDATE-MAX(B.LAST_UPDATE_DATE) DAYS , REQUEST_SET_TYPE RSTYPE FROM BIS_RS_RUN_HISTORY B , FND_REQUEST_SETS_VL F WHERE F.REQUEST_SET_ID = B.REQUEST_SET_ID AND B.PHASE_CODE ='C' AND B.STATUS_CODE <> 'X' GROUP BY B.REQUEST_SET_ID , USER_REQUEST_SET_NAME , REQUEST_SET_TYPE