Concurrent Programs-queries Oracle apps R12

Query to list concurrent program details with its parameter, values set and default value/type AND Attached Responsibilities..

1. query to list all the responsibilities attached to a user

select fu.user_name, fr.responsibility_name, furg.start_date, furg.end_date

from fnd_user_resp_groups_direct furg, fnd_user fu, fnd_responsibility_tl fr

where upper(fu.user_name) =upper(:user_name)

and furg.user_id = fu.user_id

and furg.responsibility_id = fr.responsibility_id

and fr.language = userenv('lang')

2.Query To Find Concurrent Program Attached To a Responsibility

SELECT fcpt.user_concurrent_program_name,

frt.responsibility_name,

frg.request_group_name

FROM fnd_Responsibility fr,

fnd_responsibility_tl frt,

fnd_request_groups frg,

fnd_request_group_units frgu,

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 fcpt.user_concurrent_program_name = '&conc_program_name'

ORDER BY 2,3

3.provide concurrent program name to the following query it lists all the request sets which are created with the concurrent program given

select distinct user_request_set_name

from fnd_request_sets_tl

where request_set_id in

(select request_set_id

from fnd_request_set_programs

where concurrent_program_id =

(select concurrent_program_id

from fnd_concurrent_programs_tl

where upper(user_concurrent_program_name) = upper( '&enter_prog_name')));

4. provide the request set name to the following query.it lists all concurrent programs of this request set.

select user_concurrent_program_name

from fnd_concurrent_programs_tl

where concurrent_program_id in

(select concurrent_program_id

from fnd_request_set_programs

where request_set_id =

(select request_set_id

from fnd_request_sets_tl

where upper(user_request_set_name) = upper('&request_set_name')));

5. query to list concurrent program details with its parameter, values set and default value/type:

Select fcpl.user_concurrent_program_name

, fcp.concurrent_program_name

, fav.application_short_name

, fav.application_name

, fav.application_id

, fdfcuv.end_user_column_name

, fdfcuv.form_left_prompt prompt

, fdfcuv.enabled_flag

, fdfcuv.required_flag

, fdfcuv.display_flag

, fdfcuv.flex_value_set_id

, ffvs.flex_value_set_name

, 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 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');

Get details about value sets used in concurrent program from oracle application screen(front end) from Oracle - Value Sets post.

6. query to find out concurrent program details and its parameters

select fcpl.user_concurrent_program_name