Query to display module wise reports

SELECT   fa.application_short_name applshortname,

              fcpv.user_concurrent_program_name concprogramname,

              fav.application_name applicationname,

              fcpv.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,

              fnd_application_vl fav

WHERE   fcpv.application_id = fa.application_id

and        fa.application_id=fav.application_id

and        fa.application_short_name='INV' 

ORDER BY 1