Query to get concurrent program and executable details

1SELECT fcpt.user_concurrent_program_name,
2       fcp.concurrent_program_name,
3       fat.application_name,
4       fet.executable_name,
5       fate.application_name exe_application,
6       flv.meaning           execution_method,
7       fet.execution_file_name,
8       fcp.enable_trace
9  FROM fnd_concurrent_programs_tl fcpt,
10       fnd_concurrent_programs    fcp,
11       fnd_application_tl         fat,
12       fnd_executables            fet,
13       fnd_application_tl         fate,
14       fnd_lookup_values          flv
15 WHERE     fcpt.concurrent_program_id = fcp.concurrent_program_id
16       AND fcpt.application_id = fcp.application_id
17       AND fcp.application_id = fat.application_id
18       AND fcpt.application_id = fat.application_id
19       AND fcp.executable_id = fet.executable_id
20       AND fcp.executable_application_id = fet.application_id
21       AND fet.application_id = fate.application_id
22       AND flv.lookup_type = 'CP_EXECUTION_METHOD_CODE'
23       AND flv.lookup_code = fet.execution_method_code
24       AND fate.language='US'
25       AND fat.language='US'
26       AND fcpt.language='US'
27       AND fcpt.user_concurrent_program_name = '<Concurrent Program Name>'