Request Set Details

SELECT rs.request_set_name
, rs.user_request_set_name
, rss.stage_name
, rss.user_stage_name
, rss.display_sequence
, rss.success_link_name
, rss.warning_link_name
, c.concurrent_program_name
, c.user_concurrent_program_name
, e.executable_name
, e.execution_method_code
, e.execution_file_name
FROM fnd_concurrent_programs_vl c
, fnd_executables e
, fnd_request_set_programs rsp
, fnd_req_set_stages_form_v rss
, fnd_request_sets_vl rs
WHERE c.executable_id = e.executable_id
AND rsp.concurrent_program_id = c.concurrent_program_id
AND rsp.request_set_id=rs.request_set_id
AND rsp.request_set_stage_id=rss.request_set_stage_id
AND rss.request_set_id=rs.request_set_id
AND rs.request_set_name = 'FNDRSSUB1128'
ORDER BY rss.display_sequence