The query below lists all the stages and concurrent programs in a Request Set.
SELECT rs.request_set_id set_id,
rs.user_request_set_name set_name,
rstg.display_sequence seq, rstg.stage_name,
rstgtl.user_stage_name,
rsp.concurrent_program_id con_PROG_ID,
CCP.user_concurrent_program_name
, fccp.concurrent_program_name
FROM apps.fnd_request_Sets_tl rs,
apps.FND_REQUEST_SET_STAGES RSTG,
apps.fnd_REQUEST_SET_STAGES_tl rstgtl,
apps.FND_REQUEST_SET_PROGRAMS RSP,
apps.FND_CONCURRENT_PROGRAMS_TL CCP
, apps.fnd_CONCURRENT_PROGRAMS fccp
WHERE RS.request_set_id = rstg.request_set_id
and rs.request_set_id = rstgtl.request_set_id
and rstg.request_set_id = rstgtl.request_set_id
and rstg.request_set_stage_id = rstgtl.request_set_stage_id
AND rs.request_set_id = rsp.request_set_id
AND rstg.request_set_stage_id = rsp.request_set_stage_id
AND rsp.concurrent_program_id = CCP.concurrent_program_id
and ccp.concurrent_program_id = fccp.concurrent_program_id
AND rs.user_request_set_name LIKE :req_set_name --'%F70 Flows'
ORDER BY rstg.display_sequence
