SQL – zestawienie programów współbieżnych, plików wykonywalnych i rodzajów

SELECT p.CONCURRENT_PROGRAM_NAME skrot_programu_wspolbieznego,
       p.USER_CONCURRENT_PROGRAM_NAME nazwa_programu_wspolbieznego,
       p.CREATION_DATE data_utworzenia,
       p.EXECUTABLE_ID,
       ex.EXECUTABLE_NAME skrot_pliku_wykonywalnego,
       ex.EXECUTION_FILE_NAME nazwa_pliku_wykonywalnego,
       p.EXECUTION_METHOD_CODE rodzaj_wykonywania,
       pr.MEANING rodzaj_wykonywania_opis,
       p.OUTPUT_FILE_TYPE typ_wyjscia
 
  FROM apps.fnd_concurrent_programs_vl p,
       apps.fnd_lookup_values_vl pr,
       apps.fnd_executables_vl ex
 
 WHERE p.APPLICATION_ID =
       (SELECT a.APPLICATION_ID
          FROM fnd_application_vl a
         WHERE a.APPLICATION_SHORT_NAME = 'XXCU')
 
   AND p.EXECUTION_METHOD_CODE = pr.LOOKUP_CODE(+)
   AND pr.LOOKUP_TYPE(+) = 'CP_EXECUTION_METHOD_CODE'
   AND ex.EXECUTABLE_ID(+) = p.EXECUTABLE_ID
   AND ex.APPLICATION_ID(+) = p.APPLICATION_ID
   AND p.ENABLED_FLAG = 'Y'
   AND UPPER(p.USER_CONCURRENT_PROGRAM_NAME) LIKE UPPER('%Rem%')
 ORDER BY 1