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 =  '?'