Find the Responsibility name from which a concurrent program can be run


select distinct
 
a.application_id,
 
a.concurrent_program_id,
 
a.user_concurrent_program_name,
 
a.description,
 
b.request_group_id,
 
request_group_name,
 
e.responsibility_name
 
from fnd_concurrent_programs_tl a,
 
fnd_request_groups b,
 
fnd_request_group_units c,
 
fnd_responsibility d,
 
fnd_responsibility_tl e
 
where a.concurrent_program_id = c.request_unit_id
 
and b.request_group_id = c.request_group_id
 
and b.request_group_id = d.request_group_id
 
and d.responsibility_id = e.responsibility_id
 
and a.application_id = b.application_id
 
and b.application_id = c.application_id
 
and d.application_id = e.application_id
 
-- and a.user_concurrent_program_name like 'XX%'
 
and a.concurrent_program_id = 45220
 
 
 
 
 

No comments:

Manage Inactive session in Oracle 23AI Database.

# CONNECT WITH PDB DATABASE(ORACLE 23AI) [oracle@prd-23ai ~]$ sqlplus / as sysdba  SQL*Plus: Release 23.0.0.0.0 - for Oracle Cloud and Engin...