Query To Get The Oracle Concurrent Program Parameters

  SELECT df.descriptive_flexfield_name,

         cp.user_concurrent_program_name,

         cp.concurrent_program_name,

         ap.application_name,

         cp.description,

         cp.enabled_flag,

         cp.output_file_type,

         cx.executable_name,

         lv.meaning,

         cx.user_executable_name,

         df.column_seq_num,

         df.end_user_column_name,

         df.description,

         df.enabled_flag,

         df.required_flag,

         df.security_enabled_flag,

         df.display_flag,

         fvs.flex_value_set_name,

         df.default_type,

         df.DEFAULT_VALUE

    FROM apps.fnd_concurrent_programs_vl cp,

         apps.fnd_executables_form_v cx,

         apps.fnd_application_vl ap,

         apps.fnd_descr_flex_col_usage_vl df,

         apps.fnd_flex_value_sets fvs,

         apps.fnd_lookup_values lv

   WHERE     cp.executable_id = cx.executable_id

         AND cp.application_id = ap.application_id

         AND fvs.flex_value_set_id = df.flex_value_set_id

         AND lv.lookup_type = 'CP_EXECUTION_METHOD_CODE'

         AND lv.lookup_code = cx.execution_method_code

         AND cp.user_concurrent_program_name = 'AR Aging Report'

         AND df.descriptive_flexfield_name = '$SRS$.' || cp.concurrent_program_name AND lv.language = 'US'

ORDER BY df.column_seq_num