Friday, 1 May 2015

Query To Find The Resposiblity Of Concurrent Program


SELECT frt.responsibility_name,
               frg.request_group_name,
               frg.description
  FROM fnd_request_groups frg
             ,fnd_request_group_units frgu
             ,fnd_concurrent_programs fcp
             ,fnd_concurrent_programs_tl fcpt
             ,fnd_responsibility_tl frt
             ,fnd_responsibility frs
 WHERE frgu.unit_application_id = fcp.application_id
 AND   frgu.request_unit_id = fcp.concurrent_program_id
 AND   frg.request_group_id = frgu.request_group_id
 AND   FRG.APPLICATION_ID = FRGU.APPLICATION_ID
 AND   fcpt.source_lang = '<Language>'
 AND   fcp.application_id = fcpt.application_id
 AND   fcp.concurrent_program_id = fcpt.concurrent_program_id
 AND   frs.application_id = frt.application_id
 AND   FRS.RESPONSIBILITY_ID = FRT.RESPONSIBILITY_ID
 AND   frt.source_lang = '<Language>'
 AND   frs.request_group_id = frg.request_group_id
 AND   FRS.APPLICATION_ID = FRG.APPLICATION_ID
 AND   FCP.CONCURRENT_PROGRAM_NAME  like '<Program Short name>'
 AND   fcpt.user_concurrent_program_name LIKE '<User concurrent program>'

No comments:

Post a Comment