I have a concurrent program which I want to submit .. but here is the problem. I dont know which responsibility this program is attached to. No wonder .. below is the query that can be used to find the list of responsibilities to which the programs is attached to.
Query to find concurrent program
Query to find concurrent program
select frt.responsibility_name, frg.request_group_name, frgu.request_unit_type,frgu.request_unit_id, fcpt.user_concurrent_program_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 frt.language = USERENV('LANG') and fcpt.language = USERENV('LANG') and fcpt.user_concurrent_program_name = :conc_prg_name order by 1,2,3,4
Query to find Request Set
select frt.responsibility_name, frg.request_group_name, frgu.request_unit_type,frgu.request_unit_id, fcpt.user_request_set_name From apps.fnd_Responsibility fr, apps.fnd_responsibility_tl frt, apps.fnd_request_groups frg, apps.fnd_request_group_units frgu, apps.fnd_request_Sets_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.request_set_id = frgu.request_unit_id and frt.language = USERENV('LANG') and fcpt.language = USERENV('LANG') and fcpt.user_request_set_name = :request_set_name order by 1,2,3,4
No comments:
Post a Comment