Thursday, August 11, 2016

Query to get List of Custom Concurrent Programs


SELECT DISTINCT fcp.user_concurrent_program_name "Concurrent Program Name",
 fa.application_name,
 fcp.concurrent_program_name conc_short_name,
 decode( fef.execution_method_code, 'H','Host',
 'I', 'PLSQL Stored Procedure',
 'P', 'Report',
 'L', 'SQL Loader',
 'Q','SQL*Plus',
 'A','Spawned',
 'K','Java Concurrent Program',
 'B','Request Set Stage Function',
 'S','Immediate',
 'J','Java Stored Procedure',
 'M','Multi-Language Function',
 fef.execution_method_code) "execution method",
 fef.executable_name,
 fcp.description "Concurrent Program Description",
 fef.executable_name"Executable Name",
 fef.description "Executable Description",
 fef.execution_file_name ,
 fcp.enabled_flag
 ,fcp.creation_date
FROM fnd_executables_form_v fef,
     fnd_concurrent_programs_VL fcp,
     fnd_application_tl fa
WHERE fcp.application_id=fef.application_id
  AND fa.application_id=fcp.application_id
  AND fef.executable_id=fcp.executable_id
  AND UPPER(fcp.user_concurrent_program_name) like '%XXCUST%'
ORDER BY 4;