Search 800 + Posts

Nov 2, 2013

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

No comments:

Post a Comment