Oracle apps list of concurrent programs in a Request Set

1SELECT rs.user_request_set_name        "Set Name",
2       rs.request_set_name             "Set code",
3       rs.description                  "Description",
4       rss.display_sequence            stage_Seq,
5       rss.user_stage_name,
6       rsp.sequence                    CP_SEQUENCE,
7       cp.user_concurrent_program_name "Concurrent Program",
8       ap.application_name             "Application",
9       e.executable_name               "Executable",
10       e.execution_file_name           "Executable File",
11       lv.meaning                      "Executable Type"
12  FROM apps.fnd_request_sets_vl         rs,
13       apps.fnd_req_set_stages_form_v   rss,
14       applsys.fnd_request_set_programs rsp,
15       apps.fnd_concurrent_programs_vl  cp,
16       apps.fnd_executables             e,
17       apps.fnd_lookup_values           lv,
18       apps.fnd_application_vl          ap
19 WHERE     rs.application_id = rss.set_application_id
20       AND rs.request_set_id = rss.request_set_id
21       AND rss.set_application_id = rsp.set_application_id
22       AND rss.request_set_id = rsp.request_set_id
23       AND rss.request_set_stage_id = rsp.request_set_stage_id
24       AND rsp.program_application_id = cp.application_id
25       AND rsp.concurrent_program_id = cp.concurrent_program_id
26       AND cp.executable_id = e.executable_id
27       AND cp.executable_application_id = e.application_id
28       AND e.application_id = ap.application_id
29       AND lv.lookup_type = 'CP_EXECUTION_METHOD_CODE'
30       AND lv.lookup_code = e.execution_method_code
31       AND rs.user_request_set_name = 'Function Security Reports'
32       AND lv.language = 'US'