Query to display module wise reports

Query to display module wise reports, www.askhareesh.com

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='PO'  
ORDER BY 1

*/

No comments:

Post a Comment