Query to find concurrent program Responsibility and Request Group

•By Amol Jadhav
Query to find concurrent program Responsibility and Request Group
Oracle apps concurrent program responsibility query
Oracle ebs concurrent program attached to which responsibility
concurrent program attached to request group query

SQL Querysql
1SELECT DISTINCT fcpl.user_concurrent_program_name,
2                fcp.concurrent_program_name,
3                fapp.application_name,
4                frg.request_group_name,
5                fnrtl.responsibility_name
6  FROM apps.fnd_request_groups         frg,
7       apps.fnd_application_tl         fapp,
8       apps.fnd_request_group_units    frgu,
9       apps.fnd_concurrent_programs    fcp,
10       apps.fnd_concurrent_programs_tl fcpl,
11       apps.fnd_responsibility         fnr,
12       apps.fnd_responsibility_tl      fnrtl
13 WHERE     frg.application_id = fapp.application_id
14       AND frg.application_id = frgu.application_id
15       AND frg.request_group_id = frgu.request_group_id
16       AND frg.request_group_id = fnr.request_group_id
17       AND fnr.responsibility_id = fnrtl.responsibility_id
18       AND frgu.request_unit_id = fcp.concurrent_program_id
19       AND frgu.unit_application_id = fcp.application_id
20       AND fcp.concurrent_program_id = fcpl.concurrent_program_id
21       AND fcpl.user_concurrent_program_name LIKE
22              '<Your concurrent program name>'
23       AND fnrtl.LANGUAGE = 'US'
24       AND fapp.LANGUAGE = 'US'

Related posts: