SELECT S.REQUEST_ID ID , USER_STAGE_NAME VALUE , S.SET_REQUEST_ID SRID , REQUEST_SET_TYPE RSTYPE FROM FND_REQUEST_SET_STAGES_VL F , BIS_RS_STAGE_RUN_HISTORY S , BIS_RS_RUN_HISTORY B WHERE F.REQUEST_SET_ID = S.REQUEST_SET_ID AND F.REQUEST_SET_STAGE_ID = S.STAGE_ID AND B.REQUEST_ID = S.SET_REQUEST_ID