查询报表所属的职责

SELECT FCPT.USER_CONCURRENT_PROGRAM_NAME,
        FRG.REQUEST_GROUP_NAME,
        FR.RESPONSIBILITY_KEY
FROM FND_CONCURRENT_PROGRAMS_TL FCPT,
        FND_REQUEST_GROUP_UNITS     FRGU,
        FND_REQUEST_GROUPS          FRG,
        FND_RESPONSIBILITY          FR
WHERE FCPT.CONCURRENT_PROGRAM_ID = FRGU.REQUEST_UNIT_ID
    AND FRGU.REQUEST_GROUP_ID = FRG.REQUEST_GROUP_ID
    AND FRG.REQUEST_GROUP_ID = FR.REQUEST_GROUP_ID
    AND lower(FCPT.USER_CONCURRENT_PROGRAM_NAME) LIKE lower('&program_name');