Concurrent Program Definition

This query can give you details of concurrent program. You can get same detail using responsibility Application Developer->Concurrent->Program too.

 SELECT fcp.concurrent_program_name
      , fcpt.user_concurrent_program_name
      , fe.executable_name
      , fet.user_executable_name
      , flv.meaning
      , fe.execution_file_name
      , fdfcu.column_seq_num
      , fdfcu.application_column_name 
      , fdfcu.end_user_column_name
      , fdfcut.description
      , ffvs.flex_value_set_name
      , fdfcut.form_left_prompt
      , fdfcu.enabled_flag
      , fdfcu.required_flag
      , fdfcu.default_value
   FROM fnd_concurrent_programs      fcp
      , fnd_concurrent_programs_tl   fcpt
      , fnd_executables              fe
      , fnd_executables_tl           fet
      , fnd_lookup_values            flv
      , fnd_descr_flex_column_usages fdfcu
      , fnd_descr_flex_col_usage_tl  fdfcut
      , fnd_flex_value_sets          ffvs
  WHERE fcp.application_id                  = fcpt.application_id
    AND fcp.concurrent_program_id           = fcpt.concurrent_program_id
    AND fcpt.language                       = USERENV('LANG')
    AND fcp.executable_application_id       = fe.application_id
    AND fcp.executable_id                   = fe.executable_id
    AND fe.application_id                   = fet.application_id
    AND fe.executable_id                    = fet.executable_id
    AND fet.language                        = USERENV('LANG')
    AND fe.execution_method_code            = flv.lookup_code
    AND flv.lookup_type                     = 'CP_EXECUTION_METHOD_CODE'
    AND fdfcu.descriptive_flexfield_name    = '$SRS$.' || fcp.concurrent_program_name
    AND fdfcu.application_id                = fdfcut.application_id
    AND fdfcu.descriptive_flexfield_name    = fdfcut.descriptive_flexfield_name
    AND fdfcu.descriptive_flex_context_code = fdfcut.descriptive_flex_context_code
    AND fdfcu.application_column_name       = fdfcut.application_column_name
    AND fdfcut.LANGUAGE                     = USERENV ('LANG')
    AND fdfcu.flex_value_set_id             = ffvs.flex_value_set_id
    -- 
    -- Add your paramters
    ---
    AND fcp.concurrent_program_name         = 'OEXAUGEN'
    --
    -- end of user paramters
    --
  ORDER BY fcp.concurrent_program_name
         , fdfcu.column_seq_num