CONCURRENT REQUEST BASIC DETAILS

SELECT fcpt.user_concurrent_program_name
     , fcp.concurrent_program_name
     , fcp.output_file_type
     , fat.application_name application
     , fcpt.description prog_description
     , fe.executable_name
     , 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
     , fet.user_executable_name
     , fet.description executable_description
     , fe.execution_file_name
  FROM applsys.fnd_concurrent_programs fcp
     , applsys.fnd_concurrent_programs_tl fcpt
     , applsys.fnd_application_tl fat
     , applsys.fnd_executables fe
     , applsys.fnd_executables_tl fet
 WHERE fcp.concurrent_program_id = fcpt.concurrent_program_id
   AND fcp.application_id = fat.application_id
   AND fcp.executable_id = fe.executable_id(+)
   AND NVL (fe.executable_id, 0) = fet.executable_id
   AND fcpt.user_concurrent_program_name LIKE '%Requisi%Import%'
--   AND fat.application_name = 'General Ledger'
   AND 1 = 1;