Query to get the Details and Parameter list for Concurrent Program in Oracle Applications.

Query to get the details and Parameter list for Concurrent Program in Oracle Applications.

SELECT fcpl.user_concurrent_program_name ,
              fcp.concurrent_program_name,
               fcpl.description,
               fcp.concurrent_program_name     ,
               par.column_seq_num,
               par.application_column_name   ,
               par.end_user_column_name     ,
               par.form_left_prompt prompt     ,
               par.enabled_flag     ,
               par.required_flag     ,
               par.display_flag,
               par.default_value
FROM   fnd_concurrent_programs fcp     ,
              fnd_concurrent_programs_tl fcpl     ,
              fnd_descr_flex_col_usage_vl par
Where  Fcp.Concurrent_Program_Id = Fcpl.Concurrent_Program_Id
And  Fcpl.User_Concurrent_Program_Name = 'ENTER_USER_CONCURRENT_PROG_NAME'
     And  Fcpl.Language = 'US'
     AND  par.descriptive_flexfield_name = '$SRS$.'||fcp.concurrent_program_name