EXECUTABLES - basic details

SELECT fe.executable_name
     , fe.execution_method_code
     , DECODE (fe.execution_method_code
             , 'A', 'Spawned'
             , 'B', 'Request Set Stage Function'
             , 'E', 'Perl Concurrent Program'
             , 'H', 'Host'
             , 'I', 'PL/SQL Stored Procedure'
             , 'J', 'Java Stored Procedure'
             , 'K', 'Java Concurrent Program'
             , 'L', 'SQL*Loader'
             , 'M', 'Multi Language Function'
             , 'P', 'Oracle Reports'
             , 'Q', 'SQL*Plus'
             , 'S', 'Immediate'
             , 'Other')
          execution_method_code_decode
     , fet.user_executable_name
     , fet.description executable_description
     , fe.execution_file_name
  FROM applsys.fnd_executables fe
     , applsys.fnd_executables_tl fet
 WHERE fe.executable_id = fet.executable_id;

EXECUTABLES - COUNTING DETAILS

 
          SELECT fe.execution_method_code
       , DECODE (fe.execution_method_code
               , 'A', 'Spawned'
               , 'B', 'Request Set Stage Function'
               , 'E', 'Perl Concurrent Program'
               , 'H', 'Host'
               , 'I', 'PL/SQL Stored Procedure'
               , 'J', 'Java Stored Procedure'
               , 'K', 'Java Concurrent Program'
               , 'L', 'SQL*Loader'
               , 'M', 'Multi Language Function'
               , 'P', 'Oracle Reports'
               , 'Q', 'SQL*Plus'
               , 'S', 'Immediate'
               , 'Other')
            execution_method_code
       , COUNT (*) ct
    FROM applsys.fnd_executables fe
       , applsys.fnd_executables_tl fet
   WHERE fe.executable_id = fet.executable_id
GROUP BY fe.execution_method_code
       , DECODE (fe.execution_method_code
               , 'A', 'Spawned'
               , 'B', 'Request Set Stage Function'
               , 'E', 'Perl Concurrent Program'
               , 'H', 'Host'
               , 'I', 'PL/SQL Stored Procedure'
               , 'J', 'Java Stored Procedure'
               , 'K', 'Java Concurrent Program'
               , 'L', 'SQL*Loader'
               , 'M', 'Multi Language Function'
               , 'P', 'Oracle Reports'
               , 'Q', 'SQL*Plus'
               , 'S', 'Immediate'
               , 'Other')
ORDER BY 3 DESC;