Friday, December 10, 2021

how to check concurrent program parameters from backend || Query concurrent program parameters from backend

 SELECT fcpl.user_concurrent_program_name,

       fcp.concurrent_program_name,

       par.end_user_column_name,

       par.form_left_prompt prompt,

       par.enabled_flag,

       par.required_flag,

       par.display_flag,

       ffv.flex_value_set_name

  FROM apps.fnd_concurrent_programs     fcp,

       apps.fnd_concurrent_programs_tl  fcpl,

       apps.fnd_descr_flex_col_usage_vl par,

       apps.fnd_flex_value_sets         ffv

 WHERE     fcp.concurrent_program_id = fcpl.concurrent_program_id

       AND fcpl.user_concurrent_program_name like '%Concurrent Program Name%' 

       AND fcpl.LANGUAGE = 'US'

       AND par.descriptive_flexfield_name =

              '$SRS$.' || fcp.concurrent_program_name

       AND ffv.flex_value_set_id = par.flex_value_set_id;

2 comments:

  1. Hello Sir,

    I have a one doubt regarding procurement and finance so please help me

    ReplyDelete
  2. please reply me if you available or some free time u have to
    Mail ID - vishalsonyabapushinde@gmail.com

    ReplyDelete