To Check Module Wise Reports

SELECT
fa.application_short_name,
fcpv.user_concurrent_program_name,

description,

DECODE (fcpv.execution_method_code,

'B', 'Request Set Stage Function',

'Q', 'SQL*Plus',

'H', 'Host',

'L', 'SQL*Loader',

'A', 'Spawned',

'I', 'PL/SQL Stored Procedure',

'P', 'Oracle Reports',

'S', 'Immediate',

fcpv.execution_method_code

) exe_method,

output_file_type,
program_type,
printer_name,
minimum_width,

minimum_length,
concurrent_program_name,
concurrent_program_id

FROM
fnd_concurrent_programs_vl fcpv,
fnd_application fa

WHERE
fcpv.application_id = fa.application_id

ORDER BY 1