Your Ad Here

advanced code snippet search

Posted By

theonlyalterego on 06/24/11


Tagged

sql Oracle


Versions (?)

Oracle - sql to find what responsibility can run a request / report

 / Published in: SQL
 

URL: http://www.michaelcoughlin.net/blog/index.php/2011/06/how-to-find-which-responsibility-can-run-a-request-in-oracle-apps/

Very useful sql to find which responsibility has access to a report or request.

Expand | Embed | Plain Text 
  1. SELECT -- rg.application_id, rg.request_group_id, unit_application_id, request_unit_id, request_unit_type,
  2.          request_group_name
  3. --         , rg.description RG_DESC
  4.          , cp.concurrent_program_name
  5.          , cpt.user_concurrent_program_name
  6. --         , cpt.description CCP_DESC
  7.         , fr.responsibility_key
  8.         ,frt.responsibility_name
  9.     FROM FND_REQUEST_GROUP_UNITS rgu,
  10.          fnd_request_groups rg,
  11.          fnd_concurrent_programs cp,
  12.          FND_CONCURRENT_PROGRAMS_TL cpt,
  13.          FND_RESPONSIBILITY fr,
  14.          FND_RESPONSIBILITY_TL frt
  15.    WHERE     rg.request_group_id = rgu.request_group_id
  16.          AND RGU.REQUEST_UNIT_ID = cp.concurrent_program_id
  17.          AND cp.concurrent_program_id = cpt.concurrent_program_id
  18.          AND rg.request_group_id = fr.request_group_id
  19.          AND frt.responsibility_id = fr.responsibility_id
  20.          --and upper(rg.request_group_name)  like upper(:REQ_GRP_NAME)
  21.          --and upper(cpt.user_concurrent_program_name) like upper(:CCP_FULL_NAME)
  22.          AND upper(cp.concurrent_program_name) LIKE upper(:CCP_SHRT_NAME)
  23. ORDER BY cp.concurrent_program_name

Report this snippet  

You need to login to post a comment.