Get Concurrent Program Name, Executable Name, Executable Method, Parameters, Value Set, Default Value, Enabled Flag, Required flag in Oracle Applications

Get Concurrent Program Name, Executable Name, Executable Method, Parameters, Value Set, Default Value, Enabled Flag, Required flag in Oracle Applications 



SQL:


SELECT   b.user_concurrent_program_name, b.concurrent_program_name
        ,d.meaning executable_method, c.executable_name
        ,a.application_column_name column_name, e.flex_value_set_name
        ,a.enabled_flag, a.required_flag, a.display_flag, a.default_type
        ,a.DEFAULT_VALUE
    FROM fnd_descr_flex_col_usage_vl a
        ,fnd_concurrent_programs_vl b
        ,fnd_executables_vl c
        ,fnd_lookups d
        ,fnd_flex_value_sets e
   WHERE b.concurrent_program_name = SUBSTR (descriptive_flexfield_name, 7)
     AND b.executable_id = c.executable_id
     AND c.execution_method_code = 'I'
     AND d.lookup_type = 'CP_EXECUTION_METHOD_CODE'
     AND c.execution_method_code = d.lookup_code
     AND a.flex_value_set_id = e.flex_value_set_id
     AND b.concurrent_program_name = :p_cont_prog_short_name
ORDER BY column_name