Script to find concurrent request status related information

SELECT FU.USER_NAME "User ID",
         FRT.RESPONSIBILITY_NAME "Responsibility Used",
         FCR.REQUEST_ID "Request ID",
         FCPT.USER_CONCURRENT_PROGRAM_NAME "Concurrent Program Name",
         FLV2.MEANING "Phase",
         FLV1.MEANING "Status",
         FCR.REQUEST_DATE "Request Date",
         FCR.REQUESTED_START_DATE "Request Start Date",
         FCR.PARENT_REQUEST_ID "Parent Request ID"
    FROM APPS.FND_USER FU,
         APPS.FND_RESPONSIBILITY_TL FRT,
         APPS.FND_CONCURRENT_REQUESTS FCR,
         APPS.FND_CONCURRENT_PROGRAMS_TL FCPT,
         APPS.FND_LOOKUP_VALUES FLV1,
         APPS.FND_LOOKUP_VALUES FLV2
   WHERE     1 = 1
         --
         AND FLV1.LOOKUP_CODE = FCR.STATUS_CODE
         AND FLV1.LOOKUP_TYPE = 'CP_STATUS_CODE'
         AND FLV1.ENABLED_FLAG = 'Y'
         AND FLV1.VIEW_APPLICATION_ID <> 0
         --
         AND FLV2.LOOKUP_CODE = FCR.PHASE_CODE
         AND FLV2.LOOKUP_TYPE = 'CP_PHASE_CODE'
         AND FLV2.ENABLED_FLAG = 'Y'
         AND FLV2.VIEW_APPLICATION_ID <> 0
         --
         AND FU.USER_ID = FCR.REQUESTED_BY
         AND FCR.CONCURRENT_PROGRAM_ID = FCPT.CONCURRENT_PROGRAM_ID
         AND FCR.RESPONSIBILITY_ID = FRT.RESPONSIBILITY_ID
         AND FRT.LANGUAGE = USERENV ('LANG')
         AND FCPT.LANGUAGE = USERENV ('LANG')
         -- AND fcr.request_id = 7137350  -- <change it>
         AND FCPT.USER_CONCURRENT_PROGRAM_NAME LIKE '%XX%'      -- <change it>
ORDER BY FCR.REQUEST_DATE DESC;