Oracle Ebs 职责对应请求信息

SELECT FSV.RESPONSIBILITY_NAME 职责,
       FRG.REQUEST_GROUP_NAME 请求组,
       FRGU.REQUEST_UNIT_ID,
       FCP.USER_CONCURRENT_PROGRAM_NAME 报表名称
  FROM FND_REQUEST_GROUPS         FRG,
       FND_RESPONSIBILITY_VL      FSV,
       FND_REQUEST_GROUP_UNITS    FRGU,
       FND_CONCURRENT_PROGRAMS_VL FCP
 WHERE FRG.REQUEST_GROUP_ID = FSV.REQUEST_GROUP_ID
   AND FRG.APPLICATION_ID = FSV.APPLICATION_ID
   AND FSV.REQUEST_GROUP_ID = FRGU.REQUEST_GROUP_ID
   AND FSV.APPLICATION_ID = FRGU.APPLICATION_ID
   AND FRGU.UNIT_APPLICATION_ID = FCP.APPLICATION_ID(+)
   AND FRGU.REQUEST_UNIT_ID = FCP.CONCURRENT_PROGRAM_ID(+)
   AND FCP.USER_CONCURRENT_PROGRAM_NAME = 'Program Name'