Query to find list of custom forms, custom reports and custom form personalization
1. 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