Important Queries related to Concurrent Programs.

Important Queries related to Concurrent Programs.

To get Details of Concurrent Program

SELECT *

    FROM fnd_concurrent_programs_vl

WHERE UPPER(user_concurrent_program_name) = :Concurrent_program_name    

To get Details of Concurrent Program Request details

SELECT *

    FROM fnd_concurrent_requests

   WHERE  concurrent_program_id = :concurrent_program_id 

         AND TRUNC (request_date) = TRUNC (SYSDATE)

ORDER BY request_date DESC

To get Details of Concurrent Program Parameter details 

SELECT  fdfcuv.column_seq_num

      , fdfcuv.end_user_column_name

      , fdfcuv.flex_value_set_id

      , ffvs.flex_value_set_name

     , fcpl.user_concurrent_program_name

      , fcp.concurrent_program_name

      , fav.APPLICATION_SHORT_NAME

      , fav.APPLICATION_NAME

      , fav.application_id

      , fdfcuv.form_left_prompt prompt

      , fdfcuv.enabled_flag

      , fdfcuv.required_flag

      , fdfcuv.display_flag

      , flv.meaning default_type

      , fdfcuv.DEFAULT_VALUE     

 FROM   fnd_concurrent_programs fcp

      , fnd_concurrent_programs_tl fcpl

      , fnd_descr_flex_col_usage_vl fdfcuv

      , fnd_flex_value_sets ffvs

      , fnd_lookup_values flv

      , fnd_application_vl fav

WHERE  fcp.concurrent_program_id = fcpl.concurrent_program_id

-- AND    fcpl.user_concurrent_program_name =:conc_prg_name

AND    fcp.concurrent_program_name = :conc_prg_short_name

AND    fcpl.LANGUAGE = 'US'

AND    fav.application_id=fcp.application_id

AND    fdfcuv.descriptive_flexfield_name = '$SRS$.' || fcp.concurrent_program_name

AND    ffvs.flex_value_set_id = fdfcuv.flex_value_set_id

AND    flv.lookup_type(+) = 'FLEX_DEFAULT_TYPE'

AND    flv.lookup_code(+) = fdfcuv.default_type

AND    flv.LANGUAGE(+) = USERENV ('LANG')

ORDER BY fdfcuv.column_seq_num

To get Details of Valueset details 

Select value_column_name,id_column_name,application_table_name,additional_where_clause

FROM FND_FLEX_VALIDATION_TABLES

WHERE flex_value_set_id =:Value_set_id

To get Details of Concurrent Program, Request_group and Responsibility details 

 SELECT frt.responsibility_name, frg.request_group_name,

    frgu.request_unit_type,frgu.request_unit_id,
    fcpt.user_concurrent_program_name
    FROM apps.fnd_Responsibility fr, apps.fnd_responsibility_tl frt,
    apps.fnd_request_groups frg, apps.fnd_request_group_units frgu,
    apps.fnd_concurrent_programs_tl fcpt
    WHERE frt.responsibility_id = fr.responsibility_id
    AND frg.request_group_id = fr.request_group_id
    AND frgu.request_group_id = frg.request_group_id
    AND fcpt.concurrent_program_id = frgu.request_unit_id
    AND frt.LANGUAGE = USERENV('LANG')
    AND fcpt.LANGUAGE = USERENV('LANG')
   AND fcpt.user_concurrent_program_name = :conc_prg_name
    ORDER BY 1,2,3,4