Tuesday, June 16, 2015

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

No comments:

Post a Comment

Best Blogger TipsGet Flower Effect