Query Count the number of reports registered In Each Module

Query To Count the number of reports registered In Each Module

SELECT fa.application_short_name,
Decode (fcpv.execution_method_code, ‘B’, ‘Request Set Stage Function’,
‘Q’, ‘SQLPlus’, ‘H’, ‘Host’, ‘L’, ‘SQLLoader’,
‘A’, ‘Spawned’,
‘I’, ‘PL/SQL Stored Procedure’,
‘P’, ‘Oracle Reports’,
‘S’, ‘Immediate’,
fcpv.execution_method_code)
exe_method,
Count (concurrent_program_id),COUNT
FROM fnd_concurrent_programs_vl fcpv,
fnd_application fa
WHERE fcpv.application_id = fa.application_id
AND fcpv.execution_method_code = ‘P’ –“Write your execution method code Here”
GROUP BY fa.application_short_name,
fcpv.execution_method_code
ORDER BY 1;