SELECT DISTINCT CONCURRENT_PROGRAM_ID ID , F.USER_CONCURRENT_PROGRAM_NAME VALUE , P.SET_REQUEST_ID SRID , P.STAGE_REQUEST_ID SID FROM FND_CONCURRENT_PROGRAMS_VL F , BIS_RS_PROG_RUN_HISTORY P WHERE F.CONCURRENT_PROGRAM_ID = P.PROGRAM_ID AND F.APPLICATION_ID = P.PROG_APP_ID