To find the active reports in oracle apps

SELECT DISTINCT
 FCPT.USER_CONCURRENT_PROGRAM_NAME
,FCPT.CONCURRENT_PROGRAM_NAME CP_SHORT_NAME
,FCPT.DESCRIPTION CP_DESC
,FCPT.APPLICATION_ID
--,FCP.CONCURRENT_PROGRAM_NAME SHORT_NAME
,FCP.OUTPUT_FILE_TYPE
,DECODE(FCP.ENABLED_FLAG,'Y','ACTIVE','N','INACTIVE')STATUS
,FEX.EXECUTABLE_NAME
,FEX.APPLICATION_NAME
,FEX.DESCRIPTION EX_DESC
,DECODE(FEX.EXECUTION_METHOD_CODE,'I','PL/SQL Stored Procedure','H','Host','P','Oracle Reports',
                                 'K','Java Concurrernt Program','Q','SQL*Plus','M','Multi Lanuage Function',
'A','Spawned','J','Java Stored Procedure','B','Request Set Stage Function',
'S','Immediate','L','SQL*Loader','P','Perl Concurrent Program')EXECUTION_METHOD
,FEX.EXECUTION_FILE_NAME
,FDP.END_USER_COLUMN_NAME PARAMETERS
,FDP.SRW_PARAM TOKEN
,FORM_LEFT_PROMPT PROMPT
,FFVS.FLEX_VALUE_SET_NAME
--,FRU.REQUEST_GROUP_ID
--,FRU.REQUEST_GROUP_NAME
,FAT.APPLICATION_NAME Module_name
,FAT.APPLICATION_ID
FROM
--FND_CONCURRENT_PROGRAMS_TL FCPT,
APPS.FND_CONCURRENT_PROGRAMS_VL FCPT
,APPS.FND_CONCURRENT_PROGRAMS FCP
,APPS.FND_EXECUTABLES_FORM_V FEX
,APPS.FND_DESCR_FLEX_COL_USAGE_VL FDP
,APPS.FND_FLEX_VALUE_SETS FFVS
--,FND_CONCURRENT_REQUESTS FCR
--,FND_RESPONSIBILITY_VL FRT
,APPS.FND_REQUEST_GROUP_UNITS FRU
,APPS.FND_APPLICATION_TL FAT
WHERE
FCPT.CONCURRENT_PROGRAM_ID = FCP.CONCURRENT_PROGRAM_ID
AND FCP.ENABLED_FLAG='Y'
AND FCPT.EXECUTABLE_ID = FEX.EXECUTABLE_ID
AND FCPT.EXECUTABLE_APPLICATION_ID=FEX.APPLICATION_ID
AND FCPT.APPLICATION_ID = FDP.APPLICATION_ID
AND FCPT.CONCURRENT_PROGRAM_NAME = SUBSTR(FDP.DESCRIPTIVE_FLEXFIELD_NAME,7)  
AND FDP.FLEX_VALUE_SET_ID=FFVS.FLEX_VALUE_SET_ID
AND FCPT.CONCURRENT_PROGRAM_ID = FRU.REQUEST_UNIT_ID(+)
--AND FRU.UNIT_APPLICATION_ID = FAT.APPLICATION_ID
AND FRU.APPLICATION_ID = FAT.APPLICATION_ID(+)
--AND FEX.APPLICATION_NAME like '%Busi%'
AND FCPT.USER_CONCURRENT_PROGRAM_NAME like ' Expense Analysis Report'
ORDER BY FCPT.USER_CONCURRENT_PROGRAM_NAME