User, Responsibility, Request Group, Concurrent Program Joining Query - Oracle EBS R12

http://systemadministratorsys.blogspot.com/2016/11/user-responsibility-request-group.html

User, Responsibility, Request Group, Concurrent Program Joining Query

  select jj.USER_NAME , kk.REQUEST_GROUP_NAME, mm.RESPONSIBILITY_NAME , jj.FAX , cpt.USER_CONCURRENT_PROGRAM_NAME
  from fnd_request_groups kk, FND_RESPONSIBILITY_VL  mm, FND_USER_RESP_GROUPS_DIRECT hh, fnd_user jj,
  fnd_request_group_units tt ,FND_CONCURRENT_PROGRAMS_TL CPT
  where kk.REQUEST_GROUP_ID = mm.REQUEST_GROUP_ID
  and hh.RESPONSIBILITY_ID=mm.RESPONSIBILITY_ID
  and tt.REQUEST_GROUP_ID= kk.REQUEST_GROUP_ID
  and tt.REQUEST_GROUP_ID=mm.REQUEST_GROUP_ID
  and kk.REQUEST_GROUP_ID=mm.REQUEST_GROUP_ID
  and cpt.CONCURRENT_PROGRAM_ID =tt.REQUEST_UNIT_ID
  and hh.user_id= jj.USER_ID
  and mm.END_DATE is null
  and jj.END_DATE is null

  --and kk.REQUEST_GROUP_NAME = '?'
  and cpt.USER_CONCURRENT_PROGRAM_NAME =  '?'

Query to find the Request Group of a Concurrent Program - Oracle EBS R12

http://systemadministratorsys.blogspot.com/2016/11/query-to-find-request-group-of.html

Query to find the Request Group of a Concurrent Program

SELECT
  RG.APPLICATION_ID "Request Group Application ID",
  RG.REQUEST_GROUP_ID "Request Group - Group ID",
  RG.REQUEST_GROUP_NAME,
  RG.DESCRIPTION,
  rgu.unit_application_id,
  rgu.request_group_id "Request Group Unit - Group ID",
  rgu.request_unit_id,cp.concurrent_program_id,
  cp.concurrent_program_name,
  cpt.user_concurrent_program_name,
  DECODE(rgu.request_unit_type,'P','Program','S','Set',rgu.request_unit_type) "Unit Type"
FROM
  fnd_request_groups rg,
  fnd_request_group_units rgu,
  fnd_concurrent_programs cp,
  FND_CONCURRENT_PROGRAMS_TL CPT
WHERE rg.request_group_id = rgu.request_group_id
  AND rgu.request_unit_id = cp.concurrent_program_id
  AND cp.concurrent_program_id = cpt.concurrent_program_id