Query to get the Concurrent Program along with Value Set details

SELECT fcpl1.user_concurrent_program_name

      ,fdfcuv.end_user_column_name

      ,ffvs.flex_value_set_name value_set_name

      ,ffvt.application_table_name

  ,ffvt.value_column_name

      ,ffvt.additional_where_clause

  FROM apps.fnd_concurrent_programs fcp1

      ,apps.fnd_descr_flex_col_usage_vl fdfcuv

      ,apps.fnd_flex_value_sets ffvs

      ,apps.fnd_flex_validation_tables ffvt

      ,apps.fnd_concurrent_programs_tl fcpl1

 WHERE 1 = 1     

   AND fcp1.concurrent_program_id IN (SELECT DISTINCT fcp.concurrent_program_id

                                        FROM apps.fnd_concurrent_programs fcp

                                            ,apps.fnd_concurrent_programs_tl fcpl

                                            ,apps.fnd_concurrent_requests fcr

                                       WHERE 1 = 1

                                         AND fcp.concurrent_program_id = fcpl.concurrent_program_id

                                         AND fcpl.language = 'US'

                                         AND fcr.concurrent_program_id = fcpl.concurrent_program_id

                                         AND trunc(fcr.request_date) BETWEEN :p_from_date AND :p_to_date

                                         AND fcp.concurrent_program_name LIKE '%XXCPNAME%'

)

   AND fdfcuv.descriptive_flexfield_name = '$SRS$.' ||fcp1.concurrent_program_name

   AND ffvs.flex_value_set_id = fdfcuv.flex_value_set_id

   AND ffvt.flex_value_set_id = ffvs.flex_value_set_id

   AND fcp1.concurrent_program_id = fcpl1.concurrent_program_id

ORDER BY fcpl1.user_concurrent_program_name