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
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
|
|
|