Find Concurrent Program information in ORACLE APPS using concurrent "program id"

 --------------------------------------------------------------

You will get the follwing inforamtion.=>>

 

execution_file_name
executable_id

concurrent_program_id
concurrent_program_name

responsibility_name

Useful Tables:--

1-FND_CONCURRENT_PROGRAMS 

2-,FND_EXECUTABLES 

3-fnd_request_group_units

4-fnd_responsibility_tl 

-------------------------------------------------------------------
select distinct
        b.executable_name
       ,b.execution_file_name
       ,b.executable_id
       ,a.concurrent_program_id
       ,a.concurrent_program_name
       ,d.responsibility_name
from
       FND_CONCURRENT_PROGRAMS  a
      ,FND_EXECUTABLES b
      ,fnd_request_group_units c
      ,fnd_responsibility_tl d
where
           a.executable_id=b.executable_id
    and c.application_id=d.application_id
    and a.concurrent_program_id=198703;