Eşzamanlı Olarak Çalıştırılan Program Tipi Kodları ve Anlamları

 
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 fnd_executables fe, fnd_executables_tl fet
 WHERE fe.executable_id = fet.executable_id;

 
SELECT DISTINCT lookup_code, meaning
           FROM fnd_lookup_values
          WHERE lookup_type = 'CP_EXECUTION_METHOD_CODE'