Monday 14 November 2016

Query to Display Module Wise Reports in oracle apps

/* Formatted on 11/14/2016 3:47:18 PM (QP5 v5.114.809.3010) */
  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


      ********************************************************************
 Module Wise Count:-

/* Formatted on 11/14/2016 3:49:03 PM (QP5 v5.114.809.3010) */
  SELECT   fa.application_short_name,
           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,
           COUNT (concurrent_program_id) COUNT
    FROM   fnd_concurrent_programs_vl fcpv, fnd_application fa
   WHERE   fcpv.application_id = fa.application_id
GROUP BY   fa.application_short_name, fcpv.execution_method_code
ORDER BY   1

No comments:

Post a Comment