Query to select Username,Responsibility,Request group,Executable?

1)to find all the registration steps under perticular user name 'manu'?

SELECT

      fu.user_name,

      frt.responsibility_name,

      frg.request_group_name,

      fcpt.user_concurrent_program_name conc_pgm_name,

      fef.executable_name

FROM  fnd_concurrent_programs_vl fcpt,

      fnd_request_group_units    frgu,

      fnd_request_groups         frg,

      fnd_responsibility         fr,

      fnd_user                   fu,

      fnd_user_resp_groups_direct furgd,

      fnd_responsibility_tl      frt,

      fnd_executables_form_v fef

 WHERE 1 = 1

 AND   frgu.request_unit_id = fcpt.concurrent_program_id

 AND   fu.user_id=furgd.user_id

 AND   furgd.responsibility_id=frt.responsibility_id

 AND   frg.request_group_id = frgu.request_group_id

 AND   fr.request_group_id = frg.request_group_id

 AND   frt.responsibility_id = fr.responsibility_id

 AND   fcpt.executable_id=fef.executable_id

 AND   frt.responsibility_name = 'manur'

 AND   fu.user_name='manu' 

2)to find user name and responsibilites of perticular user?

SELECT

fu.user_name,

frt.responsibility_name

FROM

fnd_user                       fu,

fnd_user_resp_groups_direct    furgd,

fnd_responsibility_tl          frt

WHERE

fu.user_id=furgd.user_id                         and

furgd.responsibility_id=frt.responsibility_id    and

fu.user_name='manu'

3) to find user,responsibilties,r.g  for perticula rspnosibility?

SELECT

       fu.user_name,

       frt.responsibility_name,

       frg.request_group_name

FROM

       fnd_user                       fu,

       fnd_user_resp_groups_direct    furgd,

       fnd_responsibility_tl          frt,

       fnd_request_groups             frg,

       fnd_responsibility             fr,

       fnd_request_group_units        frgu    

WHERE  1=1

AND    fu.user_id=furgd.user_id

AND    furgd.responsibility_id=frt.responsibility_id

AND    frg.request_group_id = frgu.request_group_id

AND    fr.request_group_id = frg.request_group_id

AND    frt.responsibility_id = fr.responsibility_id

AND    frt.responsibility_name='manur'

4) to find user,responsibilties,r.g,c.p  for perticular respnosibility?

SELECT

       fu.user_name,

       frt.responsibility_name,

       frg.request_group_name,

       fcpt.user_concurrent_program_name

FROM

       fnd_user                       fu,

       fnd_user_resp_groups_direct    furgd,

       fnd_responsibility_tl          frt,

       fnd_request_groups             frg,

       fnd_responsibility             fr,

       fnd_request_group_units        frgu,

       fnd_concurrent_programs_vl     fcpt   

WHERE  1=1

AND    fu.user_id=furgd.user_id

AND    furgd.responsibility_id=frt.responsibility_id

AND    frg.request_group_id = frgu.request_group_id

AND    fr.request_group_id = frg.request_group_id

AND    frgu.request_unit_id = fcpt.concurrent_program_id

AND    frt.responsibility_id = fr.responsibility_id

AND    frt.responsibility_name='manur'

5) to find user,responsibilties,r.g,c.p ,executable names  for perticular respnosibility?

SELECT

       fu.user_name,

       frt.responsibility_name,

       frg.request_group_name,

       fcpt.user_concurrent_program_name,

       fef.executable_name     

FROM

       fnd_user                       fu,

       fnd_user_resp_groups_direct    furgd,

       fnd_responsibility_tl          frt,

       fnd_request_groups             frg,

       fnd_responsibility             fr,

       fnd_request_group_units        frgu,

       fnd_concurrent_programs_vl     fcpt ,

       fnd_executables_form_v        fef

WHERE  1=1

AND    fu.user_id=furgd.user_id

AND    furgd.responsibility_id=frt.responsibility_id

AND    frg.request_group_id = frgu.request_group_id

AND    fr.request_group_id = frg.request_group_id

AND    frgu.request_unit_id = fcpt.concurrent_program_id

AND    frt.responsibility_id = fr.responsibility_id

AND    fcpt.executable_id=fef.executable_id

AND    frt.responsibility_name='manur'