1 Reply Latest reply: Jul 26, 2007 5:18 PM by 579671 RSS

    Request assigned to how many Responsibilities

    556702
      Hi All

      We can assign single concurrent program to many responsibilities. Can we know how many different responsibilities assigned particular concurrent program?

      Any help would appreciate.

      Thanks,
      Sai.krishna@cavaya.com
        • 1. Re: Request assigned to how many Responsibilities
          579671
          You can use the following query.

          SELECT resp_tl.responsibility_name, grps.request_group_name, appl.application_name,conc_prg.USER_CONCURRENT_PROGRAM_NAME FROM
          FND_CONCURRENT_PROGRAMS_TL conc_prg,
          FND_REQUEST_GROUP_UNITS grp_units,
          FND_REQUEST_GROUPS grps,
          FND_RESPONSIBILITY_TL resp_tl,
          FND_RESPONSIBILITY resp,
          FND_APPLICATION_TL appl
          WHERE conc_prg.USER_CONCURRENT_PROGRAM_NAME = '< Conc Program Name >'
          AND conc_prg.concurrent_program_id = grp_units.request_unit_id
          AND grps.request_group_id = grp_units.request_group_id
          AND grps.application_id = appl.application_id
          AND resp.REQUEST_GROUP_ID = grps.REQUEST_GROUP_ID
          AND resp.RESPONSIBILITY_ID = resp_tl.RESPONSIBILITY_ID

          Sudeep