SELECT a.user_concurrent_program_name AS user_concurrent_program_name,
va.execution_file_name short_name,
va.executable_name executable_name,
NVL ((SELECT ---LOB_CODE,
file_name
FROM xdo_lobs
WHERE application_short_name = 'XXJG'
AND xdo_file_type = 'RTF'
AND UPPER (lob_code) = UPPER (va.executable_name)),
'NOT RTF Report'
) rtf_name,
a.concurrent_program_name AS concurrent_program_name,
a.output_file_type, a.output_print_style,
c.application_short_name AS application_short_name,
b.column_seq_num AS column_seq_num, b.srw_param AS param_seq,
b.form_left_prompt AS prompt,
d.flex_value_set_name AS values_set_name, va.application_name
FROM fnd_concurrent_programs_vl a,
fnd_descr_flex_col_usage_vl b,
fnd_application c,
fnd_flex_value_sets d,
fnd_executables_form_v va
WHERE a.enabled_flag = 'Y'
AND a.application_id = va.application_id
AND TRIM (va.executable_name) = TRIM (a.concurrent_program_name)
AND a.concurrent_program_name = SUBSTR (b.descriptive_flexfield_name, 7, 100)
AND a.application_id = c.application_id
AND b.enabled_flag = 'Y'
AND b.flex_value_set_id = d.flex_value_set_id
AND a.application_id = 20003 --(Your Application Id)